Microsoft Word - Core PHP Programming Using PHP to Build Dynamic Web Sites

//undo the inserts //Normally, you won't do this, if we undo the inserts //each time, we can run the example over and over ociro ...

The ocicommit function commits all previous statements executed on the connection. By default, statements are committed when exe ...

array ocierror(integer identifier) If an error has occurred, the ocierror function returns an associative array that describes i ...

print(""); //print a line like "ENAME VARCHAR2(10)" print(ocicolumnname($Statement, $i). " "); print(ocicolumntype($Statement, $ ...

Table 13.10. Constants for Use with ocifetchinto Constant Description OCI_ASSOC (^) Return columns indexed by name OCI_NUM (^) R ...

//close connection ocilogoff($Connection); ?> integer ocifetchstatement(integer statement, reference data) The ocifetchstatem ...

//close connection ocilogoff($Connection); ?> boolean ocifreecursor(integer cursor) Use ocifreecursor to free the memory asso ...

$Cursor = ocinewcursor ($Connection); //create statement that calls a stored procedure $Query = "BEGIN "; $Query .= "docalculati ...

The ocinumcols function returns the number of columns in a statement. See ocifetch for an example of use. integer ociparse(integ ...

Use ociserverversion to get a string describing the version of the server for a connection. integer ocisetprefetch(integer state ...

//close the oracle cursor ora_close($Cursor); //disconnect. ora_logoff($Connection); ?> boolean ora_close(integer cursor) The ...

integer ora_do(integer connection, string query) The ora_do function executes a query on the given connection. PHP takes care of ...

boolean ora_exec(integer cursor) The ora_exec function executes a query previously parsed by the ora_parse function. Compare thi ...

for($i = 0; $i ora_numcols($Cursor); $i++) { print(""); // get column info print(ora_columnname($Cursor, $i). ": "); print(ora_c ...

integer ora_fetch_into(integer cursor, reference fields, integer flags) The ora_fetch_into function gets the next row from the c ...

The ora_getcolumn function returns the value of the column for the current row. Columns are indexed starting with zero. Long col ...

The ora_rollback function performs a rollback on the given connection. Automatic commits must be turned off first. Postgres Post ...

integer pg_connect(string host, string port, string options, string database) integer pg_connect(string host, string port, strin ...

print("\n"); //create query $Query = "SELECT * "; $Query .= "FROM item"; //execute query if(!($Result = pg_exec($Connection, $Qu ...

// free the result and close the connection pg_freeresult($Result); pg_close($Connection); ?> array pg_fetch_array(integer re ...