multidimensiona l array in to a MySQL table

[Stephen Preston]

Trying to load an multidimensiona l array into a MySQL table with columns as
follows,

level1,level2,l evel3,illust,it em,description, partNo,qua,pric e,remarks,weigh t
,size,mass

the array first line is $input[0][level1]Engine
the array secondline is $input[0][level2]Cylinder Head
etc..

A 'foreach' inside a 'foreach' echo of the array gives the following, which
is correct.

0, level1, Engine
0, level2, Cylinder Head
0, level3,
0, illust, 001.pdf
0, item, 1
0, description, Casting
0, partNo, 238356
0, qua, 1
0, price, 1,245.00
0, remarks, This is for the Z350 series
0, weight, 5
0, size, 5x5x5
0, mass, 37
1, level1, Engine
1, level2, Cylinder Head
1, level3,
1, illust, 001.pdf
1, item, 2
1, description, Valve, inlet
1, partNo, 452790
1, qua, 4
1, price, 5.46
1, remarks, This is for the Z350 series
1, weight, 5
1, size, 5x5x5
1, mass, 37
2, level1, Engine
2, level2, Cylinder Head
2, level3,
2, illust, 001.pdf
2, item, 3
2, description, Valve, exhaust
2, partNo, 345436
2, qua, 4
2, price, 5.99
2, remarks, This is for the Z350 series
2, weight, 5
2, size, 5x5x5
2, mass, 37

etc..

I have used the print_r to see all the data in the array also.
I've tried the extract() function on the first key which I assume is also an
array, inside and outside the loop to get at the column headings.

I've tried allsorts of while and for loops but can't seem to work out how to
get down to the last key to get the following statement to work. I'm trying
the get the array to work through the first key [0] to fill the row, then
the next key [1] to fill the next row in the table etc..

$query2 = "INSERT INTO $tableName
(level1,level2, level3,illust,i tem,description ,partNo,qua,pri ce,remarks,weig h
t,size,mass) VALUES
('$level1','$le vel2','$level3' ,'$illust','$it em','$descripti on','$partNo',' $
qua','$price',' $remarks','$wei ght','$size','$ mass')";
$result = mysql_query($qu ery2) or die("Couldn't insert data.");

If I knock out the loops and have the above as a single statement, I can get
the last row of records into the table.

Hope someone can put a novice out of his misery.

Thanks
Stephen

[Jerry Stuckle]

Stephen Preston wrote:

Trying to load an multidimensiona l array into a MySQL table with columns as
follows,

level1,level2,l evel3,illust,it em,description, partNo,qua,pric e,remarks,weigh t
,size,mass

the array first line is $input[0][level1]Engine
the array secondline is $input[0][level2]Cylinder Head
etc..

A 'foreach' inside a 'foreach' echo of the array gives the following, which
is correct.

0, level1, Engine
0, level2, Cylinder Head
0, level3,
0, illust, 001.pdf
0, item, 1
0, description, Casting
0, partNo, 238356
0, qua, 1
0, price, 1,245.00
0, remarks, This is for the Z350 series
0, weight, 5
0, size, 5x5x5
0, mass, 37
1, level1, Engine
1, level2, Cylinder Head
1, level3,
1, illust, 001.pdf
1, item, 2
1, description, Valve, inlet
1, partNo, 452790
1, qua, 4
1, price, 5.46
1, remarks, This is for the Z350 series
1, weight, 5
1, size, 5x5x5
1, mass, 37
2, level1, Engine
2, level2, Cylinder Head
2, level3,
2, illust, 001.pdf
2, item, 3
2, description, Valve, exhaust
2, partNo, 345436
2, qua, 4
2, price, 5.99
2, remarks, This is for the Z350 series
2, weight, 5
2, size, 5x5x5
2, mass, 37

etc..

I have used the print_r to see all the data in the array also.
I've tried the extract() function on the first key which I assume is also an
array, inside and outside the loop to get at the column headings.

I've tried allsorts of while and for loops but can't seem to work out how to
get down to the last key to get the following statement to work. I'm trying
the get the array to work through the first key [0] to fill the row, then
the next key [1] to fill the next row in the table etc..

$query2 = "INSERT INTO $tableName
(level1,level2, level3,illust,i tem,description ,partNo,qua,pri ce,remarks,weig h
t,size,mass) VALUES
('$level1','$le vel2','$level3' ,'$illust','$it em','$descripti on','$partNo',' $
qua','$price',' $remarks','$wei ght','$size','$ mass')";
$result = mysql_query($qu ery2) or die("Couldn't insert data.");

If I knock out the loops and have the above as a single statement, I can get
the last row of records into the table.

Hope someone can put a novice out of his misery.

Thanks
Stephen

Stephen,

How about showing us the failing code? It would be much easier to
troubleshoot what's going wrong.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Geoff Berrow]

Message-ID: <aM************ ********@comcas t.com> from Jerry Stuckle
contained the following:

How about showing us the failing code? It would be much easier to
troubleshoot what's going wrong.

And how did the data get into the multi-dimensional array in the first
place?

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Richard Levasseur]

Its not, really, its in $table[$row][$col] = $value format, at least if
i understand his post correctly. It also sounds like an interation
problem? I can't rightly tell if its trouble getting the last key from
table ( $row from $table ) or last key from row ($col from each $row).

In either case:

$i = 0; to $i < n, iterates n times. Make sure you're iterating to the
correct amount

foreach($table as $row) {
$columns = implode(... array_keys($row ));
$values = implode(... array_values($r ow));
$query = "insert into table ($columsn) values ($values)";
}

or

foreach($table as $row) {
"insert into table (col1, col2, ...) values ($row[level1], $row[level2]
....)";
}

Hope that helps?

[Stephen Preston]

Hi

Thanks to you all for replying, and sorry if my explaination was garbled.
The code for the section is as follows.
The first part empties the table first (which it does). After persevering
further last night the code below empties the contents of the table, and the
$result inside the brackets fills one row of the MySQL table with the first
row of the array, then issues the 'Couldn't insert data'.
If I swap the $result is outside the brackets (# commented out below), the
table is emptied again and then the last row of the array fills one row of
the table. 'Couldn't insert data' is not issued though this time.
if(isset($_POST['dataok']))
{
$input = $_POST[input];
include("dataup .inc");
$query1 = "DELETE FROM $tableName";
$result = mysql_query($qu ery1)
or die("Couldn't delete the data.");
echo "All data within $tableName has been deleted!!!<p>";

foreach($input as $row)
{
$query2 = "INSERT INTO $tableName
(level1,level2, level3,illust,i tem,description ,partNo,qua,pri ce,remarks,weig ht,size,mass)
VALUES
('$row[level1]','$row[level2]','$row[level3]','$row[illust]','$row[item]','$row[description]','$row[partNo]','$row[qua]','$row[price]','$row[remarks]','$row[weight]','$row[size]','$row[mass]')";
$result = mysql_query($qu ery2) or die("Couldn't insert data.");
}
# $result = mysql_query($qu ery2) or die("Couldn't insert
data.");

exit();
} # endif

Still trying to understand Richards first example (my lack of
understanding), not his explaination I think.

Thanks
Stephen

[Jerry Stuckle]

Stephen Preston wrote:

Hi

Thanks to you all for replying, and sorry if my explaination was garbled.
The code for the section is as follows.
The first part empties the table first (which it does). After persevering
further last night the code below empties the contents of the table, and the
$result inside the brackets fills one row of the MySQL table with the first
row of the array, then issues the 'Couldn't insert data'.
If I swap the $result is outside the brackets (# commented out below), the
table is emptied again and then the last row of the array fills one row of
the table. 'Couldn't insert data' is not issued though this time.
if(isset($_POST['dataok']))
{
$input = $_POST[input];
include("dataup .inc");
$query1 = "DELETE FROM $tableName";
$result = mysql_query($qu ery1)
or die("Couldn't delete the data.");
echo "All data within $tableName has been deleted!!!<p>";

foreach($input as $row)
{
$query2 = "INSERT INTO $tableName
(level1,level2, level3,illust,i tem,description ,partNo,qua,pri ce,remarks,weig ht,size,mass)
VALUES
('$row[level1]','$row[level2]','$row[level3]','$row[illust]','$row[item]','$row[description]','$row[partNo]','$row[qua]','$row[price]','$row[remarks]','$row[weight]','$row[size]','$row[mass]')";
$result = mysql_query($qu ery2) or die("Couldn't insert data.");
}
# $result = mysql_query($qu ery2) or die("Couldn't insert
data.");

exit();
} # endif

Still trying to understand Richards first example (my lack of
understanding), not his explaination I think.

Thanks
Stephen

Rather than just saying "Couldn't insert data", you need to find out WHY
it couldn't insert it. Try mysql_error() and see what it says.

I suspect it has to do with your values; amongst other things, numeric
values should not have quotes around them.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===