MySQL

Select rows for the current day and month

What does this script do?

This PHP script connects to a MySQL database and retrieves historical events that occurred on today's date (same day and month) from a table called today_in_history.

Demo
YearEvent
1620 Great Patent granted to Plymouth Colony
1903 Columbia grants Panama independence
1917 1st Class Mail now costs 3›
1918 Poland proclaims independence from Russia after WW I
1930 Bank of Italy becomes Bank of America
1930 Detroit-Windsor tunnel opens-1st vehicular tunnel to foreign country
1952 Clarence Birdseye markets frozen peas
1953 1st live color coast-to-coast telecast (NYC)
1955 1st virus crystallized (announced)
1956 Wizard of Oz 1st televised
1957 USSR launches Laika 1st animal in orbit
1973 Mariner 10 launched-1st Venus pics 1st mission to Mercury
1978 UK grants Dominica independence (Natl Day)
1979 63 Americans taken hostage at American Embassy (Teheran Iran)
1986 Lebanese magazine Ash Shirra reveals secret US arms sales to Iran
MySQL Query
SELECT * FROM today_in_history WHERE DAY(mcm_date)=DAY(NOW()) AND MONTH(mcm_date)=MONTH(NOW()) LIMIT 0, 60
PHP
$conn = new mysqli ("server", "user", "password", "database");
mysqli_set_charset ($conn, "utf8");

if ($conn -> connect_error) {
die ("Error: " . $conn->connect_error);
} 

$sql = "SELECT * FROM today_in_history WHERE DAY(mcm_date)=DAY(NOW()) AND MONTH(mcm_date)=MONTH(NOW()) LIMIT 0, 60";
$result = $conn -> query($sql);

echo "<table id='demoTable' class='table table-striped'>";
echo "<thead>";
echo "<tr>";
echo "<th>Year</th>";
echo "<th>Event</th>";
echo "</tr>";
echo "</thead>";
echo "<tbody>"; 

while ($row = $result -> fetch_assoc()) { 

$var_year = date_create($row["mcm_date"]);

echo "<tr>";
echo '<td>' . date_format($var_year, 'Y') . '</td>' . "\n";
echo "<td>" . $row["mcm_event"] . "</td>";
echo "</tr>";
}

echo "</tbody>";
echo "</table>";
$conn -> close();
?>