Crowdsourced Data

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM naturetrackapp ORDER BY timstmp DESC"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = $result->fetch_assoc()) { //generating table in php //echo $row["col1"]." ". $row["col2"]. " " . $row["col3"]. "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo""; //changing the account details $string=$row["acc"]; $pieces = explode("@", $string); // $pieces[0]=str_replace("."," ",$pieces[0]); // $pieces[0]=str_replace("_"," ",$pieces[0]); echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
"."Id".""."Time".""."Latitude".""."Longitude".""."Water Level".""."Flow Rate".""."Trash".""."Color".""."Comments".""."Photo".""."Submitter".""."Upvote".""."Downvote".""."verified"."
".$row["id"]."".$row["timstmp"]."".$row["latitude"]."".$row["longitude"]."".$row["species"]."".$row["genus"]."".$row["family"]."".$row["ord"]."".$row["location"]."".$row["store"]."photo".clean($pieces[0])."".$row["uvote"]."".$row["dvote"]."".$row["verify"]."
"; } $conn->close(); ?>