Advertisement
Isigar

MYSQL [TERPHP]

Feb 19th, 2015
285
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.25 KB | None | 0 0
  1. <?php
  2. namespace IPHP\DATABASE
  3. {
  4. class mysql
  5. {
  6. private static CONNECTION_TYPE = "";
  7. private static CONNECTION;
  8.  
  9. private DB_HOST = "";
  10. private DB_USER = "";
  11. private DB_PASS = "";
  12. private DB_NAME = "";
  13.  
  14. public class __construct()
  15. {
  16. if(isset(self::$CONNECTION)
  17. {
  18. switch(self::$CONNECTION_TYPE)
  19. {
  20. case 'mysql':
  21. {
  22. self::$CONNECTION = new \mysql($this->DB_HOST,$this->DB_USER,$this->DB_PASS,$this->DB_NAME);
  23. if(self::self::$CONNECTION->connect_errn)
  24. {
  25. die();
  26. }
  27. else
  28. {
  29. return self::$CONNECTION;
  30. }
  31. }
  32. }
  33. }
  34. else
  35. {
  36. return self::$CONNECTION_TYPE;
  37. }
  38. }
  39. public function get($row,$table,$arr = false)
  40. {
  41. if($query = $this->DB_CONN->prepare('SELECT * FROM '.$table)){
  42. $query->execute();
  43.  
  44. $result = $query->get_result();
  45.  
  46. foreach($result as $rowc)
  47. {
  48. if($arr == true)
  49. {
  50. return $rowc;
  51. }
  52. else
  53. {
  54. if(isset($rowc[$row]))
  55. {
  56. return $rowc[$row];
  57. }
  58. }
  59. }
  60. }
  61. }
  62. public function insert($table,$args)
  63. {
  64. $columns = implode(", ",array_keys($args));
  65. $escaped_values = array_map('mysql_real_escape_string', array_values($args));
  66. $values = implode(", ", $escaped_values);
  67.  
  68. if($query = $this->DB_CONN->prepare('INSERT INTO '.$table.' ('.$columns.') VALUES ('.$values.')'))
  69. {
  70. $query->execute();
  71. }
  72. else
  73. {
  74. print $this->DB_CONN->error;
  75. }
  76. $this->DB_CONN->query('COMMIT');
  77. }
  78.  
  79. }
  80. }
  81.  
  82. /*Usage*/
  83. use \IPHP\DATABASE;
  84.  
  85. $DB = new mysql();
  86. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement