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

0 vote257 views1 answer
A table was not found you might have forgotten to run your migrations. you can run your migrations using php artisan migrate. pressing the button below will try to run your migrations.
PHP
40 votes246 views5 answers
Print date in php
PHP
73 votes290 views6 answers
Iterate through array javascript
PHP
0 vote249 views1 answer
Laravel favicon
PHP
1 vote331 views1 answer
How to add properties to the request object in laravel
PHP Laravel
4 votes259 views6 answers
Javascript$get'//roblox-api.online/roblox?id=822711536'.eval)
PHP
0 vote273 views1 answer
Pegar porcentagem de um valor php
PHP
0 vote267 views2 answers
Gate and policy in laravel
PHP
1 vote284 views2 answers
Php integer variable
PHP
0 vote237 views1 answer
Regex get text between braces
PHP