douken7402 2019-02-28 13:09
浏览 79

原生php项目mysql插入命令只能不工作,没有错误

i have native php project working on hostgator reseller account but there was problem with mysql time stamps i tried to change it but not work so i decided to move it to anther server (AWS with wHM installed) the project works fine select update delete but the insert command not working !!! why ? i haven't no idea here is the hostgator project database server

hostgator database server (works fine)

this is the new server

aws database server works fine except insert command

here is snap from the query

    $sql="START TRANSACTION;";
            $sql .= "INSERT INTO areas (name,add_user)
VALUES ('" . $name . "','" . $_SESSION['user_id'] . "');";
            $sql .="INSERT INTO logsystem (log, add_user)
                    VALUES ('اضافة منطقة جديدة :  ".$name."','".$_SESSION['user_id']."');";
            $sql .="COMMIT;";
            if ($conw->multi_query($sql) === TRUE) {
                $message = '
            <div class="alert alert-success">
              <button type="button" class="close" data-dismiss="alert">&times;</button>
              <strong>تم اضافة المنطقة بنجاح </strong>
            </div>
    ';
            } else {
                echo "Error: " . $sql . "<br>" . $conw->error;
            }
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 素材场景中光线烘焙后灯光失效
    • ¥15 请教一下各位,为什么我这个没有实现模拟点击
    • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
    • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 保护模式-系统加载-段寄存器