用php連線oracle資料庫的程式碼
用php連線oracle首先要在php.ini中把extension=php_oci8.dllextension=php_oracle.dll前的分號“;”去掉,然後重啟apache就行了,這樣php就支援oracle了.以下是程式程式碼:
$connection=Ora_Logon("[email protected]","123");
if($connection==false){
echoOra_ErrorCode($connection).":".Ora_Error($connection)."";
exit;
$cursor=Ora_Open($connection);
if($cursor==false){
echoOra_ErrorCode($connection).":".Ora_Error($connection)."";
exit;
$query="createtableemail_info"."(fullnamevar255),email_addressvar255))";
$result=Ora_Parse($cursor,$query);
if($result==false){
echoOra_ErrorCode($cursor).":".Ora_Error($cursor)."";
exit;
$result=Ora_Exec($cursor);
if($result==false){
echoOra_ErrorCode($cursor).":".Ora_Error($cursor)."";
exit;
Ora_Commit($connection);
Ora_Close($cursor);
Ora_Logoff($connection);
【用php連線oracle資料庫的程式碼】相關文章: