PHP ModelUser::getOne Examples

Example #1

File: registerhandle.php Project: hsshhsshhssh/bianli

// 获得数据库实例
$mu = new ModelUser('bl_user');
// 判断操作的类型 chkuname为检查用户名是否重复
$type = $_POST['type'];
//print_r($_POST);
// 检查用户名是否重复
if ($type == 'chkuname') {
    // 获得待检查的用户名
    if (empty($_POST['username'])) {
        echo "1";
        return;
    } else {
        $username = $_POST['username'];
    }
    $sql = "select count(*) from bl_user where username='******'";
    $res = $mu->getOne($sql);
    if ($res != 0) {
        // 重复
        echo "1";
        return;
    } else {
        echo "0";
        return;
    }
} else {
    if ($type == 'register') {
        $data = array('username' => $_POST['username'], 'password' => $_POST['password'], 'email' => $_POST['email']);
        $res = $mu->insert($data);
        if ($res != 1) {
            echo "1";
            return;

Example #2

File: goodslist.php Project: hsshhsshhssh/bianli

}
// 获取所有栏目
$res = $mu->select(array('cate_id', 'cate_name', 'parent_id'), "is_delete=0 order by cate_id");
$catelist = ToolsInfClassify::ClassifyForOne($res);
//print_r($catelist);
// 获取该栏目下所有的子栏目
$allCateId = ToolsInfClassify::ChildrenId($res, $cate_id);
array_unshift($allCateId, $cate_id);
//print_r($allCateId);
$inCateId = '(' . implode(',', $allCateId) . ')';
// 分页显示
// 每页显示的条数
$list_per_page = 10;
// 总条数
$sql = 'select count(*) from bl_goods where cate_id in ' . $inCateId . ' && is_delete=0';
$list_total = $mu->getOne($sql);
// 总页数
$page_total = ceil($list_total / $list_per_page);
// 获得当前显示的页
if (!isset($_GET['page']) || intval($_GET['page']) < 1) {
    $page = 1;
} else {
    if (intval($_GET['page']) > $page_total) {
        $page = $page_total;
    } else {
        $page = intval($_GET['page']);
    }
}
// 获得要显示的页码数组
$result = ToolsPage::DividePage($list_per_page, $list_total, $page, 'goodslist.php?cate_id=' . $cate_id);
$pages = $result['pages'];