How To Update oracle data from php, by using 'Commit' ?

widiarifki · #1 (**permalink**) 01-29-12, 03:41

dear everybody,

I want to ask something that make me confuse. About work using PHP n Oracle together.

I want to update an existing data on oracle table. I use this script:

Code:

//connect to database
$conn=ora_logon("hr","hr");
$cur=ora_open($conn);

$no_dept=$_POST['no_dept'];
$nm_dept=$_POST['name_dept'];

ora_parse($cur, "update departement set nm_dept='$nm_dept' where no_dept='$no_dept'");
ora_exec($cur);

Going well, without error. But, when I go back to index.php which showing fetching data from department table. The data which I have updated doesn't change. I think it needs 'COMMIT'. But how I use it on PHP??

I've been searching on Google. But, I didn't find the answer.

Please help your Junior.
Thanks for your response.

Regards,
widia.