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