public function getBase() { $db = new DbQuery(); $sql = $db->select()->from('Current_Coordinate')->where('Device_Id = 1 or Device_Id=3'); echo '<br>Select '; var_dump($sql->exec()); $sql = $db->select()->from('Organizations')->join('Organizations', 'Cities', 'City_Id'); echo '<br>Join '; var_dump($sql->exec()); echo '<br>Delete '; $sql_delete = $db->delete()->from('Cities')->where("Name_City = 'Альметьевск'"); var_dump($sql_delete->exec()); echo '<br>Insert '; $sql_insert = $db->insert('Cities', array('Name_City'), array('Бугульма')); var_dump($sql_insert->exec()); echo '<br>Update '; $sql_set = $db->update('Cities', "Name_City='Альметьевск'")->where("Name_City='Бугульма'"); var_dump($sql_set->exec()); echo '<br><br>'; echo "This model"; $db = new DbQuery('mssql'); $sql = $db->select()->from('NavMessages')->order('Id ASC'); echo '<br>Select '; var_dump($sql->exec()); echo "<br>Model memory : " . memory_get_usage() / 1000 . "<br>"; /**/ }
public function checkAuth() { $db = new Db(); $login = $this->session->getSesValue('login'); $pass = $this->session->getSesValue('password'); $sql = $db->select('*')->from('users')->where("login='******' AND password='******'")->exec(); if (count($sql) == 1) { //return true; } return true; }
public function checkAuth() { $db = new Db(); $login = $this->session->getSesValue('login'); $pass = $this->session->getSesValue('pass'); $sql = $db->select('*')->from('Authorization')->where("Login='******' AND Pass='******'"); $sql = $sql->exec(); if (count($sql) == 1) { return true; } return false; }
public function setAuth($login, $pass) { $config = new Config(); $this->cookie = new Cookie(); $table = $config->getVar('auth.table'); $table_log = $config->getVar('auth.login'); $table_pass = $config->getVar('auth.pass'); $db = new Db(); $sql = $db->select()->from($table)->where("{$table_log}='{$login}' and {$table_pass}='{$pass}'"); $sql = $sql->exec(); if (is_array($sql) && count($sql) == 1) { $this->cookie->setCookie('login', $login); $this->session->setSesValue('auth', 1); } else { $this->session->setSesValue('auth', 0); } }