<?php
// YOUR MSSQL 8.0 SERVER PARAMETERS
$hostname = '10.1.1.1';
$username = 'myuser';
$password = 'mypasswd';
$dbname = 'mydatabase';
 
// CONNECT TO MSSQL 8.0 DATABASE
$conn = mssql_connect($hostname,$username,$password) or die ('Could not connect');
mssql_select_db($dbname) or die ('Could not select database.');

// Get TEMPERATURE and HUMIDITY values from shell script
// Note argv[0] is the name of this php file
$_SERVER['argv'][0..n];
$temperature = $argv[1];
$humidity = $argv[2];

// Convert values to float
$temperature = floatval($temperature);
$humidity = floatval($humidity);

// Insert values into the database
// I'm allowing database to mark date/time of entry automatically
$query1 = "INSERT INTO tbl_ithxm (Temperature, Humidity) VALUES ($temperature, $humidity)";
mssql_query($query1) or die ('Temperature and Humidity update query failed.');

mssql_close($conn);
?>