Learn VBA & Macros in 1 Week!

PHP - I'm Getting This Error From A Pdo Connection

Full Excel VBA Course - Beginner to Expert

I'm Getting This Error From A Pdo Connection	View Content

Hi I have been following a youtube tutorial trying to update my php knowledge and they use pdo to create the DB wrapper class and once i load my index.php through WAMP server i get the following on screen error:

Quote

SQLSTATE[HY000] [1049] Unknown database 'lr'

THIS IS THE DB CLASS FILE,

<?php
class DB {
   private static $_instance = null;
   private $_pdo,
   $_query,
   $_error = false,
   $_results,
   $_count = 0;

   private function __construct() {
       try {
           $this->_pdo = new PDO('mysql:host=' . Config::get('mysql/host') . ';dbname=' . Config::get('mysql/db'), Config::get('mysql/username'), Config::get('mysql/password'));
       } catch(PDOException $e) {
           die($e->getMessage());
       }
   }

   public static function getInstance() {
       if(!isset(self::$_instance)) {
           self::$_instance = new DB();
       }
       return self::$_instance;
   }

   public function query($sql, $params = array()) {
       $this->_error = false;
       if($this->_query = $this->_pdo->prepare($sql)) {
           $x = 1;
           if(count($params)) {
               foreach($params as $param) {
                   $this-> _query->bindValue($x, $param);
                   $x++;
               }
           }

           if($this->_query->execute()) {
               $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ);
               $this->count = $this->_query->rowCount();
           } else {
               $this->_error = true;
           }
       }

       return $this;
   }

   public function action($action, $table, $where = array()) {
       if(count($where) === 3) {
           $operators = array('=', '>', '<', '>=', '<=');

           $field = $where[0];
           $operator = $where[1];
           $value = $where[2];

           if(in_array($operator, $operators)) {
               $sql = "{$action} FROM {$table} WHERE {$field} {$operator} ?'";

               if(!$this->query($sql,array($value))->error()) {
                   return $this;
               }
           }
       }
       return false;
   }

   public function get($table, $where) {
       return $this->action('SELECT *', $table, $where);
   }

   public function delete($table, $where) {
       return $this->action('DELETE', $table, $where);
   }

   public function insert($table, $fields = array()) {
       if(count($fields)) {
           $keys = array_keys($fields);
           $values = '';
           $x = 1;

           foreach($field as $field) {
               $values .= '?';
               if($x < count($fields)) {
                   $values .= ', ';
               }
               $x++;
           }

           $sql = "INSERT INTO users (`" . implode('`,`', $keys) . "`) VALUES ({$values})";

           if(!$this->query($sql, $fields)->error()) {
               return true;
           }
       }
       return false;
   }

   public function results() {
       return $this->_results;
   }

   public function first() {
       return $this->results()[0];
   }

   public function error() {
       return $this->_error;
   }

   public function count() {
       return $this->_count;
   }

}

THIS IS THE INIT.PHP FILE

<?php
session_start();

$GLOBALS['config'] = array (
   'mysql' => array(
       'host' => '127.0.0.1',
       'username' => 'root',
       'password' => '',
       'db' => 'lr'
   ),
   'remember' => array(
       'cookie_name' => 'hash',
       'cookie_expiry' => 604800
   ),
   'session' => array(
       'session_name' => 'user'
   )
);

spl_autoload_register(function ($class) {
require_once 'classes/' . $class . '.php';
});

require_once 'functions/sanitize.php';

and this is the index.php file

<?php
require_once 'core/init.php';

$user = DB::getInstance()->query("SELECT username FROM users WHERE username = ?", array('alex'));

   if(!$user->count()) {
       echo 'No user';
   } else {
       echo 'OK';
   }

Edited January 17, 2020 by Michael_Baxter

Full Excel VBA Course - Beginner to Expert

Error In Db Connection : Parse Error: Syntax Error, Unexpected T_string

Similar Tutorials

PHP - I'm Getting This Error From A Pdo Connection

I'm Getting This Error From A Pdo Connection

Similar Tutorials

Error In Db Connection : Parse Error: Syntax Error, Unexpected T_string

Database Connection Error

Which Mysqli Connection Error Format To Use ?

Different Error Messages In Connection Mysqli Script.

Mysql_query Syntax Error Database Connection

Https Shopping Cart And Connection Interrupted Error

"couldn't Fetch Mysqli" Error, But Connection Isn't Closed

Connection String Showing As Comment On Page, With No Error Message Showing

Php/sql If No Connection Die

Sql Connection

Connection To A Db

Vpn Connection Using Php

Connection

A Php Error Was Encountered Severity: Error Message: Maximum Execution Time Of 120 Seconds Exceeded Error

Fatal Error: Uncaught Exception 'pdoexception' With Message 'sqlstate[42000]: Syntax Error Or Access Violation: 1064 You Have An Error In Your Sql Syn

More Than One Database Connection ??

Connection Established

Php Connection To Database.

Connection To Db From Web Page

Get Connection Type By Ip