Пагинатор

[Siberio]

Здравствуйте!

Как можно сделать лимит 6 из строк таблицы на страницу на пагинаторе (paginator) используя данный снизу поисковик?


<?php

session_start();

$webserver = 'localhost';
$administrator = 'root';
$password = '';
$db_name = 'carslist';
$db = mysqli_connect($webserver, $administrator, $password, $db_name)
or die('Error connecting');


$return_string = "<tr><td colspan=6> Enter something to search </td></tr>"; // Default message
if(isset($_REQUEST['search_term'])){
$shortened_term = substr($_REQUEST['search_term'],0, 20); // To keep the search term short
$stripped_term = strip_tags($shortened_term); // To prevent embedded HTML
$safe_term = mysqli_real_escape_string($db, $stripped_term); // To prevent an SQL injection attack
if($safe_term != "") {
echo $query = "SELECT * FROM cars WHERE make like '%$safe_term%' OR model like '%$safe_term%' OR colour like '%$safe_term%'
OR dealer like '%$safe_term%' OR town like '%$safe_term%'";
$result = mysqli_query($db, $query)
or die("Error in query: '$query'");
$return_string = "<tr>";
if ($result->num_rows > 0){
while($row = mysqli_fetch_assoc($result)) {
$return_string .= "<td> " . $row['carIndex'] . " </td>";
$return_string .= "<td> " . $row['make'] . " </td>";
$return_string .= "<td> " . $row['model'] . " </td>";
$return_string .= "<td> " . $row['Reg'] . " </td>";
$return_string .= "<td> " . $row['colour'] . " </td>";
$return_string .= "<td> " . $row['miles'] . " </td>";
$return_string .= "<td> " . $row['price'] . " </td>";
$return_string .= "<td> " . $row['dealer'] . " </td>";
$return_string .= "<td> " . $row['town'] . " </td>";
$return_string .= "<td> " . $row['telephone'] . " </td>";
$return_string .= "<td> " . $row['description'] . " </td>";

$return_string .= "<td> " . $row['region'] . " </td>";
$carindex = $row['carIndex'];
$return_string .= "<td><input type='radio' onchange = 'choosecar($carindex)' onClick='resetMeIfChecked(this)'></td>";


if (isset($_SESSION['admin']))
{
if ($_SESSION['admin'] == true)
{
$return_string .="<form method='post' action='editcar1.php'>";
$return_string .='<td> <button type="submit" class="btn btn-default" id="edit" value='.$row['carIndex'].' name="edit" >EDIT</button> </td>';
$return_string .="</td>";
$return_string .='<td><button type="submit" class="btn btn-default" id="delete" value='.$row['carIndex'].' name="delete" >DELETE</button> </td>';
$return_string .='</td>';
$return_string .='</form>';


}
}
$return_string .= '</tr>';


}

}
}
}

echo $return_string;
?>

Спасибо!

[p51x]

http://programmersforum.ru/showthread.php?t=260193