Return list of strings with mysql query in PHP

Question

I'm trying to make a simple query with PHP that returns a list of Strings with all the names of the users, but I can figure out how to do do it. The only thing i thought wa this:

<?php

$host_name  = "hostname";
$database   = "database";
$user_name  = "username";
$password   = "pass";

$connect = mysqli_connect($host_name, $user_name, $password, $database);

$select = "SELECT username from userstasker";

$result = $connect->query($select);
$rows = array();

while($r = mysqli_fetch_assoc($result)) {
    $rows[] = $r;
}

echo json_encode($rows);

$connect->close();
?>

But this returns a JSon, ant idea how to do it?

What do you mean by a "list"? HTML <li> tags, or just rows of text, or what? — iainn
– iainn, Commented Nov 8, 2017 at 11:03
Then comment out the echo json_encode($rows); and access the array $rows — IsThisJavascript
– IsThisJavascript, Commented Nov 8, 2017 at 11:05

Emile P. · Accepted Answer · 2017-11-08 11:19:00Z

1

<?php

$host_name  = "hostname";
$database   = "database";
$user_name  = "username";
$password   = "pass";

$connect = mysqli_connect($host_name, $user_name, $password, $database);

$select = "SELECT username from userstasker";

$result = $connect->query($select);
$usernames = array();

while($r = mysqli_fetch_assoc($result)) {
    $usernames[] = $r["username"];
}

$connect->close();

// Do something with $usernames

?>

answered Nov 8, 2017 at 11:19

Emile P.

3,9811 gold badge18 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Return list of strings with mysql query in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related