# config
define("sDevDatabaseName", "$databasename");
define("sDevUserName", "$username");
define("sDevPassword", "$password");
# connect
$conn = ocilogon(sDevUserName, sDevPassword, sDevDatabaseName);
$SQLs ="select * from tablename";
$st_cate = ociparse($conn, $SQLs);
ociexecute($st_cate, OCI_DEFAULT);
while (ocifetch($st_cate)) {
# Get data each field
$fieldname_id = ociresult($st_cate, "fieldname");
}
#return free result
ocifreestatement($st_cate);
ไม่มีความคิดเห็น:
แสดงความคิดเห็น