Insert is not working php pdo

Asked Sep 14 '15 at 14:02

Active Jan 02 '17 at 06:03

Viewed 43 times

Following is my code

$sqlcreate = "INSERT INTO PRTJOBSTATUS (INTJOBNO,SLNO,OPDATE,OPERTYPE,OPUSER,REMARKS,STATUSCODE,STATDATE)
            values (:int,:sn,:opdate,:optype,:opuser,:rmks,:stscode,:stdate)";
    $stmt = $dbh->prepare($sqlcreate);
    $stmt->bindValue(':int',$intjobno);
    $stmt->bindValue(':sn',$slno);
    $stmt->bindValue(':opdate',$today);
    $stmt->bindValue(':optype',$optype);
    $stmt->bindValue(':opuser',$opuser);
    $stmt->bindValue(':rmks',$remarks);
    $stmt->bindValue(':stscode',$statuscode);
    $stmt->bindValue(':stdate',$today);
    $stmt->execute();
    echo "Inserted";

While running its printing "Inserted", but not updating in my oracle database.

edited Sep 14 '15 at 14:02

Funk Forty Niner

74,450
15
68
141

asked Sep 14 '15 at 14:02

Vipin KA

3

Are you doing *any* error checking? Have you checked your error logs? – Jay Blanchard Sep 14 '15 at 14:03
maybe do you need `commit` ? – Halayem Anis Sep 14 '15 at 14:05
2

http://php.net/manual/en/pdo.errorinfo.php --- http://php.net/manual/en/pdo.error-handling.php --- http://php.net/manual/en/function.error-reporting.php - *There Sam. OP has enough to go on...* - @JayBlanchard – Funk Forty Niner Sep 14 '15 at 14:06
I put if (!$stmt) { echo "\nPDO::errorInfo():\n"; print_r($dbh->errorInfo()); } after prepare statement. nothing printing... – Vipin KA Sep 14 '15 at 17:21
How to commit using pdo?? – Vipin KA Sep 14 '15 at 17:22

Insert is not working php pdo

0 Answers0