/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

2 votes343 views1 answer
Img upload in php
PHP
0 vote390 views1 answer
Curl error (code 3) url malformed laravel
PHP Laravel
0 vote362 views1 answer
Encryption key has not encrypted laravel
PHP Laravel
0 vote382 views2 answers
Laravel loop variable
PHP Laravel
1 vote356 views1 answer
$posts- links() laravel design error
PHP
0 vote360 views2 answers
Laravel restrict home route access
PHP Laravel
0 vote339 views2 answers
Foreach loop in php stack overflow
PHP
-1 vote392 views1 answer
Sometimes validation in laravel
PHP Laravel
7 votes341 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP
4 votes363 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel