Forums

ADOBE CREATIVE SUITE

This topic is locked

page navigation problem

amit MR

Posted 24 Jun 2007 08:21:38

has voted

Vote

24 Jun 2007 08:21:38 amit MR posted:

I am having the page navigation problem,, all the code below are fine but when the NEXT and PREVIOUS button is pressed it shows the inital search page not the other data listed in the database,, if I delete the session and other search button isset feature , the naviagation works ,, why so ,, can some one suggest??<b></b><b></b>

<?php require_once('Connections/kmaile.php'); ?>
<?php

//initialize the session
session_start();
$a=rand();

if(isset($_SESSION['user']))
{
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != ""

)
{
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true"

)
{
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['user'] = NULL;
$_SESSION['verifyuser'] = NULL;
unset($_SESSION['user']);
unset($_SESSION['verifyuser']);

$logoutGoTo = "login.php";
if ($logoutGoTo)
{
header("Location: $logoutGoTo"

;
exit;
}
}

?>
<?php
if (!function_exists("GetSQLValueString"

)
{
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string"

? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
//(isset($_POST['text1']))
if ((isset($_SERVER['QUERY_STRING'])) && (@$_POST['text1']!=""

)
{

$query1=@$_POST['text1'];

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 1000;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_kmaile, $kmaile);
$query_Recordset1 = "SELECT * FROM org_tab WHERE org_tab.Fname LIKE '%" .$query1. "%' OR org_tab.Lname LIKE '%" .$query1. "%' ORDER BY org_tab.Fname";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $kmaile) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1"

== false &&
stristr($param, "totalRows_Recordset1"

== false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="logtable.css" rel="stylesheet" type="text/css" />

<title>Untitled Document</title>
<style type="text/css">

</style>
</head>

<body>
<table width="741" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="737" height="98" scope="col">COLLEGE HEADER </th>
</tr>
<tr>
<td background="images/top.gif" height="10"> </td>
</tr>
<tr>
<td background="images/top_2.gif" height="9"><div align="justify" class="style1">
<div align="center">
<p><a href="register1.php?ref=<?php echo $a; ?>"> Add Member </a>   |    List    |   Change Password    |   <a href="<?php echo $logoutAction ?>">Logout</a></p>
</div>
</div></td>
</tr>
</table><P>
<?php
function processRow($count)
{
switch(intval($count))
{
case 1:
{
$color="#cccccc";
break;
}
case 2:
{
$color="#b9b9b9";
break;
}
default:
$color="#ffffff";
}
return $color;
}
?>

<table width="635" height="94" border="1">
<tr>
<th scope="col" colspan="12" height="12"><form name="se" action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">Search Member:
<input type="text" name="text1">  <input type="submit" name="Submit" value="Search"></form></th>
<th scope="col" colspan="3"><a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Next</a> <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">dfmkm</a></th>

</tr>
<tr>
<th height="8">khecID</th>
<th width="50">Fname</th>
<th width="50">Mname</th>
<th width="60">Lname</th>
<th width="5">sex</th>
<th width="90">Faculty</th>
<th width="90">CuAdd</th>
<th width="25">ConPH</th>
<th width="25">ConMOB</th>
<th width="50">altemail</th>
<th width="50">ACcret</th>
<th width="50">ACexp</th>
<th width="30">Usern</th>
<th colspan=2>update</th>
</tr>

<?php
$count=0;
do {
if($count>=2)
{
$count=0;
}

$count= $count+1;
?>
<tr bgcolor="<?php echo processRow($count); ?>">
<td ><?php echo $row_Recordset1['khecID']; ?></td>
<td><?php echo $row_Recordset1['Fname']; ?></td>
<td><?php echo $row_Recordset1['Mname']; ?></td>
<td><?php echo $row_Recordset1['Lname']; ?></td>
<td><?php echo $row_Recordset1['sex']; ?></td>
<td><?php echo $row_Recordset1['Faculty']; ?></td>
<td><?php echo $row_Recordset1['CuAdd']; ?></td>
<td><?php echo $row_Recordset1['ConPH']; ?></td>
<td><?php echo $row_Recordset1['ConMOB']; ?></td>
<td><?php echo $row_Recordset1['altemail']; ?></td>
<td><?php echo $row_Recordset1['ACcret']; ?></td>
<td><?php echo $row_Recordset1['ACexp']; ?></td>
<td><?php echo $row_Recordset1['Usern']; ?></td>
<td width="4%"><a href="update_usere.php?id=<?php print ($row_Recordset1['khecID']);?>"> Edit</a></td>
<td width="6%"><a href="userdele.php?id=<?php print ($row_Recordset1['khecID']);?>">Delete</a>
</td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>

<p> </p>
<table width="739" height="22" border="1" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="">Copy right information</td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
}
else{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="logtable.css" rel="stylesheet" type="text/css" />

<title>Untitled Document</title>
<style type="text/css">

</style>
</head>

<body>
<table width="741" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="737" height="98" scope="col">COLLEGE HEADER </th>
</tr>
<tr>
<td background="images/top.gif" height="10"> </td>
</tr>
<tr>
<td background="images/top_2.gif" height="9"><div align="justify" class="style1">
<div align="center">
<p><a href="register1.php?ref=<?php echo $a; ?>"> Add Member </a>   |    List    |   Change Password    |   <a href="<?php echo $logoutAction ?>">Logout</a></p>
</div>
</div></td>
</tr>
</table><P>

<table width="635" height="94" border="1">
<tr>
<th scope="col" colspan="12" height="12"><form name="se" action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">Search Member:
<input type="text" name="text1">  <input type="submit" name="Submit" value="Search"></form></th>

</tr>

</table><p> </p>
<table width="739" height="22" border="1" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="">Copy right information</td>
</tr>
</table>
<?php
}

}
else //session user
{
echo "<script language='JavaScript'>";
echo "window.alert('Error! Login, You are not authorized user')";
echo "</script>";
//header("location: login1.php"

;
include ('login.php');
}
?>

Reply to this topic

Latest Extensions

App Connect Summernote File Upload Upload different files in Summernote Editor
App Connect Summernote Simple, yet powerful and modern WYSIWYG Editor
Bootstrap 4 Dynamic Table Generator 2 Automatically generate dynamic data tables
Bootstrap 4 Dynamic Form Generator 2 Auto generate perfect Bootstrap 4 dynamic forms in seconds
App Connect Bootstrap 4 Dynamic Paging Generator Auto generate awesome dynamic Bootstrap 4 paging in seconds
App Connect Event Calendar The most powerful full-sized event calendar for Dreamweaver
DMXzone App Connect Next generation client side framework for data-driven web sites and apps
DMXzone Database Custom Query Create advanced, complex custom SQL queries with ease

Latest Videos

Using App Connect Autocomplete Learn how to add autocomplete functionality on your page, using the App Connect Autocomplete
Creating Custom SQL Queries Learn how to create custom SQL Queries with DMXzone Database Custom Query
Restricting Access to Your Pages Learn how to restrict access to your pages, using DMXzone Security Provider 2
Adding Log Out Functionality with DMXzone Security Provider 2 Learn how to add log out functionality to your page with DMXzone Security Provider 2
Creating a Log In Page with DMXzone Security Provider 2 Learn how to create a log in page with DMXzone Security Provider 2
Setting Up Site Security Settings Learn how to setup your site security, using DMXzone Security Provider 2
Generating an Update Record Form Learn how to create an update record form, using the Bootstrap 4 Dynamic Form Generator 2
Generating an Insert Record Form Learn how to create an insert record form, using the Bootstrap 4 Dynamic Form Generator 2