/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 vote285 views1 answer
Laravel find or create new
PHP Laravel
0 vote254 views1 answer
Laravel count without pagination
PHP
0 vote248 views1 answer
Test lockForUpdate laravel
PHP
0 vote304 views1 answer
Laravel convert querybuilder to string
PHP Laravel
0 vote265 views2 answers
Laravel filemanger choose multiple images
PHP
0 vote276 views1 answer
Php loop html select option
PHP
7 votes247 views3 answers
Php merge array with same value
PHP
0 vote268 views1 answer
Laravel get limited character of string
PHP
1 vote280 views1 answer
Append variable into string php
PHP
25 votes294 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP Laravel