所以我试图使用 html 表单和一些 PHP 代码更新数据库字段,但我无法让它工作,它不会抛出任何错误,但不会更新该字段?,我不确定它是否因为我也回显该字段网页?它似乎所做的就是打印失败消息。
HTML:
<html>
<form method="post" name="update" action="updateform.php" />
Description:
<input type="text" name="description" />
<input type="submit" name="Submit" Value="update" />
</form>
</html>
PHP:
<?php
mysql_connect("localhost", "root", "*****") or die("Connection Failed");
mysql_select_db("Days")or die("Connection Failed");
$description = $_POST['description'];
$query = "UPDATE test SET description = '$description' ";
if(mysql_query($query)){ echo "updated";} else{ echo "fail";} ?>
我的回声(工作):
<?php
include("include/session.php");
//connect to the server
$connect = mysql_connect("localhost","root","*****");
//connect to the database
mysql_select_db("days");
//query the database
$query = mysql_query("SELECT * FROM hobby WHERE id = '1' ");
//ferch the results / convert results into an array
WHILE($rows = mysql_fetch_array($query)):
$description = $rows['description'];
echo "<div style ='font:15px/21px Arial,tahoma,sans-serif;color:#cf5c3f </h>'>$description";
endwhile;
?>
UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
更新查询示例,但我没有得到你的 sql ..你错过了where
clause
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)