本文整理匯總了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'];
?>