html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Documenttitle>
head>
<body>
session_start();
$sql="UPDATE foodList_table SET
foodName='".$_POST["foodName"]."',"
."food_temperature='".$_POST["food_temperature"]."',"
."foodScore='".$_POST["foodScore"]."',"
."food_taste='".$_POST["food_taste"]."',"
."food_tropism='".$_POST["food_tropism"]."',"
."upOrdown='".$_POST["upOrdown"]."',"
."inAir='".$_POST["inAir"]."',"
."inBlood='".$_POST["inBlood"]."',"
."gall_bladder='".$_POST["gall_bladder"]."',"
."liver='".$_POST["liver"]."',"
."lung='".$_POST["lung"]."',"
."large_intestine='".$_POST["large_intestine"]."',"
."stomach='".$_POST["stomach"]."',"
."spleen='".$_POST["spleen"]."',"
."heart='".$_POST["heart"]."',"
."intestine='".$_POST["intestine"]."',"
."bladder='".$_POST["bladder"]."',"
."kidney='".$_POST["kidney"]."',"
."pericardium='".$_POST["pericardium"]."',"
."triple_energizer='".$_POST["triple_energizer"]."',"
."spicy='".$_POST["spicy"]."',"
."sweet='".$_POST["sweet"]."',"
."tasteless='".$_POST["tasteless"]."',"
."acid='".$_POST["acid"]."',"
."bitter='".$_POST["bitter"]."',"
."salty='".$_POST["salty"]."',"
."edible_part='".$_POST["edible_part"]."',"
."water='".$_POST["water"]."',"
."energy='".$_POST["energy"]."',"
."protein='".$_POST["protein"]."',"
."fat='".$_POST["fat"]."',"
."carbohydrate='".$_POST["carbohydrate"]."',"
."insoluble_fiber='".$_POST["insoluble_fiber"]."',"
."cholesterol='".$_POST["cholesterol"]."',"
."ash='".$_POST["ash"]."',"
."total_vitaminA='".$_POST["total_vitaminA"]."',"
."carotene='".$_POST["carotene"]."',"
."retinol='".$_POST["retinol"]."',"
."thiamine='".$_POST["thiamine"]."',"
."riboflavin='".$_POST["riboflavin"]."',"
."nicotinic_acid='".$_POST["nicotinic_acid"]."',"
."vitaminC='".$_POST["vitaminC"]."',"
."vitaminE='".$_POST["vitaminE"]."',"
."calcium ='".$_POST["calcium"]."',"
."phosphorus='".$_POST["phosphorus"]."',"
."potassium='".$_POST["potassium"]."',"
."sodium='".$_POST["sodium"]."',"
."magnesium='".$_POST["magnesium"]."',"
."iron='".$_POST["iron"]."',"
."zinc='".$_POST["zinc"]."',"
."selenium='".$_POST["selenium"]."',"
."copper='".$_POST["copper"]."',"
."manganese='".$_POST["manganese"]."',"
."comment='".$_POST["comment"]."',"
."glycemic_index='".$_POST["glycemic_index"]."',"
."data_source='".$_POST["data_source"]."' WHERE food_id=".intval($_POST["food_id"]).";";
require_once("../dataBase.php");
$conn->query($sql);
if($conn->query($sql)==TRUE){
echo $_POST["foodName"];
$_SESSION["caution_words"]="食物属性修改成功";
//header("location:./search_foodlist.php");
//exit();
}else{
echo "ERROR:".$sql."
".$conn->error;
}
?>
body>
html>
你是update不是insert，是更新不是插入
UPDATE 是修改数据
如果数据库里没有对应的where条件，执行也不会报错，只不过返回的影响行数是0
数据库里的数据不会被修改
执行完更新，要提交conmmit吧
我是提交的一个表格，将之前对应的数据更新。
找到原因了，food_id 因为不想修改，在上一个表格页面中就没有放到input标签中，所以没有提交！food_id获取的是空值。谢谢大家！
UPDATE 是修改，不是插入