오라클에서 php로 Q&A게시판을 만들고있는데....오라클 연동문제인지..
에러메세지가 많이나오네요...져비..어찌해야될지..
한번 보시고...좀..
Warning: oci8_open_server: Error while trying to retrieve text for error ORA-12154 in /home/public_html/admin/admin.php3 on line 34
Warning: OCIParse: invalid connection 0 in /home/public_html/admin/admin.php3 on line 36
Warning: OCIExecute: invalid statement 0 in /home/public_html/admin/admin.php3 on line 37
Warning: OCIFetchInto: invalid statement 0 in /home/public_html/admin/admin.php3 on line 38
Warning: OCICommit: invalid connection 0 in /home/public_html/admin/admin.php3 on line 41
Warning: OCIFreeStatement: invalid statement 0 in /home/public_html/admin/admin.php3 on line 42
Warning: Oops, php3_SetCookie called after header has been sent in /home/public_html/admin/admin.php3 on line 49
$connect=ocilogon("111","111","111");
$query = "select admin_password from gnb_admin WHERE board_id='$id' AND admin_id='$PHP_AUTH_USER'";
$stmt=ociparse($connect, $query);
ociexecute($stmt);
ocifetchinto($stmt, &$result);
$admin_id=$PHP_AUTH_USER;
$admin_password = $result[0];
ocicommit($connect);
ocifreestatement($stmt);
ocilogoff($connect);
여기서 처음에러메세지가나는부분이 connect=ocilogon부분입니다..
보니깐 오라클 환경 변수문제인것같은데..환경변수를 해주면.그 환경 변수 에대한
에러메세지가나옵니다....
Fatal error: Failed opening required 'oracle_env.php3' in /home/public_html/admin/admin.php3 on line 33
이렇게요..답답합니다..
누가좀 가르쳐주세요..초보자좀살려줘요...
|