Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. $webserver = 'localhost';
  2. $administrator = 'root';
  3. $password = '';
  4. $db_name = 'cdb';
  5. $db = mysqli_connect($webserver, $administrator, $password, $db_name)
  6. or die('Error connecting');
  7.  
  8. if( isset($_REQUEST['page']))
  9. {
  10. $_SESSION['page'] = $_REQUEST['page'];
  11. }
  12. else
  13. {
  14. $_SESSION['page'] = 1;
  15. }
  16. $records_per_page = 8;
  17.  
  18. $query = " SELECT *
  19. FROM cars, users
  20. WHERE cars.dealerID = users.dealerID
  21. AND users.username = '".$_GET['username']."'";
  22.  
  23. $result = mysqli_query($db, $query)
  24. or die("Error in query: '$query'");
  25. $row = mysqli_fetch_assoc($result);
  26. $i = 1;
  27. $start = ($_SESSION['page'] - 1) * $records_per_page;
  28. $end = ($_SESSION['page']) * $records_per_page;
  29. while($row = mysqli_fetch_assoc($result) and $i < $end)
  30. {
  31. $i++;
  32. if( $i > $start )
  33. {
  34. <div>
  35. delete
  36. </div>
  37. <div of magic n' fairies>
  38. echo $row['informationandstuff'];
  39. </div>
  40. }
  41. }
  42.  
  43. function deleteCar()
  44. {
  45. $delete = "DELETE FROM cars
  46. WHERE carindex = '".$i"'";
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement