/PHP/Php pdo check if record exists before insert

Php pdo check if record exists before insert

$sql = $dbh->prepare("SELECT COUNT(*) AS `total` FROM directory WHERE telephone = :phone");
$sql->execute(array(':phone' => $telephone));
$result = $sql->fetchObject();

if ($result->total > 0) 
{
    echo 'The telephone number: ' . $telephone. ' is already in the database<br />';
}
else 
{
      echo 'No rows matched the query.';
}

Source: stackoverflow.com

Php pdo check if record exists before insert

ALTER TABLE `requests` ADD UNIQUE `imdbid_unique`(`imdbid`);

Source: stackoverflow.com

Pdo insert or update if exists

REPLACE INTO ***** SET name = ?, slideView = ?, company = ?

Source: stackoverflow.com

Similar codes

1 vote256 views3 answers
Not equal in laravel blade
PHP
1 vote337 views1 answer
Htaccess replace url parameter with slash prameter
PHP
0 vote310 views1 answer
Régler l’enregistrement automatique dans WordPress
PHP
7 votes352 views6 answers
Wordpress get post id
PHP Wordpress
0 vote253 views1 answer
Php get user county
PHP
1 vote337 views1 answer
SaveAll get all id save cakephp
PHP CakePHP
0 vote246 views2 answers
Nested array in laravel
PHP
0 vote302 views1 answer
Php laravel intervention base64 to image save
PHP Laravel
14 votes313 views2 answers
Laravel change value to intger
PHP Laravel
12 votes240 views1 answer
Laravel model without timestamps
PHP