php - How to get a column value using MySQLi?

Question

443 votes

1 answers

php - How to get a column value using MySQLi?

Get the solution ↓↓↓

Undefined answered · Answer 1 · 2022-09-25

Answer

Solution:

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

Popular technologies

Latest questions:

php - How to get a column value using MySQLi?

Answer