写了一段代码,给大家看看,提提意见吧
<?
$connection=Ora_logon("sms@server","smsbbc");
$cursor=Ora_open($connection);
$query="select * from pt_user";
Ora_parse($cursor,$query);
Ora_exec($cursor);
$i=0;
while(@Ora_ColumnName($cursor,$i))
{
$title=Ora_ColumnName($cursor,$i);
$$title=$i;
$i++;
}
while(Ora_fetch($cursor))
{
echo Ora_getcolumn($cursor,$PT_USER_ID);//大家注意这里,原来是Ora_getcolumn($cursor,0);
echo Ora_getcolumn($cursor,$PT_USER_NAME);
}
Ora_close($cursor);
Ora_logoff($connection);
?>