How to get a column value using MySQLi?

Question

I am trying to get a value from column "odznak" in "users" tab for user "user01" and store it in variable $odznak (for searching in another tab.

$stmt = $conn->prepare("SELECT odznak FROM users WHERE username = 'user01'");
$stmt->execute();
$result = $stmt;
$odznak;

score 2 · Accepted Answer · answered Sep 20 '22 at 00:47

2

You need to fetch the data (say into an associative array)

On the other hand, as a good practice, please use parameterized prepared statement in your select query

So, change to:

$stmt = $conn->prepare("SELECT odznak FROM users WHERE username = ?");
$stmt->bind_param("s", 'user01');
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$odznak=$row["odznak"];

Now, $odznak is the retrieved data

answered Sep 20 '22 at 00:47

Ken Lee

6,985
3
10
29

and for example, if I want to get $odznak as a Integer? – Martin Trnka Sep 20 '22 at 10:03
@MartinTrnka it is already integer (if this field is int in the database) – Your Common Sense Sep 20 '22 at 10:11

How to get a column value using MySQLi?

1 Answers1