Advertisement
Guest User

Untitled

a guest
Nov 13th, 2016
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. Warning: mysqli_query() expects at least 2 parameters, 1 given in dbcontroller.php on line 49
  2.  
  3. Warning: mysqli_error() expects exactly 1 parameter, 0 given in dbcontroller.php on line 51
  4. Invalid query:
  5.  
  6.  
  7. ----------------------------------------------------------------------------------------------
  8. <?php
  9. class DBController {
  10. private $host = "localhost";
  11. private $user = "";
  12. private $password = "";
  13. private $database = "";
  14.  
  15. function __construct() {
  16. $conn = $this->connectDB();
  17. if(!empty($conn)) {
  18. $this->selectDB($conn);
  19. }
  20. }a
  21.  
  22. function connectDB() {
  23. $conn = mysqli_connect($this->host,$this->user,$this->password);
  24. return $conn;
  25. }
  26.  
  27. function selectDB($conn) {
  28. mysqli_select_db($conn, $this->database);
  29. }
  30.  
  31. function runQuery($query) {
  32. $result = mysqli_query($query);
  33. while($row=mysqli_fetch_assoc($result)) {
  34. $resultset[] = $row;
  35. }
  36. if(!empty($resultset))
  37. return $resultset;
  38. }
  39.  
  40. function numRows($query) {
  41. $result = mysqli_query($query);
  42. $rowcount = mysqli_num_rows($result);
  43. return $rowcount;
  44. }
  45.  
  46. function updateQuery($query) {
  47. $result = mysqli_query($query);
  48. if (!$result) {
  49. die('Invalid query: ' . mysqli_error());
  50. } else {
  51. return $result;
  52. }
  53. }
  54.  
  55. function insertQuery($query) {
  56. $result = mysqli_query($query);
  57. if (!$result) {
  58. die('Invalid query: ' . mysqli_error());
  59. } else {
  60. return $result;
  61. }
  62. }
  63.  
  64. function deleteQuery($query) {
  65. $result = mysqli_query($query);
  66. if (!$result) {
  67. die('Invalid query: ' . mysqli_error());
  68. } else {
  69. return $result;
  70. }
  71. }
  72. }
  73. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement