本文整理汇总了PHP中DataList::SetParameter方法的典型用法代码示例。如果您正苦于以下问题:PHP DataList::SetParameter方法的具体用法?PHP DataList::SetParameter怎么用?PHP DataList::SetParameter使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataList
的用法示例。
在下文中一共展示了DataList::SetParameter方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: GetFolders
if($folder=="inbox"||$folder=='') $postuser = "发件人";
if(!empty($keyword)) $whereSql .= " AND (subject like '%".$keyword."%' OR message like '%".$keyword."%')";
if(!empty($username)) $whereSql .= " AND msgfrom like '%".$username."%'";
function GetFolders($me){
if($me=="track") return "发件箱";
else if($me=="inbox") return "收件箱";
else if($me=="outbox") return "草搞箱";
}
function IsReader($me){
$me = ereg_replace("[^0-1]","",$me);
if($me) return "<font color='green'>×</font>";
else return "<font color='red'>√</font>";
}
$sql = "SELECT * FROM #@__pms $whereSql ORDER BY dateline desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("folder",$folder);
$dlist->SetParameter("username",$username);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/member_pm.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
示例2: GetSta
function GetSta($sta)
{
if($sta==1) return "内页";
if($sta==2) return "首页";
else return "未审核";
}
$addquery = " where 1=1 ";
if($ischeck!=-1){
if($ischeck==3) $addquery .= " And ischeck>0 ";
else $addquery .= " And ischeck='$ischeck' ";
}
if(!empty($keyword)){
$addquery .= " And (url like '%$keyword%' OR webname like '%$keyword%') ";
}
$sql = "";
$sql = "Select * From #@__flink $addquery order by dtime desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("ischeck",$ischeck);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/friendlink_main.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
示例3: Dedesql
case "4":
//按肋记词
$query = "select * from #@__mainkc,#@__basic where #@__basic.cp_helpword LIKE '%" . $stext . "%' and #@__basic.cp_categories='{$cp_categories}' and #@__basic.cp_categories_down='{$cp_categories_down}' and #@__mainkc.p_id=#@__basic.cp_number";
break;
}
} else {
$query = "select * from #@__mainkc,#@__basic where #@__mainkc.p_id=#@__basic.cp_number";
}
//echo $query;
//exit();
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("cp_categories", $cp_categories);
$dlist->SetParameter("cp_categories_down", $cp_categories_down);
$dlist->SetParameter("sort", $sort);
$dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>所在仓库</td><td>库存</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['p_id'] . "</td><td> " . $row['cp_name'] . "</td><td>" . $row['cp_gg'] . "</td><td>" . get_name($row['cp_categories'], 'categories') . ">" . get_name($row['cp_categories_down'], 'categories') . "</td><td>" . get_name($row['cp_dwname'], 'dw') . "</td><td>¥" . $row['cp_jj'] . "</td><td>" . get_name($row['p_id'], 'gys') . "</td><td>" . get_name($row['l_id'], 'lab') . "</td><td><font color=red>" . $row['number'] . "</font></td><td><a href='system_kc_edit.php?pid=" . $row['cp_number'] . "&lid=" . $row['l_id'] . "&n=" . $row['number'] . "'>修改</a>|<a href='system_kc_del.php?action=del&id=" . $row['cp_number'] . "'>删除</a><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>";
}
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
$csql->close();
?>
示例4: Dedesql
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
if ($action == 'seek') {
if ($s_number == '') {
echo "<script>alert('请输入要退货的销售单号');history.go(-1);</script>";
}
$query = "select * from #@__sale where rdh='{$s_number}' and productid LIKE '%" . $stext . "%'";
} else {
$query = "select * from #@__sale";
}
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
$dlist->SetParameter("form", $form);
$dlist->SetParameter("field", $field);
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("s_number", $s_number);
$dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>售价</td><td>供应商</td><td>销售单号</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['productid'] . "</td><td> " . get_name($row['productid'], 'name') . "</td><td>" . get_name($row['productid'], 'gg') . "</td><td>¥" . getsale($row['productid']) . "</td><td>" . get_name($row['productid'], 'gys') . "</td><td>" . $row['rdh'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . get_name($row['productid'], 'name') . "' onclick=\"selectpro(this.value," . $row['productid'] . ",'" . get_name($row['productid'], 'gg') . "','" . get_name(get_name($row['productid'], 'dwname'), 'dw') . "')\"></td>\r\n</tr>";
}
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
示例5: IsExData
}
function IsExData($isex){
if($isex==0) return "未导出";
else return "已导出";
}
if($nid!=""){
$exportbt = "<input type='button' name='b0' value='导出采集内容' class='inputbut' style='width:100' onClick=\"location.href='co_export.php?nid=$nid';\"> ";
}
else{
$exportbt = "";
}
$sql .= "Select #@__courl.aid,#@__courl.nid,#@__courl.isex,#@__courl.title,#@__courl.url,";
$sql .= "#@__courl.dtime,#@__courl.isdown,#@__conote.gathername From #@__courl ";
$sql .= " left join #@__conote on #@__conote.nid=#@__courl.nid $where";
$sql .= " order by #@__courl.aid desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("nid",$nid);
$dlist->SetParameter("small",$small);
$dlist->SetSource($sql);
if($small==0) include(dirname(__FILE__)."/templets/co_url.htm");
else include(dirname(__FILE__)."/templets/co_url_2.htm");
$dlist->Close();
ClearAllLink();
?>
示例6: IsCheck
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");
$bgcolor = "";
if(!isset($keyword)) $keyword="";
if(!isset($typeid)) $typeid="0";
function IsCheck($st)
{
if($st==1) return "[已审核]";
else return "<font color='red'>[未审核]</font>";
}
$querystring = "select * from #@__feedback where CONCAT(#@__feedback.msg,#@__feedback.arctitle) like '%$keyword%' order by dtime desc";
$dlist = new DataList();
$dlist->pageSize = 10;
$dlist->Init();
$dlist->SetParameter("typeid",$typeid);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($querystring);
include(dirname(__FILE__)."/templets/feedback_main.htm");
$dlist->Close();
ClearAllLink();
?>
示例7: GetSta
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");
function GetSta($sta)
{
if($sta==1) return "正常";
else return "<font color='red'>禁用</font>";
}
function GetMan($sta)
{
if($sta==1) return "<u>禁用</u>";
else return "<u>启用</u>";
}
if(empty($keywords)) $keywords = "";
$sql = "Select * from #@__keywords order by rank desc";
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 300;
$dlist->SetParameter("f",$f);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/article_keywords_select.htm");
$dlist->Close();
ClearAllLink();
?>
示例8: GetAreaName
}
}
function GetAreaName($e,$df)
{
global $Areas;
if(isset($Areas[$e])) return $Areas[$e];
else return $df;
}
function GetMAtt($m){
if($m<1) return "";
else return "<img src='img/adminuserico.gif' width='16' height='15'><font color='red'>(荐)</font>";
}
$sql = "select ID,userid,pwd,uname,sex,email,money,c1,c2,c3,matt,
logintime,loginip,membertype,scores,spaceshow,pageshow
From #@__member $whereSql order by $sortkey desc
";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("sex",$sex);
$dlist->SetParameter("status",$status);
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
$dlist->SetTemplet(dirname(__FILE__)."/templets/member_main.htm");
$dlist->display();
$dlist->Close();
ClearAllLink();
?>
示例9: GetSta
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");
function GetSta($sta)
{
if($sta==1) return "";
else return " checked";
}
if(empty($keyword)){ $keyword = ""; $addquery = ""; }
else $addquery = " where keyword like '%$keyword%'";
$sql = "Select * from #@__keywords $addquery order by rank desc";
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 30;
$dlist->SetParameter("keyword",$keyword);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/article_keywords_main.htm");
$dlist->Close();
ClearAllLink();
?>
示例10: Dedesql
<tr>
<td> </td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong> 销售单管理</strong> - <a href="sale.php">新单</a></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$query = "select * from #@__reportsale";
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
$dlist->SetParameter("action", $action);
//设置GET参数表
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>ID</td><td>销售单号</td><td>操作人员</td><td>创单时间</td><td>保存状态</td><td>相关操作</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
if ($row['r_status'] == 1) {
$statusstring = "<img src='images/yes.png'>";
} else {
$statusstring = "<img src='images/no.png'>";
}
echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['r_dh'] . "</td><td> " . $row['r_people'] . "</td><td> " . $row['r_date'] . "</td><td> " . $statusstring . "</td><td><span onclick=showsubinfo(" . $row['id'] . ") style='cursor:hand;'>展开详情</span> | <a href=system_basic_del.php?id=" . $row['id'] . ">打印此单</a></td></tr>";
echo "<tr id='rk_subinfo" . $row['id'] . "' style='display:none;'><td colspan='6'><br><table width=\"98%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\" align=\"center\">";
$csql1 = new Dedesql(false);
$csql1->SetQuery("select * from #@__sale where rdh='" . $row['r_dh'] . "'");
$csql1->Execute();
示例11: Dedesql
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
if ($action == 'seek') {
if ($stext == '' || !is_numeric($stext) || $stext < 0) {
echo "<script>alert('请输入正确的数字');history.go(-1);</script>";
}
$query = "select * from #@__mainkc,#@__basic where #@__mainkc.number<'{$stext}' and #@__mainkc.p_id=#@__basic.cp_number";
} else {
$query = "select * from #@__mainkc,#@__basic where #@__mainkc.number<5 and #@__mainkc.p_id=#@__basic.cp_number";
}
$csql = new Dedesql(false);
$dlist = new DataList();
$dlist->pageSize = $cfg_record;
//设置GET参数表
if ($action == 'seek') {
$dlist->SetParameter("action", $action);
$dlist->SetParameter("stext", $stext);
}
$dlist->SetSource($query);
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>所在仓库</td><td>库存</td><td>选择</td></tr>";
$mylist = $dlist->GetDataList();
while ($row = $mylist->GetArray('dm')) {
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['p_id'] . "</td><td> " . $row['cp_name'] . "</td><td>" . $row['cp_gg'] . "</td><td>" . get_name($row['cp_categories'], 'categories') . ">" . get_name($row['cp_categories_down'], 'categories') . "</td><td>" . get_name($row['cp_dwname'], 'dw') . "</td><td>¥" . $row['cp_jj'] . "</td><td><a href='' title='查看与该供应商的数据'>" . get_name($row['p_id'], 'gys') . "</a></td><td><a href='' title='查看此仓库所有产品'>" . get_name($row['l_id'], 'lab') . "</a></td><td><font color=red>" . $row['number'] . "</font></td><td><a href='system_kc_edit.php?pid=" . $row['cp_number'] . "&lid=" . $row['l_id'] . "&n=" . $row['number'] . "'>修改</a>|<a href='system_kc_del.php?action=del&id=" . $row['cp_number'] . "'>删除</a><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>";
}
echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>";
echo "</table>";
$csql->close();
?>
</td>
</tr></form>
</table>
示例12: time
$nowtime = time();
$starttime = $nowtime - ($dtime*24*3600);
$where .= " And #@__log.dtime>'$starttime' ";
}
$sql = "Select #@__log.*,#@__admin.userid From #@__log
left join #@__admin on #@__admin.ID=#@__log.adminid
where 1=1 $where order by #@__log.lid desc";
$adminlist = "";
$dsql = new DedeSql(false);
$dsql->SetQuery("Select ID,uname From #@__admin");
$dsql->Execute('admin');
while($myrow = $dsql->GetObject('admin')){
$adminlist .="<option value='{$myrow->ID}'>{$myrow->uname}</option>\r\n";
}
$dsql->Close();
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 20;
$dlist->SetParameter("adminid",$adminid);
$dlist->SetParameter("cip",$cip);
$dlist->SetParameter("dtime",$dtime);
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/log_list.htm");
$dlist->Close();
ClearAllLink();
?>
示例13: And
$whereSql .= " And (arc.title like '%$keyword%' Or arc.keywords like '%$keyword%' Or arc.addinfos like '%$keyword%') ";
}
if($typeid!=0){
$tids = $tl->GetSunID($typeid,'',$channelid,true);
$whereSql .= " And arc.typeid in($tids) ";
}
$query = "
select arc.aid as ID,arc.typeid,arc.uptime,arc.channelid,arc.arcrank,arc.title,
arc.litpic,arc.adminID,arc.mid,t.typename,c.typename as channelname
from `#@__full_search` arc
left join #@__arctype t on t.ID=arc.typeid
left join #@__channeltype c on c.ID=arc.channelid
$whereSql
order by aid desc
";
$dlist = new DataList();
$dlist->pageSize = 20;
$dlist->SetParameter("dopost","listArchives");
$dlist->SetParameter("keyword",$keyword);
$dlist->SetParameter("cid",$cid);
$dlist->SetParameter("f",$f);
$dlist->SetParameter("arcrank",$arcrank);
$dlist->SetParameter("channelid",$channelid);
$dlist->SetSource($query);
include(dirname(__FILE__)."/templets/content_select_list.htm");
ClearAllLink();
?>
示例14: DedeSql
$CheckUserSend = "<input type='button' onClick=\"location='full_list.php?arcrank=-1&channelid=$channelid';\" value='稿件审核' class='inputbut'>";
}
if(empty($orderby)) $orderby = "aid";
$query = "
select a.aid,a.adminid,a.typeid,a.uptime,a.channelid,a.arcrank,a.click,a.title,a.litpic,a.adminid,a.mid,
t.typename,c.typename as channelname,adm.uname as adminname
from `#@__full_search` a
left join `#@__arctype` t on t.ID=a.typeid
left join `#@__channeltype` c on c.ID=a.channelid
left join `#@__admin` adm on adm.ID=a.adminid
$whereSql order by a.aid desc
";
$dsql = new DedeSql(false);
$dlist = new DataList();
$dlist->pageSize = 20;
$dlist->SetParameter("dopost","listArchives");
$dlist->SetParameter("keyword",$keyword);
$dlist->SetParameter("adminid",$adminid);
$dlist->SetParameter("memberid",$memberid);
$dlist->SetParameter("cid",$cid);
$dlist->SetParameter("arcrank",$arcrank);
$dlist->SetParameter("channelid",$channelid);
$dlist->SetParameter("ismember",$ismember);
$dlist->SetParameter("orderby",$orderby);
$dlist->SetSource($query);
include_once(dirname(__FILE__)."/templets/full_list.htm");
$dlist->Close();
ClearAllLink();
?>
示例15: DataList
if(empty($buyid)) $buyid = '';
$addsql = " where buyid like '%$buyid%' ";
if(isset($sta)){
$addsql .= " And sta='$sta' ";
}
$sql = "Select * From #@__member_operation $addsql order by aid desc";
$dlist = new DataList();
$dlist->Init();
$dlist->SetParameter("buyid",$buyid);
if(isset($sta)){
$dlist->SetParameter("sta",$sta);
}
$dlist->dsql->SetQuery("Select * From #@__moneycard_type ");
$dlist->dsql->Execute('ts');
while($rw = $dlist->dsql->GetArray('ts')){
$TypeNames[$rw['tid']] = $rw['pname'];
}
$dlist->SetSource($sql);
include(dirname(__FILE__)."/templets/member_operations.htm");
$dlist->Close();
ClearAllLink();