php修改資料庫出現問題

這個是guanli_ok.php

點擊提交後調到guanli_ok.php 但是那邊空白一片 也不會提示修改成功或者失敗 是什麼原因啊。。求解決方案

回複討論(解決方案)

SQL 串寫錯了
$insert=mysql_query("update tb_book set pwd='$xpwd',section='$section',name='$section' where id='$user' AND pwd='pwd'",$conn);

改了之後還是沒反應，，，

SQL 串寫錯了
$insert=mysql_query("update tb_book set pwd='$xpwd',section='$section',name='$section' where id='$user' AND pwd='pwd'",$conn);

還是沒反應啊。。

請你開啟 php 的錯誤顯示功能

請你開啟 php 的錯誤顯示功能

開啟了 但是還是空白一片

if(isset($_POST['Submit']) and $_POST['Submit']=="提交"){ 不用解釋了吧。。。

if(isset($_POST['Submit']) and $_POST['Submit']=="提交"){ 不用解釋了吧。。。

已改 但是還是空白。，。

if(isset($_POST['Submit']) and $_POST['Submit']=="提交"){ 不用解釋了吧。。。

已改 但是還是空白。，。

你沒進if

if(isset($_POST['xiugai']) and $_POST['Submit']=="確認修改"){

          
                  
     
        if(isset($_POST['Submit']) and $_POST['Submit']=="提交"){ 不用解釋了吧。。。     
已改  但是還是空白。，。    
 你沒進if   if(isset($_POST['xiugai']) and $_POST['xiugai']=="確認修改"){              
 ...

php.ini 中
display_errors = On
重啟 網頁伺服器

你的錯誤實際產生於 conn/conn.php

如果你的錯誤顯示是開啟的話
$insert=mysql_query("update tb_book set pwd='$xpwd',section='$section',name='$section' where id='$user' pwd='pwd'",$conn); //執行更新操作
echo mysql_error(); //這裡一定是有輸出的，因為 sql 指令錯了

conn

錯誤

Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404
localhost
06/30/15 13:38:48
Apache/2.2.9 (APMServ) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6

Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404
localhost
06/30/15 13:38:48
Apache/2.2.9 (APMServ) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6

你開始說是guanli_ok.php 你是guanl_ok.php

Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404
localhost
06/30/15 13:38:48
Apache/2.2.9 (APMServ) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6

你開始說是guanli_ok.php 你是guanl_ok.php

我改了 開啟發現是空白的。。

Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404
localhost
06/30/15 13:38:48
Apache/2.2.9 (APMServ) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6

你開始說是guanli_ok.php 你是guanl_ok.php

沒有錯誤提示

php.ini 中
display_errors = On
重啟 網頁伺服器

你的錯誤實際產生於 conn/conn.php

如果你的錯誤顯示是開啟的話
$insert=mysql_query("update tb_book set pwd='$xpwd',section='$section',name='$section' where id='$user' pwd='pwd'",$conn); //執行更新操作
echo mysql_error(); //這裡一定是有輸出的，因為 sql 指令錯了

是我conn錯了嗎？

print_r($_POST); 就能發現是個空數組，怎麼都不可能進入if裡面。肯定為空白了。

把你的form 定義改一改。
給 每個元素加上name 屬性。


submit 也是一樣，value改成value="提交"

改成


應該就能進入if分支了

Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404
localhost
06/30/15 13:38:48
Apache/2.2.9 (APMServ) mod_ssl/2.2.9 OpenSSL/0.9.8h PHP/5.2.6

你開始說是guanli_ok.php 你是guanl_ok.php

沒有錯誤提示

你開啟一個不存在的頁面 當然是報404了。。。

