Turn SQL value to variable

Question

so I have a database table with some user information, like ID, username, etc. and I have been trying to turn a value, for example, Bob's ID into a variable $id from the table. This is what I have right now:

$db = mysqli_connect(THIS WORKS FINE AND CONTAINS SECRET INFO :));
$sql = "SELECT ID FROM users WHERE username='$prompt'";
$result = mysqli_query($db, $sql);

and I need to turn it into a variable, because I am combining everything into a sentence so it could be $username has the id of $id. Thanks

var_dump $result to see what it is, then figure out how to extract the data you need from it. — Andrew
– Andrew, Commented Jan 31, 2017 at 5:45
this might also help stackoverflow.com/questions/15617824/result-mysql-query — Andrew
– Andrew, Commented Jan 31, 2017 at 5:45
@Andrew This is what I got: object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(1) ["type"]=> int(0) } — Francisco F.
– Francisco F., Commented Jan 31, 2017 at 5:47
WARNING: When using mysqli you should be using parameterized queries and bind_param to add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put $_POST or $_GET data directly into a query, it can be very harmful if someone seeks to exploit your mistake. — tadman
– tadman, Commented Jan 31, 2017 at 6:15

Hikmat Sijapati · Accepted Answer · 2017-01-31 05:51:14Z

1

Try like this.use sprintf().The sprintf() function writes a formatted string to a variable.

$db = mysqli_connect(THIS WORKS FINE AND CONTAINS SECRET INFO :));
$sql = "SELECT ID,username FROM users WHERE username='$prompt'";
$result = mysqli_query($db, $sql);

$row = mysqli_fetch_assoc($result);

$sentence = sprintf("%s has the id of %u.",$row['username'],$row['ID']);

echo $sentence;

For more see sprintf

answered Jan 31, 2017 at 5:51

Hikmat Sijapati

6,9691 gold badge11 silver badges19 bronze badges

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

4 Comments

Francisco F. Over a year ago

Just curious, but will it work if I just echo, for example, $row['username']?

Hikmat Sijapati Over a year ago

["num_rows"]=> int(1) means there is only one row.so $row['username'] will print username fetched from database.

tadman Over a year ago

If you're going to echo it anyway, just use printf.

Hikmat Sijapati Over a year ago

@ tadman yes i aggred with you.But op wants to turn it into a variable

Collectives™ on Stack Overflow

Turn SQL value to variable

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related