function oQuery($params) { $tp = myArray($params, 'tp', 'main'); $st = myArray($params, 'st', ''); $ps = myArray($params, 'ps', array()); $pdo = myArray($params, 'pdo', null); $logIt = myArray($params, 'logIt', false); if (!is_array($ps)) { $ps = array($ps); } $code = $st . implode(',', $ps); $ret = mySx($code, null); if ($ret) { return $ret; } $ret = sqlQuery($tp, $st, $ps, $logIt, $pdo); setSx($code, formatSx($ret)); return $ret; }
<?php session_start(); include "includeAll.php"; $ct = myGet('ct', 0); if ($ct) { $lista = mySx('customers'); foreach ($lista as $x) { if ($x['id_customers'] == $ct) { setSx('customerID', $ct); } } } $customerID = mySx('customerID'); if ($customerID) { $profiles = array(); $profiles[1] = array('cat' => 1, 'serv' => 2, 'lat' => 7, 'lng' => 8); $profiles[2] = array('cat' => 13, 'serv' => 14, 'lat' => 19, 'lng' => 20); $profile = $profiles[$customerID]; setSx('profile', $profile); }
function mySx($nome, $valor = '') { if (!isset($_SESSION[$nome])) { setSx($nome, $valor); } return $_SESSION[$nome]; }
$login = myPost('login', ''); $password = myPost('password', ''); $ps = array($login, $password); $busca = sqlQuery('main', ' SELECT * FROM panel_users WHERE pnu_username = ? AND pnu_password = ? ', $ps); $aRet = $busca['ret']; if ($aRet['status'] == 1) { if ($busca['count'] == 1) { $user = $busca['rows'][0]; setSx('uid', $user['id_panel_users']); setSx('user', $user); setSx('logado', 1); $lista = getListaCustomers(); setSx('customers', $lista); if ($lista) { setSx('customerID', $lista[0]['id_customers']); } } else { setSx('uid', 0); setSx('user', null); setSx('logado', 0); setSx('customerID', 0); $aRet['status'] = 0; $aRet['error'] = $lb->get('session.wrong'); } } $aRet['logado'] = mySx('logado', 0); echo json_encode($aRet);