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

40 votes324 views4 answers
How to split string into array php
PHP
0 vote288 views1 answer
Laravel wordpress reset password
PHP Laravel
1 vote298 views1 answer
Is php the fucking worst
PHP
0 vote297 views1 answer
Apache use public folder as root
PHP
10 votes323 views3 answers
Php check weekday of date
PHP
0 vote337 views2 answers
Laravel same route different group
PHP Laravel
0 vote315 views1 answer
Php tipi array
PHP
1 vote334 views1 answer
How add confirmation box in php before deleting
PHP
0 vote276 views1 answer
Wordpress create post programmatically
PHP
0 vote350 views1 answer
Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)
PHP