Question

我想插入“这pple,是一种果实”,来查询数据库,只能与数据库中未果的 words和水果相匹配,并交还1个水果 red。

如何修改询问法?

数据库名称食品领域如下:

id name1 name2 name3 name4 type
1 fruit apple red 10 article
2 fruit banana yellow 12 article
3 drink beer yellow 6 article
4 fruits apple yellow 16 books

法典:

mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("article") or die(mysql_error());
... ...
echo $match . "r"; // $match= This is a apple, it is a fruit
$query = mysql_query("SELECT * FROM food WHERE name1, name2 like  %$match%  ");
$row=mysql_fetch_array($query);
echo $row[ id  ]. "r" .$row[ name1 ]. "r".$row[ name2 ]. "r".$row[ name3 ]. "r".$row[ name4 ]. "n";

Answer 1

It s hard to tell, but I think if you are trying to avoid returning anything that does not equal the exact word (apples != apple). You will have to break your $match string into smaller parts and check for them individually. maybe use explode() to break the string apart using white spaces and then do exact matches on the words that apply.

目前你们正在核对数据库中任何数据,这些数据可能与任何方面相似。因此,只要有“是”、“a”和“fruit”等词,它就可以回去“pple是果实”。

或许也值得重新命名贵国的数据库栏。没有人看一看一面有名称1、姓名2、名称3. 如何打字、姓名、col、mount?

$match = trim($match);
$match = strtolower($match);
$newmatch = explode(" ",$newmatch);

So if $match was "This is an apple" $newmatch = array("this","is","an","apple")

当然,这一胜利已经摆脱了任何旁观。但是,如果你喜欢三点和预选点,你可以这样做。

Help: trim() , strtolower() , explode()

友情链接