Php mysql if exists

$mysqli = new mysqli(SERVER, DBUSER, DBPASS, DATABASE);
$result = $mysqli->query("SELECT id FROM mytable WHERE city = 'c7'");
if($result->num_rows == 0) {
     // row not found, do stuff...
} else {
    // do other stuff...
}
$mysqli->close();

Similar codes

0 vote384 views1 answer
Laravel interview questions
PHP
1 vote354 views2 answers
Php date function get previous month
PHP
45 votes411 views6 answers
Laravel migration add column after
PHP Laravel
11 votes343 views3 answers
Laravel auth 6
PHP Laravel
0 vote327 views2 answers
Laravel composite unique key
PHP
0 vote306 views1 answer
Search WordPress with custom field
PHP
0 vote324 views1 answer
Laravel faker title
PHP
8 votes331 views6 answers
Php array join
PHP
0 vote339 views2 answers
Mac install multiple php versions
PHP
1 vote379 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel