/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

74 votes180 views6 answers
String to int php
PHP
0 vote195 views1 answer
Php session name
PHP
0 vote239 views1 answer
Drupal 8 / 9 entityTypeManager get multiple comments by cid
PHP Drupal
5 votes191 views1 answer
Php get age from dob
PHP
0 vote180 views1 answer
Display data from two dimensional array in vew laravel
PHP
0 vote192 views1 answer
Php array formatted output
PHP
5 votes216 views2 answers
Set unique value validation for laravel form request
PHP Laravel
37 votes203 views6 answers
Tolower php
PHP
0 vote199 views1 answer
Test a single file laravel
PHP Laravel
4 votes187 views5 answers
Get specific key value from array php
PHP