My $_POST variable works only for the first page.

3 New Member

I have written a form in with radio buttons the name is set to orderby and the value is set to KundeVorName and the next value is KundeNachName and it goes so on. I wanna modify my query according this values. It works well for the first page but at the second it looses its value and gives me an error message. When i hard code it like "Select * from Kunde ORDER BY KundeVorName" it works for all pages when i use my variable $orderby it works just for the first page. here is my code:

Expand|Select|Wrap|Line Numbers

 
<html>

<head>

<style type="text/css">

A:link {text-decoration: none}

A:visited {text-decoration: none}

A:active {text-decoration: none}

A:hover {text-decoration: underline overline; color: red;}

table.second { margin-top:20px; margin-bottom:0px;}

</style>

<title>Implementing Paging with next and prev</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>
 
<body bgcolor="#99CC99">
 
<table width="60%" align="center" bgcolor="#009966"><tr>

<td><a href="insert.php">Veri Gir</a></td>

<td><a href="query.php">Veri Görüntüle</a></td>

<td><a href="search.php"> Veri Ara </a></td>

<td><a href="update.php"> Veri Güncelle </a></td>

<td><a href="logout.php"> Ç?k?? </a></td>

</tr></table>

<?php

include 'connect.php';

$orderby = $_POST['orderby'];

$type = $_POST['type'];
 
    if (isset($orderby)) {

        echo "orderby is set\n";

    } else {

        echo "orderby is not set\n";

    }

    if (isset($type)) {

        echo "type is set\n";

    } else {

        echo "type is not set\n";

    }
 
// how many rows to show per page

$rowsPerPage = 5;
 
// by default we show first page

$pageNum = 1;
 
// 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 * FROM Kunde ORDER BY $orderby" .

         " LIMIT $offset, $rowsPerPage";

$result = mysql_query($query) or die('Error, query failed');
 
// start of the query *******************************************************************************

?>

<div><table class='second' border='1'><tr><td>ID</td><td>?sim Soyad</td><td>Firma</td><td>S?n?f</td><td>Ürünler</td><td>Adres</td><td>?ehir</td><td>Ülke</td><td>Türü</td><td>?? Telefonu</td><td>Fax</td><td>Cep</td><td>Mail</td><td>Web</td><td>Tarih</td></b></tr>

<?php

while($row = mysql_fetch_array($result))

{

?>

<tr><td><?php echo $row['KundeID']; ?> </td>

<td> <?php echo $row['KundeVorName']."&nbsp;".$row['KundeNachName']; ?> </td>

<td> <?php echo $row['KundeFirma']; ?> </td>

<td> <?php echo $row['KundeKategorie']; ?> </td>

<td> <?php echo $row['KundeProdukte']; ?> </td>

<td> <?php echo $row['KundeAdresse']; ?> </td>

<td> <?php echo $row['KundeOrt']; ?> </td>

<td> <?php echo $row['KundeLand']; ?> </td>

<td> <?php echo $row['KundeArt']; ?> </td>

<td> <?php echo $row['KundeFestnetz']."&nbsp;"; ?> </td>

<td> <?php echo $row['KundeFax']."&nbsp;"; ?> </td>

<td> <?php echo $row['KundeMobile']."&nbsp;"; ?> </td>

<td> <?php $mail = $row['KundeMail']; ?><a href="mailto:<?php echo "$mail"; ?>"><?php echo $row['KundeMail']."&nbsp;"; ?> </a></td>

<td> <?php $web = $row['KundeWeb']; ?> <a href="http://<?php echo "$web"; ?>" Target="blank"> <?php echo $row['KundeWeb']."&nbsp;"; ?></a> </td>

<td> <?php echo $row['KundeRegDatum']."&nbsp;"; ?> </td></tr>

<?php } ?>

</table>

<?php

// end of the query *******************************************************************************

// how many rows we have in database

$query   = "SELECT COUNT(KundeID) AS numrows FROM Kunde ";

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

$row     = mysql_fetch_array($result, MYSQL_ASSOC);

$numrows = $row['numrows'];
 
// how many pages we have when using paging?

$maxPage = ceil($numrows/$rowsPerPage);
 
// print the link to access each page

$self = $_SERVER['PHP_SELF'];

$nav = '';

for($page = 1; $page <= $maxPage; $page++)

{

    if ($page == $pageNum)

    {

        $nav .= " $page ";   // no need to create a link to current page

    }

    else

    {

        $nav .= " <a href=\"$self?page=$page\">$page</a> ";

    }        

}
 
// creating previous and next link

// plus the link to go straight to

// the first and last page
 
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  = '&nbsp;'; // we're on page one, don't print previous link

    $first = '&nbsp;'; // nor the first page link

}
 
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 = '&nbsp;'; // we're on the last page, don't print next link

    $last = '&nbsp;'; // nor the last page link

}
 
// print the navigation link

echo $first . $prev . $nav . $next . $last;
 
// and close the database connection
 
?>

</body>

</html>

[Please use CODE tags when posting source code. Thanks! --pbmods]
I get orderby is not set ,type is not set and query error messages.
How can I fix my problem with the variables?

May 30 '07 #1

Subscribe Reply

2311

pbmods

5,821

Recognized Expert Expert

Heya, Mesut. Welcome to TSDN!

Um... that's a lot of code you just dumped there. And most of it really isn't relevant to your problem at all.

You might want to save your POST variables in the session. Take a look at this thread.

May 30 '07 #2

Mesut

New Member

Heya, Mesut. Welcome to TSDN!

Um... that's a lot of code you just dumped there. And most of it really isn't relevant to your problem at all.

You might want to save your POST variables in the session. Take a look at this thread.

I am really a newbie, i did not get the answer i have modified most of the scripts now i a m stucked up, i dont know how to modify

Expand|Select|Wrap|Line Numbers

 
foreach($_POST as $k => $v)

{

$_SESSION[$k] = $v;

}

[Please use CODE tags when posting source code. Thanks! --pbmods]
variable...??
Anyway thats an amazing fast answer, you are great!!

May 30 '07 #3

pbmods

5,821

Recognized Expert Expert

I am really a newbie, i did not get the answer

We've all been there. No problem ^_^

First off, you need to make one change:

Expand|Select|Wrap|Line Numbers

 
//  Add this line, or else nothing will work properly:

session_start();
 
foreach($_POST as $k => $v)

{

$_SESSION[$k] = $v;

}

Alrightey. What this code does is run through $_POST and copy the values in $_POST to $_SESSION.

To be more verbose, for each element in $_POST, we assign the key (e.g., 'orderby') to $k and the value (e.g., 'KundeVorName') to $v. Then we set $_SESION[$k] to $v ($_SESSION['orderby'] = 'KundeVorName').

The end result is that anything that was in $_POST is now in $_SESSION, and $_SESSION (unlike $_POST) is persistent between page loads.

Put that script by where you assign the value of $orderby and then change your statement from

Expand|Select|Wrap|Line Numbers

$orderby = $_POST['orderby'];

Expand|Select|Wrap|Line Numbers

$orderby = $_SESSION['orderby'];

May 30 '07 #4

by: Dan | last post by:

I was trying to troubleshoot a login page that doesn't work - it keeps saying the login/password is missing - when my tracing discovered this peculiar behavior. register_globals is off, so at...

My $_POST variable works only for the first page.

Similar topics