/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

0 vote335 views1 answer
Favicon php
PHP
0 vote395 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
0 vote395 views1 answer
Laravel translation parameter send
PHP Laravel
0 vote429 views1 answer
How to on auto_recording using zoom api in php
PHP
0 vote333 views1 answer
How to free session variable in php codeigniter
PHP
-1 vote327 views2 answers
Laravel model save get id
PHP
9 votes323 views3 answers
Get env app url laravel
PHP
0 vote383 views2 answers
How to Redirect Website to a Mobile Version when Accessed on a Mobile Device
PHP
0 vote377 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
0 vote343 views1 answer
Displaying the category name of a custom post type
PHP