Guest User

Untitled

a guest
Mar 14th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. class db {
  2. private $host;
  3. private $db_name;
  4. private $db_user;
  5. private $db_password;
  6.  
  7. public function connect() {
  8. $db_name = $this->db_name;
  9. $db_user = $this->db_user;
  10. $db_pass = $this->db_password;
  11. $db_host = $this->host;
  12.  
  13. $db_name = 'database name';
  14. $db_user = 'username';
  15. $db_pass = 'password';
  16. $db_host = 'localhost:3306';
  17.  
  18. try {
  19. $connect = new PDO('mysql:dbname=$db_name;host=$db_host;', $db_user, $db_pass);
  20. $connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  21. echo "Connection Successfull";
  22. } catch(PDOException $e) {
  23. echo "Connection Failed : " . $e->getMessage();
  24. }
  25. }
  26. }
  27.  
  28. $users = new users();
  29. $connection = new db();
  30. $connect = $connection->connect();
  31. $sql = $connect->prepare("SELECT * FROM users");
  32. $sql->execute();
  33. while($data = $sql->fetch(PDO::FETCH_ASSOC)) {
  34. echo $data['name'];
  35. }
Add Comment
Please, Sign In to add comment