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 vote214 views1 answer
Update laravel .env variables dynamically
PHP Laravel
8 votes173 views2 answers
Eloquent firstOrCreate
PHP
0 vote194 views1 answer
Wpml display language switcher
PHP
21 votes328 views6 answers
Do shortcode wordpress
PHP Wordpress
23 votes216 views6 answers
Laravel validation messages
PHP Laravel
0 vote249 views5 answers
Download file laravel s3
PHP Laravel
10 votes214 views2 answers
Laravel route list
PHP Laravel
1 vote177 views1 answer
Php remove numbers from string
PHP
0 vote172 views1 answer
Debugbar:clear in laravel
PHP
0 vote189 views1 answer
GetDoctrine
PHP