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

1 vote125 views1 answer
Laravel increment column value in update query
PHP
4 votes116 views3 answers
Laravel return json header json
PHP
2 votes124 views5 answers
Maximum execution time of 30 seconds exceeded
PHP
28 votes156 views6 answers
Laravel drop foreign key
PHP Laravel
0 vote108 views1 answer
How to get a particular column in laravel 8
PHP
0 vote134 views1 answer
Laravel route match
PHP Laravel
0 vote126 views1 answer
Autoload_namespaces.php failed to open stream: Permission denied
PHP
3 votes122 views6 answers
Laravel cors
PHP
0 vote114 views1 answer
Php reverse dns lookup
PHP
0 vote99 views1 answer
Show phpinfo just modules
PHP