#*未确定* ###**查询** * * * * * ~~~ /** * @example * SELECT `user_id` FROM `user_bind_mobile` WHERE `user_mobile` = :prepare1; * :prepare string $username * */ $id = $this->init()->table('user_bind_mobile') ->field('user_id') ->where('user_mobile',[':username',$username,\PDO::PARAM_STR]) ->getColumn(); ~~~ ~~~ $this->init()->table('user')->field('user_name')->value($username)->exists(); ~~~ ~~~ /** * @example * SELECT `module_name`,`module_info`,`module_icon`,`module_href` FROM `msq_module` WHERE 1 ORDER BY `module_order` ASC */ $this->init()->table('module') ->field('module_name','module_info','module_icon','module_href') ->order('module_order','asc') ->get(); ~~~