doupao2277 2016-07-07 07:42
浏览 84
已采纳

在php中选择查询mysql后运行更新或插入查询

i have spend more than 24 hours trying to run update or insert query after select query but select query done and update or insert query never done when submite "displayid"

code##

if($_POST["displayid"]==TRUE) {

    $sqlid = "SELECT * FROM doc1 WHERE idnum ='$pidnum' AND stats='$ok'";
    $result = mysqli_query($conn, $sqlid);
    if (mysqli_num_rows($result) > 0) {
         $sqlup = "UPDATE doc1 SET  m_phone='$pmphone', seen='$dataseen' WHERE  idnum ='$pidnum'";
        mysqli_query($conn, $sqlup);
        $found=1;
    }
    else {
        $found=0;
        $sqlfail="INSERT INTO fail(fname,lname,tname,funame,idnum,m_phone,reg_date) VALUES('$pfname','$plname','$ptname','$pfuname','$pidnum','$pm_phone','$todaydate')";
        $conn->query($sqlfail);
    }

}
  • 写回答

2条回答 默认 最新

  • duanbushi1479 2016-07-07 08:12
    关注

    First of all you update query is wrong. for checking errors please add

    error_reporting(E_ALL);
    ini_set('display_errors', 1);
    

    Updated code

    if ($_POST["displayid"] == TRUE) {
    
        $sqlid = "SELECT * FROM doc1 WHERE idnum ='$pidnum' AND stats='$ok'";
        $result = mysqli_query($conn, $sqlid);
        if (mysqli_num_rows($result) > 0) {
            $sqlup = "UPDATE doc1 SET  m_phone='$pm_phone', seen='$dataseen' WHERE  idnum ='$pidnum'";
            mysqli_query($conn, $sqlup);
            $found = 1;
        } else {
            $found = 0;
            $sqlfail = "INSERT INTO fail(fname,lname,tname,funame,idnum,m_phone,reg_date)
    VALUES ('$pfname','$plname','$ptname','$pfuname','$pidnum','$pm_phone','$todaydate')";
            $conn->query($sqlfail);
        }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 求数据集和代码#有偿答复
  • ¥15 关于下拉菜单选项关联的问题
  • ¥15 如何修改pca中的feature函数
  • ¥20 java-OJ-健康体检
  • ¥15 rs485的上拉下拉,不会对a-b<-200mv有影响吗,就是接受时,对判断逻辑0有影响吗
  • ¥15 使用phpstudy在云服务器上搭建个人网站
  • ¥15 应该如何判断含间隙的曲柄摇杆机构,轴与轴承是否发生了碰撞?
  • ¥15 vue3+express部署到nginx
  • ¥20 搭建pt1000三线制高精度测温电路
  • ¥15 使用Jdk8自带的算法,和Jdk11自带的加密结果会一样吗,不一样的话有什么解决方案,Jdk不能升级的情况