PHP public_function::getresult方法代码示例

function del($pid)
{
    $public_function = new public_function();
    $sql = "select * from blog_menu where menu_pid='{$pid}'";
    $delsql = "delete from blog_menu where menu_id='{$pid}'";
    $result = $public_function->getresult($sql);
    $num = $public_function->getnum($result);
    for ($i = 0; $i < $num; $i++) {
        $array = $public_function->getarray($result);
        del($array['menu_id']);
    }
    $result1 = $public_function->getresult($delsql);
    echo "<script>location.href='../add_new_menu.php?'</script>";
}

function getmenurightnum($menuid, $usertype)
{
    $public_function = new public_function();
    $menu_right_sql = "select * from blog_menu_user where menuid='{$menuid}' and usertype='{$usertype}'";
    $menu_right_result = $public_function->getresult($menu_right_sql);
    return $public_function->getnum($menu_right_result);
}

function getusergroup($user_type)
{
    $public_function = new public_function();
    $u_type_sql = "select usertype,usertypename from blog_user_type where usertype='{$user_type}'";
    $u_array = $public_function->getarray($public_function->getresult($u_type_sql));
    return $u_array['usertypename'];
}

function getcountmenbydept($dpid)
{
    $public_function = new public_function();
    $user_dept_sql = "select user_dept from blog_user where user_dept='{$dpid}'";
    $user_dept_result = $public_function->getresult($user_dept_sql);
    return $public_function->getnum($user_dept_result);
}

function getcountmen($user_type)
{
    $public_function = new public_function();
    $user_dept_sql = "select user_type from blog_user where user_type='{$user_type}'";
    $user_dept_result = $public_function->getresult($user_dept_sql);
    return $public_function->getnum($user_dept_result);
}

function getonepic($userid, $albumid)
{
    $public_function = new public_function();
    $sql = "select photo_album,photo_path,photo_author from blog_photo where photo_author='{$userid}' and photo_album='{$albumid}' order by RAND() limit 1";
    $array = $public_function->getarray($public_function->getresult($sql));
    return $array['photo_path'];
}

function getcountmennologin($user_type)
{
    $public_function = new public_function();
    $user_dept_sql = "select user_type,user_isedlogin from blog_user where user_type='{$user_type}' and user_isedlogin=0";
    $user_dept_result = $public_function->getresult($user_dept_sql);
    return $public_function->getnum($user_dept_result);
}

function getparentdept($pid)
{
    $public_function = new public_function();
    $sql = "select dept_pid,dept_name from blog_dept where ids='{$pid}'";
    $result = $public_function->getresult($sql);
    $array = $public_function->getarray($result);
    return $array['dept_name'];
}

function getmenuname($pid)
{
    $pmenusql = "select menu_id,menu_name from blog_menu where menu_id='{$pid}'";
    $public_function = new public_function();
    $pmenuresult = $public_function->getresult($pmenusql);
    $pmenuarray = $public_function->getarray($pmenuresult);
    $menu_name = $pmenuarray['menu_name'];
    return $menu_name;
}

function update_iseduse($pid, $ise)
{
    $public_function = new public_function();
    $sql = "select * from blog_menu where menu_pid='{$pid}'";
    $updatesql = "update blog_menu set menu_isedshow='{$ise}' where menu_id='{$pid}'";
    $result = $public_function->getresult($sql);
    $num = $public_function->getnum($result);
    for ($i = 0; $i < $num; $i++) {
        $array = $public_function->getarray($result);
        update_iseduse($array['menu_id'], $ise);
    }
    $result1 = $public_function->getresult($updatesql);
    if ($result1 > 0) {
        echo "<script>location.href='../update_menu.php?info=success&menuid=" . $pid . "'</script>";
    } else {
        echo "<script>location.href='../update_menu.php?info=fail'</script>";
    }
}

function setAlbumBG($albumid, $photosid, $iseds)
{
    $public_function = new public_function();
    $sql = "update blog_photo set photo_isedbg=1 where ids='{$photosid}'";
    $result = $public_function->getresult($sql);
    if ($result > 0) {
        $usql = "update blog_photo set photo_isedbg=0 where ids!='{$photosid}' and photo_album='{$albumid}'";
        $uresult = $public_function->getresult($usql);
        if ($uresult > 0) {
            $info = "±³¾°Í¼Æ¬ÉèÖóɹ¦";
        } else {
            $info = "±³¾°Í¼Æ¬ÉèÖÃʧ°Ü";
        }
    } else {
        $info = "±³¾°Í¼Æ¬ÉèÖÃʧ°Ü";
    }
    return $info;
}

function MenuShow_Moduletype($moduleid, $isedshow)
{
    $public_function = new public_function();
    $sql = "update picture_module set module_isedmenu='{$isedshow}' where ids='{$moduleid}'";
    $result = $public_function->getresult($sql);
    if ($result > 0) {
        $info = "相册模块更新成功";
    } else {
        $info = "由于网络原因，操作失败，请稍后重试...";
    }
    return $info;
}

function Hidden_Album($albumid, $isedyc)
{
    $public_function = new public_function();
    $update_album_sql = "update blog_album set album_isedshow='{$isedyc}' where ids='{$albumid}'";
    $update_album_result = $public_function->getresult($update_album_sql);
    if ($update_album_result > 0) {
        $info = "相册更新成功";
    } else {
        $info = "相册更新失败";
    }
    return $info;
}

function del($pid)
{
    $public_function = new public_function();
    $sql = "select * from flow_sort where sort_parent='{$pid}'";
    $delsql = "delete from flow_sort where sort_id='{$pid}'";
    $result = $public_function->getresult($sql);
    $num = $public_function->getnum($result);
    for ($i = 0; $i < $num; $i++) {
        $array = $public_function->getarray($result);
        del($array['sort_id']);
    }
    $result1 = $public_function->getresult($delsql);
    $public_function->getresult("delete from flow_type where flow_sort not in(select sort_id from flow_sort)");
    $public_function->getresult("delete from flow_print_tpl where flow_id not in(select flow_id from flow_type)");
    $public_function->getresult("delete from flow_process where flow_id not in(select flow_id from flow_type)");
    $public_function->getresult("delete from flow_query_tpl where flow_id not in(select flow_id from flow_type)");
    $public_function->getresult("delete from flow_rule where flow_id not in(select flow_id from flow_type)");
    $public_function->getresult("delete from flow_run where flow_id not in(select flow_id from flow_type)");
    $public_function->getresult("delete from flow_run_log where flow_id not in(select flow_id from flow_type)");
    $public_function->getresult("delete from flow_timer where flow_id not in(select flow_id from flow_type)");
    echo "<script>location.href='../update_flow_type.php'</script>";
}

require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$idsone = str_replace(" ", "", $_GET['ids']);
$idsall = str_replace(" ", "", $_GET['ids']);
$idsalldel = explode(',', $idsall);
$ty = str_replace(" ", "", $_GET['ty']);
$page = str_replace(" ", "", $_GET['page']);
$yeshu = str_replace(" ", "", $_GET['yeshu']);
$pagesize = str_replace(" ", "", $_GET['pagesize']);
$cnt = str_replace(" ", "", $_GET['cnt']);
$dates = str_replace(" ", "", $_GET['dates']);
$richeng_sql = "select ids,contents,starttime,endtime,types,userid,dates,date_format(dates,'%Y-%m-%d') as dates1,titles,importent from blog_richeng where userid='{$blog_userid}' and date_format(dates,'%Y-%m-%d')='{$dates}'";
$richeng_result = $public_function->getresult($richeng_sql);
$richeng_num = $public_function->getnum($richeng_result);
//echo $richeng_num;
if ($ty == "delone") {
    $delone_sql = "delete from blog_richeng where ids='{$idsone}'";
    $delone_result = $public_function->getresult($delone_sql);
    if ($delone_result > 0) {
        $info = "success";
    } else {
        $info = "fail";
    }
    rturnPage($page, $yeshu, $info, $cnt);
} else {
    if ($ty == "delall") {
        for ($i = 0; $i < count($idsalldel); $i++) {
            $sql = "delete from blog_richeng where ids='{$idsalldel[$i]}'";