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

19 votes169 views6 answers
Array_search in php
PHP
0 vote181 views1 answer
Laravel 6 use username instead of id
PHP
0 vote222 views1 answer
Cake php 2.x joins
PHP CakePHP
3 votes166 views1 answer
Install all necessary php packages for laravel
PHP
2 votes184 views4 answers
Gd php extension
PHP
1 vote186 views1 answer
Config clear laravel
PHP Laravel
0 vote189 views1 answer
Order table in laravel
PHP Laravel
0 vote182 views1 answer
Dummy data in laravel
PHP
0 vote232 views3 answers
Email or phone required in laravel
PHP Laravel
0 vote185 views3 answers
Array fill key use in php project
PHP