temperaturegettable.txt

《嵌入式Linux－硬件

#!/bin/bash
# temperatureGetTable 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.
#
# temperatureGetTable 
# temperatureGetTable is a CGI script. A 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 a temperature table 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 timestamp, temperature from temperatures where \
      location = $location order by timestamp asc;" | \
      mysql trailblazer --user=trailblazer --pass=tb --silent