Guest User

Untitled

a guest
Nov 17th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. class Database{
  2. public $isConn;
  3. protected $datab;
  4.  
  5. // connect to db
  6. public function __construct($username = "root", $password = "", $host = "localhost", $dbname = "mcland", $options = []){
  7. $this->isConn = TRUE;
  8. try {
  9. $this->datab = new PDO("mysql:host={$host};dbname={$dbname};charset=utf8", $username, $password, $options);
  10. $this->datab->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  11. $this->datab->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
  12. } catch (PDOException $e) {
  13. throw new Exception($e->getMessage());
  14. }
  15.  
  16. }
  17.  
  18. // disconnect from db
  19. public function Disconnect(){
  20. $this->datab = NULL;
  21. $this->isConn = FALSE;
  22. }
  23. // get row
  24. public function getRow($query, $params = []){
  25. try {
  26. $stmt = $this->datab->prepare($query);
  27. $stmt->execute($params);
  28. return $stmt->fetch();
  29. } catch (PDOException $e) {
  30. throw new Exception($e->getMessage());
  31. }
  32. }
  33. // get rows
  34. public function getRows($query, $params = []){
  35. try {
  36. $stmt = $this->datab->prepare($query);
  37. $stmt->execute($params);
  38. return $stmt->fetchAll();
  39. } catch (PDOException $e) {
  40. throw new Exception($e->getMessage());
  41. }
  42. }
  43. // insert row
  44. public function insertRow($query, $params = []){
  45. try {
  46. $stmt = $this->datab->prepare($query);
  47. $stmt->execute($params);
  48. return TRUE;
  49. } catch (PDOException $e) {
  50. throw new Exception($e->getMessage());
  51. }
  52. }
  53. // update row
  54. public function updateRow($query, $params = []){
  55. $this->insertRow($query, $params);
  56. }
  57. // delete row
  58. public function deleteRow($query, $params = []){
  59. $this->insertRow($query, $params);
  60. }
  61. }
  62.  
  63. class Users extends Database
  64. {
  65. public function shows() {
  66. $getRows = $this->datab->getRows("SELECT * FROM users");
  67. die_r($getRows);
  68. $this->datab->Disconnect();
  69. }
  70. }
  71.  
  72. Fatal error: Uncaught Error: Using $this when not in object context in
Add Comment
Please, Sign In to add comment