PHP SQL only returning 1 response instead of multiple

Question

Here's the PHP and I'll explain as I go

$query = "SELECT id, attendees FROM events WHERE creator = '63' AND attendees LIKE '%74%'";

$result = mysqli_query($dbc,$query);

$uid_events = mysqli_fetch_array($result,MYSQLI_ASSOC);

echo $_GET['callback'] . '("' . stripslashes(json_encode($uid_events)) . '");';

It's a jquery JSONP request and I'm trying to retrieve 2 records.

When I test this exact same query directly in my database I get these 2 records:

34acb43ccc4c34b911ba8b7d850a846b63 - 63,1,74     
09fa87b2ed809d6741c43dd669c83e1a63 - 63,74

But the PHP echoes out:

({"id":"34acb43ccc4c34b911ba8b7d850a846b63","attendees":"63,1,74"}");

Any help would be appreciated.

Alon Eitan · Accepted Answer · 2011-10-01 20:55:33Z

2

try this:

while ($uid_events = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
   echo $_GET['callback'] . '("' . stripslashes(json_encode($uid_events)) . '");';
}

answered Oct 1, 2011 at 20:55

Alon Eitan

12k8 gold badges51 silver badges61 bronze badges

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

5 Comments

Jared Farrish Over a year ago

The only thing I'm wondering is if the echo'd line would stay the same.

Alon Eitan Over a year ago

no, $uid_events will change during the while loop, it will contain an array with data of every line from your select query. sorry for my bad english :)

Jared Farrish Over a year ago

@Alon - I'm just saying, look at the output (in the question) and imagine what the code is doing on the client. I'm not entirely sure, but it looks like that output would not be useful two or more lines in a row.

Alon Eitan Over a year ago

@JaredFarrish - I agree with you, he should manipulate the results from the query, and output in the while loop only the data from the db.

Marius Miliunas Over a year ago

Actually all the scripting that had to be done was in the PHP script. I just used the output to help me debug

Mark Byers · Accepted Answer · 2011-10-01 20:55:54Z

1

The function mysqli_fetch_array fetches only one row (or returns FALSE if there are no more rows). If you want to read all rows you should run this statement in a loop, until it returns FALSE.

answered Oct 1, 2011 at 20:55

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Comments

rid · Accepted Answer · 2011-10-01 20:56:02Z

1

mysqli_featch_array() returns a single row, then advances the cursor to the next row. To get all rows, you need to call it in a loop.

answered Oct 1, 2011 at 20:56

rid

64k31 gold badges159 silver badges201 bronze badges

Collectives™ on Stack Overflow

PHP SQL only returning 1 response instead of multiple

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related