Guest User

Untitled

a guest
Mar 28th, 2019
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.65 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 = $_REQUEST['id'];
  9.  
  10.     try
  11.     {
  12.         $pdo = new PDO('mysql:host='.$sql_servername.';dbname='.$sql_database,$sql_username,$sql_password);
  13.         $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  14.  
  15.         //echo "Connected successfully";
  16.     }
  17.     catch (PDOException $e)
  18.     {
  19.     echo "Connection failed: " .$e->getMessage();
  20.     }
  21.  
  22.     $stmt1 = $pdo->prepare('SELECT * FROM customers WHERE id = ' . $uID);
  23.     $stmt1->execute();
  24.     $userInfo = $stmt1->fetch();
Add Comment
Please, Sign In to add comment