/** * 获取表查询数据 * @param string $table 表名 * @param string $field 表字段 * @param string $where where条件 * @param string $order order by条件 * @return array 查询数据 */ public function getdata($table, $field = '*', $where = '', $order = '') { global $_M; /*获取表格ajax传递的参数*/ $length = $_M['form']['length']; //每页显示数量 $start = $_M['form']['start']; //读取数据的起点 $draw = $_M['form']['draw']; //累计执行次数,无作用但必须回传 if ($_M['form']['tablepage'] && $start == 0 & $draw == 1) { $cook = explode("|", $_M['form']['tablepage']); $u = "{$_M['form']['n']},{$_M['form']['c']},{$_M['form']['a']}"; if ($cook[1] == $u) { $start = $cook[0] * $_M['form']['length']; } } /*查询表*/ if ($where) { $conds .= " WHERE {$where} "; } if ($order) { $conds .= " ORDER BY {$order} "; } //整理查询条件 $query = "SELECT {$field} FROM {$table} {$conds} LIMIT {$start},{$length}"; //mysql语句 $array = DB::get_all($query); //执行查询,获得数组 $error = DB::error(); if ($error) { $this->error = $query . "<br />" . $error; } else { $this->error = ''; } $total = DB::counter($table, $conds, '*'); //获取总数量,计算总页数 /*回传数组处理*/ $this->rarray = array(); $this->rarray['draw'] = $draw; //回传执行次数 $this->rarray['recordsTotal'] = $total; //回传总数量 $this->rarray['recordsFiltered'] = $total; //回传筛选过的总数量,暂无作用,但必须回传 return $array; }
<!--<?php $msecount = DB::counter($_M['table']['infoprompt'], " WHERE lang='{$_M[lang]}' and see_ok='0'", "*"); echo <<<EOT --> \t <div class="metcms_top_right"> \t\t<div class="metcms_top_right_box"> \t\t\t<div class="metcms_top_right_box_div clearfix"> <!-- EOT; if ($_M['form']['iframeurl']) { function get($str) { $data = array(); $parameter = explode('&', end(explode('?', $str))); foreach ($parameter as $val) { $tmp = explode('=', $val); $data[$tmp[0]] = $tmp[1]; } return $data; } $str = $_M['form']['iframeurl']; $data = get($str); $_M['form']['anyid'] = $data['anyid']; $_M['form']['n'] = $data['n']; } $adminnav = get_adminnav(); $adminapp = load::mod_class('myapp/class/getapp', 'new'); $adminapplist = $adminapp->get_app(); if ($_M['form']['anyid'] == '44') { foreach ($adminapplist as $key => $val) { if ($val['m_name'] == $_M['form']['n']) {
public function dosetsave() { global $_M; $list = explode(",", $_M[form][allid]); $type = $_M[form][submit_type]; $i = 0; foreach ($list as $id) { if ($id) { $i++; if ($type == 'save' || !$type) { $name = $_M['form']['name-' . $id]; $defaultvalue = $_M['form']['defaultvalue-' . $id]; $valueinfo = $_M['form']['valueinfo-' . $id]; $type1 = $_M['form']['type-' . $id]; $tips = $_M['form']['tips-' . $id]; $selectd = $_M['form']['selectd-' . $id]; $style = $_M['form']['style-' . $id]; $no = $_M['form']['no']; $pos = $_M['form']['pos-' . $id]; $no_order = $i; if ($pos != $_M['form']['pos']) { $counter = DB::counter($_M['table']['templates'], " WHERE no='{$_M['form']['no']}' and pos='{$pos}' and lang='{$_M['form']['lang']}'", '*'); $no_order = $no_order + $counter; } $query = "\n\t\t\t\t\t\tno = '{$no}',\n\t\t\t\t\t\tpos = '{$pos}',\n\t\t\t\t\t\tno_order = '{$no_order}',\n\t\t\t\t\t\tname = '{$name}',\n\t\t\t\t\t\tdefaultvalue = '{$defaultvalue}',\n\t\t\t\t\t\tvalueinfo = '{$valueinfo}',\n\t\t\t\t\t\ttype\t = '{$type1}',\n\t\t\t\t\t\ttips\t = '{$tips}',\n\t\t\t\t\t\tselectd\t = '{$selectd}',\n\t\t\t\t\t\tstyle\t = '{$style}',\n\t\t\t\t\t\tlang = '{$_M['form']['lang']}'\n\t\t\t\t\t"; if (is_number($id)) { //修改 $query = "UPDATE {$_M['table']['templates']} SET {$query} WHERE id = '{$id}' "; } else { //新增 $query = "INSERT INTO {$_M['table']['templates']} SET value = '{$defaultvalue}', {$query} "; } } elseif ($type == 'del') { //删除 if (is_number($id)) { $query = "DELETE FROM {$_M['table']['templates']} WHERE id='{$id}' and pos = '{$_M['form']['pos']}' and lang='{$_M['form']['lang']}' "; } } DB::query($query); } } /*同步到其它语言*/ $query = "SELECT * FROM {$_M['table']['templates']} where no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' ORDER BY no_order,id"; $tems = DB::get_all($query); foreach ($_M['langlist']['web'] as $key => $val) { if ($key != $_M['form']['lang']) { $query = "DELETE FROM {$_M['table']['templates']} WHERE no='{$_M['form']['no']}' AND lang='{$key}'"; DB::query($query); foreach ($tems as $keytems => $valtems) { $query = "INSERT INTO {$_M['table']['templates']} SET no='{$valtems['no']}',pos ='{$valtems['pos']}',no_order='{$valtems['no_order']}',type='{$valtems['type']}',style='{$valtems['style']}',selectd='{$valtems['selectd']}',name ='{$valtems['name']}',value='{$valtems['value']}',defaultvalue='{$valtems['defaultvalue']}',valueinfo ='{$valtems['valueinfo']}',tips='{$valtems['tips']}',lang='{$key}'"; DB::query($query); } } } /*生成安装文件*/ load::sys_func('file'); $file = "templates/{$_M['form']['no']}/install/install.class.php"; makefile($file); $query = "SELECT * FROM {$_M['table']['skin_table']} where skin_file='{$_M['form']['no']}'"; $tem = DB::get_one($query); $query = "SELECT * FROM {$_M['table']['templates']} where no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' ORDER BY no_order,id"; $tems = DB::get_all($query); foreach ($tems as $keytems => $valtems) { $sql[] = "pos ='{$valtems['pos']}',no_order='{$valtems['no_order']}',type='{$valtems['type']}',style='{$valtems['style']}',selectd='{$valtems['selectd']}',name ='{$valtems['name']}',value='{$valtems['defaultvalue']}',defaultvalue='{$valtems['defaultvalue']}',valueinfo ='{$valtems['valueinfo']}',tips='{$valtems['tips']}'"; } $sql_info = var_export($sql, true); $info .= "\n\$sql = {$sql_info};\n\$no='{$_M['form']['no']}';\n\$devices='{$tem['devices']}';"; $str = file_get_contents(PATH_OWN_FILE . 'file/install.class.php'); $str = str_replace('/*<!--sql-->*/', $info, $str); file_put_contents(PATH_WEB . $file, $str); turnover("{$_M[url][own_form]}a=doset&no={$_M['form']['no']}&pos={$_M['form']['pos']}", '操作成功'); }