PHP Oracle

[Anon]

hi all,

i have this problem wif converting mySQL to oracle using PHP....rather beginner stuff i guess 🙂

My code:
$sql = "INSERT INTO USER_TRACK
VALUES(\"$user_id\", \"$sel_item\", \"$sel_item_title\",
\"$sel_item_qty\", \"$sel_item_price\", \"$sel_item_totalprice\",
\"$date_added\")";

$sql_result = mysql_query($sql,$connection)
or die ("Couldn't insert record!");

$item_count = "SELECT SUM(SEL_ITEM_QTY) FROM USER_TRACK
WHERE USER_ID = \"$user_id\"";

$item_result = mysql_query($item_count)
or die("Couldn't get count");

$item_count_total = mysql_result($item_result,0,"SUM(SEL_ITEM_QTY)");

what are the corresponding Oracle commands?
I tried OCIParse -->> OCIExecute -->> OCIFetchInto but it doesn't work

thanks.

[Anon]

The order that you need is:

1. Define your connection (OCILogon);
2. Define and parse your query (OCI_PARSE);
3. Execute the parsed statement (OCI_EXECUTE);
4. Close the connection (OCILogoff);

An example for insertion into the Oracle test database is:

<?php
PutEnv("ORACLE_SID=home");

echo "Have set the Oracle SID<BR>\n";

$connection = OCILogon ("scott", "tiger");

echo "Have established the connection";

if ($connection == false){
echo "Sorry , connection failed";
echo OCIError($connection)."<BR>\n";
exit;
}

#$query = "select * from emp";
$query = "INSERT INTO emp (empno, ename, job, sal, comm, deptno) VALUES (7890, 'JINKS', 'CLERK', 1.2E3, NULL, 40)";

$cursor = OCIParse ($connection, $query);

if ($cursor == false){
echo OCIError($cursor)."<BR>\n";
exit;
}

$result = OCIExecute ($cursor);

if ($result == false){
echo OCIError($cursor)."<BR>";
exit;
}

echo "Have successfully inserted a row<BR>\n";

OCILogoff ($connection);

?>

HTH
Justin

[Anon]

thanks for ur advice
but i got the following error

Warning: OCIStmtExecute: ORA-01861: literal does not match format string in /xxxx.php on line 39
Array

What could be the problem? thanks

[mikeq]

I would use single quotes in your statements and get rid of all of those slashes

$sql = "INSERT INTO USER_TRACK
VALUES('$user_id', '$sel_item', '$sel_item_title','$sel_item_qty','$sel_item_price', '$sel_item_totalprice','$date_added')";