/PHP/Php select from database into array

Php select from database into array

<?php

// run query
$query = mysql_query("SELECT * FROM table");

// set array
$array = array();

// look through query
while($row = mysql_fetch_assoc($query)){

  // add each row returned into an array
  $array[] = $row;

  // OR just echo the data:
  echo $row['username']; // etc

}

// debug:
print_r($array); // show all array data
echo $array[0]['username']; // print the first rows username

Source: stackoverflow.com

Convert query result to array php

$result = "select * from random_table where id = 1";

$rows = [];
while($row = mysqli_fetch_array($result))
{
    $rows[] = $row;
}

Similar codes

1 vote336 views1 answer
Acf repeater example count
PHP
0 vote445 views1 answer
Cakephp get present name
PHP CakePHP
3 votes385 views2 answers
Laravel base table or view not found hasmany
PHP Laravel
0 vote389 views1 answer
Wp limit post revisions
PHP Wordpress
0 vote330 views1 answer
Ifmodule condition in htaccess
PHP
1 vote352 views2 answers
Decode jwt token laravel
PHP Laravel
0 vote337 views1 answer
PHP script
PHP
2 votes353 views2 answers
Laravel pagination with get parameters
PHP
0 vote399 views1 answer
Get post by name wordpress
PHP Wordpress
32 votes324 views2 answers
How add new column in larevel with migration
PHP