Advertisement
Guest User

Untitled

a guest
Dec 21st, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.44 KB | None | 0 0
  1. <?
  2. Class DB {
  3.    
  4.     /*public $host = '127.0.0.1';
  5.    public $db   = 'Feedback';
  6.     public $user = 'root';
  7.     public $pass = '';
  8.    public $charset = 'utf8';
  9.  
  10.     public $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  11.    public  $opt = [
  12.         PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
  13.         PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  14.         PDO::ATTR_EMULATE_PREPARES   => false,
  15.     ];
  16.    public $pdo = new PDO($dsn, $user, $pass, $opt);*/
  17.    public $host;
  18.    public $db;
  19.    public $charset;
  20.    public $pdo;
  21.    public function __construct(){
  22.    $this->db = '127.0.0.1';
  23.    $this->host = 'Feedback';
  24.    $this->charset = 'utf8';
  25.    var user = 'root';
  26.    var pass = '';
  27.    var dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  28.    var opt = [
  29.         PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
  30.         PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  31.         PDO::ATTR_EMULATE_PREPARES   => false,
  32.     ];
  33.     //$this->dsn->user->pass->opt->pdo = new PDO($dsn, $user, $pass, $opt);
  34.     $this->pdo = new PDO(dsn, user, pass, opt);
  35.    }
  36.    
  37.     function add ($name,$email,$text,$homepage='')
  38.     {
  39.          //$sql = "INSERT INTO `feedback` (`name`, `email`,`homepage`,`text`) VALUES ('{$name}','{$email}','{$homepage}','{$text}')";
  40.         //$sth = $pdo->query($sql);
  41.         $this->pdo->query("INSERT INTO `feedback` (`name`, `email`,`homepage`,`text`) VALUES ('{$name}','{$email}','{$homepage}','{$text}')");
  42.     }
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement