ID: 33747
Updated by: [EMAIL PROTECTED]
Reported By: alfred dot trapp at tvi-services dot de
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Linux
PHP Version: 5CVS-2005-07-19
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
[2005-07-20 14:07:19] [EMAIL PROTECTED]
Please provide a clean, short and OCI8-only reproduce script. Without
all those $_SESSION, fopen etc. Just a short code that contains only
oci8*() calls and reproduces the problem.
Thanks.
------------------------------------------------------------------------
[2005-07-19 10:20:13] alfred dot trapp at tvi-services dot de
Hi sniper,
thanks for the proposal, but first tests with latest win32
PHP/5.1.0-dev indicates the same bug.
------------------------------------------------------------------------
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
