php代码不工作,显示
致命错误:调用未定义的函数mysq1i_query()
<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$conn=mysqli_connect($dbhost,$dbuser,$dbpass,"vishal");
$passkey=$_GET['passkey'];
$tblname="data";
$sql="SELECT * FROM $tblname WHERE confirmcode='$passkey'";
$result=mysq1i_query($sql);
if($result)
{
$count=mysqli_num_rows(($result));
if($count==1)
{
$rows=mysqli_fetch_array($result);
$name=$rows['name'];
$emailid=$rows['emailid'];
$password=$rows['password'];
$confirm=$rows['confirm'];
$country=$rows['country'];
$table2="data1";
$sql2="INSERT INTO $table2 (name,emailid,password,confirm,country)VALUES ('$name','$emailid','$password','$confirm','$country')"; $result1=mysqli_query($sql2);
}
else
{
echo"wrong cofirmation code";
}
if($result1)
{
echo"your account has been activated";
$sql3="DELETE FROM $tblname WHERE confirm_code='$passkey'";
$result2=mysqli_query($sql3);
}
}
?>
您已在第9行使用
$result=mysq1i_query($sql);
而不是
$result=mysqli_query($sql);
您在这一行中有一个错误:
$result=mysq1i_query($sql);
它在(mysq1i)中不是1
正确的是:
$result=mysqli_query($sql);
当您收到此错误时,未定义函数意味着您没有在代码中定义此函数。