Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function connect($connect_string=null)
- {
- // DOMAIN,MYSQLDB,MYSQLUSER,MYSQLPASS
- global $thedatabase;
- if ($thedatabase) {
- return;
- } else {
- unset($domain);
- unset($db);
- unset($dbuser);
- unset($dbpass);
- if ($connect_string != "") {
- $dbinfo = explode(",", $connect_string);
- $num = count($dbinfo);
- if ($num < 4) {
- $domain = "localhost";
- $x = 0;
- } else {
- $domain = $dbinfo[0];
- $x = 1;
- }
- $db = $dbinfo[$x];
- $x++;
- $dbuser = $dbinfo[$x];
- $x++;
- $dbpass = $dbinfo[$x];
- } else {
- $domain = DOMAIN;
- $db = MYSQLDB;
- $dbuser = MYSQLDBUSER;
- $dbpass = MYSQLDBPASS;
- //die("$domain, $dbuser, $dbpass");
- //exit;
- }
- $thedatabase = mysql_connect($domain, $dbuser, $dbpass);
- if (!$thedatabase) {
- die('Not connected to ' . $domain . ': ' . mysql_error());
- exit;
- }
- $db_selected = mysql_select_db($db, $thedatabase);
- if (!$db_selected) {
- die('Can\'t use ' . $db . ' : ' . mysql_error());
- exit;
- }
- }
- }
- function disconnect()
- {
- global $thedatabase;
- if ($thedatabase) {
- mysql_close($thedatabase);
- $thedatabase = null;
- }
- }
- function escapeString($value,$connect_string=null)
- {
- connect($connect_string);
- return mysql_real_escape_string($value);
- disconnect();
- }
- function free($result)
- {
- mysql_free_result($result);
- }
- function query($query_string,$connect_string=null)
- {
- connect($connect_string);
- $result = mysql_query($query_string);
- return $result;
- free($result);
- disconnect();
- }
- function fetch_array($result,$connect_string=null)
- {
- connect($connect_string);
- $value = mysql_fetch_array($result);
- return $value;
- disconnect();
- }
- function insertid($connect_string=null)
- {
- connect($connect_string);
- return mysql_insert_id();
- disconnect();
- }
- function num_rows($result,$connect_string=null)
- {
- connect($connect_string);
- $num = mysql_num_rows($result);
- return $num;
- disconnect();
- }
Add Comment
Please, Sign In to add comment