Bug #14753: a bug about Ora_pLogon
| From: | genbin at 263 dot net | Date: | Sat, 29 Dec 2001 15:05:04 +0000 |
| Subject: | Bug #14753: a bug about Ora_pLogon | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-75248@lists.php.net to get a copy of this message | ||
From: genbin@263.net
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