Advertisement
Guest User

Untitled

a guest
Oct 14th, 2017
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.88 KB | None | 0 0
  1. ####################### getUsers.php file ############################
  2.  
  3. <?php
  4.  
  5. /** MySQL settings **/
  6. /** The name of the database for WordPress **/
  7. define('DB_NAME', 'test_db');
  8. /** MySQL database username */
  9. define('DB_USER', 'testuser');
  10. /** MySQL database password */
  11. define('DB_PASSWORD', 'testpass');
  12. /** MySQL hostname */
  13. define('DB_HOST', 'localhost');
  14.  
  15. require_once('application/classes/database.php');
  16.  
  17. function die_r($value)
  18. {
  19.     echo '<pre>';
  20.     print_r($value);
  21.     echo '</pre>';
  22.     die();
  23. }
  24.  
  25.  
  26. $db = new Database();
  27.  
  28. $getRow = $db->getRow("SELECT * FROM users WHERE userID = ?", ["1"]);
  29.  
  30. die_r($getRow);
  31.  
  32. ######################  database.php file ###############################
  33. <?php
  34.  
  35. /******  SETUP DATABASE CLASS ******/
  36.  
  37. class Database {
  38.  
  39.     /***  CONNECT TO THE DATABASE  ***/
  40.     public $isConnected;
  41.     protected $datab;
  42.  
  43.     public function __construct($dbhost = DB_HOST, $dbname = DB_NAME, $dbuser = DB_USER, $dbpass = DB_PASSWORD)
  44.                 {
  45.         $this->isConn = TRUE;
  46.  
  47.         try{
  48.                         $this->datab = new PDO ( "mysql:host={$dbhost};dbname={$dbname};charset=utf8", $dbuser, $dbpass);
  49.             $this->datab->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
  50.             $this->datab->setAttribute( PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC );
  51.         } catch ( PDOException $e ) {
  52.             $this->isConn = FALSE;
  53.             throw new Exception ($e->getMessage () );
  54.         }
  55.     }
  56.  
  57.     /***  DISCONNECT FROM DATABASE  ***/
  58.  
  59.     public function Disconnect(){
  60.         $this->datab = NULL;
  61.         $this->isConn = FALSE;
  62.     }
  63.  
  64.     /***  GET ROW  ***/
  65.  
  66.     public function getRow($query, $params = []){
  67.             try {
  68.                 $stmt = $this->datab->prepare($query);
  69.                 $stmt->execute($params);
  70.                 return $stmt->fetch();
  71.             } catch ( PDOException $e ) {
  72.                 throw new Exception ($e->getMessage () );
  73.             }
  74.     }
  75. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement