Questions about PHP and Oracle

[pablogosse]

Hi all. I've been working with PHP for almost a year now, and am quite comfortable using PHP with MySQL and PostgreSQL.

However, in my new job I have to use Oracle, and I've yet to have the pleasure of working with PHP and Oracle.

My first and most basic quetsion is whether I'm correct in making the following assumtion:

Once I have my tables created in the DB, am I able to keep working the same way I did with MySQL and Postgre whereby I:
1) open a connection to the server using ora_logon
2) open a cursor using ora_open
3) use ora_parse to parse my sql statement
4) call ora_exec to execute the statement and then deal with the data as I normally would.

If anyone could tell me if I'm correct in assuming this it would be great.

Also, if I am correct in assuming this, would there by any advantage to actually developing my code in PL/SQL blocks as opposed to this method?

Thanks in advance,

Pablo

[Anon]

this is the code i wrote to first test my oracle connections using php....

$conn = OCILogon("username","password", "database") or die("COULD NOT CONNECT");
$sql = "select * from tbl_name";
$query = OCIParse($conn, $sql);
OCIExecute($query);
$tableColumns = ociNumCols($query);
while(ociFetch($query)) {
for($nc = 1; $nc <= $tableColumns; $nc++) {
echo "&nbsp;".ociResult($query, $nc);
}
echo "<br />";
}
ociFreeStatement($query);