Esempio n. 1
0
<?php

require_once "../private/lib/utilities.php";
function print_array($array)
{
    echo "<pre>";
    print_r($array);
    echo "</pre><br><br>";
}
?>
<p style="font-weight: bold;">Get all employers... </p><p><?php 
$employers = Employer::get_all();
echo "There are " . count($employers) . " employers in the database.<br><br>";
?>
</p><p style="font-weight: bold;">Get all employers by limit... </p><p><?php 
$employers = Employer::get_all_with_limit(3, 6);
echo "There are " . count($employers) . " employers queried.<br><br>";
?>
</p><p style="font-weight: bold;">Find an employer... </p><p><?php 
$criteria = array('columns' => 'employers.name, countries.country, currencies.symbol, 
                  employers.contact_person, employers.email_addr', 'match' => 'id = \'quad567\'', 'joins' => 'countries ON countries.country_code = employers.country, 
                currencies ON currencies.country_code = countries.country_code');
$employers = Employer::find($criteria);
print_array($employers);
?>
</p><p style="font-weight: bold;">Add an employer... </p><p><?php 
$employer_id = 'ken123';
$data = array();
$data['password'] = md5('new_password');
$data['license_num'] = 'my license';
$data['name'] = 'Fatt Choy Shopping Center';