/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 vote140 views2 answers
Laravel compare date timestamp
PHP
0 vote176 views1 answer
How to set timezone for iran in laravel
PHP Laravel
0 vote137 views1 answer
* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1
PHP
0 vote126 views1 answer
Remove text keep numbers only php
PHP
2 votes143 views2 answers
How to get attachments to emails php
PHP
9 votes114 views3 answers
How to get orinal hash laravel
PHP Laravel
0 vote156 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
0 vote139 views1 answer
Php how to make sure user doesn't submit
PHP
48 votes147 views5 answers
Laravel clear route cache
PHP
0 vote141 views1 answer
Update laravel .env variables dynamically
PHP