<?php
class lifecalc
{
var $db_host = 'localhost';
var $db_name = 'flashhub_lifecalc';
var $db_user = 'flashhub_lifecalc';
var $db_pwd = 'insurance';

function lifecalc ()

{
// Define the methodTable for this class in the constructor

$this->methodTable = array(
"getClients" => array(
"description" => "Return a list of clients",
"access" => "remote"
)
);
}
function getClients () {
$mysql = mysql_connect($this->db_host, $this->db_user, $this->db_pwd);
mysql_select_db( $this->db_name);
$Query = "SELECT ID,Surname,Firstname,DOB from clients";
$Result = mysql_query( $Query );
while ($row = mysql_fetch_object($Result)) {
$ArrayOfClients[] = $row;
}
return( $ArrayOfClients );
}

function getClient($which_id)
{
  $mysql = mysql_connect(localhost, "flashhub_lifecalc", "insurance");
  mysql_select_db( "flashhub_lifecalc" );
  return mysql_query("select * FROM clients where ID='$which_id'");
}

function updateClient($data) {
$mysql = mysql_connect(localhost, "flashhub_lifecalc", "insurance");
$fld = $data['field'];
mysql_select_db( "flashhub_lifecalc" );
$Query = "UPDATE clients set $fld='".$data['data']."' where ID='".$data['id']."'";
$Result = mysql_query( $Query );
return ($data['data']);
}

}
?>