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 vote189 views1 answer
Dropzone in php
PHP
18 votes157 views3 answers
Php try json decode and check
PHP
3 votes150 views1 answer
Php remove query param from url
PHP
0 vote139 views1 answer
Wp php redirect my account page url to custom url
PHP
2 votes209 views2 answers
Assert file exists laravel
PHP
13 votes155 views5 answers
Php get day of week
PHP
41 votes182 views6 answers
Php random string
PHP
10 votes193 views4 answers
Print last query laravel
PHP Laravel
1 vote190 views1 answer
Cart icon in woocommerce
PHP
1 vote159 views4 answers
Laravel module package
PHP