PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table AllinOne ( ID int, DayTime datetime, Temperature double ); insert into AllinOne (DayTime, Temperature) values (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23), (now(), 26.23);
Copy Clear
Copy Format Clear
<?php $sql = ("SELECT ID, DayTime,Temperature FROM AllinOne ORDER BY ID DESC LIMIT 10"); $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { echo "id: " . $row["ID"]. " - DayTime: " . $row["DayTime"]. " - Temperature " . $row["Temperature"]. "<br>"; } } else { echo "0 results"; }
Show:  
Copy Clear