Need help to merge multiple arrays?

iwiz_seo · May 26, 2010, 10:09am

Hi all,

What i need to do to merge the following into a single array?

@Array ( [0] => [1] => ) For The Month Of :@Array ( [0] => For The Month Of : [1] => ) @Array ( [0] => [1] => ) Name:@Array ( [0] => Name: [1] => ) @Array ( [0] => [1] => ) Staff Number :@Array ( [0] => Staff Number : [1] => ) @Array ( [0] => [1] => ) Dept/Location :@Array ( [0] => Dept/Location : [1] => ) @Array ( [0] => [1] => ) Monthly From...To… (mm/dd/yy)@Array ( [0] => Monthly From...To… (mm/dd/yy) [1] => ) @Array ( [0] => [1] => ) @Array ( [0] => [1] => ) Amount (RM)@Array ( [0] => Amount (RM) [1] => ) Total Amount (RM)@Array ( [0] => Total Amount (RM) [1] => ) @Array ( [0] => [1] => ) Grand Total For The Month :@Array ( [0] => Grand Total For The Month : [1] => ) @Array ( [0] => [1] => ) @Array ( [0] => [1] => ) PREPARED BY : @Array ( [0] => PREPARED BY : [1] => ) SIGNATURE :@Array ( [0] => SIGNATURE : [1] => ) DATE:@Array ( [0] => DATE: [1] => )

Thanks for your help!!!

StarLion · May 27, 2010, 12:46pm

You’re missing a few pieces of information…
I assume that these are arrays inside of another array.
In which case, foreach() the array, collapse (implode on Space character, and trim?) the elements,and you’ve got what you want.

salathe · May 27, 2010, 8:02am

How familiar are you with PHP, basic string parsing functions/techniques, etc.? We’ll help you learn but we won’t* write entire solutions for you. What have you tried so far, anything?

* Unless someone is feeling excessively helpful and/or bored

iwiz_seo · May 27, 2010, 2:18am

That is not from database. Those data coming from an excel sheet.

I have an excel sheet and want to upload. But the excel sheet does not maintain any order. Following is sample data.

MONTHLY CLAIMS SUMMARY

For The Month Of : May Year: 2010

Name: Vasu

Staff Number : 552041

Dept/Location : Admin/Chennai

Monthly From…To… (mm/dd/yy) OVERTIME & STANDBY CLAIM TRAVEL CLAIM REIMBURSEMENT
Weekdays (RM13/hr) Saturday (RM13/hr) Sun & P.Holiday (RM17/hr) Standby (RM3.50/ hr) Mileage CAR (KM) Mileage Motorcycle (KM) Taxi (RM) Parking (meter) (RM) Parking (ticket) (RM) Toll (RM) Others (RM) Handphone (Postpaid) (RM) Handphone (Prepaid) (RM) Others (RM)
0.8 1.1 0.7 0.0 0.0 0.0 0.00
Amount (RM) 10.20 14.30 11.30 10.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Amount (RM) 46.00 0.00 0.00

Grand Total For The Month : 46.00

				CHECKED BY :

PREPARED BY : (Team Leader), if any MGR’S APPROVAL:
SIGNATURE : NAME: NAME:
DATE: DATE: DATE:

First row contains the tile of the sheet and next row has name and value pair and so on. Please tell me how to upload one values to database and skip the names.

Thanks for your help.

SpacePhoenix · May 26, 2010, 6:05pm

Are the arrays being created from a database results set? Is so how are you reading the results set into the arrays?

sbbtina · May 26, 2010, 10:30am

Please describe your question better, so I can help you.

iwiz_seo · May 26, 2010, 10:15am

Could some one help me to achieve this!!! Urgent!!!

iwiz_seo · May 26, 2010, 11:40am

Hi sbbtina,

Please see my previous reply and let me know what do i need to do!!

Again thanks for you help.

iwiz_seo · May 26, 2010, 11:09am

Hi sbbtina,

I want to merge the following arrays as a single array and then want to access.

Array ( [0] => [1] => ) Array ( [0] => For The Month Of : [1] => ) Array ( [0] => [1] => ) Array ( [0] => May [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Year: [1] => ) Array ( [0] => 2010 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Name: [1] => ) Array ( [0] => [1] => ) Array ( [0] => Vasu [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Staff Number : [1] => ) Array ( [0] => [1] => ) Array ( [0] => 552041 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Dept/Location : [1] => ) Array ( [0] => [1] => ) Array ( [0] => Admin/Chennai [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Monthly From…To… (mm/dd/yy) [1] => ) Array ( [0] => OVERTIME & STANDBY CLAIM [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => TRAVEL CLAIM [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => REIMBURSEMENT [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Weekdays (RM13/hr) [1] => ) Array ( [0] => Saturday (RM13/hr) [1] => ) Array ( [0] => Sun & P.Holiday (RM17/hr) [1] => ) Array ( [0] => Standby (RM3.50/ hr) [1] => ) Array ( [0] => Mileage CAR (KM) [1] => ) Array ( [0] => Mileage Motorcycle (KM) [1] => ) Array ( [0] => Taxi (RM) [1] => ) Array ( [0] => Parking (meter) (RM) [1] => ) Array ( [0] => Parking (ticket) (RM) [1] => ) Array ( [0] => Toll (RM) [1] => ) Array ( [0] => Others (RM) [1] => ) Array ( [0] => Handphone (Postpaid) (RM) [1] => ) Array ( [0] => Handphone (Prepaid) (RM) [1] => ) Array ( [0] => Others (RM) [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => 0.784615384615 [1] => ) Array ( [0] => 1.1 [1] => ) Array ( [0] => 0.664705882353 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => 0 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Amount (RM) [1] => ) Array ( [0] => 10.20 [1] => ) Array ( [0] => 14.30 [1] => ) Array ( [0] => 11.30 [1] => ) Array ( [0] => 10.20 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => [1] => ) Array ( [0] => Total Amount (RM) [1] => ) Array ( [0] => 46.00 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => 0.00 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => Grand Total For The Month : [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => 46.00 [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => CHECKED BY : [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => PREPARED BY : [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => (Team Leader), if any [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => MGR’S APPROVAL: [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => SIGNATURE : [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => NAME: [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => NAME: [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => DATE: [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => DATE: [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => DATE: [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => ) Array ( [0] => [1] => )

As you can see there are many arrays and each has two elements. All i want to do is convert the above arrays into single and then want to access the elements.

Thanks for your help!!!

hash · May 26, 2010, 10:56am

Urgent!!!

Will get on it in the morning
In the mean time, using @ isn’t a good idea.