Solved

Is there a way to combine each element of a multidimensional array with another array in php?

Posted on 2010-11-28
8
259 Views
Last Modified: 2012-06-27
I have a multidimensional array which is a set of exploded numbers .ie

3-4-7
2-5-1
1-2-3
They have been exploded using "-" delimiter to input into  a database using a form that I copy and paste the numbers from a spreadsheet. I can load them individually or as a set. just fine. However I need put them into the database combined with another array  of letters ie:

Column 1          Column2
A                          347
B                          251
C                          123

The letters array are the name of tables in the database and the numbers are being inserted with each number a different field. Again I can explode and load them fine, but I want to be able to take the letter array, and copy the numbers into the form and have the numbers load into the database based on the names in the letter array. Any ideas would be appreciated.

0
Comment
Question by:phillyrob817
  • 4
  • 4
8 Comments
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
It looks like you have two arrays there - you can use an iterator like foreach() to walk the arrays.
0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
It would probably be helpful to see your CREATE TABLE statements and a little "before-and-after" example.

This shows how the iterators work.
foreach ($column1 as $key => $table_name)

{

    echo $column2[$key];

}

Open in new window

0
 

Author Comment

by:phillyrob817
Comment Utility
Thanks for the reply.

The table names  in the db are A, B, C  and in each table the fields are: id, date, number_1, number_2 ,number_3.

I take numbers from a spreadsheet  and copy them into a text box  like so

1-2-3
4-5-6
7-8-9 ect  
up to 20 rows of numbers. My script will explode  those number delimiting on the "-"  and upload each number into the proper fiield, but I first must select each table, then copy/paste into form then hit submit to upload. I have to do each table separately. I am looking to have an array with the each table name, and when i copy the numbers, have each row be associated with each element of the array (table name) ie

table A  matched with first pasted number 1-2-3
table B with second 4-5-6 and so on.


0
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 250 total points
Comment Utility
This looks like it could benefit from a lot of automation.  Instead of cutting numbers from a spreadsheet and pasting into a text box, try writing the spreadsheet output into a file.  You can probably save the spreadsheet as a ".csv" file.  Then when you read the spreadsheet in with fgetcsv() you will have an array of numbers (corresponding to the cells of the spreadsheet).  You can store the first row into table A, the second into table B, etc.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:phillyrob817
Comment Utility
I have never used  fgetcsv(), so you have sent me down a new path that may the a very easy solution to all the code I have written. Thx I will let you know  shortly!
0
 

Author Closing Comment

by:phillyrob817
Comment Utility
This helps a lot, but leads to another question. Does not solve issue.
0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
Yeah, the reason it does not solve the issue is because you have not given EE adequate test data. Take some time to learn about "TDD" -- it will make your work much easier.
0
 

Author Comment

by:phillyrob817
Comment Utility
ok thx  I will.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now