Run a PHP function if returned SQL data matches a specific value

Question

I want to run a function if the returned data from database matches a specific value.

For example, if SELECT city FROM users ORDER BY id DESC LIMIT 1 returns "London" then run the PHP function 'myFunction()'.

What I tried is :

// Database connected successfully
$abc = "SELECT city FROM users ORDER BY id DESC LIMIT 1";
if ($abc = "London") {
myFunction();
}
else{
echo("not found");
}

You're not executing the query or fetching the results. – Barmar Sep 22 '21 at 17:52 — Barmar, Sep 22 '21 at 17:52
Read a tutorial on how to perform SQL queries in PHP. – Barmar Sep 22 '21 at 17:53 — Barmar, Sep 22 '21 at 17:53
ALso use `==` for comparison. `=` is assignment. – Barmar Sep 22 '21 at 17:54 — Barmar, Sep 22 '21 at 17:54

score 2 · Accepted Answer · answered Sep 22 '21 at 18:04

You should follow these steps.

//build database connection
$conn = mysqli_connect("localhost","my_user","my_password","my_db");

//query
$query = "SELECT city FROM users ORDER BY id DESC LIMIT 1";

//execute query
$resultSet = mysqli_query($conn, $query);
$record = mysqli_fetch_assoc($resultSet); // as we have limit 1 in query so only one record will be returned in result set

if($record['city'] == 'London'){
    //call function
    myFunction();
}else{
    echo "Not found!";
}

Run a PHP function if returned SQL data matches a specific value

1 Answers1