Advertisement
Guest User

Untitled

a guest
Apr 8th, 2016
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. Warning: mysql_connect(): Connection refused in /home/xxx/xx.xx/prueba/controllerdb.php on line 16
  2.  
  3. Warning: mysql_query(): No such file or directory in /home/xxx/xx.xx/prueba/controllerdb.php on line 34
  4.  
  5. Warning: mysql_query(): A link to the server could not be established in /home/xxx/xx.xx/prueba/controllerdb.php on line 34
  6.  
  7. Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/xxx/xx.xx/prueba/controllerdb.php on line 35
  8.  
  9. Warning: mysql_query(): No such file or directory in //home/xxx/xx.xx/prueba/controllerdb.php on line 49
  10.  
  11. Warning: mysql_query(): A link to the server could not be established in //home/xxx/xx.xx/prueba/controllerdb.php on line 49
  12. Invalid query: No such file or directory
  13.  
  14. <?php
  15. class DBController {
  16. private $host = "www.xxx.mx";
  17. private $user = "xxxx";
  18. private $password = "xxxxx";
  19. private $database = "xxxx";
  20.  
  21. function __construct() {
  22. $conn = $this->connectDB();
  23. if(!empty($conn)) {
  24. $this->selectDB($conn);
  25. }
  26. }
  27.  
  28. function connectDB() {
  29. $conn = mysql_connect($this->host,$this->user,$this->password);
  30. return $conn;
  31. }
  32.  
  33. function selectDB($conn) {
  34. mysql_select_db($this->database,$conn);
  35. }
  36.  
  37. function runQuery($query) {
  38. $result = mysql_query($query);
  39. while($row=mysql_fetch_assoc($result)) {
  40. $resultset[] = $row;
  41. }
  42. if(!empty($resultset))
  43. return $resultset;
  44. }
  45.  
  46. function numRows($query) {
  47. $result = mysql_query($query);
  48. $rowcount = mysql_num_rows($result);
  49. return $rowcount;
  50. }
  51.  
  52. function updateQuery($query) {
  53. $result = mysql_query($query);
  54. if (!$result) {
  55. die('Invalid query: ' . mysql_error());
  56. } else {
  57. return $result;
  58. }
  59. }
  60.  
  61. function insertQuery($query) {
  62. $result = mysql_query($query);
  63. if (!$result) {
  64. die('Invalid query: ' . mysql_error());
  65. } else {
  66. return $result;
  67. }
  68. }
  69.  
  70. function deleteQuery($query) {
  71. $result = mysql_query($query);
  72. if (!$result) {
  73. die('Invalid query: ' . mysql_error());
  74. } else {
  75. return $result;
  76. }
  77. }
  78. }
  79.  
  80. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement