<?php
    define ('DB_User','root');
    define ('DB_Password','password');
    define ('DB_HOST','localhost');
    define ('DB_Name','events');

    $con = mysqli_connect(DB_HOST, DB_User, DB_Password, DB_Name);

    if(!$con){
          die('Error Connecting');
    }
    //Don't this need remove at the end of coding...
    echo "Connected successfully";

    $date = DATE('y-m-d', strtotime("now"));

    $sql = "SELECT date FROM Event_table WHERE date = date(now())";

    $Query = mysql_query($sql);

    $Row = mysql_fetch_array($Query, MYSQL_ASSOC);

    $Compare = $Row[0];
    if ($Compare == DATE('y-m-d', strtotime("now"))) {
    echo "Yes";
    }
    else {
        echo "No";
    }

    ?>

<?php

    # ...

    $date = (new Date())->format('Y-m-d');

    $sql = "SELECT * FROM Event_table WHERE date = '$date'";

    $Query = mysql_query($sql);

    $Row = mysql_fetch_array($Query, MYSQL_ASSOC);

    if (count($Row)) {
        echo "Yes";
    }
    else {
        echo "No";
    }

    ?>

<?php
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "event";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);

}
date_default_timezone_set("Europe/London");

$compare = date("Y-m-d");
/*echo $compare;*/
$sql = "SELECT date FROM event_table WHERE date = '$compare'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Date: " . $row["date"]. "<br>";
        echo '<img src="C:Apache24htdocsTeyingyes_logo.png alt="icon" />';
    }
} else {
    echo "0 results";
}
$conn->close();
?>