Potrebno mi je da izlistam neke podatke iz baze uz pomoc pretrage, a da podaci budu podeljene po stranama (pagination).


Forma

<form action="index. php" method="post" name="search">
<input name="search" type="hidden" value="search">
<input name="keyword" type="text" value="keyword" size="30" maxlength="30">
<input name="search" type="submit" value="search">
</form>


query

SELECT * FROM websites WHERE `title` LIKE '%$SearchString%' OR `url` LIKE '%$SearchString%' OR `description` LIKE '%$SearchString%'



Pagination


<?php
/*
Place code to connect to your DB here.
*/
include('config. php');   // include your code to connect to DB.

$tbl_name="";    //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;

/*
First get total number of rows in data table.  
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

/* Setup vars for query.  */
$targetpage = "filename. php"; //your file name (the name of this file)
$limit = 2; //how many items to show per page
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0;    //if no page var is given, set start to 0

/* Get data.  */
$sql = "SELECT column_name FROM $tbl_name LIMIT $start, $limit";
$result = mysql_query($sql);

/* Setup page vars for display.  */
if ($page == 0) $page = 1;    //if no page var is given, default to 1.
$prev = $page - 1;    //previous page is page - 1
$next = $page + 1;    //next page is page + 1
$lastpage = ceil($total_pages/$limit);    //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1;    //last page minus 1

/*
Now we apply our rules and draw the pagination object.  
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{   
$pagination . = "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination. = "<a href=\"$targetpage?page=$prev\">« previous</a>";
else
$pagination. = "<span class=\"disabled\">« previous</span>";   

//pages   
if ($lastpage < 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
{   
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination. = "<span class=\"current\">$counter</span>";
else
$pagination. = "<a href=\"$targetpage?page=$counter\">$counter</a>";   
}
}
elseif($lastpage > 5 + ($adjacents * 2))   //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))   
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination. = "<span class=\"current\">$counter</span>";
else
$pagination. = "<a href=\"$targetpage?page=$counter\">$counter</a>";   
}
$pagination. = ". . . ";
$pagination. = "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination. = "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";   
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination. = "<a href=\"$targetpage?page=1\">1</a>";
$pagination. = "<a href=\"$targetpage?page=2\">2</a>";
$pagination. = ". . . ";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination. = "<span class=\"current\">$counter</span>";
else
$pagination. = "<a href=\"$targetpage?page=$counter\">$counter</a>";   
}
$pagination. = ". . . ";
$pagination. = "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination. = "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";   
}
//close to end; only hide early pages
else
{
$pagination. = "<a href=\"$targetpage?page=1\">1</a>";
$pagination. = "<a href=\"$targetpage?page=2\">2</a>";
$pagination. = ". . . ";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination. = "<span class=\"current\">$counter</span>";
else
$pagination. = "<a href=\"$targetpage?page=$counter\">$counter</a>";   
}
}
}

//next button
if ($page < $counter - 1)
$pagination. = "<a href=\"$targetpage?page=$next\">next »</a>";
else
$pagination. = "<span class=\"disabled\">next »</span>";
$pagination. = "</div>\n";   
}
?>

<?php
while($row = mysql_fetch_array($result))
{

// Your while loop here

}
?>

<?=$pagination?>





Jel zna neko ovo da sastavi ????

Ovaj tutorijal ti je dobar, imas lepo objasnjeno kako funkcionise:
http://php.about.com/od/phpwithmysql/ss/php_pagination_2.htm

Jel moze neka konkretna pomoc oko koda.

Sta ti nije jasno u tutorijalu koji sam ti poslao?

Tutorijal je o paginaciji, ja znam da odradim paginaciju, znam da odradim i pretragu ali neznam da napravim skriptu koja ce da radi i pretragu i paginaciju. Znaci potrebno mi je da se gore navedene skripte povezu u jednu.

Ajmo sad ovako, ti hoces da se ukuca neka rec i da se u bazi pronadju te reci i izlistaju na stranici? Ako je tako, ti bi trebalo da povezes ove input box-ove sa samim upitom, sto znaci, da vrednost input boxa ubacis u bazu:


Ovo je ugrubo, ti sad vidi da li mozes nesto da iskoristis od toga. Ti pretragu mozes da odradis u samom upitu, koji ti kasnije izlistava podatke i ukoliko ih ima vise ti pravis paginaciju i podatke prebacujes na sledecu stranu.

Nadam se da je to sto trazis.

Skripta koja meni treba, izgleda otprilike ovako:















Ovo sam sam sklapao pa naravno ne radi, bilo bi dobro ako bi mi pokazao gde gresim.

A sta ne radi? Da li izbacuje neku gresku ili ne izbacuje dobre podatke? Da li je ovaj upit gore bas taj koji tebi treba ili si samo pokupio sa nekog sajta? Ako budem imao vremena gledacu da iskoristim ovaj upit, ako je to pravi upit koji ti treba, ovu forum i da napisem kod, koji ce ti izvlaciti podatke iz baze i prikazivati iste.

Ne izbacuje nikakvu gresku, pretraga radi dobro ali paginacija se ne pojavljuje. Taj mi upit treba. Hvala ti u svakom slucaju, bas sam te iscimao oko ovoga.

Uz mnogo muke, uspeo sam !!!!