Guest book
function ConnectToDatabaseEx($username, $password, $db_name)
{
$dbc = mysql_connect('sql5.pcextreme.nl', $username, $password) or die('Cannot connect to database.');
mysql_select_db($db_name, $dbc) or die('Cannot select database.');
return $dbc;
}
function ConnectToDatabase($db_name)
{
if ($db_name == 'GamesGuestBook')
return ConnectToDatabaseEx('7905gbook', 'p8grCsd', '7905gbook');
else if ($db_name == 'GiroToto')
return ConnectToDatabaseEx('7905giro', '5KxV4mN', '7905giro');
else if ($db_name == 'UploadStuff')
return ConnectToDatabaseEx('7905gbook', 'p8grCsd', '7905login');
else if ($db_name == 'Wedding')
return ConnectToDatabaseEx('7905wedding', 'PWtBj3sL', '7905wedding');
return 0;
}
function UploadPageLogin($username, $password)
{
$dbc = ConnectToDataBase('UploadStuff');
if ($dbc)
{
$query = "SELECT `user` FROM `upload` WHERE `user` = '" . mysql_real_escape_string($username) . "' AND `password` = '" . md5($password) . "'";
$result = mysql_query($query) or die('Database error.');
if (mysql_num_rows($result) > 0)
{
mysql_close($dbc);
return 1;
}
}
mysql_close($dbc);
return 0;
}
?>