PHP openqrm_db_get_result Examples

Example #1

File: dummyuser.class.php Project: kelubo/OpenQRM

    function get_users()
    {
        $query = '
			SELECT
				user_name,
				user_id,
				user_first_name,
				user_last_name,
				role_name
			FROM ' . $this->_user_table . ', ' . $this->_role_table . '
			WHERE user_role = role_id
			ORDER BY user_name
		';
        $ar_db = openqrm_db_get_result($query);
        $ar_headline = array();
        $ar_headline[] = array('Login', 'ID', 'First Name', 'Last Name', 'Role');
        $result = array_merge($ar_headline, $ar_db);
        return $result;
    }

Example #2

File: openqrm-database-functions.php Project: kelubo/OpenQRM

function openqrm_db_get_result_double($query)
{
    $ar_Return = array();
    $result = openqrm_db_get_result($query);
    foreach ($result as $res) {
        $ar_Return[] = array("value" => $res[0]["value"], "label" => $res[1]["value"]);
    }
    return $ar_Return;
}