php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #14753 a bug about Ora_pLogon
Submitted: 2001-12-29 10:05 UTC Modified: 2002-10-26 01:00 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: genbin at 263 dot net Assigned:
Status: No Feedback Package: Oracle related
PHP Version: 4.1.1 OS: Win2000AdvServer
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2001-12-29 10:05 UTC] 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;
?>






Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-10 23:08 UTC] 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


 [2002-10-26 01:00 UTC] 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".
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sun Nov 28 09:03:14 2021 UTC