Why PHP script is not being able to update data in oracle database?

Question

The Following Code is not Updating the records into Oracle Database. Can any one please help what exactly the cause behind this. If any other reason might be making problem please suggest. Thanks in advance

<?php
if(isset($_GET['submit'])) {
echo $sl_no = $_GET['sl_no'];
echo $subject = $_GET['subject'];


// update Subject
$str2 = "update application_form af set af.subject_code=:subject where   af.application_form_sl_no=:sl_no";
$stid_update2 = oci_parse($conn, $str2);
oci_bind_by_name($stid_update2, ":subject", $subject);
oci_bind_by_name($stid_update2, ":sl_no", $sl_no);
oci_execute($stid_update2);
$success2 = oci_commit($conn);

// send successful message

    if($success2)
    {
    echo "Form saved Successfully!!!";
    }
}   
?>

Are you getting an error? checkout oci_error

Aaron W.
– Aaron W.

2012-05-25 11:16:55 +00:00
Commented May 25, 2012 at 11:16 — Aaron W.
– Aaron W., Commented May 25, 2012 at 11:16

user1403947 · Accepted Answer · 2012-05-25 11:16:20Z

1

You didn't declare the $conn variable and connect to the database

$conn = oci_connect('hr', 'welcome', 'localhost/XE');

Resource: http://php.net/manual/en/function.oci-connect.php

answered May 25, 2012 at 11:16

user1403947

Sign up to request clarification or add additional context in comments.

2 Comments

halfer Over a year ago

Indeed. OP, check your error-reporting is enabled, and that all warnings are written to the screen on your dev machine.

Samcoder Over a year ago

Thanks, and sorry to say that I have already have the code for connection in a different file and the codes for select query just above the code mentioned (which i did not typed here), are working fine. Just the update part is not working. Is any thing wrong with user privilege or connection protocol or COMMIT issue? I am well equipped with Mysql but in oracle db, though I have done with select queries but for updating records, I am new. Hope my words may help you to get my problem.

Collectives™ on Stack Overflow

Why PHP script is not being able to update data in oracle database?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related