ID:               14753
 Updated by:       [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
-Status:           Open
+Status:           Feedback
 Bug Type:         Oracle related
 Operating System: Win2000AdvServer
 PHP Version:      4.1.1
 New Comment:

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




Previous Comments:
------------------------------------------------------------------------

[2001-12-29 10:05:03] [EMAIL PROTECTED]

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

Reply via email to