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

1 vote284 views2 answers
Fetch body show in php code
PHP
15 votes247 views1 answer
Laravel composer install ignore
PHP
8 votes265 views2 answers
Php replace space with underscore
PHP
2 votes286 views1 answer
For loop php continue to next item
PHP
0 vote285 views1 answer
Multiplication des variables sur laravel
PHP Laravel
0 vote303 views1 answer
Laravel collection shuffle
PHP Laravel
6 votes250 views2 answers
Create migration model and seeder laravel at once
PHP
2 votes281 views2 answers
The requested url was not found on this server. laravel
PHP Laravel
8 votes288 views2 answers
How to debug php
PHP
0 vote254 views1 answer
Php check if string contains number
PHP