[Firebug-cvs] firebug/web db_table_select.php,NONE,1.1 db_select.php,1.5,1.6 spie.bib,1.7,1.8 spie_2

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/firebug/firebug/web
In directory sc8-pr-cvs1:/tmp/cvs-serv30827

Modified Files:
	db_select.php spie.bib spie_2004.tex 
Added Files:
	db_table_select.php 
Removed Files:
	table_select.php 
Log Message:
Small cleanups, added a reference for the sht11 
temperature and humidity sensor.

--- NEW FILE: db_table_select.php ---
<?php>
session_start();
session_register("dbname");
session_register("tblname");
?>

<html>
<head>
    <title>FireBug Client</title>
    <META HTTP-EQUIV="Refresh" 
          CONTENT="30;URL=http://localhost/firebug/db_table_select.php">
    <link rel="SHORTCUT ICON" href="./images/favicon.ico">
    <link type="text/css" rel="stylesheet" href="firebug.css">
</head>

<body>

<?php
include("nav_footer.php");
?>

<hr />

<p>
Sensor data last updated:
<?php
echo date ("l dS F Y h:i:s A");
?>
</p>

<?php
//if (!isset($HTTP_SESSION_VARS["tblname"])) {
if ($HTTP_POST_VARS["tbl1"]!=Null){
$HTTP_SESSION_VARS["tblname"] = $HTTP_POST_VARS["tbl1"];
$HTTP_SESSION_VARS["dbname"] = $HTTP_POST_VARS["db1"];	
}

$dbname = $HTTP_SESSION_VARS["dbname"];
$tblname = $HTTP_SESSION_VARS["tblname"];

print("<h1>Mote activity: Database $dbname, table $tblname</h1>");
?>

<center>

<?php
mysql_connect("localhost","root","") or die("Error: ".mysql_error()." in mysql_connect.");

mysql_select_db("$dbname") or die("Error: ".mysql_error()." in mysql_select_db.");

if ($mote_id == "") {
   $mote_id = "%";
}

if ($time == "") {
   $time = "%";
}

if ($cnt == "") {
   $cnt = "%";
}

if ($temp == "") {
   $temp = "%";
}

if ($rel_hum == "") {
   $rel_hum = "%";
}

if ($baro_pres == "") {
   $baro_pres = "%";
}

if ($rss == "") {
   $rss = "%";
}

$result = mysql_query("select * from $tblname
                       where mote_id like '$mote_id%'
                       and time like      '$time%'
                       and cnt like       '$cnt%'
                       and rss like       '$rss%'
                       and temp like      '$temp%'
                       and rel_hum like      '$rel_hum%'
                       and baro_pres like      '$baro_pres%'")
          or die("Error: ".mysql_error()." in query.");

if ($row = mysql_fetch_array($result)) {

   do { 

     print ("<tr>");

      print ("<td>");
      print $row["mote_id"];
      print ("</td>");

      print ("<td>");
      print $row["time"];
      print ("</td>");

      print ("<td>");
      print $row["temp"];
      print ("</td>");

      print ("<td>");
      print $row["rel_hum"];
      print ("</td>");

      print ("<td>");
      print $row["baro_pres"];
      print ("</td>");

      print ("<td>");
      print $row["cnt"];
      print ("</td>");

      print ("<td>");
      print $row["rss"];
      print ("</td>");

      print ("</tr>");
   } while ($row = mysql_fetch_array($result));
}

?>

</table>
</center>

<hr />

<?php
include("nav_footer.php");
?>

<hr />

<p>
Sensor data last updated:
<?php
echo date ("l dS F Y h:i:s A");
?>
</p>

</body>
</html>

Index: db_select.php
===================================================================
RCS file: /cvsroot/firebug/firebug/web/db_select.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** db_select.php	30 Jul 2003 22:04:03 -0000	1.5
--- db_select.php	4 Aug 2003 16:17:29 -0000	1.6
***************
*** 19,23 ****

! <form action="table_select.php" method="post">

  <?php
--- 19,23 ----

! <form action="db_table_select.php" method="post">

  <?php

Index: spie.bib
===================================================================
RCS file: /cvsroot/firebug/firebug/web/spie.bib,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** spie.bib	21 Jul 2003 23:39:50 -0000	1.7
--- spie.bib	4 Aug 2003 16:17:29 -0000	1.8
***************
*** 1,2 ****
--- 1,5 ----
+ 
+ 
+ 
  @misc{hill:j2000,
    author = "Jason Hill",
***************
*** 7,14 ****
  }

  @inproceedings{bulusu:n2001,
    author = {Nirupama Bulusu and Vladimir Bychkovskiy and 
  Deborah Estrin and John Heidemann},
!   title = {GPS-less Low Cost Outdoor Localization For Very
  Small Devices},
    booktitle = {21st International Conference on Distribued
--- 10,19 ----
  }

+ 
+ 
  @inproceedings{bulusu:n2001,
    author = {Nirupama Bulusu and Vladimir Bychkovskiy and 
  Deborah Estrin and John Heidemann},
!   title = {{GPS}-less Low Cost Outdoor Localization For Very
  Small Devices},
    booktitle = {21st International Conference on Distribued
***************
*** 20,23 ****
--- 25,29 ----

+ 
  @inproceedings{bulusu:n2002,
    author = {Nirupama Bulusu and Vladimir Bychkovskiy and 
***************
*** 31,34 ****
--- 37,41 ----
    url = {http://www.cs.ucla.edu/~bulusu/papers/Bulusu02a.html}
  }
+ 

***************
*** 49,52 ****
--- 56,61 ----
  }

+ 
+ 
  @inproceedings{mainwaring:a2002,
    author = "Alan Mainwaring and Joseph Polastre and 
***************
*** 62,65 ****
--- 71,76 ----
  }

+ 
+ 
  @InProceedings{mehta:v2002,
    author = 	 {V. Mehta and M. {El Zarki}},
***************
*** 83,86 ****
--- 94,98 ----

+ 
  @inproceedings{ramadurai:v2003,
    author =       {V.~Ramadurai and M.~L.~Sichitiu},
***************
*** 94,97 ****
--- 106,124 ----
  }

+ 
+ 
+ @Manual{sensirion:sht11:2003,
+   title = 	 {{R}elative {H}umidity {S}ensor {SHT}11},
+   OPTkey = 	 {},
+   author = 	 {{Sensirion {AG}}},
+   OPTorganization = {},
+   address = 	 {Sensirion AG, Eggbuehlstrasse 14, CH-8052 Zurich, Switzerland},
+   OPTedition = 	 {},
+   OPTmonth = 	 {},
+   year = 	 {2003},
+   OPTnote = 	 {},
+   OPTannote = 	 {},
+   url =          {http://www.sensirion.com/en/sensors/humidity/sensors_devices/sensorSHT11.htm}
+ }

  @inproceedings{sichitiu:ml2003,

Index: spie_2004.tex
===================================================================
RCS file: /cvsroot/firebug/firebug/web/spie_2004.tex,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** spie_2004.tex	27 Jul 2003 00:46:59 -0000	1.10
--- spie_2004.tex	4 Aug 2003 16:17:29 -0000	1.11
***************
*** 4,7 ****
--- 4,8 ----
  \usepackage{graphicx}
  \usepackage{chicago}
+ \usepackage{url}

  \setlength{\oddsidemargin}{0in}
***************
*** 43,47 ****
  surrounding the structure, which may also be monitored
  by networked sensors.  Convenience dictates that 
! any such surrounding network be wireless and self-organizing.

--- 44,49 ----
  surrounding the structure, which may also be monitored
  by networked sensors.  Convenience dictates that 
! any such surrounding network be wireless and self-organizing,
! and that the sensors be very small.

***************
*** 103,107 ****

! \paragraph{Ganesan et al.}~\cite{ganesan:d2002} 
  have done the first large scale study 
  for sensor networks to explore the behavior of such a 
--- 105,109 ----

! \paragraph{Ganesan et al.}~\shortcite{ganesan:d2002} 
  have done the first large scale study 
  for sensor networks to explore the behavior of such a 
***************
*** 484,487 ****
--- 486,491 ----
  and what the bit work should be.

+ 
+ Test for temperature sensor reference~\cite{sensirion:sht11:2003}.

  \bibliography{spie}

--- table_select.php DELETED ---

[Firebug-cvs] firebug/web db_table_select.php,NONE,1.1 db_select.php,1.5,1.6 spie.bib,1.7,1.8 spie_2

[Firebug-cvs] firebug/web db_table_select.php,NONE,1.1 db_select.php,1.5,1.6 spie.bib,1.7,1.8 spie_2004.tex,1.10,1.11 table_select.php,1.9,NONE