Array to string conversion SYmfony Sql

Question

I have an sql request:

 $listUsers=$connection->prepare("SELECT u.id as userid From user u , account a where (a.id_parent=$id_account OR  a.id=$id_account) and u.id_account=a.id ");
            $listUsers->execute();
            $users=$listUsers->fetchColumn();

but fetchColumn return just one result, and I want a set of list user id to use it in the next request.

 $listPush=$connection->prepare("select id from Table_name where id_user in (?));
 $listPush->bindValue(1, $users);
            $listPush->execute();
            $idpushs=$listPush->fetchColumn();

but this return just one result. Any Idea to replace fetchColumn by other request or using doctrince.

fetchColumn returns a single column from the next row of a result set. Try fetchAll. — Spas Bobchev
– Spas Bobchev, Commented Nov 25, 2015 at 9:42

Julien Bourdic · Accepted Answer · 2015-11-25 10:08:41Z

1

With your logic, you can simply fetch all your users and implode it.

$listUsers=$connection->prepare("SELECT u.id as userid From user u , account a where (a.id_parent=$id_account OR  a.id=$id_account) and u.id_account=a.id ");
$listUsers->execute();
$users=$listUsers->fetchAll();
$userIds = array();
foreach ($users as $user) {
   $userIds[] = $user['userid'];
}
$users = implode(',', $userIds); //that hurts me so hard to code like this with symfony :'(

Fetch colum will only return the column of the next row. So for your second piece of code, you can loop over results.

But, if you're are using a framework like symfony, you have many other ways to make it cleaner. Just check out the symfony doc to use repository relations and more generally doctrine

edited Nov 25, 2015 at 10:08

answered Nov 25, 2015 at 9:42

Julien Bourdic

1,4201 gold badge15 silver badges31 bronze badges

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

2 Comments

Majdi Taleb Over a year ago

the problem that the result is an array like this: 'array (size=1) 0 => array (size=1) 'userid' => string '10' (length=2)'

Julien Bourdic Over a year ago

Updated. Please consider the end of my answer :)

Collectives™ on Stack Overflow

Array to string conversion SYmfony Sql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related