Example #1
0
function get_currencies($handle = null)
{
    if (empty($handle)) {
        $handle = DbConnect();
    }
    $instance_table = new Table();
    $QUERY = "SELECT id,currency,name,value from cc_currencies order by id";
    $result = $instance_table->SQLExec($handle, $QUERY);
    /*
    	$currencies_list['ADF'][1]="Andorran Franc";
    	$currencies_list['ADF'][2]="0.1339";
    	[ADF] => Array ( [1] => Andorran Franc (ADF), [2] => 0.1339 )
    */
    if (is_array($result)) {
        $num_cur = count($result);
        for ($i = 0; $i < $num_cur; $i++) {
            $currencies_list[$result[$i][1]] = array(1 => $result[$i][2], 2 => $result[$i][3]);
        }
    }
    if (isset($currencies_list) && is_array($currencies_list)) {
        sort_currencies_list($currencies_list);
    }
    return $currencies_list;
}
Example #2
0
function get_currencies($handle = null)
{
    if (empty($handle)) {
        $handle = DbConnect();
    }
    $instance_table = new Table();
    $QUERY = "SELECT id, currency, name, value FROM cc_currencies ORDER BY id";
    $result = $instance_table->SQLExec($handle, $QUERY, 1, 300);
    if (is_array($result)) {
        $num_cur = count($result);
        for ($i = 0; $i < $num_cur; $i++) {
            $currencies_list[$result[$i][1]] = array(1 => $result[$i][2], 2 => $result[$i][3]);
        }
    }
    if (isset($currencies_list) && is_array($currencies_list)) {
        sort_currencies_list($currencies_list);
    }
    return $currencies_list;
}