Hallo!
Ich programmiere zurzeit eine Login-System mit myslqi.
Irgendwie werden bei der Registration keine Daten in der Datenbank gespeichert, ich erhalte allerdings auch keine Fehlermeldung.
Script:
<!DOCTYPE html>
<div style="background-color:black;
width: 100%;
height: 110px;
padding: 5px;
border:3px lightgreen solid;
">
<FONT COLOR="#FFFFFF">
<center><h1><font face="Comic Sans Ms">Cook</font></h1></center><center>
<h3>Register</h3></center>
</FONT>
</div>
<h3>Here you can create your Account.</h3>
<a href="username.php">I've got an Account.</a>
<form action="" method="POST">
<table border="0">
<tr>
<p><td>First Name:</td> <td><input type="text" name="firstname" placeholder="Enter your First Name"/></td></p>
</tr>
<tr>
<p><td>Last Name:</td> <td><input type="text" name="lastname" placeholder="Enter your Last Name"/></td></p>
</tr>
<td> <FONT COLOR="#FFFFFF">Example:</FONT> </td><td> <FONT COLOR="#FFFFFF">Example:</FONT> </td>
<tr>
<p><td>Username:</td> <td><input type="text" name="username" placeholder="Enter your Username"/></td></p>
</tr>
<tr>
<p><td>Email:</td> <td><input type="email" name="email" placeholder="Enter your Email"/></td></p>
</tr>
<tr>
<p><td>Password:</td> <td><input type="text" name="password" placeholder="Enter your Password"/></td></p>
</tr>
</table>
<p><input type="submit" value="Register"/></p>
</form>
Danke im Voraus!
Ich programmiere zurzeit eine Login-System mit myslqi.
Irgendwie werden bei der Registration keine Daten in der Datenbank gespeichert, ich erhalte allerdings auch keine Fehlermeldung.
Script:
<!DOCTYPE html>
<div style="background-color:black;
width: 100%;
height: 110px;
padding: 5px;
border:3px lightgreen solid;
">
<FONT COLOR="#FFFFFF">
<center><h1><font face="Comic Sans Ms">Cook</font></h1></center><center>
<h3>Register</h3></center>
</FONT>
</div>
<h3>Here you can create your Account.</h3>
<a href="username.php">I've got an Account.</a>
<form action="" method="POST">
<table border="0">
<tr>
<p><td>First Name:</td> <td><input type="text" name="firstname" placeholder="Enter your First Name"/></td></p>
</tr>
<tr>
<p><td>Last Name:</td> <td><input type="text" name="lastname" placeholder="Enter your Last Name"/></td></p>
</tr>
<td> <FONT COLOR="#FFFFFF">Example:</FONT> </td><td> <FONT COLOR="#FFFFFF">Example:</FONT> </td>
<tr>
<p><td>Username:</td> <td><input type="text" name="username" placeholder="Enter your Username"/></td></p>
</tr>
<tr>
<p><td>Email:</td> <td><input type="email" name="email" placeholder="Enter your Email"/></td></p>
</tr>
<tr>
<p><td>Password:</td> <td><input type="text" name="password" placeholder="Enter your Password"/></td></p>
</tr>
</table>
<p><input type="submit" value="Register"/></p>
</form>
PHP-Code:
<?php
$db = new mysqli('localhost','cook-user','123','cook');
if($db->connect_error) {
echo "<b>Critical Error: </b> The connection to the Database failed.";
}
if(isset($_POST['absenden'])) {
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];
$search_user = $db->prepare("SELECT ID FROM daten WHERE username = ?");
$search_user->bind_param('s',$username);
$search_user->execute();
$search_result = $search_user->get_result();
if($search_result->num_rows == 0) {
if(!strlen($username) > 25) {
$password = md5($password);
$db->prepare("INSERT INTO daten (Firstname,Lastname,Username,Email,Password,Regist ered,Last_Login) VALUES (?,?,?,?,?,?,?)");
$insert->bind_param('sssssss',$firstname,$lastname,$userna me,$email,$password,NOW(),NOW());
$insert->execute();
if($insert !== false) {
echo "Your Account was created successfully.";
}
}
else
echo "Your Username mustn't be longer than 25 letters.";
}
else
echo "This username is already used.";
}
?>
Danke im Voraus!
Kommentar