<?php

                      /* database connection information */
            $servername = "localhost";
            $username = "root";
            $password = "";
            $database = "sensores";



            /* error messages */
            $messErr_connectionDatabaseFailed = "Error : connection failed. Please try later.";

            $link = new mysqli($servername, $username, $password, $database);

            /* If connection failed */
            if (!$link) {
                printf($messErr_connectionDatabaseFailed);
                printf("<br />");
            }
            /* If connection successed */
            else {
                $query = "SELECT id,tipoID_fk, id_arduino_fk, valores FROM sensor";
                //echo $query;

                $results = $link->query($query);
				//echo $result->num_rows;
                if ($result->num_rows > 0)
                {
                    while($row = $result->fetch_assoc())
                    {
                        echo "id: " . $row["id"]. " - Tipo: " . $row["tipoID_fk"]. "-id arduino: " . $row["valores"]. "<br>";
                    }
                }
                else
                {
                    echo "0 results";
                }
			}
		?>