getRow($get_clients);
return $results;
}
public function get_contacts($id)
{
global $database;
$sql = "
SELECT *
FROM $db_name"."contacts
WHERE location_id = '$id'
LIMIT 1
";
$results = $database->getAll($sql);
return $results;
}
public function get_locations()
{
global $database;
$sql = "
SELECT id, CONCAT(address,', ', suburb,', ', state,', ', post_code) AS name
FROM clients_locations
";
$results = $database->getAll($sql);
$final_results = array();
foreach($results AS $result)
$final_results[$result['id']] = $result;
return $final_results;
return $results;
}
public function get_all_locations($client_id)
{
global $database;
$sql = "
SELECT id, CONCAT(address,' ', suburb,' ', state,' ', post_code) AS name
FROM clients_locations
WHERE client_id = '$client_id'
";
$results = $database->getAll($sql);
$final_results = array();
foreach($results AS $result)
$final_results[$result['id']] = $result;
return $final_results;
return $results;
}
public function get_location($location_id)
{
global $database;
$sql = "
SELECT CONCAT(address,' ', suburb,' ', state,' ', post_code) AS address
FROM clients_locations
WHERE id = '$location_id'
";
$result = $database->getOne($sql);
return $result;
}
}
?>