Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.89 KB | None | 0 0
  1. <?php
  2. $profile_id = $_GET['id'];
  3.  
  4. if(!is_numeric($profile_id)) {
  5. echo '<p align="center">Sidan du försöker nå existerar inte</p>';
  6. die();
  7. }
  8.  
  9. if(isset($profile_id)) {
  10. $query = 'SELECT
  11.     gtdr_user.id AS u_id,
  12.     gtdr_user.name AS u_name,
  13.     gtdr_user.email AS u_email,
  14.     gtdr_user.information AS u_information,
  15.     gtdr_user.image AS u_image,
  16.     gtdr_user.age AS u_age,
  17.     gtdr_user.live AS u_live,
  18.     gtdr_user.phone AS u_phone,
  19.    
  20.     gtdr_cars.id AS c_id,
  21.     gtdr_cars.model AS c_model,
  22.     gtdr_cars.img AS c_img
  23.    
  24.     FROM gtdr_user
  25.     LEFT JOIN gtdr_cars
  26.    
  27.     ON gtdr_user.id = gtdr_cars.created_by
  28.     WHERE gtdr_user.id='.$profile_id;
  29.     }
  30.    
  31. $result = mysql_query($query) or die(mysql_error());
  32. $cars = array();
  33. while ($resultdata = mysql_fetch_object($result)) {
  34.     $cars[] = $resultdata;
  35. }
  36.     echo $resultdata->u_name;
  37.     echo '<br>';
  38. foreach($cars as $car) {
  39.     echo $car->c_model;
  40.     echo '<br>';
  41.     }
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement