Question

php添加更新数据哪里错了

session_start();
header("Content-Type:text/html;charset=utf-8");
include("Conn/conn.php");
//$username=$_SESSION["username"];
$ggbjmid=$_POST['ggbjmid'];//隐藏域id
$gonggao=trim($_POST['gonggao']);
date_default_timezone_set("PRC"); // 获取系统时间更新数据库
$addtime=date("Y-m-j H:i:s");
$query = mysql_query("select * from tb_shop_xinxi where mid='$ggbjmid'"); //查询数据库
if($value = mysql_fetch_array($query)){
mysql_query("update tb_shop_xinxi set GongGao ='$gonggao', GongGaoAddTime='$addtime' where mid = '$ggbjmid' ");//如果有数据
}else{
mysql_query("insert into tb_shop_xinxi(mid,GongGao,GongGaoAddTime) values('$ggbjmid','$gonggao','$addtime')");//如果无数据，插入一条数据

if($query){
echo "<script language='javascript'>alert('信息修改成功!');history.back();</script>";}else{echo "<script language='javascript'>alert('修改失败!');history.back();</script>";}

Answer 1

<?php
session_start();
header('Content_Type:text/html;charset=utf-8');
date_default_timezone_set('PRC');
include_once 'Conn/conn.php';
$ggbjmid = $_POST['gonggao'];
$gonggao = trim($_POST['gonggao']);
$addtime = date('Y-m-d H:i:s');
$query   = mysql_query('select `mid` from `tb_shop_xinxi` where `mid` = \'' . $ggbjmid . '\'');
$Sql =  mysql_num_rows( $query ) ? 'update `tb_shop_xinxi` set `GongGao` = \'' . $gonggao . '\', GongGaoAddTime = \'' . $addtime.'\' where `mid` = \'' . $ggbjmid. '\'' : 'insert into `tb_shop_xinxi`(`mid`, `GongGao`, `GongGaoAddTime`) values (\'' . $ggbjmid . '\', \'' . $gonggao . '\', \'' . $addtime . '\')';
$Msg = mysql_query( $Sql ) ? '信息修改成功' : '修改失败';
echo '
<script type="text/javascript">
<!--
alert("' . $Msg . '");
history.back();
//-->
';
die('</script>');

Answer 2

错误提示是什么

追问

我是新手不知这样写对不对，就是如果表中有另一表的记录就更新字段，如果无记录就把另一表的记录插入在dw里这行echo "alert('信息修改成功!');history.back();";}else{echo "<script语法错误