/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

1 vote290 views2 answers
Get file name from file path in php
PHP
1 vote270 views1 answer
Laravel password verification
PHP
4 votes296 views2 answers
Remove index.php from url htaccess
PHP
1 vote423 views1 answer
Twitter login with socialite laravel 8
PHP
2 votes282 views1 answer
Create migration, controller, model and seeder laravel
PHP
2 votes377 views2 answers
Get session id in laravel
PHP Laravel
12 votes296 views6 answers
Laravel json response
PHP
0 vote299 views1 answer
Image not save laravel
PHP
0 vote357 views2 answers
Mysqli_fetch_all() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\complete-blog-php\admin\includes\post_functions.php on line 31
PHP
0 vote296 views1 answer
Discord.py Levels
PHP