Php mysql if not exists insert

$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();

Php sql insert into if not exists

INSERT IGNORE INTO `transcripts`
SET `ensembl_transcript_id` = 'ENSORGT00000000001',
`transcript_chrom_start` = 12345,
`transcript_chrom_end` = 12678;

-1

Source: stackoverflow.com

Similar codes

0 vote142 views1 answer
Javascript date to php date
PHP
7 votes116 views6 answers
Create project laravel
PHP
5 votes125 views1 answer
Limit 1 1 in laravel query
PHP
14 votes124 views3 answers
Unset php return array
PHP
2 votes135 views1 answer
Laravel mix purge css
PHP Laravel
0 vote116 views1 answer
Wordpress check if page
PHP
0 vote112 views1 answer
Php pdf
PHP
1 vote123 views1 answer
Php beautify json
PHP
1 vote112 views2 answers
Php file_get_contents online file
PHP
0 vote119 views1 answer
Laravel get current domain
PHP