php insert function

ctrohaya · #1 09-Dec-2006, 18:55

hi guys. i have a little bit problem. now, i'm developing a very simple system. it include inserting multiple row concurrently.
normally, when we click submit button, the data will be inserted into one row, so now i want it be when we click submit, all the data will be inserted into multiple row concurrently.

row[0]=Banana
row[1]=Carrot
row[3]=pineapple
...
by single clicking.

Richardknox · #2 09-Dec-2006, 18:57

More info please. I guess I am not quite seeing what your trying to do.

JdS · #3 09-Dec-2006, 20:21

Read this howto I wrote many years ago, maybe it will point you in the right direction.

http://www.desilva.biz/mysql/insert.html

ctrohaya · #4 09-Dec-2006, 22:05

Quote:

Originally Posted by Richardknox

More info please. I guess I am not quite seeing what your trying to do.

ok.. the situation is like this;
banana = 1st row
pineapple = 2nd row
apple = 3rd row
...
to insert such 3 items, i have to click submit button 3 times. first click, banana will be inserted into 1st row, and if i have 10 items, i need 10 clicking.
so now i want to save times by insert all the items by single clicking. it mean, all the items inserted into different row concurrently.

ctrohaya · #5 09-Dec-2006, 22:14

Quote:

Originally Posted by JdS

Read this howto I wrote many years ago, maybe it will point you in the right direction.

http://www.desilva.biz/mysql/insert.html

it almost same, but i use a variable.

$fruit = banana
$fruit = pineapple
$fruit = apple
...
$sql = "INSERT INTO fruits(name, quantity)
VALUES
('$fruit', '$qtt')";

is it possible if such 3 items inserted all at once

?

PcFan · #6 13-Dec-2006, 04:34

PHP Code:


$sql = "INSERT INTO fruits(name, quantity)
VALUES
('$fruit', '$qtt')";

will not work.

try something like:

PHP Code:


$sql = "INSERT INTO fruits(name, quantity)
VALUES
('banana', 3),('apple', 7), ('peach', 8)";

or, programatically, you will have to create an array containing the fruits and qty's, then compose a query string smt. like this:

PHP Code:


$sql = "INSERT INTO fruits(name, quantity)
VALUES ";

for (t=0; t< fruits.length; t++)
{
$sql_arr[] = '("'.$fruits[t].'", "'.$qty[t].'")';
}

$sql .= implode(',' , $sql_arr);

Of course, the fruits and qty arrays will have the corresponding values you need. Or, you can use an associative and/or multidimensional array.

Best Regards, PcFan

JdS · #7 13-Dec-2006, 04:40

Why thank you, PcFan

I just pulled up this thread to reply and you did it already! Again, thank you.

ctrohaya · #8 13-Dec-2006, 20:47

i've tried the script given by PcFan, but it appear an error pointing at for loop, so i change the loop to be like this;

PHP Code:


$query = "SELECT count(*) FROM class AS c LEFT JOIN markah_pelajar AS m ON c.nokp = m.nokp AND m.subjek = '$f_subjek' WHERE c.kelas = '$f_kelas' AND c.sesi ='$sesi' AND m.nokp IS NULL";    
    $result = mysql_query($query,$conn);
    $num=mysql_numrows($result);
    echo $num;
//for (p=0; p<=$num; p++){
$p = 0;
while ($p <= $num){
  $query1 ="INSERT INTO markah_pelajar(nokp,sesi,subjek,jenis_pep,markah)
   values('$IC[$p]','$sesi[$p]','$f_subjek[$p]','$f_test[$p]','$f_mark[$p]')";
   $p++;
}

also not work
and only the last row get into the dbase.

JdS · #9 13-Dec-2006, 21:43

I'll try to correct some of the typos in PcFan's example code...

PHP Code:


$sql = "INSERT INTO fruits(name, quantity)
VALUES ";

$fruits_length = sizeof( $fruits );

for( $i=0; $i<$fruits_length; $i++)
{
    $sql_arr[] = '("'.$fruits[$i].'", "'.$qty[$i].'")';
}

$sql .= implode( ',', $sql_arr );

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Message Class	TransformedBG	CPP / C++ Forum	5	29-Nov-2006 21:28
[Include] Doubly-linked List	dsmith	C Programming Language	6	14-Apr-2006 13:12
[Tutorial] Function Pointers	aaroncohn	CPP / C++ Forum	4	17-Feb-2006 11:33
Revising Script style ??????	pepee	MySQL / PHP Forum	4	14-Apr-2004 04:59

php insert function

Re: php insert function

Re: php insert function

Re: php insert function

Re: php insert function

Re: php insert function

Re: php insert function

Re: php insert function

Re: php insert function