本文整理汇总了PHP中listquery函数的典型用法代码示例。如果您正苦于以下问题：PHP listquery函数的具体用法？PHP listquery怎么用？PHP listquery使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了listquery函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: foreach
<td width="102">分类</td>
<td width="251">粉丝数</td>
<td width="145">单图文报价</td>
<td width="145">多图文报价</td>
<td width="149">备注</td>
</tr>
</table>
<form action="add_weixin.php" method="post">
<table class="table_weibo_list" border="0" cellspacing="0" cellpadding="0" >
<?php
$so=$_GET['so'];//关键词
$numq=mysql_query("select id from tb_weixin where weixinname like '%$so%' or weixinhao like '%$so%'");
require_once 'page.php';
$list=listquery("select * from tb_weixin where weixinname like '%$so%' or weixinhao like '%$so%' order by id desc limit ".$num.",20");
foreach ($list as $v){
?>
<tr>
<td width="124" ><input name="numid[]" type="checkbox" value="<?=$v['id']?>" class="checkbox" style="margin-top:5px;" onclick="check();"/>选中发布</td>
<td width="105"><?=$v['weixinname']?></td>
<td width="143"><?=$v['weixinhao']?></td>
<td width="102"><?=$v['fenlei']?></td>
<td width="251"><?=$v['fensi']?></td>
<td width="145"><?=$v['dantuwen']?> 元</td>
<td width="145"><?=$v['duotuwen']?> 元</td>
<td width="149"><?=$v['beizhu']?></td>
</tr>
<?
}示例2: listquery
<option value="手机">手机</option>
<option value="教育">教育</option>
</select>
</td>
<td></td>
</tr>
<select name="area">
<option value="<?php
echo $row[area];
?>
"><?php
echo $row[area];
?>
</option>
<?php
$area = listquery("select * from city order by id asc");
foreach ($area as $v) {
?>
<option value="<?php
echo $v['cityname'];
?>
"><?php
echo $v['cityname'];
?>
</option>
<?php
}
?>
</select>
<tr>
<td>板块地址</td>示例3: listquery
<div class="footline"></div>
<div class="foot">
<div class="foots">
<?php
$link = listquery("select * from link order by paixu asc");
foreach ($link as $v) {
?>
<a href="<?php
echo $v['url'];
?>
" target="_blank">
<?php
echo $v['title'];
?>
</a>
<?php
}
?>
</div>
<div class="foots">
<?php
echo $sg['content'];
?>
</div>
</div>
<!--foot end-->示例4: listquery
include 'left.php';
?>
</div>
<!--left-->
<!--right-->
<div class="admin_right">
<table width="776" height="53" border="0" cellpadding="1" cellspacing="1" style="border: #CCCCCC 1px solid; text-align:center;">
<tr height="30">
<td width="112">会员级别</td>
<td width="109">充值金额</td>
<td width="104">消费折扣</td>
<td width="104">修改</td>
<td width="114">删除</td>
</tr>
<?php
$row = listquery("select * from level order by id asc");
foreach ($row as $v) {
?>
<tr height="30">
<td width="112"><?php
echo $v[level];
?>
</td>
<td width="109"><?php
echo $v[price];
?>
元 <input name="" id="chongzhi<?php
echo $v[id];
?>
" type="text" style="width:40px;" /></td>
<td width="104"><?php 示例5: mysql_query
<td width="138">订单编号</td>
<td width="100">用户名</td>
<td width="70">单图文价格</td>
<td width="70">多图文价格</td>
<td width="67">订单状态</td>
<td width="122">备注说明</td>
<td width="122">操作</td>
<td width="109">订单时间</td>
<td width="109">查看详情</td>
<td width="80">发布报表</td>
</tr>
<?php
$numq = mysql_query("select * from order_weixin {$sql}");
include 'page.php';
$row = listquery("select * from order_weixin {$sql} order by id desc limit " . $num . ",10");
foreach ($row as $v) {
?>
<tr>
<td width="86"><input name="del_id[]" type="checkbox" id="del_id[]" value="<?php
echo $v['id'];
?>
" /><input name="id" type="text" id="<?php
echo $v['id'];
?>
" value="<?php
echo $v['id'];
?>
" style="display:none;" /></td>
<td width="138"><?php
echo $v['orderID'];示例6: listquery
$shang = 1;
$next = 2;
$now = 1;
} else {
$next = $page + 1;
$now = $page;
$shang = $page - 1;
}
}
if ($totle == 1) {
$next = 1;
}
if ($next > $totle) {
$next = $totle;
}
$row = listquery("select * from user order by id desc limit " . $num . ",10");
foreach ($row as $v) {
?>
<tr>
<td width="106" height="33"><input name="del_id[]" type="checkbox" id="del_id[]" value="<?php
echo $v['user'];
?>
" /></td><input name="user[]" type="text" id="user[]" value="<?php
echo $v['user'];
?>
" style="display:none;" />
<td width="121"><a href="souser.php?username=<?php
echo $v[user];
?>
"><font color="blue"><?php
echo $v[user];示例7: listquery
?>
<!--head end-->
<div class="addbox">
<!--核心代码-->
<table width="1018" height="79" border="0" cellpadding="0" cellspacing="0" style="margin-left:20px; margin-top:10px;">
<tr>
<td width="243" height="45" style="color:blue; font-size:18px;">发布论坛水军顶贴文章</td>
<td width="642"></td>
</tr>
<tr>
<td width="243" height="34">所选产品</td>
<td width="642">
<?php
$numid = listquery("select * from ordertop where user='{$user}' and tb='tb_bbsdingtie'");
//查询ordertop 产品ID系列表
foreach ($numid as $v) {
$a = query("select * from tb_bbsdingtie where id='{$v['cpID']}'");
$cpID .= $v[cpID] . ',';
//产品ID
$price[] = $a['price'];
//产品价格
echo $a['bbs'];
echo ' <font color=red> ' . $a['price'] . '元</font>';
echo '<a href="?del_id=' . $v[id] . '"><font color=blue> 点击删除</font></a>' . '<br>';
}
$hbprice = array_sum($price);
echo '总计<font color=red> ' . $hbprice . '元</font>' . '<br>';
//查询用户 余额 权限 折扣
$cha = query("select * from user where user='{$user}'");示例8: mysql_query
</div>
<div class="uright">
<table width="953" height="38" border="0" cellpadding="0" cellspacing="0" class="order3">
<tr>
<td width="96">项目名称</td>
<td width="154">订单编号</td>
<td width="277">支付宝交易号</td>
<td width="117">充值金额</td>
<td width="108">充值方式</td>
<td width="201">时间</td>
</tr>
<?php
$numq = mysql_query("select id from alipay where user='{$user}' and type>0");
require_once 'page.php';
$list = listquery("select * from alipay where user='{$user}' and type>0 order by id desc limit " . $num . ",20");
foreach ($list as $v) {
$xrmb += $v['rmb'];
?>
<tr>
<td width="96"><?php
echo $v['title'];
?>
</td>
<td width="154"><?php
echo $v['orderID'];
?>
</td>
<td width="277"><?php
echo $v['alipayID'];
?>示例9: mysql_query
<td width="105">媒体</td>
<td width="105">媒体名称</td>
<td width="102">分类</td>
<td width="251" style="text-align:center;">链接</td>
<td width="143">会员价</td>
<td width="145">可否带链接</td>
<td width="145">是否收录</td>
<td width="149">备注</td>
</tr>
</table>
<form action="add_news.php" method="post">
<table class="table_weibo_list" border="0" cellspacing="0" cellpadding="0" >
<?php
$numq = mysql_query("select id from tb_news {$m}");
include 'page.php';
$row = listquery("select * from tb_news {$m} order by id desc limit " . $num . ",20");
foreach ($row as $v) {
?>
<tr>
<td width="124" ><input name="numid[]" type="checkbox" value="<?php
echo $v['id'];
?>
" class="checkbox" style="margin-top:5px;" onclick="check();"/>选中发布</td>
<td width="105"><?php
echo $v['meiti'];
?>
</td>
<td width="105"><?php
echo $v['mtname'];
?>
</td>示例10: query
<a href="" style="float:right; border:0px;">资源总数<?php
echo $tongji;
?>
条</a>
</div>
</div>
<!--page end-->
<?php
$sex = query("select count(id) from ordertop where user='{$user}' and tb='tb_bbszhiding'");
$xge = $sex['count(id)'];
if ($xge == 0) {
$xge = 0;
}
$sexd = listquery("select * from ordertop where user='{$user}' and tb='tb_bbszhiding' order by id desc");
foreach ($sexd as $ve) {
$vid = $ve[cpID];
$sexdd = query("select * from tb_bbszhiding where id='{$vid}'");
$showxuan .= '<a>' . $sexdd['bbs'] . '<a>' . '<a href="?del_id=' . $ve[id] . '"><font color=blue>点击删除</font></a>';
}
$del_id = $_GET['del_id'];
if ($del_id) {
mysql_query("delete from ordertop where id='{$del_id}'");
exit("<script>window.location.href='list_bbszhiding.php?caozuoid=pt7';</script>");
}
?>
<?php
include 'foot.php';
?>
</form>示例11: foreach
<td width="108">论坛</td>
<td width="283">论坛地址</td>
<td width="158">条数</td>
<td width="110">周期</td>
<td width="109">会员价</td>
<td width="156">备注</td>
</tr>
</table>
<form action="add_bbsdingtie.php" method="post">
<table class="table_weibo_list" border="0" cellspacing="0" cellpadding="0" >
<?php
$so=$_GET['so'];//关键词
$numq=mysql_query("select id from tb_bbsdingtie where bbs like '%$so%' or bbsadress like '%$so%'");
require_once 'page.php';
$list=listquery("select * from tb_bbsdingtie where bbs like '%$so%' or bbsadress like '%$so%' order by id desc limit ".$num.",20");
foreach ($list as $v){
?>
<tr>
<td width="127" ><input name="numid[]" type="checkbox" value="<?=$v['id']?>" class="checkbox" style="margin-top:5px;" onclick="check();"/>选中发布</td>
<td width="108"><?=$v['bbs']?></td>
<td width="283"><a href="<?=$v['bbsadress']?>" target="_blank"><?=$v['bbsadress']?></a></td>
<td width="158"><?=$v['num']?></td>
<td width="110"><?=$v['zhouqi']?></td>
<td width="109"><?=$v['price']?> 元</td>
<td width="156"><?=$v['beizhu']?></td>
</tr>
<?
}
?>示例12: query
<a href="" style="float:right; border:0px;">资源总数<?php
echo $tongji;
?>
条</a>
</div>
</div>
<!--page end-->
<?php
$sex = query("select count(id) from ordertop where user='{$user}' and tb='tb_dxwenzhang'");
$xge = $sex['count(id)'];
if ($xge == 0) {
$xge = 0;
}
$sexd = listquery("select * from ordertop where user='{$user}' and tb='tb_dxwenzhang' order by id desc");
foreach ($sexd as $ve) {
$vid = $ve[cpID];
$sexdd = query("select * from tb_dxwenzhang where id='{$vid}'");
$showxuan .= '<a>' . $sexdd['zishu'] . '字<a>' . '<a href="?del_id=' . $ve[id] . '"><font color=blue>点击删除</font></a>';
}
$del_id = $_GET['del_id'];
if ($del_id) {
mysql_query("delete from ordertop where id='{$del_id}'");
exit("<script>window.location.href='list_dxwenzhang.php?caozuoid=pt2';</script>");
}
?>
<?php
include 'foot.php';
?>
</form>示例13: listquery
$shang = 1;
$next = 2;
$now = 1;
} else {
$next = $page + 1;
$now = $page;
$shang = $page - 1;
}
}
if ($totle == 1) {
$next = 1;
}
if ($next > $totle) {
$next = $totle;
}
$row = listquery("select * from tb_dxwenzhang order by id desc limit " . $num . "," . $pageso . "");
foreach ($row as $v) {
?>
<tr>
<td width="90"><input name="del_id[]" type="checkbox" id="del_id[]" value="<?php
echo $v['id'];
?>
" /></td>
<td width="108"><?php
echo $v[zishu];
?>
</td>
<td width="78"><?php
echo $v[zhouqi];
?>示例14: mysql_query
</div>
<div class="uright">
<table width="953" height="38" border="0" cellpadding="0" cellspacing="0" class="order3">
<tr>
<td width="96">下线用户名</td>
<td width="96">订单编号</td>
<td width="96">消费名称</td>
<td width="96">实际付款</td>
<td width="96">给我提成金额</td>
<td width="96">日期</td>
</tr>
<?php
$numq = mysql_query("select * from ticheng_b where tuijie='{$user}' and type=1");
include 'page.php';
$row = listquery("select * from ticheng_b where tuijie='{$user}' and type=1 order by id desc");
foreach ($row as $v) {
?>
<tr>
<td width="96"><?php
echo $v['user'];
?>
</td>
<td width="96"><?php
echo $v['orderID'];
?>
</td>
<td width="96"><?php
echo $v['cpname'];
?>
</td> 示例15: htmlspecialchars
<form name="del_form" action="<?php
echo htmlspecialchars($_SERVER["PHP_SELF"]);
?>
" method="post">
<table width="953" height="38" border="0" cellpadding="0" cellspacing="0" class="order3">
<tr>
<td > 时间</td>
<td > 标题</td>
<td > 内容</td>
</tr>
<?php
$sqle = "select * from gonggao ";
$numq = mysql_query($sqle);
require_once 'page.php';
$list = listquery("select * from gonggao order by id desc limit " . $num . ",20");
//echo '<script>alert('.$list.');</script>' ;
foreach ($list as $v) {
?>
<tr>
<td width="150"> <input name="del_id[]" type="checkbox" id="del_id[]" value="<?php
echo $v['id'];
?>
" /> <?php
echo $v['time'];
?>
</td>
<td width="96"> <?php
echo $v['title'];
?>