public function index() { header('Content-Type:text/html;charset=utf-8'); require './home/Lib/Action/Public.php'; $g = M('goods'); //产品中心 $n = M('News'); //新闻表中的产品知识 $dz_goods = checkTrip($g->where('goods_dz > 0')->order('goods_addtime desc')->limit(0, 6)->select()); $new_goods = checkTrip($g->order('goods_addtime desc')->limit(0, 6)->select()); $zs = checkTrip($n->where('news_class = "产品知识"')->order('add_time desc')->having('sh = 1')->limit(10)->select()); foreach ($new_goods as $key => $val) { //最新商品图片随机显 $arr = explode('-', $val['goods_pics']); $c = count($arr) - 2; $new_goods[$key]['goods_pics'] = $arr[rand(0, $c)]; } foreach ($dz_goods as $key => $val) { //打折商品图片随机显 $arr = explode('-', $val['goods_pics']); $c = count($arr) - 2; $dz_goods[$key]['goods_pics'] = $arr[rand(0, $c)]; } $this->assign(array('dzgoods' => $dz_goods, 'newgoods' => $new_goods, 'zs' => $zs)); $this->display(); }
public function showGoods() { header('Content-Type:text/html;charset=utf-8'); require './home/Lib/Action/Public.php'; $g = M('goods'); //产品中心 $gid = intval($_GET['gid']); $goods = checkTrip($g->where('id=' . $gid)->find()); $this->assign(array('goods' => $goods)); $this->display(); }
public function index() { header('Content-Type:text/html;charset=utf-8'); require './home/Lib/Action/Public.php'; $j = M('job'); //招聘 import("ORG.Util.Page"); // 导入分页类 $count = $j->count(); $page = new Page($count, 6); $show = $page->show(); $job = checkTrip($j->order('add_time desc')->limit($page->firstRow . ',' . $page->listRows)->select()); $this->assign(array('job' => $job, 'page' => $show)); $this->display(); }
public function readMsg() { header('Content-Type:text/html;charset=utf-8'); load('extend'); // 导入扩展函数(对中文字符串的截取,过滤htm $m = M('msgs'); $mid = isset($_GET['mid']) ? intval($_GET['mid']) : 1; $list = checkTrip($m->where('m_id=' . $mid)->find()); $this->assign('list', $list); if ($list['isread'] != 1) { $data['m_status'] = 1; $m->where('m_id=' . $mid)->save($data); //更新为已读 } $this->display(); }
public function index() { header('Content-Type:text/html;charset=utf-8'); require './home/Lib/Action/Public.php'; $u = M('person'); $sname = $_SESSION['username']; // $username=$u->field('username,receiver,address,phonenumber')->where('username="******"')->select(); $userinfo = checkTrip($u->field(array('username', 'password', 'email', 'phonenumber', 'createtime'))->where('username="******"')->select()); // $this->assign( // "userlist",array( // 'username'=>$username, // )); $this->assign(array('userinfo' => $userinfo)); // '$username',array('username'=>'$username') // $this->assign('list',array('one'=>'a','two'=>'b')); $this->display(); }
public function index() { header('Content-Type:text/html;charset=utf-8'); session_start(); if (!isset($_SESSION['name'])) { $path = explode('/', __URL__, -1); $path = join('/', $path); header('Location:' . $path . '/login'); } else { //如果登录成功,则更新登录次数及更新时间 $user = M('user'); $list = checkTrip($user->field(array('loginnums', 'logintime'))->find()); if (!isset($_SESSION['isloginnums'])) { $data['loginnums'] = $list['loginnums'] + 1; $data['logintime'] = time(); $user->where('id=1')->save($data); } $_SESSION['isloginnums'] = true; $this->display(); } }
public function shownews() { header('Content-Type:text/html;charset=utf-8'); $id = $_GET['nid'] + 0; if ($id <= 0) { exit('非法操作'); } require './home/Lib/Action/Public.php'; $n = M('News'); //新闻中心 $news = checkTrip($n->where('id=' . $id)->find()); if (empty($news)) { exit('没有找到数据'); } //更新访问量 session_start(); $ip = $_SERVER['REMOTE_ADDR']; $_SESSION['ok'] = true; $djs = checkTrip($n->field('news_djs')->where('id=' . $id)->find()); $data['news_djs'] = $djs['news_djs'] + 1; $n->where('id=' . $id)->save($data); $this->assign(array('news' => $news)); $this->display(); }
public function addData() { header('Content-Type:text/html;charset=utf-8'); $l = M('link'); $_POST['l_overtime'] = strtotime($_POST['l_overtime']); //将日期格式化时间戳 if (isset($_FILES['l_logo'])) { //文件上传配置 import('ORG.Net.uploadFile'); $upload = new UploadFile(); // 实例化上传类 $upload->maxSize = 1000000; // 设置附件上传大小 $upload->allowExts = array('jpg', 'gif', 'png', 'jpeg'); // 设置附件上传类型 $upload->allowTypes = array('image/jpg', 'image/jpeg', 'image/pjpeg', 'image/png', 'image/gif'); $upload->savePath = './Public/Uploads/links/'; // 设置附件上传目录 $upload->saveRule = 'uniqid'; //缩略图配置 $upload->thumb = true; $upload->thumbMaxWidth = '160'; $upload->thumbMaxHeight = '60'; $upload->thumbPrefix = 's_'; $upload->thumbRemoveOrigin = true; //开始上传 if (!$upload->upload()) { $this->error($upload->getErrorMsg()); } else { $info = $upload->getUploadFileInfo(); } $_POST['l_logo'] = $info[0]['savename']; //判断用户在添加还是在修改(在已选择文件域的情况下) if (isset($_POST['act']) && $_POST['act'] == 'edit') { //修改 $data = $_POST; //取出原图片名称,进行删除 $id = isset($_POST['id']) ? intval($_POST['id']) : 0; $list = checkTrip($l->where('id=' . $id)->field('l_logo')->find()); $oldPic = './Public/Uploads/links/s_' . $list['l_logo']; unset($data['l_time']); if ($l->where('id=' . $id)->save($data)) { $this->success('更新成功'); unlink($oldPic); } else { $this->error('更新失败'); } } else { //添加 if ($l->create()) { if ($l->add()) { $this->success('保存成功'); } else { $this->error('保存失败'); } } else { $this->error(); } } } else { //没有选择LOGO的情况下修改文字 $data = $_POST; $id = isset($_POST['id']) ? intval($_POST['id']) : 0; unset($data['l_time']); unset($data['l_logo']); if ($l->where('id=' . $id)->save($data)) { $this->success('更新成功'); } else { $this->error('更新失败'); } } }
private function PublicCode($field, $tmp) { header('Content-Type:text/html;charset=utf-8'); $gs = M('company'); $list = checkTrip($gs->order('id')->find()); if (empty($list)) { echo '<script>alert("请先完成 \'公司的基本设置\' 再添加相册");location.href="./index.php"</script>'; echo '请先完成 <font style="font-weight:900; color:blue"><A href="./index.php">公司的基本设置</a></font> 再添加相册'; } else { $pics = $list[$field]; $this->assign('pics', $pics); $this->display($tmp); } }
public function editQq() { header('Content-Type:text/html;charset=utf-8'); $q = M('qq'); $qqs = checkTrip($q->find()); $q->create(); if (empty($qqs)) { if ($q->add()) { $this->success('添加成功'); } else { $this->error('没有数据被影响'); } } else { if ($q->where('id=1')->save()) { $this->success('更新成功'); } else { $this->success('没有数据被影响'); } } }
<?php require 'init.inc.php'; $c = M('config'); //网站配置 $l = M('cate'); //网站栏目 $a = M('link'); //友情链接 $gs = M('Company'); //公司配置 $q = M('qq'); //客服QQ //公共查询 $config = checkTrip($c->find()); $cate = checkTrip($l->order('px asc')->select()); $link = checkTrip($a->where('l_status=1')->select()); $company = checkTrip($gs->find()); $qq = checkTrip($q->find()); //分配变量 $this->assign(array('config' => $config, 'cate' => $cate, 'link' => $link, 'company' => $company, 'qq' => $qq));
public function fb() { $n = M('news'); $id = $_POST['id']; $list = checkTrip($n->field('sh')->where('id=' . $id)->find()); $data['sh'] = $list['sh'] == 0 ? 1 : 0; $n->where('id=' . $id)->save($data); }
public function classList() { header('Content-Type:text/html;charset=utf-8'); $c = D('goodsClass'); $list = checkTrip($c->field('id,name,pid,path,concat(path,"-",id) as bpath')->order('bpath')->select()); if (!empty($list)) { foreach ($list as $key => $val) { $list[$key]['count'] = count(explode('-', $val['path'])); } } $this->assign('list', $list); $this->display(); }
public function index() { header('Content-Type:text/html;charset=utf-8'); /*分页及扩展配置*/ load('extend'); // 导入扩展函数(对中文字符串的截取) import("ORG.Util.Page"); // 导入分页类 $order_table = M('order'); $count = $order_table->count(); $page = new Page($count, 12); $show = $page->show(); //条件筛选 // if (!isset($_GET['search'])){ // $list = checkTrip($order_table->order('order_time desc')->limit($page->firstRow.','.$page->listRows)->select()); // }else{ // $sql = ''; // $get = $_GET; // //栏目的筛选 // if (isset($_GET['search_class'])){ // $class = $_GET['search_class']; // if ($class !=''){ // $sql .= 'goods_class = "'.$class.'" '; // } // } // //打折与未打折的筛选 // if (isset($_GET['search_bzb'])){ // $val = $_GET['search_bzb']; // if ($val!='all'){ // $and = empty($sql) ? '' : 'and'; // $sql .= ($val==10) ? $and.' goods_dz > 1' : $and.' goods_dz = '.$val; // } // } // //筛选商品名称、货号 // if ($_GET['key'] != ''){ // $v = $_GET['key']; // $field = $_GET['namenum']; // $ha = $field.' like "%'.$v.'%"'; // } // //排序 // if (isset($_GET['order'])){ // $ziduan = $_GET['order']; // $px = $_GET['px']; // $order = $ziduan.' '.$px; // } // $sql = !($sql) ? 1 : $sql; // $ha = !($ha) ? 1 : $ha; // $c = count($g->where($sql)->having($ha)->order($order)->select()); // $page = new Page($c,12); // foreach ($get as $k2=>$v2){ // if ($get[$k2] === '') unset($get[$k2]); // } // foreach ($get as $k3=>$v3){ // $page->parameter .= "$k3=".urlencode($v3)."&"; // } $list = checkTrip($order_table->limit($page->firstRow . ',' . $page->listRows)->select()); $show = $page->show(); //关键字描红 // foreach($list as $key=>$val){ // $val[$field] = str_replace($v,'<b>'.$v.'</b>',$val[$field]); // $list[$key][$field] = $val[$field]; // } //} $this->assign(array('list' => $list, 'page' => $show)); $this->display(); }
public function delCate() { header('Content-Type:text/html;charset=utf-8'); $id = $_GET['id'] + 0; if (!$id) { return '请按正常流程操作'; } $c = M('cate'); $list = checkTrip($c->where('id=' . $id)->field('lmlogo')->find()); $oldPic = './Public/Uploads/lmlogo/' . $list['lmlogo']; if ($c->where('id=' . $id)->delete()) { echo '<script>alert("删除成功");location.href="' . __URL__ . '"</script>'; unlink($oldPic); } else { echo '<script>alert("删除失败");location.href="' + __URL__ + '"</script>'; } }
<?php session_start(); $userId = $_SESSION['user_Id']; include '../db-connection.php'; if ($_SERVER["REQUEST_METHOD"] == "POST") { $trip_id = $_POST['trip_id']; try { if (checkTrip($db, $userId, $trip_id)->fetch() != null) { $stmt = $db->prepare("DELETE t.* , c.* from trips t INNER JOIN comments c on t.trip_id = c.trip_id and t.trip_id = :trip_id"); $stmt->execute(array(':trip_id' => $trip_id)); echo "trip_deleted"; } else { echo "cannot_deleted"; } } catch (PDOException $e) { echo $e->getMessage(); } } function checkTrip($db, $userId, $trip_id) { $stmt = $db->prepare("SELECT * FROM trips WHERE user_id=:user_id AND trip_id=:trip_id"); $stmt->execute(array(":user_id" => $userId, ':trip_id' => $trip_id)); return $stmt; }