Hvorfor virker dette ikke
Hej, jeg har prøvet at bruge et script inde fra evolt, men kan ikke få det til at virke, denne nedenstående side skulle oprette en bruger i databasen, men det kan jeg ikke få en til, den siger at den ikke kan connecte til databasen:Warning: Can't connect to MySQL server on '193.89.137.61' (10061) in d:\home\devicedk\www\test\cms\cmsregistration.php on line 5
Failed to connect to database!
Hvad er der galt, hvad skal jeg ændre? Je er ret ny i dette og forstår det ikke så godt, så det er nok mig der har lavet en fejl.
<? session_start(); ?>
<?
//connect to and select database
if(!($dbconnect = mysql_pconnect("193.89.137.61", "cms_user", "cms_password"))){
print("Failed to connect to database!\n");
exit();
}
if(!mysql_select_db("cms", $dbconnect)){
print("Failed to select database!\n");
exit();
}
//insert user information into table
$query = "INSERT INTO tblUser (name, email, password) ";
$query .= "VALUES ('$username', '$email', '$password') ";
if(!($dbresult = mysql_query($query, $dbconnect))){
print("MySQL reports: " . mysql_error() . "\n");
exit();
}
//query user table for admin email address
$qadmin = "SELECT email ";
$qadmin .= "FROM tblUser ";
$qadmin .= "WHERE accesslevel = 'admin' ";
if(!($dbresult = mysql_query($qadmin, $dbconnect))){
print("MySQL reports: " . mysql_error() . "\n");
exit();
}
//email message to admin
$dbadmin = mysql_fetch_object($dbresult);
$messadm = "$username has registered as an Author in the\n";
$messadm .= "Content Management System.\n\n";
mail("$dbadmin->email", "CMS Author Registration", $messadm, "From: CMS System");
//send them to the login page
header("Location: login.php"); exit;
?>
