如何在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']);

Answer 1

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.