<?phpinclude "page.class.php"; include "db.class.php"; $db = new db (); $name = ""; $tj = ""; if (!empty ($_post["MC"])// Determine if the query text box has a value {$name = $_post["MC"]; $tj = "n={$name}";//*** paging Condition}if (!empty ($_get["n"]))//based on POST values {$name = $_get["n"];$ TJ = "name={$name}";} $w = "where areaname like '%{$name}% '";//Condition query? ><br/><form action= "fenye.php" method= "POST" > <!--Build Query Button--><div> Please enter name: <input type= "text" Name= "MC" value= "<?php echo $name?>"/> <input type= " Submit "value=" Query "/></div></form><br/><table width=" 100% "border=" 1 "cellpadding=" 0 " cellspacing= "0" > <tr><td> code </td><td> name </td><td> Parent code </TD></TR ><?PHP$SQL1 = "SELECT count (*) from chinastates". $w;//Total Data $attr = $db->query ($sql 1); $total = $attr [0][0]; $page = new Page ($total, $TJ, true);//1, total data 2, data volume per page 3, paging condition 4,true display first page, false display last $SQL2 = "SELECT * from Chinastates". $w $pa ge->limit;//Conditional Paging query = $db->query($sql 2), foreach ($r as $v) {echo "<tr><td>{$v [0]}</td><td>{$v [1]}</td><td>{$v [2 ]}</td></tr> ";}? ></TABLE><BR/><?phpecho $page->fpage ();//Paging Query menu?>
PHP Paging Query