Advertisement
Guest User

Untitled

a guest
Apr 1st, 2019
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2.  
  3.     $sql_servername = "sched.rossware.net";
  4.     $sql_username = "Jason";
  5.     $sql_password = "4lGBIzjnwn0rPuOn";
  6.     $sql_database = "JasonDev";
  7.  
  8.     $uID = $_POST['id'];
  9.     // $uID = 2;
  10.  
  11.     try
  12.     {
  13.         $pdo = new PDO('mysql:host='.$sql_servername.';dbname='.$sql_database,$sql_username,$sql_password);
  14.         $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15.  
  16.         //echo "Connected successfully";
  17.     }
  18.     catch (PDOException $e)
  19.     {
  20.     echo "Connection failed: " .$e->getMessage();
  21.     }
  22.  
  23.     $stmt1 = $pdo->prepare('SELECT * FROM customers WHERE id = ' . $uID);
  24.     $stmt1->execute();
  25.     $userInfo = $stmt1->fetch(PDO::FETCH_ASSOC);
  26.  
  27.     // $results = json_encode(array('userInfo', $userInfo));
  28.     // echo $results;
  29.  
  30.     print_r($userInfo);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement