/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

8 votes165 views1 answer
Laravel custom attributes
PHP Laravel
5 votes138 views2 answers
Php time a script
PHP
1 vote174 views2 answers
How many users can a cron handle in laravel in single run
PHP
0 vote178 views1 answer
How show livewire component in laravel
PHP Laravel
0 vote154 views1 answer
Total days between two dates carbon
PHP
1 vote185 views3 answers
Display pdf file in laravel
PHP
0 vote204 views1 answer
Implement class in autoloader athow to implment data table in laravel project
PHP Laravel
0 vote133 views1 answer
19 hours from now php
PHP
17 votes151 views3 answers
Php print_r array
PHP
17 votes147 views6 answers
Laravel carbon create date from string
PHP