$MYSQL_HOST = "localhost";
$MYSQL_LOGIN = "loginname";
$MYSQL_PASS = "password";
$MYSQL_DB = "databasename";
$db = mysql_connect($MYSQL_HOST,$MYSQL_LOGIN,$MYSQL_PASS);
if(!$db){
echo('
Unable to connect to db' . mysql_error());
exit;
}
mysql_select_db($MYSQL_DB);
function q($q, $debug = 0){
$r = mysql_query($q);
if(mysql_error()){
echo mysql_error();
echo "$q ";
}
if($debug == 1)
echo " $q ";
if(stristr(substr($q,0,8),"delete") || stristr(substr($q,0,8),"insert") || stristr(substr($q,0,8),"update")){
if(mysql_affected_rows() > 0)
return true;
else
return false;
}
if(mysql_num_rows($r) > 1){
while($row = mysql_fetch_array($r)){
$results[] = $row;
}
}
else if(mysql_num_rows($r) == 1){
$results = array();
$results[] = mysql_fetch_array($r);
}
else
$results = array();
return $results;
}
function q1($q, $debug = 0){
$r = mysql_query($q);
if(mysql_error()){
echo mysql_error();
echo " $q ";
}
if($debug == 1)
echo " $q ";
$row = @mysql_fetch_array($r);
if(count($row) == 2)
return $row[0];
else
return $row;
}
function qr($q, $debug = 0){
$r = mysql_query($q);
if(mysql_error()){
echo mysql_error();
echo " $q ";
}
if($debug == 1)
echo " $q ";
if(stristr(substr($q,0,8),"delete") || stristr(substr($q,0,8),"insert") || stristr(substr($q,0,8),"update")){
if(mysql_affected_rows() > 0)
return true;
else
return false;
}
$results = array();
$results[] = mysql_fetch_array($r);
$results = $results[0];
return $results;
}
|