Advertisement
Guest User

Untitled

a guest
Apr 1st, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.50 KB | None | 0 0
  1. private $dbhost='localhost:3306';
  2. private $dbuser='WebDes';
  3. private $dbpass='1111';
  4. private $dbname='db_lb4_32_2019';
  5. private $mysqli_con;
  6.  
  7. private $pdo_con;
  8. private $pdo_host='localhost';
  9. private $pdo_port='3306';
  10.  
  11. /*подключение mysqli*/
  12. public function connect() {
  13.      $this->mysqli_con = new mysqli($this->dbhost, $this->dbuser, $this->dbpass, $this->dbname);
  14.      $this->mysqli_con->query("SET CHARACTER SET 'utf8'");
  15. }
  16.  
  17. /*подключение PDO
  18. пример:
  19. $dsn = "mysql:host=localhost;port=3306;dbname=solar_system;charset=utf8";
  20. $options = [
  21.       PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  22.       PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
  23.     ];
  24. $pdo = new PDO($dsn, 'testuser', 'testpassword', $options);
  25. $pdo->query("SELECT * FROM dogovor");
  26. */
  27. public function pdo_connect() {
  28.     try {
  29.         //точка "." в php это конкатенация(объединение) строк, если что
  30.       $this->pdo_con = new PDO('mysql:host='.$this->pdo_host.';port='.$this->pdo_port.';dbname='.$this->dbname.'; charset=utf8', $this->dbuser, $this->dbpass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
  31.     } catch (PDOException $e) {
  32.       echo 'unable to connect';
  33.     }
  34. }
  35.  
  36. /*пример запроса для mysqli*/
  37. public function mysqli_query() {
  38.     return $this->mysqli_com->query("SELECT * FROM dogovor");
  39. }
  40.  
  41. /*пример запроса для PDO*/
  42. public function pdo_query() {
  43.     return $this->pdo_con->query("SELECT * FROM dogovor");
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement