PHP Knowledge Base

$sql__count = "SELECT count(*) from $whichTable";
$stmt__count = $conn->query($sql__count);
$row__count = $stmt__count->fetchColumn();

if ( $row__count > 0 ) {
	// some 'green light' code
} else {
	// some 'red light' code
}

$sql__tag_ID = "SELECT COUNT(*) FROM $whichTable where text__eng LIKE '%$db__tag_id%'";

$stmt__tag_ID = $conn->query($sql__tag_ID);
$count__tag_ID = $stmt__tag_ID->fetchColumn();

$select = $db->prepare('SELECT username FROM users WHERE id = ?');
$select->execute([$id]);

if ($select->rowCount() > 0) {
    //Row has been found
    //Do ......
} else {
    //No row found
    //Do....
}