blocks|key|773193|text|添加mysql_error()并检查查询中是否有任何错误。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|773194|$result+=+mysql_query("SELECT+*+FROM+torrents+WHERE+name+='$search'")
++++++++++or+trigger_error(mysql_error());|code-block|syntax|javascript|773195|如果查询成功，则表可能没有任何匹配的行。|773196|如果您不想要完全匹配，而想要近似匹配，则可以使用LIKE子句代替=|773197|$result+=+mysql_query("SELECT+*+FROM+torrents+WHERE+name+LIKE+'%25$search%25'")
++++++++++++++or+trigger_error(mysql_error());|773198|最后但并非最不重要的一点是，在SQL+query中添加字符串之前，使用mysql_real_escape_string函数对字符串进行转义。|773199|entityMap^0|2|D|0|0|0|O|4|W|1|0|0|Z|O|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|Z|8|@$9|10|A|11|B|C]|$9|12|A|13|B|C]]|D|@]|E|$]]|$1|O|3|P|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|Q|3|R|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|S|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|T|$]]

Add the <code>mysql_error()</code> and check if there is any error in the query. 

<pre><code>$result = mysql_query("SELECT * FROM torrents WHERE name ='$search'")
 or trigger_error(mysql_error());
</code></pre>

If the query is successfully probably table does not have any matching row.

If you don't want exact match and wants a near by match you can use the <code>LIKE</code> clause instead of <code>=</code>

<pre><code>$result = mysql_query("SELECT * FROM torrents WHERE name LIKE '%$search%'")
 or trigger_error(mysql_error());
</code></pre>

Last thing but not least escape the string with <code>mysql_real_escape_string</code> function before appending them in SQL query.

blocks|key|773234|text|首先要做三件事|type|unstyled|depth|inlineStyleRanges|entityRanges|data|773235|使用根作为username|773236|$search的sql+injections|unordered-list-item|773237|
|773238|third，从不连接|773239|，应该使用可能的SQL注入进行过滤，因此使用mysql_real_escape_string保护您自己免受SQL+SQL的影响在执行查询之前尝试打印您的查询，以便您知道查询中传递了哪些值。或者使用trigger_error函数查看查询|offset|length|style|CODE|773240|中是否有任何错误|773241|773242|因此您的一行代码可以重写为|773243|+$search+=+mysql_real_escape_string($search);+
+$result+=+mysql_query("SELECT+*+FROM+torrents+WHERE+name+LIKE+'%25$search%25'")+or+trigger_error(mysql_error());|code-block|syntax|javascript|773244|这将使您深入了解正在发生的事情。|773245|entityMap^0|0|0|0|0|0|2Q|D|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|16|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|17|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|18|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|19|8|@$M|1A|N|1B|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1E|8|@]|9|@]|A|$]]|$1|V|3|W|5|X|7|1F|8|@]|9|@]|A|$Y|Z]]|$1|10|3|11|5|6|7|1G|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|13|$]]

three things to start with

<ul>
<li>Never connect with mysql db using root as username</li>
<li>$search should be filtered with possible sql injections so use mysql_real_escape_string to protect your self from SQL injections</li>
<li>third, try printing your query before you execute it so that you know what values are getting passed in your query. or use <code>trigger_error</code> function to see if there are any errors in your query</li>
</ul>

so a line of your code can be rewritten as

<pre><code> $search = mysql_real_escape_string($search); 
 $result = mysql_query("SELECT * FROM torrents WHERE name LIKE '%$search%'") or trigger_error(mysql_error());
</code></pre>

This will give you insight on whats happening

blocks|key|618219|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|618220|使用WHERE+name+LIKE+'%25$search%25'|ordered-list-item|offset|length|style|CODE|618221|Use全索引搜索(因为5.6它只适用于LIKE引擎)来加速搜索查询，而不是LIKE。用于SQLInjection.|618222|Use面向对象驱动程序的MySql+Manual|618223|Google，如PDO|618224|618225|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html|1|http://www.php.net/manual/pl/book.pdo.php^0|0|2|R|0|J|4|11|4|0|C|C|0|0|8|3|8|3|1|0|0^^$0|@$1|2|3|-4|4|5|6|Y|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|Z|7|@$D|10|E|11|F|G]]|8|@]|9|$]]|$1|H|3|I|4|C|6|12|7|@$D|13|E|14|F|G]|$D|15|E|16|F|G]]|8|@]|9|$]]|$1|J|3|K|4|C|6|17|7|@]|8|@$D|18|E|19|1|1A]]|9|$]]|$1|L|3|M|4|C|6|1B|7|@$D|1C|E|1D|F|G]]|8|@$D|1E|E|1F|1|1G]]|9|$]]|$1|N|3|-4|4|5|6|1H|7|@]|8|@]|9|$]]|$1|O|3|-4|4|5|6|1I|7|@]|8|@]|9|$]]]|P|$Q|$4|R|S|T|9|$U|V]]|W|$4|R|S|T|9|$U|X]]]]

<ol>
<li>Use <code>WHERE name LIKE '%$search%'</code></li>
<li>Use full index search (since 5.6 it only works on MyISAM engine) to speed search queries instead of <code>LIKE</code>. <a href="http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html" rel="nofollow">MySql Manual</a></li>
<li>Google for SQLInjection.</li>
<li>Use Object Oriented driver like <a href="http://www.php.net/manual/pl/book.pdo.php" rel="nofollow"><code>PDO</code></a></li>
</ol>

blocks|key|773300|text|虽然Click已经解决了“工作时没有错误”的问题，但这里是你的代码的一些改进。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|773301|<?php
mysql_connect("localhost",+"root",+"");
mysql_select_db("site"));

if+(isset($_GET["text"]))+{+//+you+have+to+use+GET+method+for+the+search
++++$search+=+mysql_real_escape_string($_GET["text"]);+//+an+essential+thing
++++$query++=+"SELECT+*+FROM+torrents+WHERE+name+LIKE+'%25$search%25'";
++++$result+=+mysql_query($query)+or+trigger_error(mysql_error()."+".$query);
++++while($row+=+mysql_fetch_array($result,+MYSQL_ASSOC))+{
++++++++echo+$row['name'];+
++++}
}|code-block|syntax|javascript|773302|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

although Click already nailed "works error free" problem, here is your code with some improvements.

<pre><code>&lt;?php
mysql_connect("localhost", "root", "");
mysql_select_db("site"));

if (isset($_GET["text"])) { // you have to use GET method for the search
 $search = mysql_real_escape_string($_GET["text"]); // an essential thing
 $query = "SELECT * FROM torrents WHERE name LIKE '%$search%'";
 $result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
 while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 echo $row['name']; 
 }
}
</code></pre>

I am fairly new to PHP and mysql and was wondering if I could get some help with my code for searching my database and returning the results.
<code>

<pre><code>&lt;?php
$con = mysql_connect("localhost", "root", "");
if (!$con) {
 die ("could not connect to db");
}

if (!mysql_select_db("site", $con)) {
 die ("Could not connect to table");
}

$search = $_POST["text"];
$result = mysql_query("SELECT * FROM torrents WHERE name ='$search'"); //or LIKE instead of =

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
 echo $row['name']; 
}

?&gt;
</code></pre>

</code>

Any help is appreciated. Right now the code works error free but has no output. open to all changes and advice.

Basic Search using the WHERE clause mysql_query and mysql_fetch_array

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我是PHP和mysql的新手，我想知道我是否可以在搜索数据库和返回结果的代码方面获得一些帮助。<?php$con = mysql_connect("localhost", "root", "");if (!$con) { die ("could not connect to db");}if (!mysql_se...

问使用WHERE子句mysql_query和mysql_fetch_array进行基本搜索
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用WHERE子句mysql_query和mysql_fetch_array进行基本搜索EN