php records navigation

Question

Code:

<?php 
$host='localhost'; 
$user='root'; 
$password='root'; 
$database='database'; 

$startindex=@$_REQUEST['seek']; 

$db=mysql_connect($host, $user, $password) 
or die ("Impossibile connettersi al server $host"); 

mysql_select_db($database, $db) 
or die ("Impossibile connettersi al database $database");



$query="SELECT * FROM ordini_master"; 
$dbResult=mysql_query($query, $db); 
$AffectedRows=mysql_affected_rows($db); 

mysql_data_seek($dbResult, $startindex); 

$row=mysql_fetch_row($dbResult); 

foreach($row as $k=>$v) 
{ 
    $myfield=mysql_fetch_field($dbResult, $k); 
    print($myfield->name . " : $v <br/>"); 
} 

mysql_free_result($dbResult); 
mysql_close($db); 

print("<br/>Seleziona il record<br/>"); 

for($index=0; $index<$AffectedRows; $index++) 
{ 
    print("<a href=\"{$_SERVER['PHP_SELF']}?seek=$index\" >" . 
    ($index+1) . "</a> "); 
} 
?> 

This code enables switching between a query's records, creating a page for every record in the database and displaying one record at a time. How can I change that code to page through records every ten? I want to display 10 records at a time and then make a page for the following.

Answer 1

To obtain as many records as you like, use LIMIT.

Example:

SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15

Modified working code:

<?php 
$host='localhost'; 
$user='root'; 
$password='root'; 
$database='database'; 

$startindex=(isset($_REQUEST['seek']) ? $_REQUEST['seek'] : 0); 

$db=mysql_connect($host, $user, $password) 
or die ("Impossibile connettersi al server $host"); 

mysql_select_db($database, $db) 
or die ("Impossibile connettersi al database $database");

$queryCnt = "SELECT count(*) as cnt FROM ordini_master"; 
$CntRow=mysql_fetch_row(mysql_query($query, $db));
$CntData = $CntRow[0];

$step = 10;
$query="SELECT * FROM ordini_master LIMIT $startindex, $step"; 
$result=mysql_query($query, $db); 

while ($row = mysql_fetch_assoc($result)) {
    foreach($row as $k=>$v) { 
        $myfield=mysql_fetch_field($result, $k); 
        print($myfield->name . " : $v <br/>"); 
    } 
} 

mysql_free_result($result); 
mysql_close($db); 

print("<br/>Seleziona il record<br/>"); 

for($index=0; $index<$CntData; $index=$index+$step) { 
    print("<a href=\"{$_SERVER['PHP_SELF']}?seek=$index\" >" . 
    ($index+1) . "</a> "); 
} 

Utilize Tadman's data as well. The MySQL extension will no longer be maintained, so it's crucial to take action to prevent SQL injection and to utilize PDO or the mysqli extension.

I hope this helps you.