当前位置: 首页>>代码示例>>PHP>>正文


PHP SqlParser::htmlPreparedStatement方法代码示例

本文整理汇总了PHP中SqlParser::htmlPreparedStatement方法的典型用法代码示例。如果您正苦于以下问题:PHP SqlParser::htmlPreparedStatement方法的具体用法?PHP SqlParser::htmlPreparedStatement怎么用?PHP SqlParser::htmlPreparedStatement使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SqlParser的用法示例。


在下文中一共展示了SqlParser::htmlPreparedStatement方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: substr_replace

    }
    $sOrder = substr_replace($sOrder, "", -2);
    if ($sOrder == "ORDER BY") {
        $sOrder = "";
    }
    $query .= " {$sOrder} ";
}
if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
    $query .= " LIMIT " . $_GET['iDisplayStart'] . ", " . $_GET['iDisplayLength'];
}
$list = Database::find('review')->query($query);
$rowCount = (int) Database::find('review')->query_col('SELECT FOUND_ROWS()');
$totalCount = (int) Database::find('review')->query_col('SELECT COUNT(review.checksum) FROM ' . Database::escapeField($reviewhost['review_table']) . ' AS review');
$data = array();
$data['query'] = $query;
$data['sEcho'] = intval(@$_GET['sEcho']);
$data['iTotalRecords'] = $totalCount;
$data['iTotalDisplayRecords'] = $rowCount;
$data['aaData'] = array();
//$data['query']                  = $query;
while ($row = $list->fetch_assoc()) {
    $row['fingerprint'] = SqlParser::htmlPreparedStatement($row['fingerprint'], true);
    $dr = array();
    foreach ($aColumns as $col) {
        $dr[] = $row[$col];
    }
    $dr[] = '<a class="details" href="review.php?checksum=' . $row['checksum'] . '"><img src="images/details_open.png"></a>';
    $data['aaData'][] = $dr;
}
header('Content-type: application/json');
echo json_encode($data);
开发者ID:qbdsoft,项目名称:Query-Digest-UI,代码行数:31,代码来源:list-ajax.php

示例2:

require_once 'templates/header.php';
?>

<div class="tabs">
    <ul>
        <li><a href="#queryFingerprint">Fingerprint</a></li>
        <li><a href="#querySample">Example</a></li>
        <li><a href="#normalizedQuery">Normalized</a></li>
        <li><a href="pt-query-advisor.php?checksum=<?php 
echo $_REQUEST['checksum'];
?>
">Advisor</a></li>
        <li><a href="#queryReview">Review</a></li>
    </ul>
    <div id="queryFingerprint"><?php 
echo SqlParser::htmlPreparedStatement($reviewData['fingerprint']);
?>
</div>
    <div id="querySample">
		<div style="float: right">
			<button id="samplePrev"></button>
			<button id="sampleNext"></button>
		</div>
		<div id="querySampleContent"></div>
    </div>
    <div id="normalizedQuery">Please explain the query to view the normalized query.</div>
    <div id="queryReview">
        <form method="post">
            <label for="reviewed_by">Reviewed by </label> <input type="text" name="reviewed_by" value="<?php 
echo $reviewData['reviewed_by'];
?>
开发者ID:nettedfish,项目名称:Query-Digest-UI,代码行数:31,代码来源:review.php


注:本文中的SqlParser::htmlPreparedStatement方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。