/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

30 votes118 views3 answers
Random key generator php
PHP
22 votes169 views5 answers
Foreign key string laravel
PHP Laravel
0 vote111 views2 answers
Php json decode not working on array
PHP
2 votes113 views1 answer
Php discord webhook
PHP
0 vote112 views1 answer
Add auth middleware to route laravel
PHP
2 votes152 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP Laravel
0 vote115 views1 answer
Replace default WP search and dropdown placeholder
PHP
0 vote184 views1 answer
Foreach loog in php
PHP
1 vote178 views1 answer
Laravel mongodb field delete (key delete) (column delete) drop
PHP Laravel
-1 vote116 views2 answers
How to Delete Multiple Records using Checkbox in Laravel
PHP