how to convert string into array in php

Question

I am fetching records from mysql database through while loop.

$sql=mysql_query("SELECT * FROM animate ORDER BY RAND() LIMIT 10") or die("query Field");

 while($row=mysql_fetch_array($sql)){

$row['code'];

 }

output is xyacefg.

Now I want to break this output into an array I want to place each letter into separate index of array like

array('x','y','a','c','e','f','g');

I have used explode

$array = explode(' ', $row['code']);

but it didnot work. now the final code is .

$sql=mysql_query("SELECT * FROM animate ORDER BY RAND() LIMIT 10") or die("query Field");

 while($row=mysql_fetch_array($sql)){

$row['code'];

 }

$array = explode(' ', $row['code']);

$array[] = str_split($row['code']) inside the loop, print_r($array) outside the loop — Alex Andrei
– Alex Andrei, Commented Apr 15, 2016 at 17:19

Death-is-the-real-truth · Accepted Answer · 2016-04-15 17:35:52Z

2

You need to create an empty array and assign value to them like below:-

$new_array = array(); // create a new array
$sql=mysql_query("SELECT * FROM animate ORDER BY RAND() LIMIT 10") or die("query Field");

 while($row=mysql_fetch_array($sql)){

    $new_array[] = $row['code']; // assign value to array

 }
echo "<pre/>";print_r($new_array); // print array which is created

Note:- My assumption is $row['code'] giving you value one-by-one because it is in while loop.

edited Apr 15, 2016 at 17:35

answered Apr 15, 2016 at 17:16

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

1 Comment

Daniel Over a year ago

Nope, this seems to be the correct answer, rather than the (current) top. @Anant

Thamilhan · Accepted Answer · 2016-04-15 17:17:06Z

2

Its easy with str_split:

<?php
$array = str_split("xyacefg"); //In your case: str_split($row['code']);
print_r($array);

Output:

Array
(
    [0] => x
    [1] => y
    [2] => a
    [3] => c
    [4] => e
    [5] => f
    [6] => g
)

answered Apr 15, 2016 at 17:17

Thamilhan

13.3k5 gold badges40 silver badges60 bronze badges

Comments

Arshad Hussain · Accepted Answer · 2016-04-15 17:24:17Z

0

Just use str_split() function. If you want to get exact same result as you want like:

array('x','y','a','c','e','f','g');

then use following code:

<?php
  $string = "xyacefg";
  $exploded = str_split($string);
  echo 'array("'.implode('", "', $exploded).'");';
?>

answered Apr 15, 2016 at 17:24

Arshad Hussain

7875 silver badges23 bronze badges

Collectives™ on Stack Overflow

how to convert string into array in php

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related