/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 vote288 views1 answer
Php hide decimals if zero
PHP
0 vote283 views1 answer
Detect the page realod in php
PHP
0 vote339 views1 answer
Auto check a category when creating new post
PHP
0 vote301 views1 answer
How to perform form inpot in laravel 8 and export database
PHP
0 vote276 views1 answer
CODEIGNITER codeigniter 4 auth
PHP
0 vote338 views1 answer
Laravel child relation get max value
PHP Laravel
3 votes266 views2 answers
Php get string before character
PHP
9 votes288 views6 answers
Laravel ui auth
PHP Laravel
0 vote282 views1 answer
Url decode function in php
PHP
0 vote301 views1 answer
Php increment and decrement
PHP