php的mysql查询语句可不可以这样用呢?
$query = "SELECT name FROM bank WHERE area LIKE 'aaa'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)) { $http = $row['http']; $task_query = "SELECT * FROM task WHERE link LIKE'%$http%'"; $task_result = mysql_query($task_query) or die(mysql_error()); while($task = mysql_fetch_array($task_result)); echo $task['high'].'<br />'; }
回复内容:
php的mysql查询语句可不可以这样用呢?
$query = "SELECT name FROM bank WHERE area LIKE 'aaa'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)) { $http = $row['http']; $task_query = "SELECT * FROM task WHERE link LIKE'%$http%'"; $task_result = mysql_query($task_query) or die(mysql_error()); while($task = mysql_fetch_array($task_result)); echo $task['high'].'<br />'; }
SELECT * FROM task JOIN (SELECT http AS zhttp FROM bank WHERE area LIKE 'aaa') AS Z ON task.link LIKE CONCAT('%', Z.zhttp, '%')
SELECT * FROM bank LEFT JOIN task ON task.link LIKE concat('%', bank.http, '%') WHERE bank.area = 'aaa'
我觉得你可能需要JOIN
....
<code>select task.high from task left join bank on task.link like concat('%', bank.http. '%') where bank.area like 'aaa' </code>
你在 $task_query = "SELECT * FROM task WHERE link='%$http%'";
这里应该是希望得到模糊匹配的效果,怎么能用 =
呢?

PHPsessionfilesarestoredinthedirectoryspecifiedbysession.save_path,typically/tmponUnix-likesystemsorC:\Windows\TemponWindows.Tocustomizethis:1)Usesession_save_path()tosetacustomdirectory,ensuringit'swritable;2)Verifythecustomdirectoryexistsandiswrita

ToretrievedatafromaPHPsession,startthesessionwithsession_start()andaccessvariablesinthe$_SESSIONarray.Forexample:1)Startthesession:session_start().2)Retrievedata:$username=$_SESSION['username'];echo"Welcome,".$username;.Sessionsareserver-si

The steps to build an efficient shopping cart system using sessions include: 1) Understand the definition and function of the session. The session is a server-side storage mechanism used to maintain user status across requests; 2) Implement basic session management, such as adding products to the shopping cart; 3) Expand to advanced usage, supporting product quantity management and deletion; 4) Optimize performance and security, by persisting session data and using secure session identifiers.

The article explains how to create, implement, and use interfaces in PHP, focusing on their benefits for code organization and maintainability.

The article discusses the differences between crypt() and password_hash() in PHP for password hashing, focusing on their implementation, security, and suitability for modern web applications.

Article discusses preventing Cross-Site Scripting (XSS) in PHP through input validation, output encoding, and using tools like OWASP ESAPI and HTML Purifier.

Autoloading in PHP automatically loads class files when needed, improving performance by reducing memory use and enhancing code organization. Best practices include using PSR-4 and organizing code effectively.

PHP streams unify handling of resources like files, network sockets, and compression formats via a consistent API, abstracting complexity and enhancing code flexibility and efficiency.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
