PHP無法寫進mySQL
Jun 13, 2016 am 11:20 AM
PHP無法寫入mySQL
小妹是php新手
最近想要試著寫一個搜尋程式
主要是藉由php作為媒介連結android和mySQL
不過卻卡在我的php一直無法成功判讀SQL語法
以下是我主要問題程式片段:
(in?java)
try?{
String?result?=?DBConnector.executeQuery("SELECT*FROM?user?where?zip?=?'newzip'?");
System.out.println(result);
(php語法)
$db?=?mysql_pconnect("localhost","root","1234");
mysql_query("SET?CHARACTER?SET?'UTF8';");
mysql_query("SET?NAMES?UTF8;");
mysql_query("SET?CHARACTER_SET_CLIENT=UTF8;");
mysql_query("SET?CHARACTER_SET_RESULTS=UTF8;");
mysql_select_db("food");
$sql?=?$_POST["query_string"];
$res?=?mysql_query($sql);
while($r?=?mysql_fetch_assoc($res))
$output[]?=?$r;
print(json_encode($output));
mysql_close();
?>
這是我的錯誤訊息:
mysql_fetch_assoc():?supplied?argument?is?not?a?valid?MySQL?result?resource?in?C:\AppServ\www\AndroidConnectDB\android_connect_db.php?on?line?13
我有將java中的語法直接在phpmyadmin中執(zhí)行
(即SELECT*FROM?user?where?zip?=?'newzip')
是可以正確找到該筆符合條件的資料
但是不知道為什麼?透過java寫入至php中去呼叫mySQL執(zhí)行時卻總是傳回錯誤
上網爬過很多文
有試著去修正過編碼的問題(SET?NAMES?UTF8;)
也有去php.ini修改過?magic_quotes_gpc?=?On
但仍舊回傳null以及錯誤訊息
但是我將它改成
SELECT*FROM?user?where?id=1?時
是可以正確執(zhí)行的00"
所以再猜想會不會是單引號引起的問題
也有將它改成
SELECT*FROM?user?where?zip?=?/'newzip/'
卻仍舊不見好轉ˊˋ
想要請問各位大大是否有解決的方法?ˊˋ
------解決方案--------------------
猜測是沒有用的,需要看到出錯時的錯誤信息
$res?=?mysql_query($sql)?or?die(mysql_error());
因為你給出的錯誤信息是
mysql_fetch_assoc():?supplied?argument?is?not?a?valid?MySQL?result?resource?
即傳遞給?mysql_fetch_assoc?的不是有效的?MySQL?資源,所以要逐步向上查找
------解決方案--------------------
你不覺得應該是這樣嗎?
SELECT * FROM user where zip = 'newzip'
------解決方案--------------------
關閉魔術引號,修改php.ini magic_quotes_gpc = Off
或者臨時對傳入字符串反轉義
$sql = stripslashes($_POST["query_string"]);?也可以應付過來

Hot AI Tools

Undress AI Tool
Undress images for free

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

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

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

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

The key to setting up PHP is to clarify the installation method, configure php.ini, connect to the web server and enable necessary extensions. 1. Install PHP: Use apt for Linux, Homebrew for Mac, and XAMPP recommended for Windows; 2. Configure php.ini: Adjust error reports, upload restrictions, etc. and restart the server; 3. Use web server: Apache uses mod_php, Nginx uses PHP-FPM; 4. Install commonly used extensions: such as mysqli, json, mbstring, etc. to support full functions.

The key to writing PHP comments is to clarify the purpose and specifications. Comments should explain "why" rather than "what was done", avoiding redundancy or too simplicity. 1. Use a unified format, such as docblock (/*/) for class and method descriptions to improve readability and tool compatibility; 2. Emphasize the reasons behind the logic, such as why JS jumps need to be output manually; 3. Add an overview description before complex code, describe the process in steps, and help understand the overall idea; 4. Use TODO and FIXME rationally to mark to-do items and problems to facilitate subsequent tracking and collaboration. Good annotations can reduce communication costs and improve code maintenance efficiency.

ToinstallPHPquickly,useXAMPPonWindowsorHomebrewonmacOS.1.OnWindows,downloadandinstallXAMPP,selectcomponents,startApache,andplacefilesinhtdocs.2.Alternatively,manuallyinstallPHPfromphp.netandsetupaserverlikeApache.3.OnmacOS,installHomebrew,thenrun'bre

TolearnPHPeffectively,startbysettingupalocalserverenvironmentusingtoolslikeXAMPPandacodeeditorlikeVSCode.1)InstallXAMPPforApache,MySQL,andPHP.2)Useacodeeditorforsyntaxsupport.3)TestyoursetupwithasimplePHPfile.Next,learnPHPbasicsincludingvariables,ech

There are three common methods for PHP comment code: 1. Use // or # to block one line of code, and it is recommended to use //; 2. Use /.../ to wrap code blocks with multiple lines, which cannot be nested but can be crossed; 3. Combination skills comments such as using /if(){}/ to control logic blocks, or to improve efficiency with editor shortcut keys, you should pay attention to closing symbols and avoid nesting when using them.

PHPblockcommentsareusefulforwritingmulti-lineexplanations,temporarilydisablingcode,andgeneratingdocumentation.Theyshouldnotbenestedorleftunclosed.BlockcommentshelpindocumentingfunctionswithPHPDoc,whichtoolslikePhpStormuseforauto-completionanderrorche

Comments cannot be careless because they want to explain the reasons for the existence of the code rather than the functions, such as compatibility with old interfaces or third-party restrictions, otherwise people who read the code can only rely on guessing. The areas that must be commented include complex conditional judgments, special error handling logic, and temporary bypass restrictions. A more practical way to write comments is to select single-line comments or block comments based on the scene. Use document block comments to explain parameters and return values at the beginning of functions, classes, and files, and keep comments updated. For complex logic, you can add a line to the previous one to summarize the overall intention. At the same time, do not use comments to seal code, but use version control tools.

The key to writing good comments is to explain "why" rather than just "what was done" to improve the readability of the code. 1. Comments should explain logical reasons, such as considerations behind value selection or processing; 2. Use paragraph annotations for complex logic to summarize the overall idea of functions or algorithms; 3. Regularly maintain comments to ensure consistency with the code, avoid misleading, and delete outdated content if necessary; 4. Synchronously check comments when reviewing the code, and record public logic through documents to reduce the burden of code comments.
