Advertisement
Guest User

FileA.php

a guest
Sep 26th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. <?php
  2. ini_set('max_execution_time',3600);
  3. Class Database4{
  4. protected $username;
  5. protected $password;
  6. protected $server;
  7. protected $dbName;
  8. public $conn;
  9.  
  10. public function __construct(){
  11. $this->connection();
  12. }
  13. public function __destruct(){
  14. $this->conn=null;
  15. }
  16. protected function connection(){
  17. try{
  18. $this->username='dummyUser';
  19. $this->password='dummyPass';
  20. $this->server='192.168.0.42';
  21. $this->dbName='dummyDatabase';
  22. $this->conn=new PDO('dblib:host='.$this->server.':1433;dbname='.$this->dbName, $this->username, $this->password);
  23. } catch (PDOException $e){echo "Error: ".$e->getMessage();}
  24. }
  25.  
  26. public function insert($sqlInsert){
  27. $stmt=$this->conn->prepare($sqlInsert);
  28. $stmt->execute();
  29. return $stmt;
  30. }
  31.  
  32. public function update($sqlUpdate){
  33. $stmt=$this->conn->prepare($sqlUpdate);
  34. $stmt->execute();
  35. return $stmt;
  36. }
  37. public function delete($sqlDelete){
  38. $stmt=$this->conn->prepare($sqlDelete);
  39. $stmt->execute();
  40. return $stmt;
  41. }
  42. public function select($sqlSelect){
  43. $stmt=$this->conn->prepare($sqlSelect);
  44. $stmt->execute();
  45. return $stmt;
  46. }
  47. public function numofrows($sql){
  48. $stmt=$this->conn->prepare($sql);
  49. $stmt->execute();
  50. $numofrows= count($stmt->fetchAll());
  51. return $numofrows;
  52. }
  53. }
  54. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement