Logo Luan Morina
   Select rows with the current day and month
YearEvent
1756 England decares war on France
1804 Napoleon became Emperor of France
1897 NY Giant William Joyce sets record of 4 triples in 1 game
1899 World Good-Will Day - 26 nations meet in 1st Hague Peace Conference
1910 Passage of Earth through tail of Halley's Comet causes near-panic
1917 US passes Selective Service act
1933 TVA Act signed by FDR
1951 UN moves HQ to NYC
1953 1st woman pilot faster than speed of sound (Jacqueline Cochran)
1969 Apollo 10 launched toward lunar orbit
1974 India becomes 6th nation to explode an atomic bomb
1980 Mt St Helens blows its top in Washington State
Bootstrap CSS and JS Files
<link href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css">
<script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
HTML and 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 mcm_demo_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();
?>
CSS
.demo-container {
  margin: 0 auto;
  max-width: 900px;
  padding: 2em;
}

.dataTables_paginate {
  margin-top: 1em;
  border: none;
}

.header-search-results {
  margin: 2em 0;
  padding: 0.5em;
  border: 1px solid #ECECEC;
}
	
.dataTables_filter {
   width: 50%;
   float: right;
   text-align: right;
}
	
ul.pagination {
  float: right !important;
  padding-top: 2em;
}
JS
<script>
$(document).ready(function() {
$("#table-demo").DataTable({
paging: true,
pageLength: 4,
ordering: true,
info: false,
lengthChange: false,
language: {
search: "_INPUT_",
searchPlaceholder: "Search"
},
search: {
addClass: 'form-control input-lg col-xs-12',
},
});
});
</script>
   Select table rows with the current day and month