Connect to database
Moderator: General Moderators
Connect to database
Is it possible to connect to a database located on another server ?
I agree with feyd on this, most db's are configured to allow local access only. But, if you want to connect to an Oracle9i server there are two parts. 1. Did you install php with oracle support?
--> You can do this two ways. Either:
-->-->a. uncomment these lines from your php.ini file:
or:
-->-->b. recompile php with the following options:
Note: you can check weather or not oracle is enabled within php with a simple php file with:
When you call that page from your browser it will give you all sorts of information about your php install. Make sure to delete this file or move it after you are done.
The actual connection to the db is accomplished with the following:
--This is using the OCI Extension Module --
or using the ORA Extension module:
here is an example for select, insert, update and delete:
I hope this helps. In either event you came to the right place for asking questions.
--> You can do this two ways. Either:
-->-->a. uncomment these lines from your php.ini file:
Code: Select all
;extension = php_oci8.dll
;extension = php_oracle.dll-->-->b. recompile php with the following options:
Code: Select all
--with-oracle=/path/to/oracle/home/dir
--with-oci8=/path/to/oracle/home/dirCode: Select all
<?php
phpinfo();
?>The actual connection to the db is accomplished with the following:
--This is using the OCI Extension Module --
Code: Select all
<?php
if ($c=OCILogon("scott", "tiger", "orcl")) {
echo "Successfully connected to Oracle.\n";
OCILogoff($c);
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
?>Code: Select all
<?php
if ($c=ora_logon("scott@orcl","tiger")) {
echo "Successfully connected to Oracle.\n";
ora_commitoff($c);
ora_logoff($c);
} else {
echo "Oracle Connect Error " . ora_error();
}
?>Code: Select all
<?php
$c=OCILogon("scott", "tiger", "orcl");
if ( ! $c ) {
echo "Unable to connect: " . var_dump( OCIError() );
die();
}
// Drop old table...
$s = OCIParse($c, "drop table tab1");
OCIExecute($s, OCI_DEFAULT);
// Create new table...
$s = OCIParse($c, "create table tab1 (col1 number, col2 varchar2(30))");
OCIExecute($s, OCI_DEFAULT);
// Insert data into table...
$s = OCIParse($c, "insert into tab1 values (1, 'Frank')");
OCIExecute($s, OCI_DEFAULT);
// Insert data using bind variables...
$var1 = 2;
$var2 = "Scott";
$s = OCIParse($c, "insert into tab1 values (:bind1, :bind2)");
OCIBindByName($s, ":bind1", $var1);
OCIBindByName($s, ":bind2", $var2);
OCIExecute($s, OCI_DEFAULT);
// Select Data...
$s = OCIParse($c, "select * from tab1");
OCIExecute($s, OCI_DEFAULT);
while (OCIFetch($s)) {
echo "COL1=" . ociresult($s, "COL1") .
", COL2=" . ociresult($s, "COL2") . "\n";
}
// Commit to save changes...
OCICommit($c);
// Logoff from Oracle...
OCILogoff($c);
?>Re Oracle Connection
Hye Thanks for that, Much appreciated but I have now decided to use MYSQL and php which I have connected
Shab
Shab