/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 vote171 views1 answer
Show error php in htaccess
PHP
0 vote301 views1 answer
How to set 1 year date without saturday in while loop php
PHP
3 votes170 views1 answer
Laravel firstOrFail
PHP
0 vote215 views1 answer
How to put cloth on 3d model using javascript and php
PHP
1 vote191 views3 answers
Php convert string to boolean
PHP
0 vote226 views4 answers
Laravel get last created id
PHP Laravel
25 votes171 views6 answers
Php merge 2 arrays
PHP
3 votes179 views3 answers
Php remove last element array
PHP
3 votes178 views3 answers
Fillable property to allow mass assignment
PHP
0 vote174 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP