Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class Db
- {
- private $pdo;
- public function __construct($connParams)
- {
- $dsn = 'mysql:host='.$connParams['host'].';dbname='.$connParams['name'].';charset=utf8';
- $connOpt = array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => 1 );
- $this->pdo = new PDO($dsn, $connParams['user'], $connParams['pass'], $connOpt);
- }
- public function query($sql, $options)
- {
- $smt = $this->pdo->prepare($sql);
- $smt->execute($options);
- do
- {
- $resp = $smt->fetchAll();
- if(!empty($resp))
- $data[] = $resp;
- }
- while($smt->nextRowset());
- if(empty($data))
- return false;
- if($isFullResponse)
- return $data;
- return $data;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement