/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 vote209 views3 answers
Laravel except route
PHP Laravel
0 vote198 views2 answers
Laravel date format valdiate
PHP
15 votes198 views3 answers
Pass data to blade laravel
PHP Laravel
1 vote239 views1 answer
Xdebug won't step over in phpstorm
PHP
0 vote174 views1 answer
Associative array in php have same value join them
PHP
0 vote185 views1 answer
Call to a member function setcookie() on null laravel middleware
PHP
0 vote237 views1 answer
Check current user role
PHP
0 vote206 views1 answer
Polymorph laravel return order by
PHP Laravel
0 vote170 views1 answer
Php refresh_ttl
PHP
5 votes203 views3 answers
Home url wordpress
PHP Wordpress