public_function::getresult PHP Code Examples

Example #1

0

Show file

File: delcurrentmenu.php Project: ZH9009/jjczj

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>";
}

Example #2

0

Show file

File: set_user_group.php Project: ZH9009/jjczj

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);
}

Example #3

0

Show file

File: show_userinfo.php Project: ZH9009/jjczj

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'];
}

Example #4

0

Show file

File: dept_gl.php Project: ZH9009/jjczj

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);
}

Example #5

0

Show file

File: setshortmenu.php Project: ZH9009/jjczj

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);
}

Example #6

0

Show file

File: gl_album.php Project: ZH9009/jjczj

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'];
}

Example #7

0

Show file

File: gl_usergroup.php Project: ZH9009/jjczj

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);
}

Example #8

0

Show file

File: update_dept.php Project: ZH9009/jjczj

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'];
}

Example #9

0

Show file

File: update_menu.php Project: ZH9009/jjczj

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;
}

Example #10

0

Show file

File: usecurrentmenu.php Project: ZH9009/jjczj

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>";
    }
}

Example #11

0

Show file

File: set_toalbum_bg.php Project: ZH9009/jjczj

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;
}

Example #12

0

Show file

File: update_onealbumtype.php Project: ZH9009/jjczj

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;
}

Example #13

0

Show file

File: update_onealbum.php Project: ZH9009/jjczj

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;
}

Example #14

0

Show file

File: delcurrentflowtype.php Project: ZH9009/jjczj

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>";
}

Example #15

0

Show file

File: delricheng.php Project: ZH9009/jjczj

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]}'";

Example #16

0

Show file

File: updateflow.php Project: ZH9009/jjczj

$create_time = CURRENT_TIME;
if ($dept_id0 == "" || $dept_id0 == null) {
    $dept_id = 0;
}
if ($flow_name == "" || $flow_name == null) {
    echo "<script>alert('Á÷³ÌÃû³Æ²»ÄÜÎª¿Õ');location.href='../update_flow.php'</script>";
} else {
    if ($flow_id == 0 || $flow_id == null || $flow_id == "") {
        $result1 = mysql_query("select * from flow_type where flow_name='{$flow_name}'");
        $num1 = mysql_num_rows($result1);
        $array1 = mysql_fetch_array($result1);
        if ($num1 > 0) {
            echo "<script>alert('ÏµÍ³ÒÑ¾´æÔÚ¸ÃÁ÷³ÌÃû³Æ');location.href='../update_flow.php'</script>";
        } else {
            $sql = "insert into flow_type(flow_name,flow_no,flow_sort,flow_desc,dept_id,create_time) values('{$flow_name}','{$flow_no}','{$flow_sort}','{$flow_desc}','{$dept_id}','{$create_time}')";
            $result = $public_function->getresult($sql);
            $menuid = mysql_insert_id();
            if ($result > 0) {
                echo "<script>location.href='../update_flow.php?flowid=" . $menuid . "'</script>";
            } else {
                echo "<script>alert('ÍøÂç´íÎó,ÇëÉÔºòÖØÊÔ.');location.href='../update_flow.php'</script>";
            }
        }
    } else {
        $result3 = mysql_query("select * from flow_type where flow_id='{$flow_id}'");
        $array3 = mysql_fetch_array($result3);
        if ($array3['flow_sort'] == $flow_sort && $array3['flow_name'] == $flow_name) {
            $sql6 = "update flow_type set flow_name='{$flow_name}',flow_no='{$flow_no}',flow_sort='{$flow_sort}',flow_desc='{$flow_desc}',dept_id='{$dept_id}',create_time='{$create_time}' where flow_id='{$flow_id}'";
            $result6 = $public_function->getresult($sql6);
            if ($result6 > 0) {
                echo "<script>location.href='../update_flow.php?flowid=" . $flow_id . "'</script>";

Example #17

0

Show file

File: xingganmn.php Project: ZH9009/jjczj

<?php 
require_once '../include/conmysql.php';
require_once '../include/public_function.php';
require_once '../include/photo_gl_function.php';
$public_function=new public_function();
$blog_type_user=$_SESSION['UID'];
$mid=str_replace(" ", "", $_GET['mid']);
$url=str_replace(" ", "", $_GET['url']);

$menu_sql="select ids,module_name,module_iseduse,module_sort,module_url,module_showhome,module_isedmenu,module_url
		from picture_module where module_isedmenu=1 order by module_sort asc";
$menu_result=$public_function->getresult($menu_sql);
$menu_num=$public_function->getnum($menu_result);

//获取推荐的相册
$album_sql="select ids,album_name,album_desc,album_author,album_createdate,photo_size,album_iseddel,album_right,album_fangke,album_pinglun,album_zan,album_bg,album_module,album_isedhot,album_isedshow from blog_album where album_iseddel=0 and album_isedshow=1 and album_module='$mid' order by ids desc";
$album_result=$public_function->getresult($album_sql);
$album_num=$public_function->getnum($album_result);
$pagesize=4;
$yeshu=ceil($album_num/$pagesize);          //求得一共需要多少页
$geshu=3;                                  //一页显示10个页码*-*
if($_POST['page']!=null){
	$page=$_POST["page"];
}else{
	$page=$_GET["page"];
}

if(empty($page))
{
	$page=1;
}

Example #18

0

Show file

File: delonerjqx.php Project: ZH9009/jjczj

<?php

require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$blog_right = str_replace(" ", "", $_GET['blogright']);
$blog_rightid = str_replace(" ", "", $_GET['blogrightid']);
$select_sql = "update blog_blog set blog_right=1 where blog_right='{$blog_right}'";
$select_result = $public_function->getresult($select_sql);
if ($select_result > 0) {
    $sql = "delete from blog_right_type where right_type_id='{$blog_rightid}'";
    $result = $public_function->getresult($sql);
    if ($result > 0) {
        $info = "success";
    } else {
        $info = "fail";
    }
} else {
    $info = "fail";
}
echo "<script>location.href='../set_riji_viewright.php?info=" . $info . "'</script>";

Example #19

0

Show file

File: delmoreflow.php Project: ZH9009/jjczj

<?php

require_once '../../../../include/conmysql.php';
require_once '../../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$flowids0 = str_replace(" ", "", $_GET['flowids']);
$flowids = explode(',', $flowids0);
$page = str_replace(" ", "", $_GET['page']);
$yeshu = str_replace(" ", "", $_GET['yeshu']);
$cnt = str_replace(" ", "", $_GET['cnt']);
for ($i = 0; $i < count($flowids); $i++) {
    if (delflow($flowids[$i])) {
        $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)");
        returndelflow($page, $info = "²Ù×÷³É¹¦", $cnt, $yeshu, $flowids);
    } else {
        returndelflow($page, $info = "ÍøÂç´íÎó,ÇëÉÔºòÖØÊÔ.", $cnt, $yeshu, $flowids);
    }
}
function delflow($flowid)
{
    if (mysql_query("delete from flow_type where flow_id='{$flowid}'") > 0) {
        return true;
    } else {
        return false;

Example #20

0

Show file

File: user_jg_edit.php Project: ZH9009/jjczj

     if ($user_passwd0 == "") {
         //$user_passwd=md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5("123456"))))))))))));
         $sql1 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
     } else {
         $user_passwd = md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5($_REQUEST['user_passwd']))))))))))));
         $sql1 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',user_passwd='{$user_passwd}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
     }
     $updateresult = mysql_query($sql1);
     if ($updateresult > 0) {
         echo "<script>alert('机构信息更新成功');location.href='" . $url . ".php?page=" . $page . "';</script>";
     } else {
         echo "<script>alert('由于网络原因,操作失败,请稍后重试...');location.href='" . $url . ".php?page=" . $page . "';</script>";
     }
 } else {
     $ised_yes_sql = "select user_name,user_type,user_passwd from blog_user where user_name='{$user_name}'";
     $ised_yes_result = $public_function->getresult($ised_yes_sql);
     $ised_yes_num = $public_function->getnum($ised_yes_result);
     if ($ised_yes_num > 0) {
         echo "<script>alert('系统已经存在该机构信息,请重新换一个机构名称?');location.href='" . $url . ".php?page=" . $page . "';</script>";
     } else {
         if ($user_passwd0 == "") {
             //$user_passwd=md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5("123456"))))))))))));
             $sql2 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
         } else {
             $user_passwd2 = md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(md5($_REQUEST['user_passwd']))))))))))));
             $sql2 = "update blog_user set user_name='{$user_name}',user_type='{$user_type}',user_passwd='{$user_passwd2}',jg_mc='{$jg_mc}',user_truename='{$jg_jc}',jg_fr='{$jg_fr}',fr_dh='{$fr_dh}',jg_lxr='{$jg_lxr}',jg_lxrdh='{$jg_lxrdh}',update_date='{$create_date}' where user_id='{$user_id}'";
         }
         $updateresult2 = mysql_query($sql2);
         if ($updateresult2 > 0) {
             echo "<script>alert('机构信息更新成功');location.href='" . $url . ".php?page=" . $page . "';</script>";
         } else {

Example #21

0

Show file

File: edittestname.php Project: ZH9009/jjczj

require_once '../../include/public_function.php';
require_once '../../include/blog_menu_function.php';
require_once '../../include/user_function.php';
$public_function = new public_function();
$user_function = new user_function();
$username = str_replace(" ", "", $_GET['pid']);
$userid = str_replace(" ", "", $_GET['uid']);
header("content-type:text/html;charset=gb2312");
if ($username == "") {
    echo "<font color='red'>警告:用户名不能为空!</font>";
    exit;
} else {
    $ui_result = mysql_query("select user_name,user_id from blog_user where user_id='{$userid}'");
    $ui_array = mysql_fetch_array($ui_result);
    if ($ui_array['user_name'] == $username) {
        echo "<font color='red'>*</font>用户名可包含数字、字母、下划线和汉字,2-20";
        exit;
    } else {
        $sql = "select user_name,user_isedlogin from blog_user where user_name='" . $username . "'";
        $query = $public_function->getresult($sql);
        $num = $public_function->getnum($query);
        $array = $public_function->getarray($query);
        if ($num > 0) {
            echo "<font color='red'>警告:系统已存在该用户名</font>";
            exit;
        } else {
            echo "<font color='green'>√&nbsp;恭喜:该用户名可以使用</font>";
            exit;
        }
    }
}

Example #22

0

Show file

File: set_next_step.php Project: ZH9009/jjczj

$flowid = $_GET['flowid'];
$prcsid = $_GET['prcsid'];
if ($public_function->getbgbyuser($blog_userid) != "") {
    $bg = $public_function->getbgbyuser($blog_userid);
} else {
    if ($public_function->getbgbysys() != "") {
        $bg = $public_function->getbgbysys();
    } else {
        $bg = "images/bg/bg3.jpg";
    }
}
//获取流程信息
$flow_result = mysql_query("select * from flow_type where flow_id='{$flowid}'");
$flow_array = mysql_fetch_array($flow_result);
//获取单个步骤信息
$flow_step_result = $public_function->getresult("select * from flow_process where id='{$prcsid}'");
$flow_step_array = $public_function->getarray($flow_step_result);
//获取当前流程的所有步骤
$flow_step_all_result = $public_function->getresult("select * from flow_process where flow_id='{$flowid}' order by prcs_id asc");
$flow_step_all_num = mysql_num_rows($flow_step_all_result);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<title>设置当前流程步骤下一步</title>
<link rel="stylesheet" href="../../../css/public.css" />
<script type="text/javascript">
function setflownextstep(){
	var a=new Array();

Example #23

0

Show file

File: logincheck.php Project: ZH9009/jjczj

function clearCookies()
{
    setcookie('uid', '', time() - 3600);
}
?>

<?php 
$sql = "select user_id,user_name,user_passwd,user_isedlogin,user_type from blog_user where user_name='{$username}'";
$user_result = mysql_query($sql);
if (mysql_num_rows($user_result) > 0) {
    $user_array = mysql_fetch_array($user_result);
    if ($user_array['user_passwd'] == $userpasswd) {
        if ($user_array['user_isedlogin'] == 1) {
            $user_function->user_login_registersession($user_array['user_id'], $user_array['user_type']);
            //setcookie("UID1", "cccccccccccc", time()+3600*24*365);
            //$user_function->user_login_registercookie($user_array['user_id'],$user_array['user_type']);
            $blog_log_ip = $public_function->getip();
            $blog_log_date = CURRENT_TIME;
            $blog_log_user = $user_array['user_id'];
            $logsql = "insert into blog_log(blog_log_ip,blog_log_date,blog_log_user) values('{$blog_log_ip}','{$blog_log_date}',{$blog_log_user})";
            $public_function->getresult($logsql);
            echo "<script>location.href='../admin.php';</script>";
        } else {
            echo "<script>alert('您的账号已被锁,请联系管理员!');location.href='../admin.php';</script>";
        }
    } else {
        echo "<script>alert('您输入的密码不正确,请重新输入!');location.href='../admin.php';</script>";
    }
} else {
    echo "<script>alert('您输入的账号不正确,请重新输入!');location.href='../admin.php';</script>";
}

Example #24

0

Show file

File: add_album.php Project: ZH9009/jjczj

<?php

require_once '../../include/conmysql.php';
require_once '../../include/public_function.php';
$public_function = new public_function();
$blog_type_user = $_SESSION['UID'];
$url = $_GET['url'];
$select_blog_album_right_sql = "select album_right,album_right_name,album_right_desc from blog_album_right";
$select_blog_album_right_result = $public_function->getresult($select_blog_album_right_sql);
$select_blog_album_right_num = $public_function->getnum($select_blog_album_right_result);
$album_right = $_POST['album_right'];
$album_name = $_POST['album_name'];
$album_desc = $_POST['album_desc'];
$album_module = $_POST['album_module'];
/* if($album_desc0=="说说这个相册的故事...(非必填)"){
	$album_desc="";
}else{
	$album_desc=$album_desc0;
} */
$album_createdate = CURRENT_TIME;
$insert_blog_sql = "insert into blog_album(album_name,album_desc,album_author,album_createdate,album_right,album_module) \nvalue('{$album_name}','{$album_desc}','{$blog_type_user}','{$album_createdate}','{$album_right}','{$album_module}')";
if ($album_name == "" || $album_name == null || $album_name == "相册名称") {
    $info1 = "相册名称";
    $info2 = "说说这个相册的故事...(非必填)";
} else {
    $select_album_name_sql = "select album_name,album_author from blog_album where album_name='{$album_name}' and album_author='{$blog_type_user}'";
    if ($public_function->getnum($public_function->getresult($select_album_name_sql)) > 0) {
        $info = "该相册已创建";
    } else {
        $public_function->getresult($insert_blog_sql);
        $album = mysql_insert_id();

Example #25

0

Show file

File: delallriczy.php Project: ZH9009/jjczj

<?php

require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$update_sql = "update blog_richeng set importent=1";
$update_result = $public_function->getresult($update_sql);
if ($update_result > 0) {
    $sql = "delete from blog_richeng_isedimport where ids<>1";
    $result = $public_function->getresult($sql);
    echo "<script>location.href='../richeng_fl.php'</script>";
} else {
    echo "<script>location.href='../richeng_fl.php'</script>";
}

Example #26

0

Show file

File: set_priv_step.php Project: ZH9009/jjczj

$flowid = $_GET['flowid'];
$prcsid = $_GET['prcsid'];
if ($public_function->getbgbyuser($blog_userid) != "") {
    $bg = $public_function->getbgbyuser($blog_userid);
} else {
    if ($public_function->getbgbysys() != "") {
        $bg = $public_function->getbgbysys();
    } else {
        $bg = "images/bg/bg3.jpg";
    }
}
//获取流程信息
$flow_result = mysql_query("select * from flow_type where flow_id='{$flowid}'");
$flow_array = mysql_fetch_array($flow_result);
//获取单个步骤信息
$flow_step_result = $public_function->getresult("select * from flow_process where id='{$prcsid}'");
$flow_step_array = $public_function->getarray($flow_step_result);
//获取当前流程的所有步骤
$flow_priv_all_result = $public_function->getresult("select * from blog_user_type where usertype!=1 and usertype!=2 and usertype!=3");
$flow_priv_all_num = mysql_num_rows($flow_priv_all_result);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<title>设置当前流程步骤下一步</title>
<link rel="stylesheet" href="../../../css/public.css" />
<script type="text/javascript">
function prcs_priv(){
	var a=new Array();

Example #27

0

Show file

File: gl_blog.php Project: ZH9009/jjczj

if($public_function->getbgbyuser($blog_userid)!=""){
	$bg=$public_function->getbgbyuser($blog_userid);
}else if($public_function->getbgbysys()!=""){
	$bg=$public_function->getbgbysys();
}else{
	$bg="../../images/bg/bg3.jpg";
}
$types_option=turn_string_str($_GET['types']);
//日记管理
$select_blog_sql="select blog_id,blog_title,
	blog_content,blog_userid,blog_type,blog_right,blog_date,
	blog_viewtime,blog_shoucangtime,blog_zhuanfatime,blog_zantime,
	blog_fenxiangtime,blog_isedview,blog_isedzhuanzai,blog_isedshoucang,
	blog_isedzan,blog_isedfenxiang,blog_isedshow from blog_blog where blog_userid='$blog_userid'
	order by blog_id desc";
$select_blog_result=$public_function->getresult($select_blog_sql);
$select_blog_num=$public_function->getnum($select_blog_result);

$settypes="gl_blog";
if($types_option=="setpagesize"){
	$public_function->setPageSize(turn_string_sql($_GET['pagesizeset']), turn_string_sql($_GET['settypes']), $blog_userid);
	echo "<script>location.href='gl_blog.php'</script>";
}
$ised_pagesize_result=mysql_query("select * from czj_pagesize where types='$settypes' and userid='$blog_userid'");
$ised_pagesize_num=mysql_num_rows($ised_pagesize_result);
$ised_pagesize_array=mysql_fetch_array($ised_pagesize_result);
if($ised_pagesize_num>0){
	$pagesize=$ised_pagesize_array['pagesize'];
}else{
	$pagesize=$PAGESIZE;
}

Example #28

0

Show file

File: menu_list.php Project: ZH9009/jjczj

		}
	});
});
</script>
</head>

<body style="background-color: #ececec;">
<div class="st_tree" style="width:300px;overflow: auto;">
<?php 
$userid = $_SESSION['UID'];
$utype = $_SESSION['UTYPE'];
$usertype_sql = "";
if ($utype == 1) {
    $usertype_sql = "";
} else {
    $usertype_sql = "where menu_id in(select menuid from blog_menu_user where usertype='{$utype}')";
}
//获取公共类
$public_function = new public_function();
$sql = "select * from blog_menu " . $usertype_sql . " order by menu_order";
$result = $public_function->getresult($sql);
for ($i = 0; $i < $public_function->getnum($result); $i++) {
    $r[] = $public_function->getarray($result);
}
echo getTreeupdate($r, 0);
?>
</div>
</body>

</html>

Example #29

0

Show file

File: del_bbs_type.php Project: ZH9009/jjczj

<?php

require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$bbstypeid = str_replace(" ", "", $_GET['bbstypeid']);
$result = $public_function->getresult("delete from blog_bbs_content where bbs_type='{$bbstypeid}'");
$result = $public_function->getresult("delete from blog_bbs_type where ids='{$bbstypeid}'");
$result = $public_function->getresult("delete from blog_bbs_content_shoucang where bbsid not in(select ids from blog_bbs_content)");
$result = $public_function->getresult("delete from blog_bbs_content_viewhistory where bbsid not in(select ids from blog_bbs_content)");
$result = $public_function->getresult("delete from blog_bbs_jb where jbbbsid not in(select ids from blog_bbs_content)");
echo "<script>location.href='../shyule_bbsmodule_gl.php'</script>";

Example #30

0

Show file

File: main.php Project: ZH9009/jjczj

			echo getUserNameBySessionUID($userid);
		}else{
			echo getUserNameBySessionUID($userid)."(".$user_type_array['usertypename'].")";
		}*/
?>
           
            </div>
        </div>
        <!--头部结束-->
        <!--左边菜单开始-->
        <div class="left_c left">
            <h1>系统菜单</h1>
        	<div class="acc">
                <?php 
$sql = "select * from blog_menu " . $usertype_sql . " order by menu_order";
$result = $public_function->getresult($sql);
$num = $public_function->getnum($result);
for ($i = 0; $i < $public_function->getnum($result); $i++) {
    echo "<div>";
    $array = $public_function->getarray($result);
    $array_id = $array['menu_id'];
    $result1 = $public_function->getresult("select * from blog_menu " . $usertype_sql . " and menu_pid='{$array_id}' order by menu_order");
    $num1 = $public_function->getnum($result1);
    if ($num1 > 0) {
        ?>
						<a class="one" href="#" title="<?php 
        echo $array['menu_name'];
        ?>
"><?php 
        echo $array['menu_name'];
        ?>

PHP public_function::getresult Examples