database.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. <?php
  2. class Database
  3. {
  4. function __construct()
  5. {
  6. $this->customer_table = "customer";
  7. $this->category_table = "category";
  8. $this->product_table = "product";
  9. $this->price_table = "price";
  10. $this->priceset_table = "priceset";
  11. $this->tax_table = "tax";
  12. $this->bill_table = "bill";
  13. $this->bill_product_table = "bill_product";
  14. $this->tour_table = "tour";
  15. $this->assistant_table = "assistant";
  16. $this->group_table = "`group`";
  17. $this->customer_template_table = "customer_template";
  18. $this->ready = false;
  19. }
  20. function connectToDb()
  21. {
  22. $host = getenv('CLOUDRON_MYSQL_HOST');
  23. $user = getenv('CLOUDRON_MYSQL_USERNAME');
  24. $password = getenv('CLOUDRON_MYSQL_PASSWORD');
  25. $db = getenv('CLOUDRON_MYSQL_DATABASE');
  26. $port = getenv('CLOUDRON_MYSQL_PORT');
  27. // $host = "mysql5.nebulon.de";
  28. // $user = "db30675_9";
  29. // $password = "manda1337";
  30. // $db = "db30675_9";
  31. // $host = "localhost";
  32. // $user = "root";
  33. // $password = "";
  34. // $db = "faursprung_net";
  35. $this->db_link = mysqli_connect($host, $user, $password);
  36. if(!$this->db_link)
  37. exit("Error: ".mysqli_connect_error());
  38. if(!mysqli_select_db($this->db_link, $db))
  39. exit("Error: selecting db");
  40. $this->ready = TRUE;
  41. }
  42. function query($query)
  43. {
  44. if(!$this->ready)
  45. $this->connectToDb();
  46. if(!($result = mysqli_query($this->db_link, $query)))
  47. echo "Error: ".mysqli_error($this->db_link);
  48. return $result;
  49. }
  50. function fetchRows($result)
  51. {
  52. if(!$this->ready)
  53. $this->connectToDb();
  54. $all_rows = array();
  55. while($row = mysqli_fetch_row($result))
  56. $all_rows[] = $row;
  57. return $all_rows;
  58. }
  59. function writeToFile($path, $data)
  60. {
  61. $file_access_ok = true;
  62. $file_open = false;
  63. clearstatcache();
  64. if (file_exists($path))
  65. if (!is_writable($path))
  66. $file_access_ok = false;
  67. if ($file_access_ok and (!$file_handle = fopen($path, "w+b")))
  68. $file_access_ok = false;
  69. if ($file_access_ok)
  70. {
  71. if (!fwrite($file_handle, $data) and ($data != ''))
  72. $file_access_ok = false;
  73. else
  74. $file_open = true;
  75. }
  76. if ($file_open)
  77. fclose($file_handle);
  78. return $file_access_ok;
  79. }
  80. }
  81. ?>