Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('max_execution_time',3600);
- Class Database4{
- protected $username;
- protected $password;
- protected $server;
- protected $dbName;
- public $conn;
- public function __construct(){
- $this->connection();
- }
- public function __destruct(){
- $this->conn=null;
- }
- protected function connection(){
- try{
- $this->username='dummyUser';
- $this->password='dummyPass';
- $this->server='192.168.0.42';
- $this->dbName='dummyDatabase';
- $this->conn=new PDO('dblib:host='.$this->server.':1433;dbname='.$this->dbName, $this->username, $this->password);
- } catch (PDOException $e){echo "Error: ".$e->getMessage();}
- }
- public function insert($sqlInsert){
- $stmt=$this->conn->prepare($sqlInsert);
- $stmt->execute();
- return $stmt;
- }
- public function update($sqlUpdate){
- $stmt=$this->conn->prepare($sqlUpdate);
- $stmt->execute();
- return $stmt;
- }
- public function delete($sqlDelete){
- $stmt=$this->conn->prepare($sqlDelete);
- $stmt->execute();
- return $stmt;
- }
- public function select($sqlSelect){
- $stmt=$this->conn->prepare($sqlSelect);
- $stmt->execute();
- return $stmt;
- }
- public function numofrows($sql){
- $stmt=$this->conn->prepare($sql);
- $stmt->execute();
- $numofrows= count($stmt->fetchAll());
- return $numofrows;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement