/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 vote57 views2 answers
Http://www.endmemo.com/program/R/vector.php
PHP
1 vote97 views1 answer
Laravel s3 presigned url
PHP
18 votes104 views2 answers
Reload page in php
PHP
2 votes99 views2 answers
Check number is positive or negative in php
PHP
0 vote183 views3 answers
Email or phone required in laravel
PHP Laravel
3 votes108 views2 answers
Create variable in laravel blade
PHP
0 vote110 views1 answer
Laravel asset resolving to http not https
PHP
4 votes107 views1 answer
Aravel 8 how to order by using eloquent orm
PHP
0 vote122 views1 answer
Php 8 Match Expression / Switch Case
PHP
1 vote134 views1 answer
Php foreach if last item
PHP