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] [EMAIL PROTECTED]

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("[EMAIL PROTECTED]","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