connectio problem with php5&oracle 8i

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
paudelvikash
Forum Newbie
Posts: 4
Joined: Thu Jul 05, 2007 3:21 am

connectio problem with php5&oracle 8i

Post by paudelvikash »

feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


hi all
i tried to establish a connectio with oracle 8i using oci_connect() function
but it throws following error:
Fatal error: Call to undefined function oci_connect() in C:\Program Files\xampp\htdocs\conn.php on line 6

i have uncomment php_oci8.dll
i am using xampp 1.5.2

Code looks like something

Code: Select all

<?php

$user="test";
$password="test";
$dbname="students";
	
$conn = oci_connect($user, $password,'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.202)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=students))');



if (!$conn) 
  	echo "could not connect to server"; 
	 		
else
                echo"Connection successful";
 
?>
any suggestion?


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Run the following in a new file and tell us the results please.

Code: Select all

<?php

$neg = array('off', 0, false, '', null);
$flags = array(
	'Register Globals' => 'register_globals',
	'Short Tags' => 'short_open_tag',
	'Display Errors' => 'display_errors',
	'Magic Quotes GPC' => 'magic_quotes_gpc',
	'Magic Quotes Runtime' => 'magic_quotes_runtime',
	'Magic Quotes Sybase' => 'magic_quotes_sybase',
);
$ve = phpversion();
$os = PHP_OS;
$er = intval(error_reporting());
foreach ($flags as $n => $v)
{
	$flags[$n] = (in_array(strtolower(ini_get($v)), $neg) ? 'Off' : 'On');
}
$flags['Config file'] = get_cfg_var('cfg_file_path');
if (empty($flags['Config file']))
{
	$flags['Config file'] = '-';
}
$cli = (php_sapi_name() == 'cli');
$eol = "\n";

$gle = get_loaded_extensions();
$rows = array();
$le = '';
$wide = 4;
$j = count($gle);
$pad = $wide - $j % $wide;
$len = max(array_map('strlen', $gle));
$func = create_function('$a', 'return str_pad($a, ' . intval($len) . ');');
$gle = array_map($func, $gle);
for($i = 0; $i < $j; $i += $wide)
{
	$le .= '   ' . implode('   ', array_slice($gle, $i, $wide)) . $eol;
}

$ec = array(
	'E_STRICT' => 2048, 'E_ALL' => 2047, 'E_USER_NOTICE' => 1024,
	'E_USER_WARNING' => 512, 'E_USER_ERROR' => 256, 'E_COMPILE_WARNING' => 128,
	'E_COMPILE_ERROR' => 64, 'E_CORE_WARNING' => 32, 'E_CORE_ERROR' => 16,
	'E_NOTICE' => 8, 'E_PARSE' => 4, 'E_WARNING' => 2, 'E_ERROR' => 1,
);

$e = array();
$t = $er;
foreach ($ec as $n => $v)
{
	if (($t & $v) == $v)
	{
		$e[] = $n;
		$t ^= $v;
	}
}
if (ceil(count($ec) / 2) + 1 < count($e))
{
	$e2 = array();
	foreach ($ec as $n => $v)
	{
		if (!in_array($n, $e) and $n != 'E_ALL')
		{
			$e2[] = $n;
		}
	}
	$er = $er . ' ((E_ALL | E_STRICT) ^ ' . implode(' ^ ', $e2) . '))';
}
else
{
	$er = $er . ' (' . implode(' | ', $e) . ')';
}

if (!$cli)
{
	echo '<html><head><title>quick info</title></head><body><pre>', $eol;
}

echo 'PHP Version: ', $ve, $eol;
echo 'PHP OS: ', $os, $eol;
echo 'Error Reporting: ', $er, $eol;
foreach ($flags as $n => $v)
{
	echo $n, ': ', $v, $eol;
}
echo 'Loaded Extensions:', $eol, $le, $eol;

if (!$cli)
{
	echo '</pre></body></html>', $eol;
}

?>
paudelvikash
Forum Newbie
Posts: 4
Joined: Thu Jul 05, 2007 3:21 am

Post by paudelvikash »

Thanks for your interest
i apologise for the late response

The result it shows are as follows:

Code: Select all

PHP Version: 5.1.2
PHP OS: WINNT
Error Reporting: 2039 ((E_ALL | E_STRICT) ^ E_STRICT ^ E_NOTICE))
Register Globals: Off
Short Tags: On
Display Errors: On
Magic Quotes GPC: On
Magic Quotes Runtime: Off
Magic Quotes Sybase: Off
Config file: C:\Program Files\xampp\apache\bin\php.ini
Loaded Extensions:
   bcmath       calendar      com_dotnet        ctype         
   date         ftp           iconv             odbc         
   pcre         Reflection    session           libxml       
   standard     tokenizer     zlib              SimpleXML     
   dom          SPL           wddx              xml           
   xmlreader    xmlwriter     apache2handler    Zend Optimizer
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

You already had a thread on the exact same topic
see viewtopic.php?t=70333
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

volka wrote:You already had a thread on the exact same topic
see viewtopic.php?t=70333
That one was the newer of the two threads, so it's locked. ;)
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

oh... right :)
Still would love to see the output of

Code: Select all

<?php
$ini = get_cfg_var('cfg_file_path');
echo 'version: ', phpversion(), "<br />\n";
echo 'sapi: ', php_sapi_name(), "<br />\n";
echo 'php.ini: ', $ini, "<br />\n";

echo "<pre>\n--\n";
foreach(file($ini) as $l) {
  if ( false!==strpos($l, 'oci') ) {
    echo $l;
  }
}
echo "--\n</pre>\n";
...curious me ;)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Oracle isn't in the actively loaded extensions as shown by the output of the "run this" script.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

correct, and now I'd like to see if this is because paudelvikash didn't edit the php.ini or didn't edit the right php.ini or ignored any warning message messages/messageboxes when starting the webserver.
paudelvikash
Forum Newbie
Posts: 4
Joined: Thu Jul 05, 2007 3:21 am

Post by paudelvikash »

well there was few confusion going round here and the problem of connection was solved with yours guidance . Thanks for that .
well feyd, you expected oci_8|PDO_OCI to appear and it did
and volka , i think u might be expecting
extension=php_oci8.dll
extension=php_pdo_oci.dll
extension=php_pdo_oci8.dll



well the connection problem was solved. but the new problem has occurred and other thing i have switched to 10g
when 10g was installed , the name of the machine was changed. and this has now restricted the connection and throws the following error:

Notice: Could not establish a connection: ORA-12541: TNS:no listener in C:\Program Files\xampp\htdocs\dbConn4.php on line 38

Warning: ocierror() expects parameter 1 to be resource, boolean given in C:\Program Files\xampp\htdocs\dbConn4.php on line 50

Notice: Failed to parse SQL query: in C:\Program Files\xampp\htdocs\dbConn4.php on line 52


i tried with replacing the name of the host computer with its IP address but the problem still exist.
the host name in listener.ora file was also changed.
waiting for your suggestion.
Post Reply