Pdo check if row exists

Php pdo Check if row exists in the database

$stmt = $conn->prepare('SELECT * FROM table WHERE ID=?');
$stmt->bindParam(1, $_GET['id'], PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);

if( ! $row)
{
    echo 'nothing found';
}

/*
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC); // Same here
if( ! $rows)
{
    echo 'nothing found';
}
*/

Source: stackoverflow.com

Pdo php check if row exist

$sql = 'SELECT 1 from table WHERE id = ? LIMIT 1';
//$sql = 'SELECT COUNT(*) from table WHERE param = ?'; // for checking >1 records
$stmt = $conn->prepare($sql);
$stmt->bindParam(1, $_GET['id'], PDO::PARAM_INT);
$stmt->execute();

if($stmt->fetchColumn()) echo 'found';

Source: stackoverflow.com

Similar codes

-1 vote147 views1 answer
Php: foreach loop
PHP
0 vote142 views3 answers
Is_unique in codeigniter form validation
PHP
0 vote151 views1 answer
SET DEFAULT hide title astra wordpress
PHP Wordpress
0 vote163 views1 answer
Wordpress rename post format
PHP
11 votes146 views4 answers
Remove .php htaccess
PHP
19 votes134 views2 answers
Navigate json decode php
PHP
10 votes116 views3 answers
Shortcode wordpress plugin
PHP
0 vote155 views1 answer
Eager realationship in laravel
PHP
1 vote195 views3 answers
Laravel required if
PHP Laravel
0 vote179 views1 answer
Laravel datepicker date format
PHP Laravel