putenv ("ORACLE_BASE=/ora");
putenv ("ORACLE_HOME=/ora");
putenv("NLS_LANG=AMERICAN");
//$conn = Ora_PLogon("hostname","passwd");
$conn = Ora_PLogon("web@web","web");
@ora_commiton($conn);
$cur=ora_open($conn);
$err_no=0;
$query = "select PASSWORD from register where mobilno='$t_tele_num'";
$result=ora_parse($cur,$query);
$result=ora_exec($cur);
if(ora_fetch($cur))
$datacount = ora_getcolumn($cur, 0);
echo "$datecount";
ora_close($cur);
putenv ("ORACLE_HOME=/ora");
putenv("NLS_LANG=AMERICAN");
//$conn = Ora_PLogon("hostname","passwd");
$conn = Ora_PLogon("web@web","web");
@ora_commiton($conn);
$cur=ora_open($conn);
$err_no=0;
$query = "select PASSWORD from register where mobilno='$t_tele_num'";
$result=ora_parse($cur,$query);
$result=ora_exec($cur);
if(ora_fetch($cur))
$datacount = ora_getcolumn($cur, 0);
echo "$datecount";
ora_close($cur);
<?
putenv ("ORACLE_BASE=/ora");
putenv ("ORACLE_HOME=/ora");
putenv("NLS_LANG=AMERICAN");
//$conn = Ora_PLogon("hostname","passwd");
$conn = Ora_PLogon("interdb","interdb");
@ora_commiton($conn);
$cur=ora_open($conn);
echo $cur."<br><br>";
$err_no=0;
$query = "select PASSWORD from register where mobilno='$t_tele_num'";
$result=ora_parse($cur,$query);
$result=ora_exec($cur);
if(ora_fetch($cur))
$datacount = ora_getcolumn($cur, 0);
echo "$datecount";
ora_close($cur);
?>执行后出错:
Warning: Unable to connect to ORACLE (ORA-12203: TNS:unable to connect to destination) in d:\japan\dnd\test1.php on line 6Warning: Supplied argument is not a valid Oracle-Connection resource in d:\japan\dnd\test1.php on line 8Warning: Supplied argument is not a valid Oracle-Cursor resource in d:\japan\dnd\test1.php on line 13Warning: Supplied argument is not a valid Oracle-Cursor resource in d:\japan\dnd\test1.php on line 14Warning: Supplied argument is not a valid Oracle-Cursor resource in d:\japan\dnd\test1.php on line 16Warning: Supplied argument is not a valid Oracle-Cursor resource in d:\japan\dnd\test1.php on line 19
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
怎么解决?/??
laosan(老三)兄,顺便再给我写一份引用这个类的例子。