Question

php操作MYSQL数据库无法更新；$sql = "UPDATE data1 SET idata='".$_POST['FCKeditor1']."' WHERE id='1'"

Answer 1

<?php

//原始 $sql = "UPDATE data1 SET idata='".$_POST['FCKeditor1']."' WHERE id='1'"

$idata=$_POST['FCKeditor1'];
$idata || die('没有传递过来值哟,当然你就无法更新了');
$sql = "UPDATE data1 SET idata='".$idata."' WHERE id=1"
//id='1' 没必要 直接id=1 即可 还有注意如果传递的值里面里面有需要转义的必须转义 否则报错
?>

Answer 2

function update($table_name, $field, $subquery){
$query = '';
foreach ($field as $index => $value){
$value = addslashes($value);
if (!$query) {$query = "`$index` = '$value'"; }else{$query .= ", `$index` = '$value'";}}
$query = "UPDATE `$table_name` SET " . $query . ' ' . $subquery;
$link = mysql_query($query);
return $link;}

用这个函数是下
$arr['idata']=$_post['aa']
update(data1);

Answer 3

<?php
session_start();
include "../conn.php";

$zhuti=($_POST['zhuti']);
$neirong=($_POST['neirong']);
$id=($_POST['id']);
$shenhe="update zhuti set zhuti='$zhuti',neirong='$neirong' where id='$id'";
mysql_query($shenhe);
{

echo "<script>alert('登陆成功！');location='bjxw.php';</script>";
}

?>
试试这段代码，具体的就得你自己去改了，不明白就百度我!

Answer 4

$FCKeditor1 = $_POST['FCKeditor1'];
$sql = "UPDATE data1 SET idata='$FCKeditor1' WHERE id='1'"

你这样试下把。