Sve sam ok podesio ali kada sam napravio probni fajl u kome mi stoji
Code:
<?php
$db_conn = ocilogon("sys", "root", "//127.0.0.1/ocrl");
$cmdstr = "select last_name, salary from employees";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<html><head><title>Oracle PHP Test</title></head><body>";
echo "<center><h2>Oracle PHP Test</h2><br>";
echo "<table border=1 cellspacing='0' width='50%'>\n<tr>\n";
echo "<td><b>Name</b></td>\n<td><b>Salary</b></td>\n</tr>\n";
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td>" . $results["LAST_NAME"][$i] . "</td>";
echo "<td>$ " . number_format($results["SALARY"][$i], 2). "</td>";
echo "</tr>\n";
}
echo "<tr><td colspan='2'> Number of Rows: $nrows</td></tr></table>";
echo "<br><em>If you see data, then it works!</em><br></center></body></html>\n";
?>
<?php
$db_conn = ocilogon("sys", "root", "//127.0.0.1/ocrl");
$cmdstr = "select last_name, salary from employees";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<html><head><title>Oracle PHP Test</title></head><body>";
echo "<center><h2>Oracle PHP Test</h2><br>";
echo "<table border=1 cellspacing='0' width='50%'>\n<tr>\n";
echo "<td><b>Name</b></td>\n<td><b>Salary</b></td>\n</tr>\n";
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td>" . $results["LAST_NAME"][$i] . "</td>";
echo "<td>$ " . number_format($results["SALARY"][$i], 2). "</td>";
echo "</tr>\n";
}
echo "<tr><td colspan='2'> Number of Rows: $nrows</td></tr></table>";
echo "<br><em>If you see data, then it works!</em><br></center></body></html>\n";
?>
Javlja mi sledeci error
Warning: ocilogon() [function.ocilogon]: ORA-12541: TNS:no listener in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 6
Warning: ociparse() expects parameter 1 to be resource, boolean given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 10
Warning: ociexecute() expects parameter 1 to be resource, null given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 11
Warning: ocifetchstatement() expects parameter 1 to be resource, null given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\index.php on line 1
Da li neko zna do cega je?
hvala unapred
djLapac