Count number of cells in db using PDO?

Question

PHP

Good afternoon!
There is a table:

$_GET contains data that corresponds to the number in the "user_id" column.
The query structure starts like this:

if(!empty($_GET)) {

    $id = intval($_GET['id']);
    
    //здесь должен быть запрос PDO в БД
}

How to form a query that will return the number (number) of records where user_id corresponds to $id?
Thank you.

Answer 1

$st = $pdo->prepare('SELECT COUNT(user_id) as cnt FROM `article` WHERE user_id=:user_id');
$st->bindParam(':user_id', $id, PDO::PARAM_INT);
$art_column = $st->fetch();
$st->execute();
$data = $st->fetch();
echo $data['cnt']; // выводим количество

Answer 2

SELECT count(user_id) FROM tablitsa WHERE user_id = '$id'