PHP Script uses custom CSS to generate HTML styled table to contain last nine database rows from the vehicle speed system.<\/p>\n
$servername = “xxxxxxx”;
\n$username = “xxx”;
\n$password = “xxxxx”;
\n$dbname = “xxxxx”;<\/p>\n
\/\/ Create connection
\n$conn = new mysqli($servername, $username, $password, $dbname);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}<\/p>\n
$sql = “SELECT * FROM traffic ORDER BY Time DESC LIMIT 9”;
\n$result = $conn->query($sql);<\/p>\n
if ($result->num_rows > 0) {
\necho “<table class=styled-table>”;
\necho “<thead><tr><th>Time<\/th><th>Speed<\/th><th>Direction<\/th><th>Count<\/th><th>SD<\/th><\/tr><\/thead>”;
\n\/\/ output data of each row
\necho “<tbody>”;
\nwhile($row = $result->fetch_assoc()) {<\/p>\n
$secvar = “”;
\n{$secvar = strtotime((trim($row[“Time”])));}
\n{$secvar2 = date(“H:i:s”, $secvar);}
\n$firstvar = “”;
\nif (trim($row[‘Direction’]) ==1)
\n{$firstvar = “Up”;}
\nif (trim($row[‘Direction’]) ==2)
\n{$firstvar = “Down”;}
\necho “<tr><td>”.$secvar2.”<\/td><td>”.$row[“Speed”].”<\/td><td>”.$firstvar.”<\/td><td>”.$row[“Count”].”<\/td><td>”.$row[“SD”].”<\/td><\/tr>”;
\n}
\necho “<\/tbody>”;
\necho “<\/table>”;
\n} else {
\necho “0 results”;
\n}
\n$conn->close();<\/p>\n","protected":false},"excerpt":{"rendered":"
PHP Script uses custom CSS to generate HTML styled table to contain last nine database rows from the vehicle speed system. Converts MySQL DateTime entry YYYY\/MM\/DD H:i:s:xxx to h:i:s Converts Direction Integer to Text 1 = Up, 2=Down $servername = “xxxxxxx”; $username = “xxx”; $password = “xxxxx”; $dbname = “xxxxx”; \/\/ Create connection $conn = … Continue reading “PHP To Extract Latest Data From MySQL”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,16],"tags":[],"class_list":["post-216","post","type-post","status-publish","format-standard","hentry","category-raspberry-pi","category-raspberry-pi-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/posts\/216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=216"}],"version-history":[{"count":2,"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/posts\/216\/revisions"}],"predecessor-version":[{"id":220,"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/posts\/216\/revisions\/220"}],"wp:attachment":[{"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thedrift.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}