run update or insert query after select query mysql in php

Question

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);
    }

}

try `if(isset($_POST["displayid"]))` instead of `if($_POST["displayid"]==TRUE)`. Learn about prepared statments to prevent SQL injection — Jens, Jul 07 '16 at 07:47
try this $conn->query($sqlfail); to this mysqli_query($conn,$sqlfail); — JYoThI, Jul 07 '16 at 07:49
i use connection as $conn = new mysqli($servername, $username, $password, $dbname); — soma, Jul 07 '16 at 07:54

score 0 · Answer 1 · answered Jul 07 '16 at 07:57

Where is the $conn object come from? try this..

<?php

if($_POST["displayid"])
{

$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' AND 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')";
mysqli_query($conn, $sqlfail);


}

}

in the upadte code error was using ", " instant of "AND" - but insert code not working — soma, Jul 07 '16 at 10:10

score 0 · Accepted Answer · answered Jul 07 '16 at 08:12

0

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);
    }
}

answered Jul 07 '16 at 08:12

urfusion

5,528
5
50
87

your update code i working now but insert is still not work – soma Jul 07 '16 at 09:30
insert might not work because you are getting values by `select` query – urfusion Jul 07 '16 at 09:32
if mysqli_num_rows($result) is zero the else should work and insert ino fail table is right? – soma Jul 07 '16 at 10:08
Yes. Insert should wrk – urfusion Jul 07 '16 at 10:15

run update or insert query after select query mysql in php

2 Answers2