Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $db = mysqli_connect('localhost', 'root', '', 'cdb')
- or die('Error connecting');
- if( isset($_REQUEST['page'])) {
- $_SESSION['page'] = $_REQUEST['page'];
- }else{
- $_SESSION['page'] = 1;
- }
- $records_per_page = 8;
- $where = substr($where, 0, -3);
- $query = "SELECT * FROM cars
- ".$where."";
- $result = mysqli_query($db, $query)
- or die("Error in query: '$query'");
- $row = mysqli_fetch_assoc($result);
- $i = 0;
- $start = ($_SESSION['page'] - 1) * $records_per_page;
- $end = ($_SESSION['page']) * $records_per_page;
- while($row = mysqli_fetch_assoc($result) and $i < $end)
- {
- $i++;
- if( $i > $start )
- {
- echo'
- <div class="result_main flip'.$i.' shadow2">
- <div class="main_result_carname">
- <h2><b>'.$row['make'].' '.$row['model'].'</b></h2>
- </div>
- <div class="main_result_carprice">
- <h2><b>£'.$row['price'].'</b></h2>
- </div>
- </div>';
- }
- }
- ?>
- $row = mysqli_fetch_assoc($result);
- $i = 0;
- $result = mysqli_query($db, $query)
- or die("Error in query: '$query'");
- $row = mysqli_fetch_assoc($result);
- $i = 0;
- while($row = mysqli_fetch_assoc($result) and $i < $end)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement