PHP 脚本不工作，除了连接

Question

我正在通过查看一些视频教程在 android studio 中开发一个登录和注册应用程序，并且 php 脚本与教程中的一样是 100%，它第一次工作，然后现在不工作了。我不能'无法识别出了什么问题.. 我是 php 和 android 的新手

在教程中它纯粹是工作。教程链接>> Registration app tutorial

链接数据库用了两天多，一直卡着，最后进stackoverflow，求高人指点。谢谢

init.php 用于连接，连接成功

<?php
$host = "localhost";
$user = "blood";
$password = "rifkan123";
$dbname = "userdb";

$con = mysqli_connect($host,$user,$password,$dbname);

if(!$con)
{
die("Error in Database Connection".mysqli_connect_error());

}
else
{
Echo "<h3> Database Connection Success !";
}

?>

login.php 登录脚本

<?php
$email = $_POST["email"];
$pass = $_POST["password"];
require "init.php";

$query = "Select * userinfo where email like. '".$email."';";
$result = mysqli_query($con,$query);

if(mysqli_num_rows($result)>0)
{
$response = array();
$code ="login_true";
$row = mysqli_fetch_array($result);
$name = $row[0];
$message ="Login Success ! Welcome ".$name;
array_push($response,array("code"=>$code,"message"=>$message));
echo json_encode(array(server_response=>$response));    
}
else
{
$response = array();
$code ="login_false";
$message ="Login Failed ! Try Again";
array_push($response,array("code"=>$code,"message"=>$message));
echo json_encode(array(server_response=>$response));    
}
mysqli_close($con);
?>

register.php 用于用户注册

<?php

$name = $_POST["name"];
$email = $_POST["email"];
$pass = $_POST["password"];
require "init.php";

$query = "select * from userinfo where email like '".$email."';";
$result = mysqli_query($con,$query);

if(mysqli_num_rows($result)>0)
{

$response = array();
$code = "reg_false";
$message = "User Already Exist !";
array_push($response,array("code"=>$code,"message"=>$message));
echo json_encode(array("server_response"=>$response));

}
else
{
$query = "insert into userinfo      values('".$name."','".$email."','".$pass."');";
$result = mysqli_query($con,$query);

if(!$result)
{
    $response = array();
    $code = "reg_false";
    $message = "Registration Failed, Try Again!";
    array_push($response,array("code"=>$code,"message"=>$message));
    echo json_encode(array("server_response"=>$response));
}
else
{
    $response = array();
    $code = "reg_true";
    $message = "Registration Success, Login to Continue!";
    array_push($response,array("code"=>$code,"message"=>$message));
    echo json_encode(array("server_response"=>$response));
}
mysqli_close($con);
}
?>

我错过了登录脚本中的 FROM，添加后检测到新错误 Screen shot new Error

Answer 1

你忘记了 login.php 中的 FROM 子句

这里

  $query = "Select * from userinfo where email like. '".$email."';";

同时考虑添加 %% 和 like