Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class MyDB{
- private $spojeni;
- function __construct($type,$host,$user,$pass,$name){
- $options=array(
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
- );
- $this->spojeni= @new PDO("$type:host=$host;dbname=$name",$user,$pass,$options);
- }
- function query($query,$param=Array()){
- $navrat=$this->spojeni->prepare($query);
- $navrat->execute($param);
- return $navrat->rowCount();
- }
- function queryOne($query,$param=Array()){
- $navrat=$this->spojeni->prepare($query);
- $navrat->execute($param);
- return $navrat->fetch(PDO::FETCH_ASSOC);
- }
- function queryAll($query,$param=Array()){
- $navrat=$this->spojeni->prepare($query);
- $navrat->execute($param);
- return $navrat->fetchAll(PDO::FETCH_ASSOC);
- }
- function getID($what){
- $value=$this->queryOne("SELECT currval('$what') AS lastid");
- return $value['lastid'];
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement