Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $webserver = 'localhost';
- $administrator = 'root';
- $password = '';
- $db_name = 'cdb';
- $db = mysqli_connect($webserver, $administrator, $password, $db_name)
- or die('Error connecting');
- if( isset($_REQUEST['page']))
- {
- $_SESSION['page'] = $_REQUEST['page'];
- }
- else
- {
- $_SESSION['page'] = 1;
- }
- $records_per_page = 8;
- $query = " SELECT *
- FROM cars, users
- WHERE cars.dealerID = users.dealerID
- AND users.username = '".$_GET['username']."'";
- $result = mysqli_query($db, $query)
- or die("Error in query: '$query'");
- $row = mysqli_fetch_assoc($result);
- $i = 1;
- $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 )
- {
- <div>
- delete
- </div>
- <div of magic n' fairies>
- echo $row['informationandstuff'];
- </div>
- }
- }
- function deleteCar()
- {
- $delete = "DELETE FROM cars
- WHERE carindex = '".$i"'";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement