1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 6:32 am May 2, 2026

Forum Moderators: coopster

Message Too Old, No Replies

Pagination

         

coniuratus

7:00 am on Jun 17, 2007 (gmt 0)

10+ Year Member



Hi boys and girls.
I have a small problem with one of my scripts, I have a pagination script and I've turn to the forum that I use and no one could help me, so I'll try this one :)
Let's see, my problem is a pagination script (doh)
I have this code: 

<?
require_once 'config.php';
$rezultate_maxime_in_linie = 1;
$rezultate_maxime_in_jos = 2;
$totale = mysql_result(mysql_query('SELECT COUNT(*) as Num FROM `anunturi`
WHERE categorii = "afaceri"'),0);
if(!isset($_GET['page'])) $page = 1;
else $page = $_GET['page'];
$cerereSQL = mysql_query('SELECT * FROM `anunturi` WHERE categorii = "afaceri" ORDER by `id` ASC LIMIT '.(($page * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)) - ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)).', '.($rezultate_maxime_in_jos*$rezultate_maxime_in_linie).' ');
$pagini_totale = ceil($totale / ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie));
if($page > $pagini_totale) echo 'Pagina nu a fost gasita';
elseif($pagini_totale > 0) {
$seteaza = 0;
$numar = ($page - 1) * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie);
 $culoare_celula = '#FFE0B3';
 echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
$numar++;
if($seteaza == $rezultate_maxime_in_linie) {
 echo "</tr><tr>\n";
$seteaza = 1;
 if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
 else $culoare_celula = "#FFE0B3";
 } else $seteaza++;
 echo "<td bgcolor=".$culoare_celula.">
 ".$numar."
 ".$rand['categorii']."
 ".$rand['tip']."
 ".$rand['judet']."
 ".$rand['anunt']."
 ".$rand['data']."
 ".$rand['telefon']."
 ".$rand['pret']."
 ".$rand['moneda']."</td>\n";
}
 echo "</tr></table>";
if($pagini_totale == 1) echo 'bal bla';
else {
echo '<div align="center">';
if($page > 1) {
 $inapoi = ($page - 1);
 echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inapoi.'">&laquo;</a>&nbsp;';
}
for($pagini = 1; $pagini <= $pagini_totale; $pagini++){
 if(($page) == $pagini) echo '<b>'.$pagini.'</b>&nbsp;';
else echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$pagini.'">'.$pagini.'</a>&nbsp;';
}
if($page < $pagini_totale) {
$inainte = ($page + 1);
echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inainte.'">&raquo;</a>&nbsp;';
}
echo '</div>';
 }
}
?>

If you want to see it live the link is:

It works fine and dandy, but when I use it in the script that I need, it doesn't recognize something, the script that I want to use it in is: 

<?php
if (isset($_POST['Trimite']))
{
$tip = $_POST['tip'];
$judet = $_POST['Judete'];
if (($judet == 'Toate') && ($tip == 'Toate')){
$rezultate_maxime_in_linie = 1;
$rezultate_maxime_in_jos = 2;
$totale = mysql_result(mysql_query('SELECT COUNT(*) as Num FROM `anunturi`
WHERE categorii = "afaceri"'),0);
if(!isset($_GET['page'])) $page = 1;
else $page = $_GET['page'];
$cerereSQL = mysql_query('SELECT * FROM `anunturi` WHERE categorii = "afaceri" ORDER by `id` ASC LIMIT '.(($page * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)) - ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)).', '.($rezultate_maxime_in_jos*$rezultate_maxime_in_linie).' ');
$pagini_totale = ceil($totale / ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie));
if($page > $pagini_totale) echo 'Pagina nu a fost gasita';
elseif($pagini_totale > 0) {
$seteaza = 0;
$numar = ($page - 1) * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie);
 $culoare_celula = '#FFE0B3';
 echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
$numar++;
if($seteaza == $rezultate_maxime_in_linie) {
 echo "</tr><tr>\n";
$seteaza = 1;
 if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
 else $culoare_celula = "#FFE0B3";
 } else $seteaza++;
 echo "<td bgcolor=".$culoare_celula.">
 ".$numar."
 ".$rand['categorii']."
 ".$rand['tip']."
 ".$rand['judet']."
 ".$rand['anunt']."
 ".$rand['data']."
 ".$rand['telefon']."
 ".$rand['pret']."
 ".$rand['moneda']."</td>\n";
}
 echo "</tr></table>";
if($pagini_totale == 1) echo 'bal bla';
else {
echo '<div align="center">';
if($page > 1) {
 $inapoi = ($page - 1);
 echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inapoi.'">&laquo;</a>&nbsp;';
}
for($pagini = 1; $pagini <= $pagini_totale; $pagini++){
 if(($page) == $pagini) echo '<b>'.$pagini.'</b>&nbsp;';
else echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$pagini.'">'.$pagini.'</a>&nbsp;';
}
if($page < $pagini_totale) {
$inainte = ($page + 1);
echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inainte.'">&raquo;</a>&nbsp;';
}
echo '</div>';
 }
}
}
 else if (($judet!== '') && ($tip == 'Toate')){
$rezultate_maxime_in_linie = 1;
$rezultate_maxime_in_jos = 2;
$totale = mysql_result(mysql_query('SELECT COUNT(*) as Num FROM `anunturi`
WHERE categorii = "afaceri" AND judet = "'.$judet.'"'),0);
if($totale == 0) echo 'Nu exista intrari ...';
elseif(!isset($_GET['page'])) $page = 1;
else $page = $_GET['page'];
$cerereSQL = mysql_query('SELECT * FROM `anunturi` WHERE categorii = "afaceri" AND judet = "'.$judet.'" ORDER by `id` ASC LIMIT '.(($page * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)) - ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)).', '.($rezultate_maxime_in_jos*$rezultate_maxime_in_linie).' ');
$pagini_totale = ceil($totale / ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie));
if($page > $pagini_totale) echo 'Pagina nu a fost gasita';
elseif($pagini_totale > 0) {
echo '<b>Sistem de paginare</b><br><br>';
$seteaza = 0;
$numar = ($page - 1) * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie);
 $culoare_celula = '#FFE0B3';
 echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
$numar++;
if($seteaza == $rezultate_maxime_in_linie) {
 echo "</tr><tr>\n";
$seteaza = 1;
 if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
else $culoare_celula = "#FFE0B3";
} else $seteaza++;
echo "<td bgcolor=".$culoare_celula.">".$numar." ".$rand['categorii']."
 ".$rand['tip']."
 ".$rand['judet']."
 ".$rand['anunt']."
 ".$rand['data']."
 ".$rand['telefon']."
 ".$rand['pret']."
 ".$rand['moneda']."</td>\n";
}
 echo "</tr></table>";
if($pagini_totale == 1) echo '';
else {
echo '<div align="center">';
if($page > 1) {
 $inapoi = ($page - 1);
 echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inapoi.'">&laquo;</a>&nbsp;';
}
for($pagini = 1; $pagini <= $pagini_totale; $pagini++){
 if(($page) == $pagini) echo '<b>'.$pagini.'</b>&nbsp;';
else echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$pagini.'">'.$pagini.'</a>&nbsp;';
}
if($page < $pagini_totale) {
$inainte = ($page + 1);
echo '<a href=" '.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inainte.'">&raquo;</a>&nbsp;';
}
echo '</div>';
 }
}
}
 else if (($judet == 'Toate') && ($tip!=='')){
 $rezultate_maxime_in_linie = 1;
$rezultate_maxime_in_jos = 2;
$totale = mysql_result(mysql_query('SELECT COUNT(*) as Num FROM `anunturi`
WHERE categorii = "afaceri" AND tip = "'.$tip.'"'),0);
if(!isset($_GET['page'])) $page = 1;
else $page = $_GET['page'];
$cerereSQL = mysql_query('SELECT * FROM `anunturi` WHERE categorii = "afaceri" AND tip = "'.$tip.'" ORDER by `id` ASC LIMIT '.(($page * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)) - ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)).', '.($rezultate_maxime_in_jos*$rezultate_maxime_in_linie).' ');
$pagini_totale = ceil($totale / ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie));
if($page > $pagini_totale) echo 'Pagina nu a fost gasita';
elseif($pagini_totale > 0) {
echo '<b>Sistem de paginare</b><br><br>';
$seteaza = 0;
$numar = ($page - 1) * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie);
 $culoare_celula = '#FFE0B3';
 echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
$numar++;
if($seteaza == $rezultate_maxime_in_linie) {
 echo "</tr><tr>\n";
$seteaza = 1;
 if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
else $culoare_celula = "#FFE0B3";
} else $seteaza++;
echo "<td bgcolor=".$culoare_celula.">".$numar." ".$rand['categorii']."
 ".$rand['tip']."
 ".$rand['judet']."
 ".$rand['anunt']."
 ".$rand['data']."
 ".$rand['telefon']."
 ".$rand['pret']."
 ".$rand['moneda']."</td>\n";
}
 echo "</tr></table>";
if($pagini_totale == 1) echo '';
else {
echo '<div align="center">';
if($page > 1) {
 $inapoi = ($page - 1);
 echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inapoi.'">&laquo;</a>&nbsp;';
}
for($pagini = 1; $pagini <= $pagini_totale; $pagini++){
 if(($page) == $pagini) echo '<b>'.$pagini.'</b>&nbsp;';
else echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$pagini.'">'.$pagini.'</a>&nbsp;';
}
if($page < $pagini_totale) {
$inainte = ($page + 1);
echo '<a href=" '.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inainte.'">&raquo;</a>&nbsp;';
}
echo '</div>';
 }
}
}
 else if (($judet!=='') && ($tip!=='')){
$rezultate_maxime_in_linie = 1;
$rezultate_maxime_in_jos = 2;
$totale = mysql_result(mysql_query('SELECT COUNT(*) as Num FROM `anunturi`
WHERE categorii = "afaceri" AND tip = "'.$tip.'" AND judet = "'.$judet.'"'),0);
if(!isset($_GET['page'])) $page = 1;
else $page = $_GET['page'];
$cerereSQL = mysql_query('SELECT * FROM `anunturi` WHERE categorii = "afaceri" AND tip = "'.$tip.'" AND judet = "'.$judet.'" ORDER by `id` ASC LIMIT '.(($page * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)) - ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)).', '.($rezultate_maxime_in_jos*$rezultate_maxime_in_linie).' ');
$pagini_totale = ceil($totale / ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie));
if($page > $pagini_totale) echo 'Pagina nu a fost gasita';
elseif($pagini_totale > 0) {
echo '<b>Sistem de paginare</b><br><br>';
$seteaza = 0;
$numar = ($page - 1) * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie);
 $culoare_celula = '#FFE0B3';
 echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
$numar++;
if($seteaza == $rezultate_maxime_in_linie) {
 echo "</tr><tr>\n";
$seteaza = 1;
 if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
else $culoare_celula = "#FFE0B3";
} else $seteaza++;
echo "<td bgcolor=".$culoare_celula.">".$numar." ".$rand['categorii']."
 ".$rand['tip']."
 ".$rand['judet']."
 ".$rand['anunt']."
 ".$rand['data']."
 ".$rand['telefon']."
 ".$rand['pret']."
 ".$rand['moneda']."</td>\n";
}
 echo "</tr></table>";
if($pagini_totale == 1) echo '';
else {
echo '<div align="center">';
if($page > 1) {
 $inapoi = ($page - 1);
 echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inapoi.'">&laquo;</a>&nbsp;';
}
for($pagini = 1; $pagini <= $pagini_totale; $pagini++){
 if(($page) == $pagini) echo '<b>'.$pagini.'</b>&nbsp;';
else echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$pagini.'">'.$pagini.'</a>&nbsp;';
}
if($page < $pagini_totale) {
$inainte = ($page + 1);
echo '<a href=" '.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inainte.'">&raquo;</a>&nbsp;';
}
echo '</div>';
 }
}
 }
} else {
echo 'Selecteza tipul anuntului si judetul<br><br><br>
<form method="post" class="cauta" action="">
<select name="tip">
<option>Toate</option>
<option>Afaceri-oferte</option>
<option>Afaceri-cereri</option>
</select>&nbsp;&nbsp;&nbsp;
<select name="Judete">
<option>Toate</option>
<option>Alba</option>
<option>Arad</option>
<option>Arges</option>
<option>Bacau</option>
<option>Bihor</option>
<option>Bistrita</option>
<option>Botosani</option>
<option>Braila</option>
<option>Brasov</option>
<option>Bucuresti</option>
<option>Buzau</option>
<option>Calarasi</option>
<option>Caras</option>
<option>Cluj</option>
<option>Constanta</option>
<option>Covasna</option>
<option>Dambovita</option>
<option>Dolj</option>
<option>Galati</option>
<option>Giurgiu</option>
<option>Gorj</option>
<option>Harghita</option>
<option>Hunedoara</option>
<option>Ialomita</option>
<option>Iasi</option>
<option>Ilfov</option>
<option>Maramures</option>
<option>Mehedinti</option>
<option>Mures</option>
<option>Neamt</option>
<option>Olt</option>
<option>Prahova</option>
<option>Salaj</option>
<option>Satu-mare</option>
<option>Sibiu</option>
<option>Suceava</option>
<option>Teleorman</option>
<option>Timis</option>
<option>Tulcea</option>
<option>Valcea</option>
<option>Vaslui</option>
<option>Vrancea</option>
</select><br><br><br>
<input name="Trimite" type="submit" class="searchbutton" value="Cauta">
 </form>';
 }
?>

If you want to see the script in action here is the link:

I think that it doesn't recognize something, I've tried everything, I don't know what to do any more, I hope someone can help me.
Thank you.

[edited by: jatar_k at 12:39 pm (utc) on June 17, 2007]
[edit reason] no urls thanks [/edit]

Habtom

7:11 am on Jun 17, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Welcome to Webmasterworld coniuratus.

>>I think that it doesn't recognize something
The post is too long for me to trace things out. Can you specify the error messages you get, if you know where the error lies or anything that can help people here in WW help you.

Habtom

coniuratus

7:25 am on Jun 17, 2007 (gmt 0)

10+ Year Member



Hi, thanks for the reply, there aren't any errors, but if you click the link that I provided in the first topic:

You would see that if I click search the database it search it and when I click to go to the second page and the third page it redirects me to the search page again and again, the thing is that the link on the url bar shows me that I an on the right page but I need to click the search witch is the "Cauta" button, I think that it doesn't recognize the "$_POST['Trimite']" for all the pages. :(

[edited by: jatar_k at 12:40 pm (utc) on June 17, 2007]
[edit reason] no urls thanks [/edit]

Habtom

7:36 am on Jun 17, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



>> it doesn't recognize the "$_POST['Trimite']" for all the pages

$_POST can't be retrieved on subsequent pages once posted, you need to find a way to keep on passing that info either using hidden text boxes or SESSIONS.

Btw, URLs are not allowed in WW.

Habtom

coniuratus

7:44 am on Jun 17, 2007 (gmt 0)

10+ Year Member



Sorry, I didn't read the user and agreements :">, can you please give me a example? ¦¦ something, I'm not a php guru :(, I don't know how and where to set the session, I mean I know how to set a session but I don't know where and how to set this one, thank you very much ...

Borgscan

8:28 am on Jun 17, 2007 (gmt 0)

10+ Year Member



You could just pass the variables you need through the next page URL? 

echo '<a href=" '.$_SERVER['PHP_SELF'].'?pagina=afaceri&trimite='.$trimite.'&page='.$inainte.'">&raquo;</a>&nbsp;';

Then to retrieve the variable... 

if (!isset($_GET['trimite'])
{
 // Run through your script.
}

Forgive me if I missunderstand the purpose of some of your variables due to them not being in english. However, I've included the script I used for pagination in the past. My coding style has a changed a bit and note I've taken out most of the HTML to make it easier to follow. Hope I've helped in some way. 


<?php
if (isset($_GET['cid']))
{
$cid = $_GET['cid'];
}
else
{
include "header.php";
// Show search form.
include "footer.php";
exit();
}
if(isset($_GET['page']))
{
$page_num = $_GET['page'];
} else {
$page_num = 1;
}
$rows_per_page = 9;
$offset = ($page_num -1) * $rows_per_page;
$sql1 = "SELECT title FROM product_cat WHERE id = '".$cid."'";
$result1 = mysql_query($sql1);
$row1 = mysql_fetch_array($result1);
$cid_title = $row1['title'];
if (!$result1)
{
include "header.php";
// show error message, no category found in database.
include "footer.php";
exit();
}
$sql2 = "SELECT * FROM product WHERE cid = '".$cid."'";
$result2 = mysql_query($sql2);
$numrows2 = mysql_num_rows($result2); 
if ($numrows2 == 0)
{
include "header.php";
// show error message, no products found in database.
include "footer.php";
exit();
}
$thumbcols = 3;
$thumbrows = ceil($numrows2 / $thumbcols);
include "header.php";
echo "<table>";
$sql3 = "SELECT * FROM product WHERE cid = '".$cid."' AND active = 1 ORDER BY id LIMIT $offset, $rows_per_page";
$result3 = mysql_query($sql3);
for($r=1;$r<=$thumbrows;$r++)
{
echo "<tr>";
for($c=1;$c<=$thumbcols;$c++)
{
$row3 = mysql_fetch_array($result3);
$pid=$row3['id'];
$title= $row3['title'];
$image_thumb=$row3['image_thumb'];
$price_au=$row3['price_au'];
$price_nz=$row3['price_nz'];
// do html here to display the product
}
}
echo "</tr>";
}
echo "</table>";
$sql4 = "SELECT id FROM product WHERE cid = '".$cid."' AND active = 1";
$result4= mysql_query($sql4);
$numrows4 = mysql_num_rows($result4);
$max_page = ceil($numrows4 / $rows_per_page);
if ($numrows4 > $rows_per_page)
{
if ($page_num > 1)
{
$page = $page_num - 1;
$prev = " <a href=\"index.php?idx=$idx&cid=$cid&page=$page\" class=\"link\">[Prev]</a> ";
$first = " <a href=\"index.php?idx=$idx&cid=$cid&page=1\" class=\"link\">[First Page]</a> ";
} 
else
{
$prev="<span class=\"font\">[Prev]</span>";
$first="<span class=\"font\">[First Page]</span>";
}
if ($page_num < $max_page)
{
$page = $page_num + 1;
$next = " <a href=\"index.php?idx=$idx&cid=$cid&page=$page\" class=\"link\">[Next]</a> ";
$last = " <a href=\"index.php?idx=$idx&cid=$cid&page=$max_page\" class=\"link\">[Last Page]</a> ";
} 
else
{
$next = "<span class=\"font\">[Next]</span>";
$last = "<span class=\"font\">[Last Page]</span>";
}
echo $first . $prev . " <span class=\"font\">$page_num of $max_page</span> " . $next . $last;
}
include "footer.php";
?>

coniuratus

9:22 am on Jun 17, 2007 (gmt 0)

10+ Year Member



The only reply that makes sense to me is the reply from Habtom, if someone can show me an example on how to use a session to resolve the problem it would be great, It's to difficult for me :(
Thanks a lot for trying.

henry0

11:24 am on Jun 17, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



// top of each relevant page
session_start();
// after the line that reads $trinite=$_POST['trinite'];
// start trinite session
$_SESSION['trinite']=$trinite;
$trinite=$_SESSION['trinite'];
// at this point you have declared a session named trinite
// next to make it available on each page (Where you need it):
// simlpy again on top of each page add
session_start();
$trinite=$_SESSION['trinite'];
// from there it is available to the rest of your script for that very page.. and so going on...

You may declare as many sessions as you need
but you only need to type start session once per page
session_start();

coniuratus

12:27 pm on Jun 17, 2007 (gmt 0)

10+ Year Member



$_POST['trimite']; ---- is from a form button witch is like this:
<input name="Trimite" type="submit" class="searchbutton" value="Cauta">
at the end of the script, and it checks if is set like this: 

if (isset($_POST['Trimite']))
{ 
/*it doesn't recognize the "$_POST['Trimite']" for all the pages */
$trimite=$_POST['Trimite']; // trimite in english means send
$_SESSION['trimite']=$trimite;
$trimite=$_SESSION['trimite'];
$tip = $_POST['tip'];
$judet = $_POST['Judete'];
if (($judet == 'Toate') && ($tip == 'Toate')){
$rezultate_maxime_in_linie = 1;
$rezultate_maxime_in_jos = 2;
$totale = mysql_result(mysql_query('SELECT COUNT(*) as Num FROM `anunturi`
WHERE categorii = "afaceri"'),0);
if(!isset($_GET['page'])) $page = 1;
else $page = $_GET['page'];
$cerereSQL = mysql_query('SELECT * FROM `anunturi` WHERE categorii = "afaceri" ORDER by `id` ASC LIMIT '.(($page * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)) - ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie)).', '.($rezultate_maxime_in_jos*$rezultate_maxime_in_linie).' ');
$pagini_totale = ceil($totale / ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie));
if($page > $pagini_totale) echo 'Pagina nu a fost gasita';
elseif($pagini_totale > 0) {
$seteaza = 0;
$numar = ($page - 1) * ($rezultate_maxime_in_jos*$rezultate_maxime_in_linie);
 $culoare_celula = '#FFE0B3';
 echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
$numar++;
if($seteaza == $rezultate_maxime_in_linie) {
 echo "</tr><tr>\n";
$seteaza = 1;
 if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
 else $culoare_celula = "#FFE0B3";
 } else $seteaza++;
 echo "<td bgcolor=".$culoare_celula.">
 ".$numar."
 ".$rand['categorii']."
 ".$rand['tip']."
 ".$rand['judet']."
 ".$rand['anunt']."
 ".$rand['data']."
 ".$rand['telefon']."
 ".$rand['pret']."
 ".$rand['moneda']."</td>\n";
}
 echo "</tr></table>";
if($pagini_totale == 1) echo '';
else {
echo '<div align="center">';
if($page > 1) {
 $inapoi = ($page - 1);
 echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inapoi.'">&laquo;</a>&nbsp;';
}
for($pagini = 1; $pagini <= $pagini_totale; $pagini++){
 if(($page) == $pagini) echo '<b>'.$pagini.'</b>&nbsp;';
else echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$pagini.'">'.$pagini.'</a>&nbsp;';
}
if($page < $pagini_totale) {
$inainte = ($page + 1);
echo '<a href="'.$_SERVER['PHP_SELF'].'?pagina=afaceri&page='.$inainte.'">&raquo;</a>&nbsp;';
}
echo '</div>';
 }
}
} 
}else {
echo 'Selecteza tipul anuntului si judetul<br><br><br>
<form method="post" class="cauta" action="">
<select name="tip">
<option>Toate</option>
<option>Afaceri-oferte</option>
<option>Afaceri-cereri</option>
</select>&nbsp;&nbsp;&nbsp;
<select name="Judete">
<option>Toate</option>
<option>Alba</option>
<option>Arad</option>
<option>Arges</option>
<option>Bacau</option>
<option>Bihor</option>
<option>Bistrita</option>
<option>Botosani</option>
<option>Braila</option>
<option>Brasov</option>
<option>Bucuresti</option>
<option>Buzau</option>
<option>Calarasi</option>
<option>Caras</option>
<option>Cluj</option>
<option>Constanta</option>
<option>Covasna</option>
<option>Dambovita</option>
<option>Dolj</option>
<option>Galati</option>
<option>Giurgiu</option>
<option>Gorj</option>
<option>Harghita</option>
<option>Hunedoara</option>
<option>Ialomita</option>
<option>Iasi</option>
<option>Ilfov</option>
<option>Maramures</option>
<option>Mehedinti</option>
<option>Mures</option>
<option>Neamt</option>
<option>Olt</option>
<option>Prahova</option>
<option>Salaj</option>
<option>Satu-mare</option>
<option>Sibiu</option>
<option>Suceava</option>
<option>Teleorman</option>
<option>Timis</option>
<option>Tulcea</option>
<option>Valcea</option>
<option>Vaslui</option>
<option>Vrancea</option>
</select><br><br><br>
<input name="Trimite" type="submit" class="searchbutton" value="Cauta">
 </form>';
 }
?>

My question is how and where can i use the session for the next and previous pages?
I know that sounds stupid but I don't get it.
If someone explains me and I don't get I am hopeless, I'll throw myself to the garbage.

henry0

1:28 pm on Jun 17, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I did not figure that trinite was a button

however we need to know what the error is
since it uses SELF the script should be ok as is and not require furhter sessions

but again it's a long script and I do not understand the wordings
Please,post the error.

coniuratus

1:43 pm on Jun 17, 2007 (gmt 0)

10+ Year Member



Thats just it, it doesn't show me any errors, it works great, but when i click to go to the next pages and previous ones it redirects me to the search page, I have to click again the "trimite" button to go to the page that I want to go.

henry0

4:03 pm on Jun 17, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



try this

echo "<table border=\"1\"><tr>\n";
while($rand = mysql_fetch_array($cerereSQL)) {
// $numar++;

if($seteaza == $rezultate_maxime_in_linie) {
echo "</tr><tr>\n";
$seteaza = 1;
if($culoare_celula == "#FFE0B3") $culoare_celula = "#FFFFFF";
else $culoare_celula = "#FFE0B3";
} else $seteaza++;
echo "<td bgcolor=".$culoare_celula.">
".$numar."
".$rand['categorii']."
".$rand['tip']."
".$rand['judet']."
".$rand['anunt']."
".$rand['data']."
".$rand['telefon']."
".$rand['pret']."
".$rand['moneda']."</td>\n";
}
$numar++;
echo "</tr></table>";

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

  1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 6:32 am May 2, 2026