function getLogin($login, $passw) { //check login/md5(user) App::db('sysuser')->query('SELECT CONCAT(primeiro_nome, " ", segundo_nome)NAME, id as ID FROM `erp_usuarios` WHERE email = :login AND senha = :passw AND ativo = 1', [':login' => $login, 'passw' => md5($passw)]); $res = App::db('sysuser')->result(); if ($res === false) { return false; } else { return $res[0]; } }
function getUserList() { App::db()->query('SELECT * FROM view_msg_from_users'); $rs = App::db()->result(); if ($rs === false) { return false; } $o = []; foreach ($rs as $col) { $o[$col->ID]['id'] = $col->ID; $o[$col->ID]['name'] = $col->NAME; $o[$col->ID]['last'] = $col->LAST; $o[$col->ID]['total'] = $col->TOTAL; $o[$col->ID]['type'] = $col->TYPE; } return $o; }
function getUserList() { App::db()->query('SELECT * FROM users'); $rs = App::db()->result(); if ($rs === false) { return false; } $o = []; foreach ($rs as $col) { $o[$col->ID]['id'] = $col->ID; $o[$col->ID]['name'] = $col->NAME; $o[$col->ID]['last'] = $col->LAST; } return $o; }
<?php use Model\App; use Model\Request; use Service\ConfigParams; include __DIR__ . '/../app/bootstrap.php'; $request = Request::createFromGlobals(); $configParams = new ConfigParams(APP_PATH, APP_URL_BASE, APP_INDEX, APP_TEMPLATE_PATH, APP_TITLE, APP_VERSION, APP_DATABASE_FILE); $app = new App($configParams); echo $app->run($request);