|
> PHP3를 이용한 오라클 연동 테스트입니다.
>
> select * from emp
>
> Warning: OCIResult: invalid column 0 in /home/http/htdocs/oracle.php3
> on line 28
> NULL 7369 SMITH CLERK 7902 17-DEC-80 800 NULL
>
> Warning: OCIResult: invalid column 0 in /home/http/htdocs/oracle.php3
> on line 28
> NULL 7499 ALLEN SALESMAN 7698 20-FEB-81 1600
> 300
> Warning: OCIResult: invalid column 0 in /home/http/htdocs/oracle.php3
> on line 28
> NULL 7521 WARD SALESMAN 7698 22-FEB-81 1250
> 500
>
> 이렇게 주의라는 메세지가 납니다..
> Warning: OCIResult: invalid column 0 in /home/http/htdocs/oracle.php3
> on line 28
> 이 메세지좀 안나오게 해주세여
>
> 소스는 다음과 같습니다.
> ####################################
> <center>
> <br>
> PHP3를 이용한 오라클 연동 테스트입니다.
> <p>
> </center>
>
> <?php
> putenv("ORACLE_SID=ORCL");
> putenv("ORACLE_HOME=/home/oracle");
> putenv("NLS_LANG=AMERICANy_AMERICA.KO16KSC5601");
> putenv("ORA_NLS33=/home/oracle/ocommon/nls/admin/data");
> putenv("TNS_ADMIN=/home/oracle/network/admin");
>
> $handle = OCIPLogon("scott","tiger","ORCL") or die;
>
> $query = "select * from emp";
> $Parse = OCIParse($handle,$query) or die;
> OCIexecute($Parse);
>
> echo "<pre>\n";
> echo "$query\n\n";
>
> $numcols=0;
> while (OCIFetch($Parse)) {
> $numcols = OCINumcols($Parse);
> for ($column=0; $column < $numcols; $column++) {
> $data = OCIResult($Parse, $column); <===이부분이 잘못 됐나여?
>
> if ($data == "") $data = "NULL";
> echo "$data\t";
> }
> echo "\n";
> }
> $numrows = OCIRowCount($Parse);
> echo "\nROWS RETURNED: $numrows\n";
> echo "</pre>";
>
> OCILogoff($handle);
> ?>
|
