Hi,

I have an array with a few entries. How do I insert those entries into a MySQL database?

I have used the foreach () statement, and if I 'echo' the variable inside the foreach statement I can see each value.

BUT when I use the MySQL Query to insert it into the database it only inserts the last item in my Array.

Can anyone please help me with this? It is rather urgent, my boss is sitting on my neck to get this done!

Use the implode and explode functions available in PHP. implode takes an array, and will return a string with all the items in a list. Explode takes a list of items in a string, and gives you back an array. You specify the character(s) that are used as the dividers. For example:

PHP Code:

$test = Array('one','two','five','seven');
foreach($test as $value) echo $value.'<br />';
$tstring = implode(',' , $test);
echo $tstring.'<br />';
$test2 = explode(',' $tstring);
foreach($test2 as $value) echo $value.'<br />'; 


Will produce:

one
two
five
seven
one,two,five,seven
one
two
five
seven

The value of $tstring is just a string, and can be inserted into a mysql field of type VARCHAR or TEXT. Convert the array in question to a string for storage, and then recover the original array using explode.

Llama,

Use the implode() method to convert your array into a delimited string, then use explode() to reverse the process and convert the concatenated string back into an array.

Follow the links to see code examples.

HTH.

EDIT: Ah, 0beron is quick on the draw! Oh well, consider it confirmation!

Thank you very much! I'll try it tonight. Thanx again!

I thought it was urgent and your boss was chopin @ ur *$*$ to get it sorted? lol

Well, i stay in South Africa and here it is 8pm now, and still working on it, hope to have it all done by Friday. I tried your advise, and yes it inserts all the data now, BUT.... it inserts it all into one field in the database. Each Array position should be a new line entry in the database. Maybe I should explain what i am required to build. Our company manufacture parts for companies accross the world, and they need a program that basically automates their shipping for one department. so it is basically a shipping inventory list if you want to call it that. Each line that is entered in the PHP Form contains several fields that should be entered into the database, but each Line on the form is also a new line in the database. Does that explain what i am trying a little better?

I really do appreciate ALL your help though, because I have downloaded so many books on PHP and I couldn't really get it right, but NOTHING beats asking someone!! :-)


Thanks again.

i am only joking dude. Although slightly more technical, the code above still applies. Instead of echo you INSERT
Is that any clearer?

Dont worry Im joking to...

Well rather let me give you the script that I've got ... PLEASE DONT LAUGH!! I'm fairly new to the whole PHP thing....

<?php
$shipment_base_invoice=$_POST['shipment_base_invoice];

foreach ($shipment_base_invoice as $value) echo ($value.'<br>');
$tstring = implode(',' , $shipment_base_invoice);

$shipment_base_invoice_query="INSERT INTO boeing_shipmenttbl (shipment_base_invoice) VALUES ('$tstring')";

$shipment_base_invoice_result="mysql_query ($shipment_base_invoice_query);
if ($shipment_base_invoice_result)
{
echo ("RECORDED!")l
exit();
}
?>

So.... does that help in anyway? Cause all that happens is that it inserts the whole Array into one field of my Database table, where each value must be entered into a new line.

Can you help me?

//put connection to database here

foreach($shipment_base_invoice as $value)
{
$insert="INSERT INTO boeing_shipmenttbl (shipment_base_invoice) VALUES ('$value')";

mysql_query($insert) OR die(mysql_error())

}

you could give that a try

the line $shipment_base_invoice=$_POST['shipment_base_invoice];
has a ' missing POST['shipment_base_invoice'];

You Are A Genius!!
That works... now I just need to put things together and Phase one of this project will be completed.

Thank you very much for your help!! There is still some other questions I have but I will do that once I have finnished with setting up all the information to be entered into the database.

Thank You!!

glad i could help

Hi ASM!!

Llama here... I was so eager to see your reply to my little problem with inserting Array's into MySQL Database... and when I saw you posted a reply, that I HOPE could help me... I could not access it anymore! Now when I go to the query I logged it shows that there is only 10 replies and also only 57 views. Last I know of there was 17 replies and over a 100 views... PLEASE tell me you have a solution for my little problem!??

Originally Posted by Llama

Now when I go to the query I logged it shows that there is only 10 replies and also only 57 views. Last I know of there was 17 replies and over a 100 views...

Llama, the reason for the alteration to the thread was the database problems WT experienced over the weekend which precipitated the need to roll the entire WT forum back to July 26th. Sorry for any inconvenience this may have caused.

Kyrnt,
Thats ok... :-) it happens.

has this been resolved??

I feel like CRYING!! Or KILLING!!! :-) just kidding... but no, I am still strugeling my @#% oFF!!!

I changed the whole thing to use UPDATE instead of INSERT, but here's the thing:

COLUMN 1 COLUMN 2 COLUMN 3
-------------------------------------------------------------------------------------
row 1 fixed value value=always the same value=changes
row 2 fixed value value=always the same value=changes
row 3 fixed value value=always the same value=changes


I have an array with 3 values, 1 for each row.
When I update the mysql table, it will update COLUMN 3 as it should BUT it inserts the LAST value of the aray into all 3 rows.

HOW do I insert each value in its own row ????


PLEASE HELP!!!

I am getting GRILLED by my boss!!

Do you mean the last value of the array i.e. $myArray[2] is being inserted, are you updating old data or inserting fresh data?

there are 3 values in the array lets say: blue, green, red.
It should insert blue into Column 3 row 1
green into Column 3 row 2
red into Cloumn 3 row 3

BUT IT DOES THIS INSTEAD:
red into column 3 row 1
red into column 3 row 2
red into column 3 row 3

Yes, it is new data.

I am using the foreach statement...
ANY ADVISE?>??