成人在线亚洲_国产日韩视频一区二区三区_久久久国产精品_99国内精品久久久久久久

您的位置:首頁技術(shù)文章
文章詳情頁

如何在PHP中使用Oracle數(shù)據(jù)庫(5)

瀏覽:107日期:2024-01-23 08:47:12
利用ORA列出全部數(shù)據(jù)表'email_info'中的數(shù)據(jù) 下面,我們將逐條讀出數(shù)據(jù)庫的內(nèi)容,并以html表格形式顯示'email_info'數(shù)據(jù)表中的數(shù)據(jù);;相關(guān)PHP代碼: PutEnv("ORACLE_SID=ORASID"); $connection = Ora_Logon ("username","password"); if ($connection == false){ ;;echo Ora_ErrorCode($connection).": ".Ora_Error($connection)." ";exit; } $cursor = Ora_Open ($connection); if ($cursor == false){ ;;echo Ora_ErrorCode($connection).": ".Ora_Error($connection)." ";exit; };;;;$query = "select * from email_info"$result = Ora_Parse ($cursor, $query); if ($result == false){ ;;echo Ora_ErrorCode($cursor).": ".Ora_Error($cursor)." ";exit;;;} $result = Ora_Exec ($cursor); if ($result == false){ ;;echo Ora_ErrorCode($cursor).": ".Ora_Error($cursor)." ";exit; } echo " "echo ";;Full Name Email Address;;"while (Ora_Fetch_Into ($cursor, &$values)){ ;;$name = $values[0]; ;;$email = $values[1]; ;;echo ";;$name $email;;"} echo " "Ora_Close ($cursor); Ora_Logoff ($connection); ?>;;;;程序運(yùn)行的瀏覽效果如下所示: ;;;;姓名 Email 地址;;春花 springflower@163.com;;秋月 autumnmoon@163.com;;... ...;;;;
標(biāo)簽: PHP