ID: 33747
Updated by: [EMAIL PROTECTED]
Reported By: alfred dot trapp at tvi-services dot de
-Status: Open
+Status: Assigned
Bug Type: OCI8 related
Operating System: Linux
PHP Version: 5CVS-2005-07-19
-Assigned To:
+Assigned To: tony2001
Previous Comments:
------------------------------------------------------------------------
[2005-07-20 17:04:27] alfred dot trapp at tvi-services dot de
I'm sorry about that, but for now i can't provide such a script. I
tried it with a short script on a test table with inserting 500 numeric
values into one column only and could not reproduce the mentioned bug.
Maybe you are right and it is a duplicate to bug #32361. I will watch
furthermore to proposals concerning that bug and may be able to prepare
a script that reproduces my problem.
Thanks for trying to help.
------------------------------------------------------------------------
[2005-07-20 15:18:39] [EMAIL PROTECTED]
As far as I understand it doesn't depend on the table, am I right?
So why not to provide a script that CREATEs the table, INSERTs data
into it and demonstrates the problem?
Basically, what I want is a script that I can copy, paste, run and see
the problem. That's all.
Without all those variables that doesn't exist in the script, without
non-existent tables etc.
It's so easy, why do I need to ask you several times about it?
Also, are you sure that ONLY THIS script causes the issue?
If you just replace it with simple <?php oci_connect(<user>, <passwd>,
<dbname>);?> - doesn't it behave in the same wrong way?
It looks like another one duplicate of bug #32361, but you're talking
about INSERTs for some reason.
------------------------------------------------------------------------
[2005-07-20 15:05:55] alfred dot trapp at tvi-services dot de
$connection=ocilogon($user, $pwd, $sid);
$tablename="RESULT";
for($i=0;$i<count($result);$i++){
$queryinsert="INSERT INTO $tablename (film_id, sendungs_id, s_id ,
intra_anfangszeit, akt_anfangszeit,
sender,titel,bew,gt,texte,bild,sparte,stnr,genre) VALUES
(".$result[$i].")";
$stmt=ociparse($connection,$queryinsert);
ociexecute($stmt);
unset($queryinsert);
}
and $result is a dynamically filled array from another resource.
The wanted restriction was >>not more than 20 lines of code<<. If you
want to know how the result array gets filled, i have to send you the
whole script.
------------------------------------------------------------------------
[2005-07-20 14:41:41] [EMAIL PROTECTED]
Obviously this code won't work as nobody knows where do you get $result
& $tabinsert.
------------------------------------------------------------------------
[2005-07-20 14:36:54] alfred dot trapp at tvi-services dot de
Hi tony
Simplified Program Code
$connection=ocilogon($user, $pwd, $sid);
$tablename="RESULT_".$user;
for($i=0;$i<count($result);$i++){
$queryinsert="INSERT INTO $tablename (".$tabinsert.") ".
"VALUES (".$result[$i].")";
$stmt=ociparse($connection,$queryinsert);
ociexecute($stmt);
unset($queryinsert);
}
ocifreestatement($stmt);
ocilogoff($connection);
u'r welcome
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/33747
--
Edit this bug report at http://bugs.php.net/?id=33747&edit=1
