? if (＄conn=Ora_Logon( user@TNSNAME , password )) { echo B SUCCESS ! Connected to database B /n } else { echo B Failed :-( Could not connect to database B /n } Ora_Logoff(＄conn); phpinfo(); ? 以上代碼使用TNSNAME（在你的tnsnames.ora文件中指明）定義的Oracle數(shù)據(jù)庫名稱、用戶名稱和密碼連接數(shù)據(jù)庫。在成功連接的基礎上，ora_logon函數(shù)返回一個非零的連接ID并儲存在變量＄conn中。
4.2 查詢
假設與數(shù)據(jù)庫已經連接就緒，下面我們就來實際的應用對數(shù)據(jù)庫的查詢。下面的代碼演示了一個連接并查詢的典型例子： ? /* * 連接數(shù)據(jù)庫并執(zhí)行查詢 */ function printoraerr(＄in_cur) { // 檢查Oracle是否出錯 // 如果存在錯誤則顯示 // 當指針被激活時每次請求Oracle后調用該函數(shù) if(ora_errorcode(＄in_cur)) echo Oracle code - .ora_error(＄in_cur). /n return; } /** 主程序 */ if (!(＄conn=ora_logon( user@TNSNAME , password ))) { echo Connection to database failed/n exit; } echo Connected as connection - b ＄conn /b br /n echo Opening cursor ... br /n ＄cursor=ora_open(＄conn); printoraerr(＄cursor); echo Opened cursor - b ＄cursor /b br /n ＄qry= select user,sysdate from dual echo Parsing the query b ＄qry /b ... br /n ora_parse(＄cursor,＄qry,0); printoraerr(＄cursor); echo Query parsed br /n echo Executing cursor ... br /n ora_exec(＄cursor); printoraerr(＄cursor); echo Executed cursor br /n echo Fetching cursor ... br /n while(ora_fetch(＄cursor)) { ＄user=ora_getcolumn(＄cursor,0); printoraerr(＄cursor); ＄sysdate=ora_getcolumn(＄cursor,1); printoraerr(＄cursor); echo row = B ＄user, ＄sysdate /B br /n } echo Fetched all records br /n echo Closing cursor ... br /n ora_close(＄cursor); echo Closed cursor br /n echo Logging off from oracle... br /n ora_logoff(＄conn); echo Logged off from oracle br /n ? （譯者注：以上代碼段缺少注釋，請讀者參考PHP Manual的Oracle數(shù)據(jù)庫函數(shù)部分）html教程
