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

11 votes298 views4 answers
Get first row of array php
PHP
19 votes285 views3 answers
Print array on php
PHP
1 vote265 views2 answers
Getting last day of next month in php
PHP
0 vote287 views1 answer
Get post php
PHP
12 votes463 views6 answers
Email validation in laravel
PHP
0 vote268 views1 answer
Php convert file_get_content to string
PHP
7 votes332 views3 answers
How to show validation error in laravel blade
PHP Laravel
0 vote289 views1 answer
Debian php switch version
PHP
0 vote336 views2 answers
How to set optional third parameter in routes of codeigniter
PHP
9 votes308 views3 answers
Make controller laravel 8 with resource
PHP