<?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
