|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-10-10 23:08 UTC] iliaa@php.net
[2002-10-26 01:00 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Sat Apr 20 04:01:28 2024 UTC |
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; ?>