PHP voltsToFarenheit Examples

Example #1

File: current.php Project: bstorz/code-samples

<?php

function voltsToFarenheit($volts)
{
    return ($volts - 0.5) * 100.0 * (9.0 / 5.0) + 32.0;
}
$con = mysql_connect("localhost", "root", "root");
$now = time();
if (!$con) {
    die('COULD NOT CONNECT: ' . mysql_error());
}
mysql_select_db("temp_mon", $con);
$result = mysql_query("SELECT * FROM temp ORDER BY timestamp DESC LIMIT 0,1");
$row = mysql_fetch_array($result);
echo "<span class='currentTemp'><span class='theTemp'>" . voltsToFarenheit($row['temp']) . "</span>&deg;F</span> on " . date("M d, Y \\a\\t h:i:s a", strtotime($row['timestamp']));

Example #2

File: json.php Project: bstorz/code-samples

//Mysql Connections
mysql_connect("localhost", "root", "root") or die('Could not Connect: ' . mysql_error());
mysql_select_db("temp_mon");
//Get and Process Results
$result = mysql_query("SELECT * FROM temp WHERE timestamp BETWEEN '" . $date1 . "' AND '" . $date2 . "'") or die(mysql_error());
$prev = false;
$prevTimestamp = time();
$totalVolts = 0;
$count = 0;
$data = array();
while ($row = mysql_fetch_array($result)) {
    $time = date("m-d-y H:i", strtotime($row['timestamp']));
    if ($time != $prev) {
        if ($prev != false) {
            //Throw outputted data into an array.
            array_push($data, array("y" => date("m-d-y @ h:i", $prevTimestamp), "a" => voltsToFarenheit($totalVolts / $count)));
        }
        $prev = $time;
        $prevTimestamp = strtotime($row['timestamp']);
        $totalVolts = $row['temp'];
        $count = 1;
    } else {
        $totalVolts += $row['temp'];
        $count++;
    }
}
//Throw outputted data into an array.
array_push($data, array("y" => date("m-d-y @ h:i", $prevTimestamp), "a" => voltsToFarenheit($totalVolts / $count)));
//echo count($data)."<br /><br />";
//JSON-itize it.
echo json_encode($data);