I'm facing some problem in paging data using php. It's working for the first page but, when I refresh the page or click on next it gives error. I'm adding the code below. help me please.
Code: Select all
<?
$hostname = "localhost";
$username = "********";
$password = "********";
$dbName = "reviewer";
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect");
@MYSQL_SELECT_DB("$dbName") OR DIE("Unable to select database");
if(!isset($start)) $start = 0;
$myreport = $_POST["report"];
$reports = $myreport;
$q= stripslashes($reports);
$query = $q. " LIMIT $start, 5";
$report1 = $q;
$query1 = $report1;
$result1 = mysql_query($query1);
$numrows = mysql_num_rows($result1);
$result = mysql_query($query);
$total_rows = mysql_num_rows($result);
$row = mysql_fetch_row($result);
$total_cols = count($row);
$timetotalp= $timetotal;
if (!$total_rows) {
print "<HTML><title>Reports</title><table width='800' border='0' cellspacing='3' cellpadding='3' align='center'>";
print "<tr bgcolor="#CCCCCC" height='200' align='center'><td><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>No report found! Please search again.... </b></FONT></td></tr></table></BODY></HTML>";
return;
}
print "<HTML><title>Reports</title><BODY text="#000000" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" topmargin='0' marginheight='0'>";
print "<table width='800' border='0' cellspacing='0' cellpadding='3' align='center'> ";
print "<tr bgcolor="#CCCCCC">";
$count = mysql_num_fields($result);
for ($i = 0; $i < $count; $i++) {
print "<td><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>";
$header = mysql_field_name($result, $i)."\t";
print $header;
print "</b></FONT></td>";
}
print "</tr>";
print "<tr>";
$i=0;
while($i < $total_cols){
print "<td><FONT size='1' face='Verdana, Arial, Helvetica, sans-serif'>";
print $row[$i];
print "</FONT></td>";
$i++;
}
print "</tr>";
$j = 1;
while($row = mysql_fetch_row ($result)) {
$j++;
$i = 0;
if ($j%2 == 0) {
print "<tr bgcolor=#F4F4F4>";
}else{
print "<tr bgcolor=#FFFFFF>";
}
while($i < $total_cols){
print "<td ><FONT size='1' face='Verdana, Arial, Helvetica, sans-serif'>";
print $row[$i];
print "</FONT></td>";
$i++;
}
print "</tr>";
}
print "<tr bgcolor=#CCCCCC><td colspan=$total_cols align=center>";
print "<table width='100%' border='0' cellspacing='0' cellpadding='2' align='center'> ";
print "<tr width='50%'><td align='left' width='25%'><FONT size='2' color='#FFFFFF' face='Verdana, Arial, Helvetica, sans-serif'>";
if($start > 0)
echo "<< <a href="" . $PHP_SELF . "?start=" . ($start - 5) ."&report=".$query1."">Previous</a>";
print "</FONT></td><td align='center' width='50%' height='20'><FONT size='2' color='#FFFFFF' face='Verdana, Arial, Helvetica, sans-serif'>";
print "<a href="javascript:void(window.print())"><img src="images\printicon.gif" border='0' alt='print'></a>";
print "</FONT></td><td align='right' width='25%' height='20'><FONT size='2' color='#FFFFFF' face='Verdana, Arial, Helvetica, sans-serif'>";
if($numrows > ($start + 5))
echo "<a href="" . $PHP_SELF . "?start=" . ($start + 5) ."&report=".$query1."">Next</a> >>";
print "</FONT></td></tr>";
print "</TABLE>";
print "</td></tr>";
print "</TABLE></BODY></HTML>";
?>
?>I'm passing the query from flash on a button click.
Code: Select all
report = "SELECT DATE_FORMAT(dateText, '%d-%m-%Y' ) AS 'Date' , indStatus AS 'Status', slideNo AS 'Slide', frameNo AS 'Frame', usName AS 'Reviewer', usComments AS 'Reviewer_Comments', indRectified AS 'Rectifiedby', indComments AS 'Developer_Comments' FROM reviews WHERE project='"+project+"' AND relatedTeam = '"+rTeam+"' ORDER BY dateText DESC";
getURL("http://192.168.1.12/reviewer/report.php?&start=0&report=SELECT%20DATE_FORMAT(dateText,'%d-%m-%Y')%20AS%20'Date',%20indStatus%20AS%20'Status',%20slideNo%20AS%20'Slide',%20frameNo%20AS%20'Frame',%20usName%20AS%20'Reviewer',%20usComments%20AS%20'Reviewer_Comments',%20indRectified%20AS%20'Rectifiedby',%20indComments%20AS%20'Developer_Comments'%20FROM%20reviews%20WHERE%20project=''"+project+"''%20AND%20relatedTeam=''"+rTeam+"''%20ORDER%20BY%20dateText%20DESC", "_blank", "POST");Could you please help me to solve this issue.
thanks,
Denis
feyd | stripped user/pass