store result of sql request in a variable php

Question

With a POST request, I get the name of someone that I want to link with its id the mySQL database. For that, I create a query as you can see below and I need to put the result (a simple number) into a variable to use it for other queries.

I know that I could make joints with SQL but I'm trying to do it this way.

$owner = $_POST['owner'];

$queryUser = "SELECT id FROM collections WHERE name = '$owner'";
$idUser = $mysqli->query($queryUser) or die($mysqli->error.__LINE__);

With this code, I can't use $idUserbecause it appears as an 0, a 1 (recogniezd as an array?) or nothing when I try to write it somewhere in my database. I tried to use the intval() function with no results...

Any help?

Remember to fetch the result ^^

Jesper
– Jesper

2015-02-24 13:16:19 +00:00
Commented Feb 24, 2015 at 13:16 — Jesper
– Jesper, Commented Feb 24, 2015 at 13:16

taliezin · Accepted Answer · 2015-02-24 13:14:59Z

1

You have to fetch result from query:

$res = $mysqli->query($queryUser) or die($mysqli->error.__LINE__);
$idUser = $res->fetch_assoc();

so your id will be $idUser['id']

answered Feb 24, 2015 at 13:14

taliezin

9161 gold badge14 silver badges20 bronze badges

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

3 Comments

ahbon Over a year ago

I used the fetch_assoc() but I didn't realize that I'll have to use $idUser['id'] instead of $idUser. Many thanks!

ahbon Over a year ago

Actually, the fetch displays the good value of the id with an echo but I still got a 0 in my database...

taliezin Over a year ago

You are selecting id from database, and your result id is in $idUser['id']. Please clarify what is missing?

kidA · Accepted Answer · 2015-02-24 13:17:24Z

0

You can use the fetch_array method which fetches the result as an associative array

$query = $mysqli->query($queryUser) or die($mysqli->error.__LINE__);

$row = $query->fetch_array(MYSQLI_ASSOC);

echo $row['id']

answered Feb 24, 2015 at 13:17

kidA

1,3871 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

store result of sql request in a variable php

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related