Advertisement
Guest User

Untitled

a guest
Oct 28th, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1. <?php
  2.  
  3.   class databaseConnect {
  4.  
  5.     public function __construct($serverName, $dbName, $dbUsername, $dbPassword) {
  6.       $this->serverName = $serverName;
  7.       $this->dbName = $dbName;
  8.       $this->dbUsername = $dbUsername;
  9.       $this->dbPassword = $dbPassword;
  10.     }
  11.  
  12.     public function databaseQuery() {
  13.       $conn = new PDO("mysql:host={$this->serverName};dbname={$this->dbName}", $this->dbUsername, $this->dbPassword);
  14.       $query = $conn->query("Select * from posts");
  15.       foreach ($query as $row) {
  16.         echo $row['id'] . ".<br>";
  17.         echo $row['subject'] . ".<br>";
  18.         echo $row['content'] . "<br>";
  19.         echo $row['date'] . ".<br>";
  20.       }
  21.     }
  22.   }
  23.   $classname = new databaseConnect("Localhost", "phplessons", "root", "");
  24.   $classname->databaseQuery();
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement