鸿 网 互 联 www.68idc.cn

当前位置 : 服务器租用 > cms安装教程 > phpcms > >

phpcms2007中sql语句学习

来源:互联网 作者:佚名 时间:2015-08-18 08:54
SELECT * FROM ".TABLE_ADS." AS a LEFT JOIN ".TABLE_ADS_PLACE." AS p ON (a.placeid=p.placeid) WHERE a.placeid=".$placeid." AND a.fromdate=UNIX_TIMESTAMP() AND a.todate=UNIX_TIMESTAMP() AND p.passed=1 AND a.passed=1 AND a.checked=1 ORDER BY
SELECT * FROM ".TABLE_ADS." AS a LEFT JOIN ".TABLE_ADS_PLACE." AS p ON (a.placeid=p.placeid) WHERE a.placeid=".$placeid." AND a.fromdate<=UNIX_TIMESTAMP() AND a.todate>=UNIX_TIMESTAMP() AND p.passed=1 AND a.passed=1 AND a.checked=1 ORDER BY a.addtime
phpcms2007下拉框写法
$_adsplaces_select = "";
foreach ($_adsplaces as $r)
{
$_checked = ($placeid==$r['placeid'])?" selected":"";
$_adsplaces_select .= "<option value='{$r['placeid']}'{$_checked}>{$r['placename']}</option>";
}
$_adsplaces_select = "<SELECT name='placeid'>{$_adsplaces_select}</SELECT>";
$_values=$db->query("SELECT placeid,placename FROM ".TABLE_ADS_PLACE);
while($r=$db->fetch_array($_values))
{
    $_adsplaces[$r['placeid']] = $r;
}
$adsplacewhere = $adsplaceid?" and a.placeid={$adsplaceid}":"";
$adsplacewhere .= $ads_expired?" and a.todate<UNIX_TIMESTAMP()":" and a.todate>=UNIX_TIMESTAMP()";
$result=$db->query("SELECT count(*) as num FROM ".TABLE_ADS." as a left join ".TABLE_ADS_PLACE." as p on (a.placeid=p.placeid) where 1=1 and p.passed=1 {$adsplacewhere}");
$r=$db->fetch_array($result);
$number=$r['num'];
$adsplaces_select = "<select onchange='location.href=\"?mod=".$mod."&file=".$file."&action=manage&ads_expired=".$ads_expired."&adsplaceid=\"+this.value'><option value='0'>".$LANG['all_advertisement']."</option>";
foreach ($adsplaces as $place) {
$checked = ($place['placeid']==$adsplaceid)?" selected":"";
$adsplaces_select .= "<option value='{$place['placeid']}'{$checked}>{$place['placename']}</option>";
}
$adsplaces_select .= "</select>";
$query ="SELECT a.*,p.placename as placename,if(a.todate<UNIX_TIMESTAMP(),1,0) as passdate ".
   "FROM ".TABLE_ADS." as a left join ".TABLE_ADS_PLACE." as p on (a.placeid=p.placeid)".
    "where 1=1 and p.passed=1 {$adsplacewhere} "."order by a.addtime desc ".
    "limit $offset,{$PHPCMS['pagesize']}";
$result=$db->query($query);

circledong” 博客,谢绝转载!

网友评论
<