PHP PDO always give only one result

Question

I wrote a SQL query with PDO. DB table has 3 results with match the query. But the PDO shows only one result.

my code is this

conn.php

function connect() { $servername = "localhost"; $dbname = "guiding_db"; $username = "user"; $password = "pass"; $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return $conn; }

_admin.php

include_once './conn.php'; function getStudentsRequests(){ $sql = "SELECT * FROM `user` WHERE signas = 'student' AND accept='0'"; $result = connect()->query($sql); $out = $result->fetch(PDO::FETCH_ASSOC); print_r($out); return $out; } getStudentsRequests();

What is the value of print_r($out);??

Saty
– Saty

2016-06-16 11:33:47 +00:00
Commented Jun 16, 2016 at 11:33 — Saty
– Saty, Commented Jun 16, 2016 at 11:33

Shira · Accepted Answer · 2016-06-16 11:35:14Z

PDOStatement::fetch() loads a single row only. Use PDOStatement::fetchAll() to load all rows (or use a while loop):

$out = $result->fetchAll(PDO::FETCH_ASSOC);

nospor · Accepted Answer · 2016-06-16 11:33:48Z

fetch method return only one row from query. If you want all you need to use while loop or fetchAll method

maximkou · Accepted Answer · 2016-06-16 11:34:09Z

0

fetch method return next result (one). If you wish get all results - use methods like fetchAll

answered Jun 16, 2016 at 11:34

maximkou

5,3421 gold badge23 silver badges41 bronze badges

Collectives™ on Stack Overflow

PHP PDO always give only one result

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related