mysql查询中未定义的索引错误 [英] undefined index error in mysql query

问题描述

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

错误越来越严重

注意:未定义的变量:C:\ xampp \ htdocs \ selva \ jqsty.php中的name1 在第13行
注意:未定义的变量:C:\ xampp \ htdocs \ selva \ jqsty.php中的phone1 在第13行
注意:未定义变量:C:\ xampp \ htdocs \ selva \ jqsty.php中的email1 在第13行
注意:未定义变量:C:\ xampp \ htdocs \ selva \ jqsty.php中的pass1 在第13行

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

推荐答案

您正在检查$_POST['submit']的存在，并设置一些变量(如果找到).然后，您将在条件块之外执行mysql查询，因此，如果找不到$ _POST变量，则会出现undefined variable错误.

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.

尝试

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

这篇关于mysql查询中未定义的索引错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！