Year | Event |
---|---|
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 |
<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>
$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();
?>
.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;
}
<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>