<?php
//make SOAP request to MS SharePoint to retrieve the latest menu data
//maybe use _soapCall
$client = new SoapClient("http://thevault/vti_bin/lists.asmx?WSDL");
$result = $client->GetListItems(array('listname' => "Today's Lunch"));
//assume the response will be an arry
$menuData = $result->GetListItemsResponse->GetListItemsResult;
//open canteen system database
$user_name = "root";
$password = "******";
$database = "canteenSystem";
$server = "127.0.0.1";
$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);
if ($db_found) {
print "Database Found";
//erase all menu entries from the menu table within the canteen system
$sql_truncate = "TRUNCATE TABLE canteenSystem";
mysql_query($sql_truncate, $db_handle);
//now we can try and access each menu data in the response array
foreach ($menu as $menuItem) {
$station = $menuItem['ows_LinkTitle'];
$item = $menuItem['ows_Item'];
$price = $menuItem['ows_Price'];
//now write stuff into database
//populate with the newest menu data (i.e. insert PARAMS into menu)
$sql_insert = "INSERT INTO menu (station,item,price,availability) VALUES('" . $station . "','" . $item . "','" . $price . "',true)";
mysql_query($sql_insert);
}
} else {