/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

9 votes154 views3 answers
Define url wordpress
PHP
1 vote126 views10 answers
Test
PHP
0 vote172 views2 answers
Php artisan app:name in laravel 6
PHP
0 vote169 views1 answer
Jupiter/framework/admin/generators/option-generator.php on line 80
PHP
1 vote141 views2 answers
Array_unique multidimensional php
PHP
0 vote149 views1 answer
Get first name user
PHP
1 vote138 views2 answers
What is php file
PHP
0 vote145 views1 answer
Php on page query
PHP
0 vote156 views2 answers
How to implement maatwebsite excel in my laravel project
PHP
0 vote168 views1 answer
Laravel string capitalize in view
PHP Laravel