就是ocidefinebyname($id,"rownum",&$rownum);對應了查詢中的rownum,一個對應一個,
而且最應該注意的就是,在定義的時候,字段名必須是大寫的,因為oracle里不認小寫
其它的就差不多了,賦值,顯示,關閉游標
$conn = ocilogon("gcxx","gcxx","server1");
$id = ociparse($conn,"select rownum,gcdjbh,gcmc from zbgg");
ocidefinebyname($id,"rownum",&$rownum);
ocidefinebyname($id,"gcdjbh",&$gcdjbh);
ocidefinebyname($id,"gcmc",&$gcmc);
ociexecute($id);
$i=0;
while (ocifetch($id)) {
echo "序號:".$rownum."
";
echo "工程登記編號:".$gcdjbh."
";
echo "工程名稱:".$gcmc."
";
$i++;
if ($i>10) break;
}
ocifreestatement($id);
ocilogoff($conn);
?>
新聞熱點
疑難解答