Guest User

Untitled

a guest
Jun 21st, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.23 KB | None | 0 0
  1. function connect($connect_string=null)
  2. {
  3. // DOMAIN,MYSQLDB,MYSQLUSER,MYSQLPASS
  4. global $thedatabase;
  5. if ($thedatabase) {
  6. return;
  7. } else {
  8. unset($domain);
  9. unset($db);
  10. unset($dbuser);
  11. unset($dbpass);
  12. if ($connect_string != "") {
  13. $dbinfo = explode(",", $connect_string);
  14. $num = count($dbinfo);
  15. if ($num < 4) {
  16. $domain = "localhost";
  17. $x = 0;
  18. } else {
  19. $domain = $dbinfo[0];
  20. $x = 1;
  21. }
  22. $db = $dbinfo[$x];
  23. $x++;
  24. $dbuser = $dbinfo[$x];
  25. $x++;
  26. $dbpass = $dbinfo[$x];
  27. } else {
  28. $domain = DOMAIN;
  29. $db = MYSQLDB;
  30. $dbuser = MYSQLDBUSER;
  31. $dbpass = MYSQLDBPASS;
  32. //die("$domain, $dbuser, $dbpass");
  33. //exit;
  34. }
  35. $thedatabase = mysql_connect($domain, $dbuser, $dbpass);
  36. if (!$thedatabase) {
  37. die('Not connected to ' . $domain . ': ' . mysql_error());
  38. exit;
  39. }
  40. $db_selected = mysql_select_db($db, $thedatabase);
  41. if (!$db_selected) {
  42. die('Can\'t use ' . $db . ' : ' . mysql_error());
  43. exit;
  44. }
  45. }
  46. }
  47.  
  48. function disconnect()
  49. {
  50. global $thedatabase;
  51. if ($thedatabase) {
  52. mysql_close($thedatabase);
  53. $thedatabase = null;
  54. }
  55. }
  56.  
  57. function escapeString($value,$connect_string=null)
  58. {
  59. connect($connect_string);
  60. return mysql_real_escape_string($value);
  61. disconnect();
  62. }
  63.  
  64. function free($result)
  65. {
  66. mysql_free_result($result);
  67. }
  68.  
  69. function query($query_string,$connect_string=null)
  70. {
  71. connect($connect_string);
  72. $result = mysql_query($query_string);
  73. return $result;
  74. free($result);
  75. disconnect();
  76. }
  77.  
  78.  
  79. function fetch_array($result,$connect_string=null)
  80. {
  81. connect($connect_string);
  82. $value = mysql_fetch_array($result);
  83. return $value;
  84. disconnect();
  85. }
  86.  
  87. function insertid($connect_string=null)
  88. {
  89. connect($connect_string);
  90. return mysql_insert_id();
  91. disconnect();
  92. }
  93.  
  94. function num_rows($result,$connect_string=null)
  95. {
  96. connect($connect_string);
  97. $num = mysql_num_rows($result);
  98. return $num;
  99. disconnect();
  100. }
Add Comment
Please, Sign In to add comment