Execute queries in Oracle with PHP

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

/*******************************************************

* MYCPLUS Sample Code - https://www.mycplus.com *

* *

* This code is made available as a service to our *

* visitors and is provided strictly for the *

* purpose of illustration. *

* *

* Please direct all inquiries to saqib at mycplus.com *

*******************************************************/

//fetch the data from oracle using the PHP.

<html>

<head>

</head>

<body>

//in case these aren't set for httpd

putenv("ORACLE_HOME=/usr/local/oracle7");

putenv("ORACLE_SID=ORCL");

function reportError($id, $message)

{

print("$message<br />\n");

print("Error Code: " . ora_errorcode($id) . "<br />\n");

print("Error Message: " . ora_error($id) . "<br />\n");

}

//connect to server

if(!($Connection = ora_logon("scott", "tiger")))

{

print("Could not connect to database!<br />\n");

exit;

}

//open cursor

if(!($Cursor = ora_open($Connection)))

{

reportError($Connection, "Cursor could not be opened!");

exit;

}

$Query = "SELECT * ";

$Query .= "FROM emp ";

//parse query

if(!ora_parse($Cursor, $Query))

{

reportError($Cursor, "Statement could not be parsed!");

exit;

}

// execute query

if(!ora_exec($Cursor))

{

reportError($Cursor, "Statement could not be executed!");

exit;

}

//start table

print("<table BORDER=\"1\">\n");

//print header row that describes each column

print("<tr>\n");

for($i = 0; $i < ora_numcols($Cursor); $i++)

{

print("<th>");

// get column info

print(ora_columnname($Cursor, $i) . ": ");

print(ora_columntype($Cursor, $i) . " ");

print("(" . ora_columnsize($Cursor, $i) . ")");

print("</th>\n");

}

print("</tr>\n");

// get each row

while(ora_fetch($Cursor))

{

print("<tr>\n");

//loop over each column

for($i = 0; $i < ora_numcols($Cursor); $i++)

{

print("<td>");

// get column

print(ora_getcolumn($Cursor, $i));

print("</td>\n");

}

print("</tr>\n");

}

//close table

print("</table>\n");

print("<br />\n");

print("Rows: " . ora_numrows($Cursor));

print("<br />\n");

// Close the Oracle cursor

ora_close($Cursor);

// disconnect.

ora_logoff($Connection);

</body>

</html>