private function saveCountAction() { $fromType = $this->getFrom(); $pv = 1; $uv = 1; $insertArr = array('formtype' => $fromType, 'pv' => $pv, 'uv' => $uv, 'date' => date('Ymd', time())); $Smysql = middle::load('mysql'); $res = $Smysql->table('countdata')->where($insertArr)->sel(); print_r($res); }
<meta http-equiv="content-type" content="text/html;charset=utf-8"> <?php include 'lxapi/webApi.php'; $db = middle::load('mysql'); //加载middle中的load自动加载方法 $db->loadSql('db1', 1); # # 功能:分页 # $page = middle::load('page'); $page->setConf(1000, 10, '/page/', 5); $page_data = $page->showpage(); print_r($page_data); # # 功能:数据库执行 # //$sql = 'select * from tmall_list order by id desc '.$page->limit;//LIMIT 130,10 $result = $db->table('csm_ul_num')->where(array('num' => 65))->setFiles(array('id', 'wxdat'))->order('id desc')->limit('3')->selectAll(); $resultOne = $db->table('csm_ul_num')->where(array('id' => '96'))->selectOne(); print_r($resultOne); print_r($result); #$update = $db->table('csm_ul_num')->where(array('id' =>93))->update(array('num'=>65,'dat'=>1)); //print_r($update); #$insert = $db->table('csm_ul_num')->insert(array('num'=>65,'dat'=>1)); #print_r($insert); //$delete = $db->table('csm_ul_num')->where(array('id'=>98))->delete(); //print_r($delete); # # 功能:视图设置 # //$smarty = LxWeb::_Temp();
<?php /* * 内容详细页面 */ include 'lxapi/webApi.php'; $smarty = LxWeb::_Temp(); $db = middle::load('mysql'); //加载middle中的load自动加载方法 $db->loadSql('db1', 1); $arcInfo = $db->table('a_tmall_wx')->where(array('id' => intval($_GET['pid'])))->selectOne(); if (!$arcInfo) { die; } //print_r($arcInfo); $rightFirst = getRand(15); $smarty->assign('rightFirst', $rightFirst); $smarty->assign('arcInfo', $arcInfo); $smarty->display('a.html'); function getRand($limit = 10) { global $db; $arcList = $db->table('a_tmall_wx')->setFiles(array('title', 'id', 'shop_title', 'shop_pic'))->order('rand()')->limit($limit)->selectAll(); return $arcList; }
<?php include './../../lx/lx.php'; $ms = middle::load('mysql'); $ms->loadSql('db1', 1); print_r($ms);