$dbHost = "localhost";
$dbName = "rossel";
$dbUsername = "dba_recreatie";
$dbPassword = "RO#RE!";
$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';
function MySQL_report(){
global $dbHost;
global $dbName;
global $dbUsername;
global $dbPassword;
echo "host: ".$dbHost."
";
echo "user: ".$dbUsername."
";
echo "pass:
";
echo "dbname: ".$dbName."
";
}
function MySQL_OpenConnection()
{
global $dbHost;
global $dbName;
global $dbUsername;
global $dbPassword;
global $MYSQL_ERRNO;
global $MYSQL_ERROR;
$link_id = @mysql_connect ($dbHost,$dbUsername,$dbPassword);
if(!$link_id)
{
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = 'Connection failed to host '.$dbHost.'.';
return 0;
}
else if (!mysql_select_db($dbName, $link_id))
{
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else
{
return $link_id;
}
}
function MySQL_CloseConnection($link_id)
{
mysql_close ($link_id);
}
function MySQL_EchoError($SQL)
{
global $MYSQL_ERRNO;
global $MYSQL_ERROR;
$errMsg = '
'.$SQL;
if (empty($MYSQL_ERROR))
{
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
}
$errMsg .= '
'.$MYSQL_ERRNO.": ".$MYSQL_ERROR;
return $errMsg;
}
function MySQL_SubmitQuery($SQL,$link_id)
{
//echo("
".$SQL."
\n");
if ($link_id)
{
$result = @mysql_query($SQL)
or die(MySQL_EchoError($SQL));
}
else
{
die(MySQL_EchoError($SQL));
}
return $result;
}
function MySQL_CreateInsertQuery($table,$data)
{
$SQL = '';
if (!empty($table) && is_array($data)) {
$SQL_INSERT = 'INSERT INTO '.$table.' (';
$SQL_VALUES = 'VALUES (';
foreach($data as $varname => $value)
{
$SQL_INSERT .= $varname.", ";
$SQL_VALUES .= "'".$value."', ";
}
$SQL_INSERT = substr($SQL_INSERT,0,-2).') ';
$SQL_VALUES = substr($SQL_VALUES,0,-2).') ';
$SQL = $SQL_INSERT.$SQL_VALUES;
}
return $SQL;
}
function MySQL_CreateUpdateQuery($table,$data,$recordID)
{
$SQL = '';
if (!empty($table) && is_array($recordID) && is_array($data)) {
$SQL = 'UPDATE '.$table.' ';
$SQL .= 'SET ';
foreach($data as $varname => $value)
{
$SQL .= $varname."='".$value."', ";
}
$SQL = substr($SQL,0,-2);
$SQL .= ' WHERE '.$recordID[0].'='.$recordID[1];
}
return $SQL;
}
function MySQL_CreateDeleteQuery($table,$recordID)
{
$SQL = '';
if (!empty($table) && is_array($recordID)) {
$SQL = 'DELETE FROM '.$table.' ';
$SQL .= ' WHERE '.$recordID[0].'='.$recordID[1];
}
return $SQL;
}
function MySQL_FormatVar($value)
{
if(!is_array($value)){
$value = trim($value);
$value = str_replace ('\"', """, $value);
$value = str_replace ("\\'", "'", $value);
}
return $value;
}
function MySQL_UnformatVar($value)
{
$value = trim($value);
$value = str_replace (""", '"', $value);
$value = str_replace ("'", "'", $value);
return $value;
}
?>