Sensor Workshop at ITP | Class / PHP Dataviewer

Back to Thermistor and Solar Cell by John Schimmel

<?php

include "dbconnect.php";

//if someone requests // log.php?flip=1 then show the data flipped by the dateTime field if ($_GET['flip'] == "1") {

    $results = mysql_query("SELECT * FROM sensors ORDER BY dateTime desc");

} else {

    //query the database
    $results = mysql_query("SELECT * FROM sensors");

} ?>

<html>

a {

    text-decoration:none;

} a.info{

    position:relative; /*this is the key*/
    z-index:24;
    text-decoration:none}

a.info:hover{z-index:25; background-color:#f00} a.info span{display: none}

a.info:hover span { font-size:17px;

    display:block;
    position:absolute;
    top:2em; left:2em; width:15em;
    border:2px solid #000;
    background-color:#FFF;// color:#000;
    text-align: center;

}

li {

    list-style-type:none;

z-index:3; font-size:20%; }

li.thermistor a.info{

    color:blue;

}

li.solar a.info{

    color:red;

}

li.thermistor a.info:hover {

    font-weight:bold;

} li.solar a.info:hover {

    font-weight:bold;

}

hr.hourly {

    border: none;
    color: #000;
    height: 1px;
    width: 100%

}

</style> </head> <body> below is a active sensor log. One thermistor and one solar cell are in my apartment detecting the amount of heat and the amount of light. thermistor data solar cell data <?

//build link for viewing flipped data // if the query string is flip = 1 then do not include flip in link // else include ?flip=1 if ($_GET['flip'] !="1") {

    $flip = "?flip=1";

} ?> <a href="log.php<?= $flip; ?>">Flip Data</a>

<? echo "Number of records: " . mysql_num_rows($results) . " ";

//loop through the records that were returned from the query you made above while ($row = mysql_fetch_assoc($results)) {

    $currentDay = date("d", strtotime($row['dateTime'])); //get the current day
    $currentHour = date("H",strtotime($row['dateTime'])); //get the current hour

    //place title for new days.
    if ($prevDay != $currentDay) {
        echo "<br><br>" . date("M d, Y", strtotime($row['dateTime'])) . "<br><br>";;
    }

    //place a horizontal line for new hours
    if ($prevHour != $currentHour) {
        echo "<hr class='hourly'>";
    }


    //display the data
    $count=0;
    echo "<li class='thermistor'><a href='#' class='info'>";

    //print a line of  '.' the length of the thermistor value
    while($count<$row['temp']) {
        echo ".";
        $count++;
    }
    //span will include the mouse over information
    echo "<span>" . date("M d,Y H:i:s", strtotime($row['dateTime'])) . "<br> thermistor=". $row['temp'] . "<br>solar=" . $row['solar'] . "</span>";
    echo "</a></li>";


    $count = 0; //reset count for the solar data
    echo "<li class='solar'><a href='#' class='info'>";

      //print a line of  '.' the length of the thermistor value
        while($count<$row['solar']) {
        echo ".";
        $count++;
    }

    //span will include the mouse over information
    echo "<span>" . date("M d,Y H:i:s", strtotime($row['dateTime'])) . "<br> thermistor=". $row['temp'] . "<br>solar=" . $row['solar'] . "</span>";
    echo "</a></li>";

    $prevDay = $currentDay; //save currentday as prevday
    $prevHour = $currentHour; //save current hour as prevhour

} //end of while loop

?> </body> </html>

CLASS DOCUMENTS

REPORTS & ASSIGNMENTS

CLASS CONTENT

USING THIS SITE

PHP Dataviewer