print database rows to an array to use with javascript for filtering

Question

I'm trying to use php to run a sql select statement to pull data from a database and then only output one column(username) to an array that I can then use to filter using a JS script. Similar to how facebook/twitter does their real time searching of contacts when you start typing someone's name in. I keep getting an error though in php when I try to pull the username column and set it to an array and output that:

<?php
session_start();
include_once 'dbconnect.php';
$contact = mysql_real_escape_string($con, $_POST['contact']);
$sql = "select * from users";
$result = $con->query($sql);
if ($result->num_rows > 0) {
   ($row = $result->fetch_assoc()) {
      printf($row["username"]);
    }
} else {
    echo "0 results";
}
?>

@bitfiddler nothing get's returned, it's completely blank...if i comment out the ($row ...){...} section and just put in a simple echo'result'; it get's printed but other wise nothing gets returned... — DRE
– DRE, Commented Apr 15, 2016 at 0:47

Ruben · Accepted Answer · 2016-04-15 00:48:17Z

2

It would help to know what the exact error PHP is giving you is. But from a cursory look on your code I believe you are missing a while keyword.

   while ($row = $result->fetch_assoc()) {
      printf($row["username"]);
    }

answered Apr 15, 2016 at 0:48

Ruben

6595 silver badges6 bronze badges

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

1 Comment

Ruben Over a year ago

@GregBorbonus, this isn't my question though so it's up to DRE .

Collectives™ on Stack Overflow

print database rows to an array to use with javascript for filtering

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related