I'm trying to develop website using php but I have two servers:
*one for php files
*other one for database (oracle)
so I'm trying to get data from database using following connection string
$dbstr=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx.xx.x.xx)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=BHDB)
)
)
global $objConnect;
$objConnect = oci_connect('building', 'building', $dbstr, 'AL32UTF8');
if (!$objConnect) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
but in oci_connect the file can't display any thing in php (blank page)
but I don't know the problem
Add
error_reporting(E_ALL); // In PHP 5.3 use E_ALL|E_STRICT
ini_set('display_errors', 'On');
to your script and check the errors.
You can simplify your connection string to:
$dbstr='xxx.xx.x.xx/BHDB';
I get the impression you haven't read the Underground PHP & Oracle Manual.