66th Day of Class page query

Create a paging interface and query methods

<?PHP//refer to pagination classes and connection database functions, respectivelyinclude"Class/page-class.php";include"Function/unionmysql-function.php";//Processing Submission Information$name="";$TJ="";if(isset($_get[' Name '])){    $name=$_get[' Name ']; $TJ= "where areaname like '%{$name}%‘ ";}//get the total number of data in a database$sqlcount= "SELECT count (*) from Chinastates".$TJ;$sqlcount=unionmysql ($sqlcount);$sqlcount=$sqlcount[0] [0];//initializing the Paging class$page=NewPage ($sqlcount, 15);//query data based on paging criteria, add conditional $page->limit after query to achieve pagination effect$sql= "SELECT * from Chinastates".$TJ.$page-limit;$sql=unionmysql ($sql);?><!--Create a query condition--><br/><form action= "" method= "get" ><div align= "center" >Please enter query criteria: <input type= "text" name= "name" value= "<?php Echo$name?> "/><input type=" Submit "/></form></div><br/><!--print form--><table width=" 1000px "border=" 1px "align=" center "bordercolor=" #00FF00 "> <tr> <td> location </td> <td& gt; Parent code </td> <td>root</td> </tr><?PHPforeach($sql  as $i){    $j= "<font color= ' #FF0000 ' >$name</font> "; $i[1]=Str_replace("$name","$j","$i[1] "); Echo"<tr> <td>$i[1]</td> <td>$i[2]</td> <td>$i[3]</td> </tr>";}? ></table><br/><div align= "center" ><?phpEcho $page->fpage ()?></div>

66th Day of Class page query