Чтобы распечатать результат запроса счетчика в PHP, вы можете использовать следующие методы:

Метод 1: использование расширения mysqli:

<?php
// Assuming you have already established a database connection
$query = "SELECT COUNT(*) AS count FROM your_table";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$count = $row['count'];
echo "Count: " . $count;
?>

Метод 2: использование PDO (объекты данных PHP):

<?php
// Assuming you have already established a database connection using PDO
$query = "SELECT COUNT(*) AS count FROM your_table";
$result = $pdo->query($query);
$count = $result->fetchColumn();
echo "Count: " . $count;
?>

Метод 3. Использование объектно-ориентированного mysqli:

<?php
// Assuming you have already established a database connection using mysqli
$query = "SELECT COUNT(*) AS count FROM your_table";
$result = $connection->query($query);
$row = $result->fetch_object();
$count = $row->count;
echo "Count: " . $count;
?>

Метод 4. Использование процедурного mysqli:

<?php
// Assuming you have already established a database connection using mysqli
$query = "SELECT COUNT(*) AS count FROM your_table";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$count = $row['count'];
echo "Count: " . $count;
?>