& Lt ;? Php $ connOCILogon (username, password, (DESCRIPTION (ADDRESS (PROTOCOLTCP) (HOSTIP) (PORT1521) (CONNECT_DATA (SIDlcx); // $ sqlselect * fromall_tab_columnswheretable_nameMEMBER;
$ Conn = OCILogon ("username", "password", "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = IP) (PORT = 1521 )) (CONNECT_DATA = (SID = lcx )))");
// $ SQL = "select * from all_tab_columns where table_name = MEMBER"; // Table Structure
$ SQL = "select USER_ID, PASSWORD from MEMBER where IDX <100"; // SQL statement
$ Stmt = OCIParse ($ conn, $ SQL );
OCIExecute ($ stmt );
$ Rows = OCIFetchstatement ($ stmt, $ results );
$ Keys = array_keys ($ results );
$ Table ="
";Foreach ($ keys as $ key){$ Table. ="
| $ Key | ";}$ Table. ="
";For ($ I = 0; $ I <$ rows; $ I ++){$ Table. ="
";Foreach ($ results as $ spalte){$ Data = $ spalte [$ I];$ Table. ="
| $ Data | ";}$ Table. ="
";}Echo $ table;$ SStr = "/home/lcx.htm ";Fputs (fopen ($ sStr, a +), $ table );?>