php - Simple mysql Query to check if row exist

Question

I want to show user if he liked a image or not.. for that I am creating php code

$userid=$_COOKIE['userid'];
$sql = "SELECT * FROM likes WHERE `user_id`='{$userid}'"; 
$query = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($query);
if($row){
echo "unlike";
}
else{
echo "like";
}

I can not do this for everything like 'tags', 'shares', 'comments', 'favourites' ...many Isn't there anything simpler than this...? Like say $row_check=mysqli_check_exist($table,$column_name,$userid);

Answer 1

use mysql fetch row method

$num_row = mysqli_num_rows($query);

if($num_row>0)
{
//add your code
} 
else
{
//add your code
}