PHP :无法从MYSQL数据库获得精确匹配

Question

这个php确实给了我一些问题。我想从数据库中返回数据，我希望它显示来自数据库的主要数据，我希望它显示来自数据库的数据，以匹配从数据库输入的信息--例如，如果我输入名称"Paul Mason“并单击search按钮，它连接到数据库并回显站点上的信息。

下面显示了我编写的代码。

<html>
<title>Search Records</title>
<head>
<body>
    <form name="" id="" method="post" action="search.php"/>
    <p> Enter Student name : <input type="text" name="fullname" id="fullname"/>
    <input type="submit" name="senda" value="Search Data" />

</form>

<?php
if(isset($_POST['senda'])){

    include 'mysqlconn.php';
    $con = mysqli_connect($host, $dbuser, $pass, $db) or die('Cannot Connect');

    $name = $_POST['fullname'];

        $sql = "SELECT * FROM scores WHERE MATCH(fullname) AGAINST('$name')";
        $result = mysqli_query($con,$sql)  or die("Error: ".mysqli_error($con));

    while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
    {
        printf("%s (%s)\n", $row['Fullname'] ." ". $row['studentNo'] ." ". $row['SubjectName'] ." ". $row['GPA'] ." ". $row['CGPA'] ." ". $row['SCORE']);

        mysqli_free_result($result);
    }
     mysqli_close($con);
    }

?>
</body>
</head>
</html>

相反，它显示了其他类似的东西：Error: Can't find FULLTEXT index matching the column list

什么是错的，我需要有人来纠正我的编程！

Answer 1

在要引用的列上没有全文索引。对于单个列搜索，如果不希望创建索引，请尝试(也转换为为您准备的语句)：

对于松散的比赛：

$con = new mysqli($host, $dbuser, $pass, $db) or die('Cannot Connect');
$name = $_POST['fullname'];
$query = $con->prepare("SELECT * FROM scores WHERE fullname LIKE '%$name%'");
$query->execute();

准确匹配：

$con = new mysqli($host, $dbuser, $pass, $db) or die('Cannot Connect');
$name = $_POST['fullname'];
$query = $con->prepare("SELECT * FROM scores WHERE fullname = '$name'");
$query->execute();

如果您确实有或创建了一个完整的文本索引，那么它将工作，但仍然建议准备查询以防止注入攻击：

$con = new mysqli($host, $dbuser, $pass, $db) or die('Cannot Connect');
$name = $_POST['fullname'];
$query = $con->prepare("WHERE MATCH(fullname) AGAINST('$name')");
$query->execute();