PHP public_function::getnum方法代码示例

function getcountphoto($albumid, $userid)
{
    $public_function = new public_function();
    $select_photo_size_sql = "select ids,photo_author,photo_album from blog_photo where photo_author='{$userid}' and photo_album='{$albumid}'";
    $select_photo_size_num = $public_function->getnum($public_function->getresult($select_photo_size_sql));
    return $select_photo_size_num;
}

function getcountalbum($moduleid)
{
    $public_function = new public_function();
    $select_album_sql = "select * from blog_album where album_module='{$moduleid}'";
    $select_album_num = $public_function->getnum($public_function->getresult($select_album_sql));
    return $select_album_num;
}

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

<?php

require_once '../../../include/conmysql.php';
require_once '../../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
$typesname = str_replace(" ", "", $_GET['typesname']);
$select_sql = "select typesname from blog_richeng_type where typesname='{$typesname}'";
$select_result = $public_function->getresult($select_sql);
$select_num = $public_function->getnum($select_result);
if ($select_num > 0) {
    echo "<script>location.href='../richeng_fl.php'</script>";
} else {
    $sql = "insert into blog_richeng_type(typesname) values('{$typesname}')";
    $result = $public_function->getresult($sql);
    echo "<script>location.href='../richeng_fl.php'</script>";
}

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

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]}'";
            $delall_richeng = $public_function->getresult($sql);

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

<?php

require_once '../../include/conmysql.php';
require_once '../../include/public_function.php';
$public_function = new public_function();
$blog_userid = $_SESSION['UID'];
//日记分类管理
if ($_REQUEST['edtype'] == "edit") {
    $blog_type_id = $_REQUEST['blog_type_id'];
    if ($blog_type_id != null || $blog_type_id != 0 || $blog_type_id != "") {
        $blog_type_name = $_REQUEST['blog_type_name'];
        //查询当前名称是否存在数据库
        $select_blog_type_sql = "select blog_type_name,blog_type_user from blog_type where blog_type_name='{$blog_type_name}' and blog_type_user='{$blog_userid}'";
        if ($public_function->getnum($public_function->getresult($select_blog_type_sql)) > 0) {
            echo "<script>alert('该名称已存在');location.href='blog_type_construct.php'</script>";
        } else {
            $select_blog_type_sql = "update blog_type set blog_type_name='{$blog_type_name}' where blog_type_id='{$blog_type_id}'";
            $select_blog_type_result = $public_function->getresult($select_blog_type_sql);
            echo "<script>location.href='blog_type_construct.php'</script>";
        }
    } else {
        $blog_type_name1 = $_REQUEST['blog_type_name1'];
        $select_blog_type_sql1 = "insert into blog_type(blog_type_name,blog_type_user) value('{$blog_type_name1}','{$blog_userid}')";
        $select_blog_type_result = $public_function->getresult($select_blog_type_sql1);
        echo "<script>location.href='blog_type_construct.php'</script>";
    }
} elseif ($_REQUEST['edtype'] == "del") {
    $blogtypeid = $_REQUEST['blogtypeid'];
    $del_blog_type = "delete from blog_type where blog_type_id='{$blogtypeid}'";
    $del_blog_type_result = $public_function->getresult($del_blog_type);
    $update_blog_type_sql = "update blog_blog set blog_type=1 where blog_userid='{$blog_userid}'";

" name="link_name" id="link_name" style="width:210px;" placeholder="╩С╚в═Эои├ч│к"/></td>
        </tr>
        <tr>
          <td width="100px" align="right">═ЭоиБ║</td>
          <td align="left" width="400"><input type="text" value="<?php 
echo $select_url_array['link_url'];
?>
" name="link_url" id="link_url" style="width:400px;" placeholder="╩С╚в═Эои"/></td>
        </tr>
        <tr>
          <td width="100px" align="right">ио└ЯБ║</td>
          <td align="left" width="210">
          	<select name="link_module">
          		<?php 
$urltyperesult = getAllCanUseWebSiteType();
$urltypenum = $public_function->getnum($urltyperesult);
for ($i = 0; $i < $urltypenum; $i++) {
    $urltypearray = $public_function->getarray($urltyperesult);
    ?>
          		<option value="<?php 
    echo $urltypearray['ids'];
    ?>
" <?php 
    if ($select_url_array['link_module'] == $urltypearray['ids'] || $urltypearray['ids'] == $urlmoduleid) {
        echo "selected";
    }
    ?>
><?php 
    echo $urltypearray['module_name'];
    ?>
</option>