PHP Array Generator

Question

I have some values in a excel file and I want all of them to be array element remember file also have other data in it.

I know one way is that copy them one by one and put into array initialize statment

A sample list which is just a part of whole list

Bay Area 
Greater Boston
Greater Chicago
Greater Dallas-Ft. Worth
Greater D.C.
Las Vegas
Greater Houston
Greater LA
Greater New York
Greater San Diego
Seattle
South Florida

It is easy to initialize array with values when there are not much items like

$array= array('Bay Area '=>'Bay Area ','Greater Boston'=>'Greater Boston',....) 
// and so on

But I have 70-80 of items it is very tedious task to initialize array like above.

So, Guys Is there any alternate or short cut to assign array with the list of values?

Is there any auto array generator tool?

ohmusama · Accepted Answer · 2011-05-03 08:28:23Z

6

If you copied them to a file with each one its own line you could read the file in php like this

$myArray = file('myTextFile');

//sets the keys to the array equal to the values
$myArray = array_combine($myArray, $myArray);

You could export the data from excel to a CSV, then read the file into php like so:

$myArray = array();
if (($file = fopen("myTextFile", "r")) !== FALSE) {
    while (($data = fgetcsv($file)) !== FALSE) {
        foreach($data as $value) {
            $myArray[$value] = $value;
        }
    }
    fclose($handle);
}

answered May 3, 2011 at 8:28

ohmusama

4,2556 gold badges27 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ohmusama Over a year ago

Updated for new version of question.

Maxime Pacary · Accepted Answer · 2011-05-03 08:35:16Z

3

$array = explode("\n", file_get_contents('yourfile.txt'));

For more complex cases for loading CSV files in PHP, maybe use fgetcsv() or even PHPExcelReader for XLS files.

EDIT (after question edit)

(Removed my poor solution, as ohmusama's file() + array_combine() is clearly nicer)

edited May 3, 2011 at 8:35

answered May 3, 2011 at 8:21

Maxime Pacary

23.2k12 gold badges92 silver badges117 bronze badges

Comments

Matej Baćo · Accepted Answer · 2011-05-03 08:20:45Z

1

This one:

$string_var = "
Bay Area 
Greater Boston
Greater Chicago
Greater Dallas-Ft. Worth
";

$array_var = explode("\n", $string_var);

answered May 3, 2011 at 8:20

Matej Baćo

1,3322 gold badges10 silver badges12 bronze badges

1 Comment

Daric Over a year ago

Sorry forgot to mention, I need key=>value pair question updated

netbrain · Accepted Answer · 2011-05-03 08:23:44Z

1

get notepad++, open the excel file there, and do a simple search and replace with regex. something like search for "(.*)\n" and replace with "'(\1)'," (" quoutes not included), this would give you a long list of:

'Bay Area','Greater Boston','Greater Chicago'

This would be the fastest way of creating the array in terms of php execution time.

answered May 3, 2011 at 8:23

netbrain

9,3046 gold badges44 silver badges69 bronze badges

Comments

ern0 · Accepted Answer · 2011-05-03 08:24:56Z

0

I think it's looks better:

$a[] = "Bay Area";
$a[] = "Greater Boston";
$a[] = "Greater Chicago";

For creating such text file, use Excel (I don't have Excel, but it looks somewhat):

=concatenate(" $a[] = ",chr(34),A1,chr(34),";")

Then export only that column.

answered May 3, 2011 at 8:24

ern0

3,18029 silver badges43 bronze badges

Collectives™ on Stack Overflow

PHP Array Generator

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related