From: [EMAIL PROTECTED]
Operating system: Win2000AdvServer
PHP version: 4.1.1
PHP Bug Type: Unknown/Other Function
Bug description: a bug about Ora_pLogon
run at pl/sql developer:
/++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/
SQL> select * from pt_smsojb_temp;
PT_SMSOBJ_TEMP_ID PT_SMSOBJ_TYPE PT_SMSOBJ_ID PT_SMSOBJ_MOBI
PT_SMSOBJ_USER_ID PT_SMSOBJ_NAME
----------------- -------------- ------------ --------------
----------------- --------------------
27 u 11 13900000002
1 陈庭昀
28 u 1 13950362526
1 叶建斌
29 o 1 13900000005
1 大头
26 u 10 13900000001
1 林应广
30 o 2 13959355539
1 王大霖
31 o 3 13959344539
1 王小霖
32 o 4 13900000006
1 李华
33 o 5 13900000007
1 李大华
34 o 6 13900000037
1 李小华
35 o 7 13900030037
1 李不华
36 o 8 13933030037
1 李林华
37 o 9 13933330037
1 李林林
12 rows selected
/++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/
my php code
/++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/
<html>
<head>
<title>列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<?
$connection=Ora_pLogon("ptsms@doone","ptsms123");
$cursor=Ora_Open($connection);
<form name="sendmore" method="post" action="sendtoobj.php?action=more"
target=center_w>
<?
$query="select * from pt_smsojb_temp";
Ora_Parse($cursor,$query);
Ora_Exec($cursor);
while(Ora_fetch($cursor))
{
?><input type="checkbox" name="member[]" value="<?echo
Ora_getcolumn($cursor,0);?>" checked><?echo
Ora_getcolumn($cursor,5);?>[<?echo Ora_getcolumn($cursor,3);?>]<br>
<?
}
?>
</form>
</body>
</html>
/++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/
It will display 12 records sometimes or 13 records sometimes when I refresh
the web,but it should display 13 records.
Why?
I used the function Ora_commit when I insert a record to database in php.
It's my code.
<?
$query="insert into pt_smsojb_temp
(PT_SMSOBJ_TEMP_ID,PT_SMSOBJ_TYPE,PT_SMSOBJ_ID,PT_SMSOBJ_MOBI,PT_SMSOBJ_USER_ID,PT_SMSOBJ_NAME)
values
(pt_smsojb_temp_id.nextval,'u','$PT_SMSOBJ_ID','$PT_SMSOBJ_MOBI','$userid','$PT_SMSOBJ_NAME')";
Ora_Parse($curor,$query);
Ora_Exec($curor);
Ora_commit;
?>
--
Edit bug report at: http://bugs.php.net/?id=14753&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
