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 vote129 views1 answer
Php remove non alphanumeric
PHP
0 vote133 views2 answers
Php send values in $_SESSION to other page
PHP
0 vote127 views1 answer
Php get file type from url
PHP
4 votes156 views2 answers
Add class to body class wordpress
PHP Wordpress
21 votes138 views3 answers
Brew version
PHP
1 vote126 views1 answer
File_get_contents timeout
PHP
1 vote140 views1 answer
Phpexcel set row height
PHP
0 vote159 views1 answer
Php send json post
PHP
2 votes129 views1 answer
Download speed limit php
PHP
1 vote251 views1 answer
Twig symfony get route
PHP Symfony