search from database(refersh page)..

kar07 · September 18, 2007

Hi Friends,

i am new to php programming...

in my php application i just retrive record from mysql databse.where i put the condition "SELECT id,yearday ,thisyear,startdate,enddate FROM tblpcspcbdtt

where startdate >='$sdate' "

i pass the date from html page as a post method..

afterthat i can dispaly the records in php page..it says 6 pages...when i try to move next page it is change to 82 pages ....because initially i run without any condition like that. "SELECT id,yearday ,thisyear,startdate,enddate FROM tblpcspcbdtt" .it has 82 pages..

but now i already put date condition in the query , after that it says 6 pages..but after i ckick next url it's goes back to 82 pages, then display the 82 pages records.but really i need to see only the 6 pages..

i dn't know why it is goes back old pages??..

please help me..

here are my code..

-----------------------------------------------

<html>

<head>

<title>Test Result</title>

<h1><b> Test Result</b></h1>

</head>

<?php

include 'library/config.php';

include 'library/opendb.php';

// how many rows to show per page

$rowsPerPage = 10;

//$CHECKDT=$_POST["name"];

// by default we show first page

$pageNum = 1;

//$emp_id = $_POST["name"];

$sdate = $_POST["dt1"];

//$edate = $_POST["dt2"];

//echo($emp_id);

//echo($sdate);

//echo($edate);

// if $_GET['page'] defined, use it as page number

if(isset($_GET['page']))

{

$pageNum = $_GET['page'];

}

// counting the offset

$offset = ($pageNum - 1) * $rowsPerPage;

$query = " SELECT id,yearday ,thisyear,startdate,enddate FROM tblpcspcbdtt

where startdate >='$sdate' ";

//and enddate <='$edate'

//where id = '$emp_id'

$pagingQuery = "LIMIT $offset, $rowsPerPage";

$result = mysql_query($query . $pagingQuery) or die('Error, query failed2');

// print the student info in table

echo '<table border="1" bgcolor=#FFFFFF" align ="center"><tr><td>Serial Id</td><td>Yearday</td><td>Year</td><td>StartDate</td><td>End Date</td></tr>';

while(list($id, $yearday, $thisyear, $startdate, $enddate) = mysql_fetch_array($result))

{

echo "<tr><td>$id</td><td>$yearday</td><td>$thisyear</td><td>$startdate</td><td>$enddate</td></tr>";

}

echo '</table>';

echo '<br>';

$result = mysql_query($query) or die('Error, query failed1');

$numrows = mysql_num_rows($result);

echo $numrows;

$maxPage = ceil($numrows/$rowsPerPage);

$self = $_SERVER['PHP_SELF'];

if ($pageNum > 1)

{

$page = $pageNum - 1;

$prev = "<a href=\"$self?page=$page\">[Prev]</a>";

$first = "<a href=\"$self?page=1\">[First Page]</a>";

}

else

{

$prev = ' [Prev] ';

$first = ' [First Page] ';

}

if ($pageNum < $maxPage)

{

$page = $pageNum + 1;

$next = "<a href=\"$self?page=$page\">[Next]</a>";

$last = "<a href=\"$self?page=$maxPage\">[Last Page]</a>";

}

else

{

$next = ' [Next] '; // we're on the last page, don't enable 'next' link

$last = ' [Last Page] '; // nor 'last page' link

}

// print the page navigation link

echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last;

include 'library/closedb.php';

?>

</body>

</html>

--------------------------------------------------

waiting for your valable reply....

with regards,

kar07..

Sign In

search from database(refersh page)..

Recommended Posts

kar07

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information