This is the source to add the beer temp to my MySQL database.
$conn = mysql_connect(“192.168.1.5″, “beerfridge”, “password”) or die(“It doesn’t connect!”);
mysql_select_db(“beerfridge”, $conn) or die(mysql_errno() . “: ” . mysql_error() . “”);
$lines = file(‘/home/restill/sensor/tslpy/tsl.1′);
foreach ($lines as $line_num => $line) {
$line = substr($line,0,5);
$sql=”INSERT INTO tTemps(fTemp) VALUES($line)”;
mysql_query($sql,$conn);
}
mysql_query($sql,$conn);