关于mysql索引错误,mysql查询中未定义的索引错误

$conn=mysql_connect("localhost","root","")

or die("cannot connect");

$db=mysql_select_db("ticket",$conn)

or die("no db");

if (isset($_POST['submit']))

{

$name1=$_POST['name'];

$phone1=$_POST['phone'];

$email1=$_POST['email'];

$pass1=$_POST['password'];

}

$query="insert into register(name,phone,email,pass) values ('$name1','$phone1','$email1','$pass1')";

$result=mysql_query($query)

or die("Error in pushing".mysql_error());

mysql_close($conn);

?>

error am getting

Notice: Undefined variable: name1 in C:\xampp\htdocs\selva\jqsty.php

on line 13

Notice: Undefined variable: phone1 in C:\xampp\htdocs\selva\jqsty.php

on line 13

Notice: Undefined variable: email1 in C:\xampp\htdocs\selva\jqsty.php

on line 13

Notice: Undefined variable: pass1 in C:\xampp\htdocs\selva\jqsty.php

on line 13

解决方案

You're checking for the presence of $_POST['submit'], and setting some variables if it's found. You're then executing your mysql query outside the conditional block, so if the $_POST variables aren't found you'll get undefined variable errors.

Try

$conn=mysql_connect("localhost","root","")

or die("cannot connect");

$db=mysql_select_db("ticket",$conn)

or die("no db");

if (isset($_POST['submit']))

{

$name1=$_POST['name'];

$phone1=$_POST['phone'];

$email1=$_POST['email'];

$pass1=$_POST['password'];

// This code now inside if block

$query="insert into register(name,phone,email,pass) values ('$name1','$phone1','$email1','$pass1')";

$result=mysql_query($query)

or die("Error in pushing".mysql_error());

mysql_close($conn);

}

?>