How to create php array from MySQL column?

Question

I have such table:

id | name                                 | link
---+--------------------------------------+---------------
1  |SAsasasdsa,Главная страница,Main page | addsad

I want to get array like that:

$arr = array('az'=>'SAsasasdsa','ru'=>'Главная страница','en'=>'Main page');

where does it comes 'az','ru' and 'en' , from database?? — xkeshav
– xkeshav, Commented Dec 22, 2011 at 6:30
@GauravVashishtha is a language implementation using CSV in database — ajreal
– ajreal, Commented Dec 22, 2011 at 6:31

xkeshav · Accepted Answer · 2011-12-22 11:06:50Z

3

TRY

$qry = mysql_query('SELECT * FROM table');
//for multiple rows
$row = mysql_fetch_assoc($qry)) { $input[] = $row['name'] }
$key = array('az', 'ru', 'en');
foreach($input as $val) { 
  $output[] = array_combine($key,explode(',',$val));
}
echo "<pre>"; print_r($output);

Reference

array_combine

edited Dec 22, 2011 at 11:06

answered Dec 22, 2011 at 6:38

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

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

3 Comments

Someone Over a year ago

I tried your version but got error. before left delimeter is there while?

Someone Over a year ago

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in test.php on line 8

Someone Over a year ago

finally it worked. but i have more than 1 row. you said but could you show example pls??

Collectives™ on Stack Overflow

How to create php array from MySQL column?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related