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 vote152 views1 answer
Image::make en php
PHP
0 vote151 views1 answer
Doiffernce between text and string in laravel migration
PHP
0 vote151 views1 answer
Send image in request body laravel 6
PHP
2 votes178 views3 answers
Codeigniter last insert id
PHP CodeIgniter
0 vote142 views2 answers
Sorting sql query array by column key php
PHP
0 vote158 views2 answers
Upload multiple images in php
PHP
6 votes169 views1 answer
Wordpres get_posttype
PHP
2 votes148 views2 answers
Php check if input is int
PHP
0 vote161 views1 answer
Laravel find model inside the same model
PHP
6 votes179 views1 answer
Join 2 tables laravel
PHP Laravel