public function add_answer_action($params) { $a = arr::extract($params, ['question_id', 'content', 'type']); db::exec($this->db, "INSERT INTO i_answers (question_id, content, type) VALUES(:question_id, :content, :type)", [':question_id' => $a['question_id'], ':content' => $a['content'], ':type' => $a['type']]); $curr_a = db::last_id($this->db); $this->view->render('json', $curr_a); }
public function get_interviews_list_action($params) { $i_meta = db::exec($this->db, "SELECT m.*, DATE(m.date) as date_only, COUNT(i.id) as ans_cnt FROM i_interview_meta m RIGHT JOIN i_interview i ON m.id = i.meta_id GROUP BY i.meta_id", null); $q = db::exec($this->db, "SELECT * FROM i_questions", null); $i = arr::array_to_hash_id(db::exec($this->db, "SELECT * FROM i_interview", null)); $u = arr::array_to_hash_id(db::exec($this->db, "SELECT * FROM i_users", null)); $this->view->render('json', ['interviews_list' => $i_meta, 'interview_logs' => $i, 'users' => $u, 'questions' => $q]); }
public function signOut($userId, $hash) { $sql = 'delete from `users_sessions` where `user_id` = ? and `hash` = ? limit 1'; db::exec($sql, [$userId, $hash]); $this->model('session')->remove('userId'); $this->model('session')->remove('userSessionHash'); setcookie($this->model('session')->getName(), '', time() - 42000); session_destroy(); header('Location: /'); exit; }
public function checkExistingSheetEntity($searchCriteria, $findBy = 0, $entity = null) { $sql = 'select pge.entity_id, pge.uid, pge.info, pge.e_type from packed_general_entities pge where pge.' . (!$findBy ? 'uid' : 'entity_id') . ' = ?'; $args = [$searchCriteria]; if ($entity) { array_push($args, $entity); $sql .= ' and pge.e_type = ?'; } return db::exec($sql . ' limit 1', $args); }
public function getInitialInfoByEmail($email) { $sql = "select `id`, `password`, `salt`, `is_active`, `is_confirmed`, `entity_id`, concat(`first_name`, ' ', `surname`) as initials from `users` where `email` = ? limit 1"; return db::exec($sql, $email); }
define('DB_PORTRO', ''); //留空 define('DB_TYPE', 'sqlite'); define('DB_PATH', 'db3.db'); define('DB_A', ''); $DB = new db(); //判断数据库文件是否存在 if (!file_exists("db3.db")) { $sql = ' CREATE TABLE "opera"( [id] integer PRIMARY KEY AUTOINCREMENT ,[cishu] text ,[daxiao] text ); '; $DB->exec($sql); $DB->insert('opera', array('cishu' => '0', 'daxiao' => '0')); } if ($_SERVER['REQUEST_METHOD'] == 'GET') { if (function_exists("curl_init")) { $row = $DB->select('*', 'opera')->fetchALL(); $row = $row['0']; $cs = $row['cishu']; $dx = sizecount($row['daxiao']); $ym = $_SERVER['SERVER_NAME'] . $_SERVER["PHP_SELF"]; $text = ' <!DOCTYPE HTML> <html> <body> <h1>Opera Mini Mirror Server</h1> <p>欢迎使用Opera Mini的镜像服务器,您只需要有一个支持变更服务器的Opera Mini就可以使用本程序!</p>
public function checkExistingEmail($email) { return db::exec('select id from users where email = :email limit 1', [':email' => $email]); }
} else { echo '<div class="error">', $error, '</div>'; } unset($bd); if ($instalacion) { /// actualizamos los modulos sys y admin require_once 'admin/modulo.php'; $nuevo_modulo = new modulo_(); $nuevo_modulo->actualizar(); $bd = new db(); if ($bd->conectar()) { /// insertamon el usuario admin $password = sha1('admin'); $consulta = "INSERT INTO fs_usuarios (usuario,pass) VALUES ('admin','{$password}');"; $consulta .= "INSERT INTO fs_ack (usuario,modulo) VALUES ('admin','admin');"; if ($bd->exec($consulta)) { echo "<div class='mensaje'>Usuario creado correctamente</div>"; } else { echo "<div class='error'>Error al crear el usuario admin</div>"; } echo "<br/><br/>\n <div class='centrado'>\n <h1>¡ facturaScripts instalado satisfactoriamente !</h1> Ya puedes comenzar a usarlo.<br/>\n No te olvides de instalar los módulos y actualizar la base de datos.<br/><br/>\n <b>Usuario:</b> admin<br/><b>Contraseña:</b> admin<br/>\n <br/><a href='index.php'>Entrar</a>"; } else { echo "<div class='error'>Error al conectar a la base de datos</div>"; } echo "</div>"; } else { echo "<br/><br/>\n", "<div class='centrado'><a href='index.php'>Entrar</a></div>"; } echo "</div>\n"; } else { echo "<div class='copyright'>Error al conectar a la base de datos</div>\n";
public function removeLike($entityId, $entityUserId) { $sql = 'delete from likes where `entity_id` = ? and `entity_id_user` = ? limit 1'; return db::exec($sql, [$entityId, $entityUserId]); }
public function get_users_list_action($params) { $result = db::exec($this->db, "SELECT id, name, role FROM i_users", null); $this->view->render('json', $result); }
public function checkFriendship($uId1, $uId2) { $sql = 'select exists(select entity_user_id1 from friends where (entity_user_id1 = :u1 and entity_user_id2 = :u2) or (entity_user_id1 = :u2 and entity_user_id2 = :u1) limit 1) as fExists'; return (bool) array_filter(db::exec($sql, [':u1' => $uId1, ':u2' => $uId2])); }