Advertisement
Guest User

Untitled

a guest
Jul 5th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.59 KB | None | 0 0
  1.         $pdo = connectToDB();
  2.         $userData = getUserData($pdo);
  3. function getUserData($pdo) {
  4.     $data = $pdo->prepare("SELECT User_ID FROM Users WHERE Username = :username AND Password = :password");
  5.     $data->bindValue(':username', trim($_POST['username']));
  6.     $data->bindValue(':password', trim($_POST['password']));
  7.     $data->execute();
  8.     $x = $data->columnCount();
  9.     print($x);
  10. }
  11. function connectToDB() {
  12.     require_once 'config.php';
  13.     if($pdo = new PDO('mysql:host='.HOST.';port='.PORT.';dbname='.DB.';charset=utf8' , USER, PASSWORD))
  14.         return $pdo;
  15.     else
  16.         return "Couldn't connect to Database";
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement