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
1356 English defeat French at Battle of Poitiers
1796 George Washington's farewell address as president
1812 Napoleon's retreat from Russia begins
1848 Bond (US) & Lassell (England) independently discover Hyperion
1849 1st commercial laundry established in Oakland California
1863 Battle of Chickamauga Tenn; Union forces retreat
1873 Black Friday: Jay Cooke & Co fails causing a securities panic
1881 Pres Garfield dies of gunshot wound
1966 Mike Burke named Yankees president
1968 Baby born on Golden Gate Bridge (those Marin County folk!)
1970 Mary Tyler Moore show premiers
1982 Streetcars stop running on Market St after 122 years of service
1983 St Christopher-Nevis gains independence from Britain (Nat'l Day)
1986 Captain EO permieres
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();
?>