<?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 $_SERVER['argv'][0] is the name of this php file
$temperature = $_SERVER['argv'][1];
$humidity = $_SERVER['argv'][2];

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

// Insert values into the database
$query1 = "INSERT INTO ITHXData (Temperature, Humidity) VALUES ($temperature, $humidity)";
mssql_query($query1); // or die ('Temperature and Humidity update query failed.');

mssql_close($conn);
?>