PHP sp_execute_multi示例

示例#1

文件： order.php 项目： noikiy/Bentley

" size="12">
                        </div>
                        <button type="submit" class="btn btn-primary" style="margin-left:24px; width:100px;">查询</button>
                    </form>
                </div>
                <div class="col-sm-4" style="text-align:right">
                    <button onclick="location.href='order_export.php'" style="margin-left:24px; width:100px;" class="btn btn-default">导出明细</button>
                </div>
                <?php 
$mid = 0;
if (isset($_REQUEST["mid"])) {
    $mid = $_REQUEST["mid"];
}
//
$params = array(array(intval($_SESSION["cid"]), SQLSRV_PARAM_IN), array($mid, SQLSRV_PARAM_IN), array("" . $qdt, SQLSRV_PARAM_IN));
$rs = sp_execute_multi("{call web_canteen_query_orders(?,?,?)}", $params);
?>
                <div class="col-sm-12" style="height:40px; line-height:40px; text-align:right; font-size:13px; border-top:1px solid #ddd;">
                    <?php 
echo sprintf('查询日期：%s&nbsp;&nbsp;&nbsp;&nbsp;订单总数：%s&nbsp;&nbsp;&nbsp;&nbsp;总金额：￥%0.2f', $rs[0][0]["tdt"], $rs[0][0]["otn"], $rs[0][0]["pay_t"]);
?>
                </div>
                <table id="sample_1" class="table table-bordered table-condensed">
                    <thead>
                    <tr>
                        <th width="80px">订单编号</th>
                        <th width="120px">预订时间</th>
                        <th width="80px">姓名</th>
                        <th width="80px">部门</th>
                        <th width="120px">菜品名称</th>
                        <th width="80px">单价(元)</th>

示例#2

文件： overview_admin.php 项目： noikiy/Bentley

<?php

/**
 * Created by PhpStorm.
 * User: Applexiang
 * Date: 2015/8/3
 * Time: 17:45
 * 系统管理员首页
 */
?>
<div class="panel-title">微信用户基本统计</div>
<div class="panel-body">
    <?php 
$sp = "{call web_get_global_info}";
$rs = sp_execute_multi($sp, null);
$row1 = $rs[0][0];
$row2 = $rs[1][0];
?>
    <table class="table table-bordered tongji">
        <tbody>
        <tr>
            <th>公众平台数</th>
            <td><?php 
print_r($row1["ptt"]);
?>
</td>
            <th>餐厅总数</th>
            <td><?php 
print_r($row1["cantnum"]);
?>
</td>