temperaturegetlast.txt

《嵌入式Linux－硬件

#!/bin/bash
# temperatureGetLast v1.0 12/31/01
# www.embeddedlinuxinterfacing.com
#
# The original location of this code is
# http://www.embeddedlinuxinterfacing.com/chapters/12/
#
# Copyright (C) 2001 by Craig Hollabaugh
#
# This program is free software; you can redistribute it and/or modify
# it however you want.
#
# temperatureGetLast 
# temperatureGetLast is a CGI script. A field target board or web service
# sends an HTTP request with a Trailblazer location number 
# as a parameter. Apache calls this script setting the $QUERY_STRING 
# variable to the location number. This script forms a SELECT statement 
# that returns the last recorded temperature for that location. 
#
# Here's the header/content blank separation line required by Apache
echo

# Set the location
location=$QUERY_STRING


# Form the SELECT statement and pipe it to mysql.
# You have to login in to mysql as trailblazer with
# password tb because apache will execute this script as 
# user www-data not root.
echo "SELECT temperature from temperatures where location = $location \
      order by timestamp desc limit 0,1" | \
      mysql trailblazer --user=trailblazer --pass=tb --silent