我试图插入eshop_db中的客户表
当我运行它时,它没有任何错误,但它没有存储在mysql中。
我的代码中有什么问题?
我真的不明白。
请给出一些答案。谢谢。
--registerForm.php--
User ID: *
Password: *
Retype Password: *
First Name: *
Last Name: *
Your Address (*):
Phone: *
E-mail: *
--register.php--require "sql_connection.php";
if(isset($_POST['submit']))
{
if($_POST["password"]==$_POST["repassword"])
{
mysql_query("insert into customer (userId, password, firstName, lastName, address, phone, email)
values ('$_POST[userId]','$_POST[password]','$_POST[firstName]','$_POST[lastName]','$_POST[addres]]','$_POST[phone]','$_POST[email]')")
or die(mysql_error());
}
}
?>--sql_connection.php--
$db_host = "localhost";
$db_username = "root";
$db_pass = "mypass";
$db_name = "eshop_db";
@mysql_connect("$db_host", "$db_username", "$db_pass", "$db_name") or die("connection is fail.");
@mysql_select_db("$db_name") or die("database does not exsist.");
echo "Successfully connected!!";
?>