// 是否赞 $data['importance'] = 0; //默认为普通文章,若为1则是重要文章 $data['abstract'] = $abstract; //摘要 /** * *****存入wx_info数据库*********** * */ //查看是否是文化理念 $sql_type = "select type from wx_articlelist_module where id=" . $moduleId; $res_type = $db->getrow($sql_type); if ($res_type['type'] == 2) { //该模块为文化理念,删除其他文章,只留一篇文章 $sql_delete = "delete from wx_info where moduleId=" . $moduleId; $res_delete = $db->execsql($sql_delete); } $insert = $db->insert('wx_info', $data); // 插入语句 if ($insert) { $upload['infoId'] = mysql_insert_id(); $upload['error'] = 1; // 保存成功 if ($res_type['type'] == 2) { //该模块为文化理念,修改文化理念的微信端链接 $urlWechat = "../../culture/html/culturelist.php?arctileId=" . $upload['infoId']; $urlPC = "../../article/html/cultureidea.html?articleId=" . $upload['infoId']; $sql_update = "update wx_articlelist_module set urlWechat='{$urlWechat}' and urlPC='{$urlPC}' where id=" . $moduleId; $res_update = $db->execsql($sql_update); } if ($public == 1) {
header("content-type:text/json;charset=utf-8"); $path = dirname(dirname(dirname(__FILE__))); // echo $path; require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/uploadFiles.php'; require_once '../../../common/php/regexTool.class.php'; session_start(); $db = new DB(); $regex = new regexTool(); $file = array(); $type = $_GET['type']; //获取type的值 //$type="modify_past"; if ($type == "show") { $sql_show = "select * from wx_talent_philosophy "; $res_show = $db->execsql($sql_show); // var_dump($res_show); if (empty($res_show)) { $file['empty'] = true; } else { $file['empty'] = false; $file['show'] = $res_show; } echo json_encode($file); } elseif ($type == 'updateInfo') { /** * *****************后台管理员编辑、修改文章信息的具体内容,点击“修改”按钮********************** */ $infoId = $_GET['infoId']; //获取显示具体内容的文章信息ID //$infoId = 5; // 获取显示具体内容的文章信息ID
//请检查空值 } else { if (empty($subcom['coordinate'])) { echo 3; //坐标值获取失败 } elseif (!$regex->isEmail($subcom['email'])) { echo 4; //email格式错误 } else { //判断是否有置顶项,若有,则取消其他置顶 if ($subcom['isTop'] == 1) { $sql_top = "select id from wx_map where isTop=1"; $res_top = $db->getrow($sql_top); if (!empty($res_top)) { $sql_topDel = "update wx_map set isTop=0 where id=" . $res_top['id']; $res_topDel = $db->execsql($sql_topDel); } } //判断同一子公司名称是否重复添加 $sql_repeat = "select id from wx_map where companyName='{$subcom['companyName']}'"; $res_repeat = $db->getrow($sql_repeat); if (!empty($res_repeat)) { echo 6; //该子公司信息已存在,不能重复添加 } else { $insert = $db->insert('wx_map', $subcom); if ($insert) { echo 1; //添加成功 } else { echo 0;
//微信端显示 $a = 1; // $review_name="往期回顾"; // $sql_name="select id ,name from wx_activity_module where name !='{$review_name}'"; // // echo $sql_name; // $res_name=$db->execsql($sql_name); // $file['activity_IdandName']=$res_name; //所有用于往期回顾活动的ID和名字 $reviewName = $_POST['reviewName']; $sql = "select * from " . $reviewName . " where review = " . $a; // echo $sql;die; $result = mysql_query($sql); // var_dump($result); $sql_list = "select id,title,review,start from " . $reviewName . " where review =\n\t\t'{$a}' and valid = 0 order by start desc limit " . $start . "," . $num; //选择能够往期回顾的活动 // echo $sql_list;die; $res_list = $db->execsql($sql_list); // var_dump($res_list); $file['details_dataBase'] = $reviewName; //往期回顾的活动名称 $file['list'] = $res_list; //往期回顾的列表显示信息 $file['num'] = mysql_num_rows($result); // echo $reviewName;die; $sql_details = "select fronturl from wx_activity_module where reviewTable = '{$reviewName}'"; // echo $sql_details;die; $res_details = $db->getrow($sql_details); // var_dump($res_details); $file['fronturl'] = $res_details; echo json_encode($file); } elseif ($list_type == "manager_delete") { //删除往期回顾
/* * ***********招聘信息标题列表显示********************* */ if ($type == "list") { $page = $_POST['page']; //获取页码 // $page=1; $num = 10; //每页的容量 $start = ($page - 1) * $num; $sql = "SELECT * FROM wx_talent_recruit"; $result = mysql_query($sql); // $sql_list="select * from wx_talent_recruit order by date desc limit ".$start.",".$num; $sql_list = "select title,date,id from wx_talent_recruit order by date desc limit " . $start . "," . $num; // echo $sql_list;die; $res_list = $db->execsql($sql_list); $file['list'] = $res_list; $file['num'] = mysql_num_rows($result); // var_dump($res_list);die; echo json_encode($file); /* * **********招聘信息的详细展示****************** */ } elseif ($type == "details") { // echo "234"; $details_id = $_POST['id']; //获取要查看的招聘信息ID // $details_id=24; $sql_details = "select * from wx_talent_recruit where id=" . $details_id; $res_details = $db->getrow($sql_details); $file['details'] = $res_details;
function delmenu($menuType, $menuId) { $db = new DB(); if ($menuType == 1) { /* * 若要删除的菜单按钮为活动类型,则活动的模块表为wx_activity_module */ // 查找出存储活动数据的表 $sql_table = "select b.id,reviewTable from wx_wechat_module as a left join wx_activity_module as b on a.id=b.menuid where a.id='{$menuId}'"; $res_table = $db->getrow($sql_table); if ($res_table['reviewTable'] == 'wx_activity_interact_project') { /* * 图片互动类型的活动 */ $sql_delete_interact = "DELETE a,b,c,d from wx_activity_interact as b left join wx_activity_interact_project as a on a.id=b.projectId\n\t\t\tleft join wx_activity_leaveword as c on c.activityId=b.id\n\t\t\tleft join wx_activity_zan as d on d.activityId=b.id\n\t\t\twhere a.moduleId='{$res_table['id']}'"; $res_delete_interact = $db->execsql($sql_delete_interact); if (mysql_affected_rows() >= 0) { $error1 = 1; //删除成功 } else { $error1 = 0; //删除失败 } } elseif ($res_table['reviewTable'] == 'wx_vote_project') { /* * 投票类型的活动 */ $sql_delete_vote = "delete a,b,c from wx_vote_project as a left join wx_vote_option as b on b.voteId=a.id\n\t\t\t\t\t left join wx_vote_interact as c on c.voteId=a.id"; $res_delete_vote = $db->execsql($sql_delete_vote); if (mysql_affected_rows() >= 0) { $error1 = 1; //删除成功 } else { $error1 = 0; //删除失败 } } // 删除菜单数据库表 $sql_delete_menu = "delete a,b from wx_wechat_module as a left join wx_activity_module as b on a.id=b.menuId where a.id='{$menuId}'"; $res_delete_menu = $db->execsql($sql_delete_menu); if (mysql_affected_rows() > 0) { $error2 = 1; // 删除成功 } else { $error2 = 0; // 删除失败 } if ($error1 && $error2) { $del['error'] = "删除成功"; } else { $del['error'] = "删除失败"; } } elseif ($menuType == 2) { /* * 若要删除的菜单按钮为文章列表类型,则活动的模块表为wx_activity_module */ // 判断要删除的是否是菜单 if ($menuId != 0) { /* * 是菜单类型 */ // 删除相关文件 $sql_file = "select thumb,media from wx_info as b left join wx_articlelist_module as a on a.id=b.moduleId where a.menuId='{$menuId}'"; $res_file = $db->execsql($sql_file); foreach ($res_file as $val_file) { if (!empty($val_file['thumb'])) { unlink($val_file['thumb']); } if (!empty($val_file['media'])) { $media = explode(';', $val_file['media']); foreach ($media as $key_media => $val_media) { if (empty($val_media)) { unset($media[$key_media]); } else { unlink($val_media); } } } } // 删除数据库中的数据 $sql_delete_articlelist = "DELETE a,b,c,d from wx_info as b left join wx_articlelist_module as a on a.id=b.moduleId\n\t\t\tleft join wx_leaveword as c on c.infoId=b.id\n\t\t\tleft join wx_zan as d on d.infoId=b.id\n\t\t\twhere a.menuId='{$menuId}'"; $res_delete_articlelist = $db->execsql($sql_delete_articlelist); if (mysql_affected_rows() >= 0) { $error1 = 1; //删除成功 } else { $error1 = 0; //删除失败 } // 删除菜单数据库表 $sql_delete_menu = "delete a,b from wx_wechat_module as a left join wx_articlelist_module as b on a.id=b.menuId where a.id='{$menuId}'"; $res_delete_menu = $db->execsql($sql_delete_menu); if (mysql_affected_rows() > 0) { $error2 = 1; // 删除成功 } else { $error2 = 0; // 删除失败 } if ($error1 && $error2) { $del['error'] = "删除成功"; } else { $del['error'] = "删除失败"; } } else { $del['error'] = "不是菜单类型,不能删除"; } } elseif ($menuType == 3) { /* * 菜单类型为人才理念 */ $sql_delete_talent2 = "delete from wx_talent_philosophy"; $sql_delete_talent2 = $db->execsql($sql_delete_talent2); if (mysql_affected_rows() >= 0) { $errortalent2 = 1; // 删除成功 } else { $errortalent2 = 0; // 删除失败 } // 删除菜单数据库表 $sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'"; $res_delete_menu = $db->execsql($sql_delete_menu); if (mysql_affected_rows() > 0) { $errortalent1 = 1; // 删除成功 } else { $errortalent1 = 0; // 删除失败 } if ($errortalent1 && $errortalent2) { $del['error'] = "删除成功"; } else { $del['error'] = "删除失败"; } } elseif ($menuType == 4) { /* * 菜单类型为人才招聘 */ $sql_delete_talent1 = "delete from wx_talent_recruit"; $res_delete_talent1 = $db->execsql($sql_delete_talent1); if (mysql_affected_rows() >= 0) { $errortalent1 = 1; // 删除成功 } else { $errortalent1 = 0; // 删除失败 } // 删除菜单数据库表 $sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'"; $res_delete_menu = $db->execsql($sql_delete_menu); if (mysql_affected_rows() > 0) { $errortalent2 = 1; // 删除成功 } else { $errortalent2 = 0; // 删除失败 } if ($errortalent1 && $errortalent2) { $del['error'] = "删除成功"; } else { $del['error'] = "删除失败"; } } elseif ($menuType == 5) { /* * 菜单类型为企业简介 */ // 删除相关文件 $sql_file = "select picture from wx_profile"; $res_file = $db->execsql($sql_file); foreach ($res_file as $val_file) { unlink($val_file['picture']); } // 删除数据库中的数据 $sql_delete_profile = "delete from wx_profile"; $res_delete_profile = $db->execsql($sql_delete_profile); if (mysql_affected_rows() >= 0) { $error1 = 1; // 删除成功 } else { $error1 = 0; // 删除失败 } // 删除菜单数据库表 $sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'"; $res_delete_menu = $db->execsql($sql_delete_menu); if (mysql_affected_rows() > 0) { $error2 = 1; // 删除成功 } else { $error2 = 0; // 删除失败 } if ($error1 && $error2) { $del['error'] = "删除成功"; } else { $del['error'] = "删除失败"; } } elseif ($menuType == 6) { /* * 菜单类型为地图导航 */ // 删除数据库中的数据 $sql_delete_map = "delete from wx_map"; $res_delete_map = $db->execsql($sql_delete_map); if (mysql_affected_rows() >= 0) { $error1 = 1; // 删除成功 } else { $error1 = 0; // 删除失败 } // 删除菜单数据库表 $sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'"; $res_delete_menu = $db->execsql($sql_delete_menu); if (mysql_affected_rows() > 0) { $error2 = 1; // 删除成功 } else { $error2 = 0; // 删除失败 } if ($error1 && $error2) { $del['error'] = "删除成功"; } else { $del['error'] = "删除失败"; } } return $del; }
* ************显示文章信息列表*************** */ $page = $_REQUEST['page']; $moduleId = $_REQUEST['moduleId']; $list = array(); //根据moduleId查询模块名称 $sql_name = "select name from wx_articlelist_module where id=" . $moduleId; $res_name = $db->getrow($sql_name); $list['moduleName'] = $res_name['name']; $num = 10; //每页显示10条 $start = ($page - 1) * $num; //本页显示的起始位置 // 从wx_info中查询出文章信息的基本文章信息 $sql_info_num = "select id from wx_info where moduleId='{$moduleId}' and importance=0 "; $res_info_num = $db->execsql($sql_info_num); $list['PageNum'] = ceil(count($res_info_num) / $num); if ($page == 1) { //查找是否有置顶项,在首页显示 $sql_top_select = "select id,title,thumb,abstract,content,date,is_leaveword,is_zan,importance from wx_info where moduleId='{$moduleId}' and importance=1 order by date desc "; $res_top_select = $db->execsql($sql_top_select); if (!empty($res_top_select)) { //有置顶项 $list['top'] = $res_top_select; } $sql_info = "select id,title,thumb,abstract,content,date,importance from wx_info where moduleId='{$moduleId}' and importance=0 order by date desc limit " . $start . "," . $num; $res_info = $db->execsql($sql_info); } else { $sql_info = "select id,title,thumb,abstract,content,date,importance from wx_info where moduleId='{$moduleId}' and importance=0 order by date desc limit " . $start . "," . $num; $res_info = $db->execsql($sql_info); }
<?php /** * 判断用户是否已在PC端绑定,并根据微信ID将职员编号取出,保存到session中 */ require_once 'dbaccess-SAE.php'; require_once 'getuser.php'; $db = new DB(); session_start(); // 获取微信ID //$openid = '0002'; // 判断微信是否已确认绑定 $flag = $_GET['flag']; if ($flag == 1) { $sql = "update t_hs_wechat set FType = 1 where FWechatID='{$openid}'"; $db->execsql($sql); } $sql_type = "select FType,FNumber from t_hs_wechat where FWechatID='{$openid}'"; $res_type = $db->getrow($sql_type); // var_dump($res_type);die; if (count($res_type) == 0) { //没有记录 //echo 2; // 请先在PC端绑定微信号 echo "<p>您的微信ID为:<b>" . $openid . "</b></p>"; echo "请先在PC端绑定微信号"; $db->db_close(); die; } elseif ($res_type['FType'] == 0) { //echo 0; // 显示确认界面 $fnumber = $res_type['FNumber']; $sql = "select a.FName, b.FName,c.FName from t_hs_employee as a inner join t_hs_company as b on a.FCompanyID == b.FID inner join \n\t t_hs_section as c on a.FSectionID == c.FID where a.FNumber == '" . $fnumber . "'";
require_once '../../../common/php/regexTool.class.php'; require_once '../../../common/php/leaveword.class.php'; require_once '../../../common/php/zan.class.php'; session_start(); $openid = $_SESSION['openid']; $db = new DB(); $lwd = new LWD('wx_activity_leaveword'); $zan = new ZAN('wx_activity_zan'); $regex = new regexTool(); $type = $_GET['type']; if ($type == "ing") { /***************************显示当前正在进行的活动*************************/ //将活动中的过期的活动关闭 //wx_activity_interact_project表 $sql_valid_activity = "select valid,end,id from wx_activity_interact_project"; $res_valid_activity = $db->execsql($sql_valid_activity); $nowTime = time(); foreach ($res_valid_activity as $val_valid_activity) { if ($val_valid_activity['valid'] == 1) { if (strtotime($val_valid_activity['end']) <= $nowTime) { $sql_update_activity = "update wx_activity_interact_project set valid=0 where id='{$val_valid_activity['id']}'"; $res_update_activity = $db->execsql($sql_update_activity); } } } /*********************************显示活动*************************************/ $moduleId = $_GET['moduleId']; if ($regex->isNumber($moduleId)) { $page = $_GET['page']; //获得当前页码 $num = 10;
<?php header('content-type:text/html;charset=utf-8'); require_once '../php/db_mysql/dbaccess.php'; // error_reporting(0); session_start(); if (empty($_GET['function_name']) && empty($_GET['path']) && empty($_GET['id'])) { echo 2; //空值 } else { $db = new DB(); $_SESSION['user']['number'] = $_SESSION['user']['name']; $_SESSION['user']['modify_person'] = $_SESSION['user']['name']; $call['function_name'] = $_GET['function_name']; $call['path'] = $_GET['path']; $call['interface_detail'] = $_GET['interface_detail']; $call['modify_time'] = date('Y-m-d H:i:s', time()); $_SESSION['user']['name'] = $_GET['modify_persion']; $sql = "UPDATE showinterfacetable set function_name='{$_GET['function_name']}',path='{$_GET['path']}',interface_detail='{$_GET['interface_detail']}',modify_time='{$call['modify_time']}',modify_person='{$_GET['modify_persion']}' where id={$_GET['id']}"; //echo $sql; $res = $db->execsql($sql); if ($res) { echo 1; //成功 } else { echo 0; //失败 } }
/** * **判断标题内容是否为空**** */ $title = $_POST['title']; $content = $_POST['content']; $moduleId = $_POST['moduleId']; $abstract = $_POST['abstract']; $subtype = $_GET['subtype']; $articleupload = $_REQUEST['articleupload']; $public = $_POST['public']; //1:是;0:否 $picurl = $_POST['picurl']; //echo "test".$picurl;//die; //查询文章的最大排序字段 $sql_max_seq = "SELECT MAX( seq ) as max_seq FROM wx_info WHERE moduleId ='{$moduleId}'"; $res_max_seq = $db->execsql($sql_max_seq); $seq = $res_max_seq[0]['max_seq'] + 1; //echo "subtype".$subtype; if ($subtype == 'upvideo') { /** * ***视频上传功能*** */ unset($_SESSION['upvideo']); $dest = uploadmulti('video', 1); $_SESSION['upvideo'] = $dest[0]; echo $dest[0]; } elseif (empty($title) || empty($content)) { $upload['error'] = 2; // 标题和内容不能为空 } elseif (get_strlength($abstract) > 200) { $upload['error'] = 3;
<?php header("content-type:text/json;charset=utf-8"); require_once '../../../common/php/dbaccess.php'; $db = new DB(); // 查询出图文类型的模块名称 $sql_type = "select id,name,urlPC from wx_articlelist_module where type=0"; $res_type = $db->execsql($sql_type); foreach ($res_type as $key_type => $val_type) { if (!empty($val_type['urlPC'])) { $type[$key_type]['name'] = $val_type['name']; $type[$key_type]['moduleId'] = $val_type['id']; } } echo json_encode($type);
require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/uploadFiles.php'; require_once '../../../common/php/regexTool.class.php'; require_once '../../../common/php/leaveword_pc.class.php'; require_once '../../../common/php/zan.class.php'; $db = new DB(); $lwd = new LWD('wx_activity_leaveword'); $zan = new ZAN('wx_activity_zan'); $regex = new regexTool(); $type = $_REQUEST['type']; if ($type == 'list') { /***************将过期的活动关闭,并分页显示图片互动活动列表*******************/ //将活动中的过期的活动关闭 //wx_activity_interact_project表 $sql_valid_activity = "select valid,end,id from wx_activity_interact_project"; $res_valid_activity = $db->execsql($sql_valid_activity); // var_dump($res_valid_activity); $nowTime = time(); // echo $nowTime;die; foreach ($res_valid_activity as $val_valid_activity) { if ($val_valid_activity['valid'] == 1) { if (strtotime($val_valid_activity['end']) <= $nowTime) { $sql_update_activity = "update wx_activity_interact_project set valid=0 where id='{$val_valid_activity['id']}'"; $res_update_activity = $db->execsql($sql_update_activity); } } } /* //wx_vote_project表 $sql_valid_vote="select valid,end,id from wx_vote_project"; $res_valid_vote=$db->execsql($sql_valid_vote); // var_dump($res_valid_vote);
$is_zan = 1; } else { $is_zan = 0; } /*****构造wx_info数据库表的数据结构****/ $data['userId'] = $_SESSION['user']['id']; //用户ID $data['picture'] = $dest_db; //图片地址 $data['moduleId'] = $_POST['moduleId']; //模块信息 $data['date'] = date('Y-m-d H-i-s', time()); //日期 $data['title'] = $_POST['title']; //标题 $data['content'] = $_POST['content']; //内容 $data['is_leaveWord'] = $is_leaveWord; //是否评论 $data['is_zan'] = $is_zan; //是否赞 /*******存入wx_info数据库************/ $insert = $db->insert('wx_info', $data); if ($db->execsql($insert)) { $data['error'] = 0; //保存成功 } else { $data['error'] = 1; //保存失败 } echo json_encode($data);
if ($nickname == "" || $headimgurl == "") { $url2 = "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" . $access_token . "&openid=" . $openid . "&lang=zh_CN"; $res2 = getData($url2); $result2 = json_decode($res2, true); $nickname = $result2['nickname']; $headimgurl = $result2['headimgurl']; } //查找数据库中是否有该用户信息,若没有,则添加 $_SESSION['openid'] = $openid; $_SESSION['nickname'] = $nickname; $_SESSION['headimgurl'] = $headimgurl; $sql_user = "******"; $res_user = $db->getrow($sql_user); if (empty($res_user)) { $sql_insert = "insert into wx_user (openId,wechatName,header) values('{$openid}','{$nickname}','{$headimgurl}')"; $res_insert = $db->execsql($sql_insert); } elseif ($res_user['wechatName'] != $nickname || $res_user['header'] != $headimgurl) { $sql_update = "update wx_user set wechatName='{$nickname}' and header='{$headimgurl}' where id='{$res_user['id']}'"; $res_update = $db->execsql($sql_update); } } function getData($url) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (compatible; MSIE 5.01; Windows NT 5.0)'); curl_setopt($ch, CURLOPT_ENCODING, 'gzip'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $data = curl_exec($ch);
} else { $upload['error'] = $result['errcode']; //消息发送失败 $upload['errmsg'] = $result['errmsg']; } //end预览接口 } else { $upload['error'] = 7; //请选择需要推送的文章 } } echo json_encode($upload); } else { //将预览的文章删除 $sql_del_preview = "delete from wx_info where preview=1"; $res_del_preview = $db->execsql($sql_del_preview); $articles = $_POST['data']; //接收到的json格式的文章数组 foreach ($articles as $key => $val) { if (empty($val)) { array_splice($articles, $key, 1); } } //修改mouleId,实现不归类功能 foreach ($articles as $key_mo => $val_mo) { if (!$regex->isNumber($val_mo['moduleId'])) { $articles[$key_mo]['moduleId'] = 0; } } $flag = 1; //用于标志文章信息插入数据库是否成功,默认值为1
<?php header("content-type:text/json;charset=utf-8"); require_once '../../../common/php/dbaccess.php'; $db = new DB(); $type = $_GET['type']; // $type="show"; if ($type == "show") { $sql_show = "select * from wx_audit"; $res_show = $db->execsql($sql_show); // var_dump($res_show); echo json_encode($res_show); } elseif ($type == "set") { $lwd = $_GET["lwd"]; //评论功能是否审核 $pic = $_GET["pic"]; //图片互动是否审核 $sql_setlwd = "update wx_audit set flag='{$lwd}' where name='leaveword'"; // echo $sql_setlwd;die; $res_setlwd = $db->execsql($sql_setlwd); if (mysql_affected_rows() >= 0) { $result1 = true; } else { $result1 = false; } $sql_setpic = "update wx_audit set flag='{$pic}' where name='pictureInteract'"; $res_setpic = $db->execsql($sql_setpic); if (mysql_affected_rows() >= 0) { $result2 = true; } else { $result2 = false;
if ($past_password != $a) { echo 0; //密码输入错误 } elseif ($past_password == $a) { echo 1; } } elseif ($passwordType == "newpwdType") { $now_password1 = $_POST['now_password1']; //获取用户第一次的新密码 $now_password2 = $_POST['now_password2']; //获取用户第二次的新密码 /*************判断两次新密码输入是否相同***************/ if ($now_password1 == $now_password2) { // echo 123; $now_password1 = md5(md5($now_password1)); $sql_update = "update wx_admin set pwd='{$now_password1}' where id = " . $_SESSION['admin']['id']; // 存入数据库 $res_update = $db->execsql($sql_update); $res = mysql_affected_rows(); if ($res > 0) { echo 1; // 修改成功 } else { echo 0; // 修改失败 } } elseif ($now_password1 != $now_password2) { echo 2; //密码输入不一致 } }
<?php session_start(); header("Content-type: text/html; charset=utf-8"); require_once '../php/db_mysql/dbaccess.php'; // error_reporting(0); $db = new DB(); $username = '******'; $password = 123; $sql = "select * from showinterfacetable where version=1"; $result = $db->execsql($sql); $num = count($result); $arr = json_encode($result); echo $arr; $status = 0; if (empty($result)) { $status = -1; } else { $status = 1; }
$regex = new regexTool(); define(IP, "www.chinwhiz.cn"); if ($type == 'list') { /** * ************显示文章信息列表*************** */ $page = $_REQUEST['page']; $moduleId = $_REQUEST['moduleId']; $list = array(); $num = 10; //每页显示10条 $start = ($page - 1) * $num; //本页显示的起始位置 // 从wx_info中查询出文章信息的基本文章信息 $sql_info_num = "select id from wx_info where moduleId='{$moduleId}' "; $res_info_num = $db->execsql($sql_info_num); $list['PageNum'] = ceil(count($res_info_num) / $num); $sql_info = "select id,title,thumb,date,importance,seq from wx_info where moduleId='{$moduleId}' order by importance desc,seq asc limit " . $start . "," . $num; $res_info = $db->execsql($sql_info); foreach ($res_info as $key_list => $val_list) { // 根据文章信息ID在wx_leaveword表中查询出该文章信息的评论次数,在wx_zan表中查询出该文章信息的点赞次数 $list[$key_list]['num_leaveword'] = $lwd->lwdNum($val_list['id']); //评论次数 $list[$key_list]['num_zan'] = $zan->zanNum($val_list['id']); //点赞次数 $list[$key_list]['id'] = $val_list['id']; $list[$key_list]['thumb'] = $val_list['thumb']; $list[$key_list]['title'] = $val_list['title']; $list[$key_list]['date'] = $val_list['date']; $list[$key_list]['importance'] = $val_list['importance']; }
//获取页码 // $page=1; $num = 10; //每页的容量 $start = ($page - 1) * $num; if ($list_type == "wx") { $a = 1; $sql = "select * from " . $reviewName . " where review = " . $a; // echo $sql;die; $result = mysql_query($sql); // var_dump($result); // echo mysql_num_rows($result); $sql_list = "select id,title,review,start from " . $reviewName . " where review =\n\t\t'{$a}' order by start desc limit " . $start . "," . $num; //选择能够往期回顾的信息 // echo $sql_list;die; $res_list = $db->execsql($sql_list); // var_dump($res_list); $file['details_dataBase'] = $reviewName; $file['list'] = $res_list; $file['num'] = mysql_num_rows($result); echo json_encode($file); } elseif ($list_type == "manager_show") { $sql = "select * from " . $reviewName; // echo $sql;die; $result = mysql_query($sql); $sql_list = "select id,title,review,start from " . $reviewName . " order by start desc limit " . $start . "," . $num; //选择要往期回顾的信息 // echo $sql_list;die; $res_list = $db->execsql($sql_list); $file['list'] = $res_list; $file['num'] = mysql_num_rows($result);
require_once '../../../common/php/regexTool.class.php'; //正则表达式匹配的类文件 $db = new DB(); $regex = new regexTool(); $type = $_GET['type']; if ($type == 'checkPage') { /**********************分页查询公司信息**************************/ $check_data = array(); $page = $_GET['page']; $num = 10; //每页显示10条 $start = ($page - 1) * $num; //本页显示的起始位置 // $sql_check="select * from wx_map limit ".$start.",".$num; $sql_check = "select * from wx_map order by isTop desc,convert(companyName USING gbk) COLLATE gbk_chinese_ci desc limit " . $start . "," . $num; $res_check = $db->execsql($sql_check); // 获取总数据 $sql_info_num = "select * from wx_map "; $res_info_num = $db->execsql($sql_info_num); $check_data['PageNum'] = ceil(count($res_info_num) / $num); $num_res = count($res_check); if ($num_res == 0) { $check_data['error'] = 0; //数据为空 } else { $check_data['check'] = $res_check; $check_data['error'] = 1; //数据不为空 } echo json_encode($check_data); } elseif ($type == 'checkFuzzy') {
switch ($menuType) { case 'picture': $mediaType = 0; $urlPC = '../../article/html/articlelist.html'; $wechat = "../../article/html/newslist.php?moduleId="; break; case 'video': $mediaType = 1; $urlPC = '../../article/html/videolist.html'; $wechat = ""; break; default: break; } $sql_insert_second = "insert into wx_articlelist_module (name,type,menuId,parentId,urlPC) values ('{$name}','{$mediaType}',0,'{$parentId}','{$urlPC}')"; $res_insert_second = $db->execsql($sql_insert_second); if (mysql_affected_rows() > 0) { $moduleid = mysql_insert_id(); if ($menuType == "picture") { $sql_update1 = "update wx_articlelist_module set urlWechat='" . $wechat . $moduleid . "' where id=" . $moduleid; $res_update1 = $db->execsql($sql_update1); } if (mysql_affected_rows() > 0) { echo 1; //操作成功 } else { echo 0; //操作失败 } } else { echo 0;
<?php /** * $type="showmenuPC":用于显示PC端左侧的菜单 */ header("content-type:text/json;charset=utf-8"); require_once './dbaccess.php'; $db = new DB(); $type = $_GET['type']; if ($type == "showmenuPC") { /* * 将菜单按级别输出名字和ID,用于PC端左侧菜单展示 */ //获取一级模块名称 $sql_menu = "select id,name,urlPC,menuType from wx_wechat_module where parentId=0 order by seq asc"; $res_menu = $db->execsql($sql_menu); //遍历获取二级模块名称 foreach ($res_menu as $key_First => $val_First) { //如果是文章列表类型的菜单,则输出moduleId $sql_type = "select name from wx_wechat_module_type where id='{$val_First['menuType']}'"; $res_type = $db->getrow($sql_type); // echo $sql_type;die; if ($res_type['name'] == "文章列表") { $sql_module = "select id from wx_articlelist_module where menuId='{$val_First['id']}'"; $res_module = $db->getrow($sql_module); $res_menu[$key_First]['moduleId'] = $res_module['id']; } //自身连接查询 $sql_second = "select s.id,s.name,s.urlPC,s.parentId,s.menuType from wx_wechat_module as s left join wx_wechat_module as p\n\t\ton s.parentId=p.id where p.id='{$val_First['id']}' order by s.seq asc"; $res_second = $db->execsql($sql_second); foreach ($res_second as $key_second => $val_second) {
define('SHOW_DIR', '../uploadfile/'); $db = new DB(); $act = $_REQUEST['act']; if ($act == "uploadpic") { //上传 $info = array(); $dest = uploadmulti('thumbpic', 0); $sql_count = "select count(*) as rsum from wx_profile"; $res = $db->getRow($sql_count); if (!$res) { $index = 1; } else { $index = $res['rsum'] + 1; } $sql_insert = "insert into wx_profile (picture,seq) values('" . $dest[0] . "'," . $index . ")"; $res = $db->execsql($sql_insert); if ($res) { $info["error"] = false; //上传成功 $info["dest"] = $dest[0]; $info["index"] = $index; } else { $info["error"] = true; //上传失败 } echo json_encode($info); } elseif ($act == "save") { //保存图片设置 $images = $_GET['images']; $separator = ":"; $images_array = explode($separator, $images);
*/ header("content-type:text/json;charset=utf-8"); // echo $path; require_once '../../../common/php/dbaccess.php'; require_once '../../../common/php/regexTool.class.php'; $db = new DB(); $regex = new regexTool(); $type = $_GET['type']; if ($type == "list") { /**********列出管理员信息**************/ $page = $_GET['page']; //获得当前页码 $num = 10; // 每页显示的条数 $sql_list1 = "select number,name from wx_admin "; $res_list1 = $db->execsql($sql_list1); $list['PageNum'] = ceil(count($res_list1) / $num); // 总页数 $start = ($page - 1) * $num; $sql_list = "select id,number,name from wx_admin limit " . $start . "," . $num; $res_list = $db->execsql($sql_list); if (empty($res_list)) { $list['error'] = 0; // 当前页为空 } else { $list['list'] = $res_list; } echo json_encode($list); } else { if ($type == "add") { /**********添加管理员帐号**************/