Emps-Scape
Neues Mitglied
hi leute ich hab so einen php code zum verbinden von meiner database aber das funktioniert irgendwie nicht könnt ihr mir vielleicht helfen?
danke
PHP:
<center>
<?php
// set your infomation.
$dbhost='***.***.*.*'
$dbusername='****'
$dbuserpass='********'
$dbname='****'
$table='account'
// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass)
mysql_select_db($dbname) or die("Can not")
//Are they just getting here or submitting their info?
if (isset($_POST["username"])) {
$username = $_POST["username"]
$password = $_POST["password"]
$cpassword = $_POST["cpassword"]
$email = $_POST["email"]
//Was a field left blank?
if($username==NULL|$password==NULL|$cpassword==NULL|$email==NULL) {
echo "A field was left blank."
{else}
//Do the passwords match?
if($password!=$cpassword) {
echo "Passwords do not match"
}else{
//Has the username or email been used?
$checkuser = mysql_query("SELECT username FROM $table WHERE username='$username')"
$username_exist = mysql_num_rows($checkuser)
$checkemail = mysql_query("SELECT email FROM $table WHERE email='$email')"
$email_exist = mysql_num_rows($checkemail)
if ($email_exist>0|$username_exist>0) {
echo "The username or email is already in use"
}else{
//Everything seems good, lets insert.
$query = "INSERT INTO $table (username, password, email) VALUES('$username','$password','$email')"
mysql_query($query) or die(mysql_error())
echo "The user $username has been successfully registered."
}
}
}
}
?>
danke
