Hi,
This is my first post, but I have searched and not seen this question posted before. If it has please just point me to a post....
Enough of the disclaimer...
I am trying to connect to both a MySQL database and an Oracle database. The connection to the MySQL database works perfectly however when I edit the php.ini file and uncomment the line "extension=php_oci8.dll" I am getting the error below. I haven't even added my code to the script. I have only uncommented the line. Has anyone seen this? Anyone have suggestions?
Here is the code. Like I said I have not added the Oracle OCI code yet, but I still get the error above.... I have commented out the databasename, username, and password with *****... I trust you, just not that much
<?php
$conn = @new mysqli('**********.**********.*****', '******', '*********', '****************');
if(mysqli_connect_errno() != 0)
{
$errno = mysqli_connect_errno();
$errmsg = mysqli_connect_error();
echo "Connect Failed with: ($errno) $errmsg<br/>\n";
exit;
}
$conn->query("SET NAMES 'utf8'");
// prepare the query
$query_str = "select trans_ref_no from TransHeader";
$result = @$conn->query($query_str);
if ($result == FALSE)
{
$errno = $conn->errno;
$errmsg = $conn->error;
echo "Connect Select Failed with: ($errno) $errmsg<br/>\n";
$conn->close();
exit;
}
while(($row_data = @$result->fetch_assoc()) != NULL)
{
echo "{$row_data['trans_ref_no']}<br/>\n";
}
$conn->close();
?>
|
RSS2 Feed
Posted: Mon Jul 09, 2007 2:24 pm
