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 vote324 views1 answer
Get data from stdclass object php
PHP
3 votes323 views1 answer
Laravel e commerce full project
PHP
11 votes309 views2 answers
Select distinct laravel
PHP
7 votes297 views2 answers
Php Undefined index: error
PHP
0 vote375 views1 answer
How to on debug on wp
PHP Wordpress
20 votes287 views3 answers
File exist php
PHP
1 vote348 views1 answer
Laravel read origanl value before update
PHP Laravel
2 votes307 views1 answer
Debug query in moodle
PHP
1 vote292 views2 answers
Get wordpress posts by category name..!
PHP
-1 vote384 views1 answer
Laravel edit form select don't repeat a selected value
PHP Laravel