enter code here
<?php
//declare the basic variables
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "coursework";
//create connection
$link = new mysqli($servername, $username, $password, $dbname);
if($link->connect_error){
die ("connection failed: " . $link->connect_error);
}
$sql = "INSERT INTO user (firstname, lastname, email, phn_number, password) VALUES ('".$_POST['firstname']."', '".$_POST['lastname']."', '".$_POST['email']."', '".$_POST['phn_number']."', '".$_POST['password']."')";
if (mysqli_query($link, $sql)){
echo "Signed up Successfully";
}else{
echo "Error: Sign up Unsuccessfull $sql . " . mysqli_error($link);
}
//close db
$link -> close();
?>
这是我的PHP文件代码。每次运行它都会创建一个新用户,但用户输入的数据不会保存在数据库中。然后出现错误
Notice: Undefined index: firstname in C:xampphtdocsC.Wregister.php on line 18
Notice: Undefined index: lastname in C:xampphtdocsC.Wregister.php on line 19
Notice: Undefined index: email in C:xampphtdocsC.Wregister.php on line 20
Notice: Undefined index: phn_number in C:xampphtdocsC.Wregister.php on line 21
Notice: Undefined index: password in C:xampphtdocsC.Wregister.php on line 22
帮助! !
用这个更新你的代码:
if($link->connect_error){
die ("connection failed: " . $link->connect_error);
}
$sql ="INSERT INTO user (firstname, lastname, email, phn_number, password) VALUES ('Dinanath', 'Thakur', 'dina@example.com', 123456789, 'xyz')";
你的HTML表单应该是这样的格式,更新你的HTML表单:
<p>
<label for="firstname"> First Name: </label>
<input type="text" name="firstname" id="firstname"> <br/> <br/>
<label for="lastname"> Last Name: </label>
<input type="text" name="lastname" id="lastname"> <br/> <br/>
<label for="email"> E-mail: </label>
<input type="text" name="email" id="email"> <br/> <br/>
<label for="phn_number"> Phone Number: </label>
<input type="text" name="phn_number" id="phn_number"> <br/> <br/>
<label for="password"> Password: </label>
<input type="text" name="password" id="password">
</p>
<input type="submit" value="Sign Up">
您可能忘记包括这个:
form action="name_of_your_php_file.php" method="POST"
将它插入到上面提供的代码中,得到:
<form action="name_of_your_php_file.php" method="POST">
<p> <label for "firstname"> First Name: </label>
<input type="text" name"firstname" id="firstname"> <br/ > <br/ >
<label for "lastname"> Last Name: </label> <input type="text" name"lastname" id="lastname"> <br/ > <br/ >
<label for "email"> E-mail: </label> <input type="text" name"email" id="email"> <br/ > <br/ >
<label for "phn_number"> Phone Number: </label> <input type="text" name"phn_number" id="phn_number"> <br/ > <br/ > <label for "password"> Password: </label>
<input type="text" name"password" id="password"> </p>
<input type="submit" value="Sign Up"></form>
if($link->connect_error){
die ("connection failed: " . $link->connect_error);
}
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$pno = $_POST['pno'];
$pass = $_POST['pass'];
$sql ="INSERT INTO user (firstname, lastname, email, phn_number, password) VALUES ('$fname', '$lname', '$email', '$pno', '$pass')";
$res = mysql_query($sql);