How to have multiple inserts?

Anon

I am doing a project now for my final year and came across a problem. I am using PHP and oracle as my database.

It seems i can't have multiple inserting into my database at the same time from the same webpage.

Is there a way this is done?

[deleted]

codesample?

Anon

hi... thanks for replying.

basically it goes something like,

$conn = ocilogon ("f75030", "pass", $d😎;
$sql = "SELECT * FROM modules WHERE mid = $etemp";
$stmts = ociparse($conn, $sql);
ociexecute ($stmts, OCI_DEFAULT);
while (ocifetch($stmts)) {

$mid = ociresult ($stmts, 1);
$modno = ociresult ($stmts, 2);
ocilogoff ($conn);

$conn = ocilogon ("f75030", "pass", "sid3.comp.nus.edu.sg");
$title = $modno." Exam";
$sql = "INSERT INTO Event VALUES (running.NEXTVAL, '$userid', '$title', '$day', $dayW";
$sql = $sql.", $Stime, $Etime, 'N', 'N', NULL, NULL, NULL)";

echo $sql;
$stmte = ociparse ($conn, $sql);

ociexecute ($stmte, OCI_COMMIT_ON_SUCESS);
ocilogoff ($conn);

okay... here is the problem in detail. all the code of fetching from one table and inserting into another table is within a for-loop. sometimes, it complains that the error of fetching out of space... then sometimes it doesn't at all...

so when it doesn't complain, i assumed that it was okay, but i select * from events, it seems that the values were never inserted in.... do you have any idea why this is so?

[deleted]

Why do you close the first database conneciton inside the loop?
and why do you create a new connection inside the loop?

Anon

that was cause i was desperate. =P

i just cannot understand why it doesn't work. previously, my $conn was external to the whole for-loop. only at the end of the program did i logoff. but the error was so uncalled for that i tried all sorts of ways to get rid of it. my school database is very unstable (it seems) so i thought it cannot hold long enough or something... was just trying out all sorts of ways to at least get it working.

so you gather that this is not the one that is causing the errors?

the funny thing is, sometimes it doesn't fetch out of space, but yet sometimes it does. and there is no difference in the variable passed in... so i too don't comprehend why with such inconsistent errors.

Anon

Hey,

I am using MySQL to create my database applications but currently while looking fora job I found that Oracle is more used. I searched the Internet go get a copy of this product but no result.

Could you tell me from where I could download this database software?

Thank you!

Svetlin

[deleted]

Oracle is VERY VERY VERY expensive.

Try PostgreSQL, it is fully featured and free.

Anon

Ok,

Then how come that so many people learn to use it. Is there a trial or something.

How could I learn to use it without the ability to buy it?

Svetlin

[deleted]

YOu can order or download a free copy of Oracle from their website, but if you plan to use it commercially, you have to buy a licence, and that costs muchos pesetas.
A cheaper alternative (and a lot simpler to install/maintain) is INFORMIX.

Anon

like i did say at the start of the thread... i am doing this as a project so the resource came from school.

anyway thanks for helping vincent... i just submitted the project today... didn't go really well but i sure am glad it's over!

Anon

Hey,

I went to the Oracle web site but I couldn't find any trials of Oracle.

I do not want it for commercial use. I just want to learn how to use it and how to do that without being able to use it.

Could you give me any URL from where I could download it (how big is it?)

Thanks!

Svetlin

[deleted]

http://otn.oracle.com/software/content.html

You may have to resigter for the Oracle development network (free)