<?php //get the variables $var = $_POST['query'] ; $trimmed = trim($var); $table = $_POST['table']; //make connection $conn = mysql_connect('localhost','root','123') or die("Error:".mysql_error()); mysql_select_db('sutilities',$conn) or die("Error:".mysql_error()); //delete temp search table $del_table = "drop table search"; #mysql_query($del_table) or die ("Error:".mysql_error()); // Create a MySQL table in the selected database #mysql_query("CREATE TABLE search( #id INT NOT NULL AUTO_INCREMENT, ##PRIMARY KEY(id), # table_queried VARCHAR(30), # trimmed varchar(200))") # or die(mysql_error()); mysql_query("insert into search (table_queried, trimmed) values ('$table','$trimmed')") or die ("Error:".mysql_error()); // find out how many rows are in the table $query = "SELECT COUNT(*) FROM $table"; $result = mysql_query($query, $conn) or die("Error:".mysql_error()); $r = mysql_fetch_row($result); $numrows = $r[0]; // number of rows to show per page $rowsperpage = 10; // find out total pages $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { // cast var as int $currentpage = (int) $_GET['currentpage']; } else { // default page num $currentpage = 1; } // end if // if current page is greater than total pages... if ($currentpage > $totalpages) { // set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage < 1) { // set current page to first page $currentpage = 1; } // end if // the offset of the list, based on current page $offset = ($currentpage - 1) * $rowsperpage; // get the info from the db if ($table == "canteen"){ $sql="select canteen.price, canteen.url, canteen.item, canteen.shop from canteen where canteen.item like '%$trimmed%'". "or canteen.shop like '%$trimmed%' LIMIT $offset, $rowsperpage"; } if ($table == "timetables"){ $sql="select timetables.grade, timetables. url, timetables.section, timetables.idtimetables from timetables where timetables.grade like '%$trimmed%'". "or timetables.section like '%$trimmed%'". "or timetables.idtimetables like '%$trimmed%' LIMIT $offset, $rowsperpage"; } if ($table == "tc_sell"){ $sql="select tc_sell.name, tc_sell.age, tc_sell.grade, tc_sell.hp_no, tc_sell.email, tc_sell.price from tc_sell where tc_sell.name like '%$trimmed%'". "or tc_sell.age like '%$trimmed%'". "or tc_sell.grade like '%$trimmed%'". "or tc_sell.hp_no like '%$trimmed%'". "or tc_sell.email like '%$trimmed%'". "or tc_sell.item like '%$trimmed%'". "or tc_sell.price like '%$trimmed%' LIMIT $offset, $rowsperpage"; } if ($table == "tc_buy"){ $sql="select tc_buy.name, tc_buy.age, tc_buy.grade, tc_buy.hp_no, tc_buy.email, tc_buy.price from tc_buy where tc_buy.name like '%$trimmed%'". "or tc_buy.age like '%$trimmed%'". "or tc_buy.grade like '%$trimmed%'". "or tc_buy.hp_no like '%$trimmed%'". "or tc_buy.email like '%$trimmed%'". "or tc_buy.item like '%$trimmed%'". "or tc_buy.price like '%$trimmed%' LIMIT $offset, $rowsperpage"; } $result = mysql_query($sql, $conn) or die("Error:".mysql_error()); $count=0; while ($list = mysql_fetch_assoc($result)) { if ($table == "canteen"){ $count=$count+1; echo "<table><tr><td>".$count."</td><td>".$list['item']."</td><td>".$list['price']."</td><td>".$list['shop']."<br></td></tr></table>"; } } $range = 3; if ($currentpage > 1) { echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> "; $prevpage = $currentpage - 1; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> "; } for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { if (($x > 0) && ($x <= $totalpages)) { if ($x == $currentpage) { echo " [<b>$x</b>] "; } else { echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> "; } } } if ($currentpage != $totalpages) { $nextpage = $currentpage + 1; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> "; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> "; } ?>when i click the 'next' button on the results page, i get the following error:
PHP Notice: Undefined index: query in C:\inetpub\wwwroot\search(i).php on line 67
PHP Notice: Undefined index: table in C:\inetpub\wwwroot\search(i).php on line 69
could u pls point out whr i am going wrong?
how do i retain the form variables?? any suggestions? any other idea??
thx a lot in advance!!
Regards,
Makrand
