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 vote335 views1 answer
Current pathinfo php
PHP
0 vote274 views1 answer
Remove invalid characters from a string laravel
PHP
0 vote364 views1 answer
Echo require php
PHP
1 vote323 views1 answer
Date format in laravel month name day name
PHP Laravel
3 votes326 views1 answer
Install all necessary php packages for laravel
PHP Laravel
1 vote350 views1 answer
Redirect image attachment pages in Wordpress
PHP Wordpress
0 vote277 views1 answer
General error: 1390 Prepared statement contains too many placeholders
PHP
2 votes265 views2 answers
Get php memory limit command line
PHP
0 vote317 views1 answer
Laravel Filesystem chmod(): Operation not permitted
PHP Laravel
0 vote272 views1 answer
Php draw line pixel
PHP