#14753 [Com]: a bug about Ora_pLogon

ID: 14753 Comment by: sdaf at qewfad dot com Reported By: genbin at 263 dot net Status: No Feedback Bug Type: Oracle related Operating System: Win2000AdvServer PHP Version: 4.1.1 New Comment: http://www.11nong.com Previous Comments: ------------------------------------------------------------------------ [2006-03-20 02:32:04] replica_supplier at yahoo dot com http://www.replica-supplier.com title:<a href="http://www.replica-supplier.com">replica rolex replica lv replica chanel replica cd replica gucci replica cartier</a> 99% precise Fake Watches Rolex Replica 2005 collection: Rolex Replica, Replica Watches, Swiss Rolex Replica, Fake Rolex watches, Replica Rolex Replicas, fake rolex, fake watches, fake rolex replicaes replica watch part and Rolex Watches at replica-supplier.com ------------------------------------------------------------------------ [2002-10-26 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-10-10 23:08:58] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2001-12-29 10:05:03] genbin at 263 dot net 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 this bug report at http://bugs.php.net/?id=14753&edit=1