$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);
}
?>