Unable to delete data from oracle database using php

[Nida_2]

Hey!! i am using php to delete data from database but its not deleting and no error is showing. Please help me.

      <?php
        include('connect.php');
        $p_No = $_POST['p_No'];
        $sql2 = "DELETE FROM usersR WHERE p_No = '$p_No'";
        $compiled1 = oci_parse($conn,$sql2);
        $ex = oci_execute($compiled1,OCI_DEFAULT);
        ?>

[AndrisP]

1. Read manual about coommit http://php.net/manual/en/function.oci-execute.php
2. Bind variables after oci_parse to prevent from SQL injection http://php.net/manual/en/function.oci-bind-by-name.php

Post to the web development forum. This is community. You already have an open thread on this issue there.