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

11 votes230 views6 answers
Object to array php
PHP
54 votes233 views6 answers
Php today date
PHP
0 vote220 views1 answer
Check string length is greater than 0 php
PHP
3 votes223 views1 answer
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add index `users_userable_type_userable_id_index`(`userable_type`, `userable_id`)
PHP
1 vote245 views1 answer
Dispatch queue jobs
PHP
0 vote271 views1 answer
CakeResque::enqueue
PHP
0 vote254 views1 answer
Laravel count data wise
PHP Laravel
0 vote224 views1 answer
Pmxi_gallery_image
PHP
24 votes225 views6 answers
Laravel create model
PHP
0 vote286 views1 answer
Call variable from inside a collection laravel
PHP Laravel