How to call three databases with PHP (3)_PHP tutorial

Oracle is the world's most popular relational database. It is a powerful engine of industrialization promoted by large companies. Let’s take a look at its related functions first:

(1) integer ora_logon (string user, string password)

Start a connection to an Oracle database server.

(2)integer ora_open(integer connection)

Open the cursor of the given connection.

(3)integer ora_do(integer connection, string query)

Execute the query on the given connection. PHP generates an indicator, parses the query, and executes it.

(4)integer ora_parse(integer cursor, string query)

Parse a query and prepare it for execution.

(5) boolean ora_exec(integer cursor)

Execute a query previously parsed by the ora_parse function.

(6) boolean ora_fetch(integer cursor)

This function will cause the rows in an executed query to be fetched into the indicator. This allows you to call the ora_getcolumn function.

(7) string ora_getcolumn(integer cursor, integer column)

Return the current value. Column zero-based numeric index.

(8) boolean ora_logoff(integer connection)

Disconnect the link to the database server.

The following is a sample program to insert data into the ORACLE database:

ID	name	Description
	< ;input type="text" name="email" maxlength="255" size="30">

//Set first Two environment variables ORACLE_HOME, ORACLE_SID

putenv("ORACLE_HOME=/oracle/app/oracle/product/8.0.4");

putenv("ORACLE_SID=ora8");

//Set the web page to display Chinese

putenv("NLS_LANG=Simplified_Chinese.zhs16cgb231280");

if($connection=ora_logon("scott","tiger")) {

//Library table test has three items: ID, name, and Description

$sql = 'insert into test(ID, name, Description) values ​​';

$sql .= '('' . $ID . '','' . $name . '',''. $Description . '')';

if($cursor=ora_do($connect,$ sql)) {

print("insert finished!");

}

$query = 'select * from test';

if( $cursor=ora_do($connect,$query)) {

ora_fetch($cursor);

$content0=ora_getcolumn($cursor,0);

$content1 =ora_getcolumn($cursor,1);

$content2=ora_getcolumn($cursor,2);

print("$content0");

print("$ content1");

print("$content2");

ora_close($cursor);

}

ora_logoff($connection);

}

?>

http://www.bkjia.com/PHPjc/315531.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315531.htmlTechArticleOracle (Oracle) is the most popular relational database in the world. It is a powerful engine of industrialization promoted by large companies. Let’s take a look at its related functions first: (1) integer ora_lo...