本文整理匯總了PHP中Sql::pSelectMapped方法的典型用法代碼示例。如果您正苦於以下問題：PHP Sql::pSelectMapped方法的具體用法？PHP Sql::pSelectMapped怎麽用？PHP Sql::pSelectMapped使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Sql的用法示例。
在下文中一共展示了Sql::pSelectMapped方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: foreach
$collations = Sql::pSelectMapped('SHOW VARIABLES LIKE "%collation%"');
foreach ($collations as $ch_name => $val) {
echo $ch_name . ' = ' . $val . '<br/>';
}
echo '<br/>';
// show MySQL query cache settings
$data = Sql::pSelectMapped('SHOW VARIABLES LIKE "%query_cache%"');
if ($data['have_query_cache'] == 'YES') {
echo '<h2>Query cache settings</h2>';
echo 'Type: ' . $data['query_cache_type'] . '<br/>';
//valid values: ON, OFF or DEMAND
echo 'Size: ' . formatDataSize($data['query_cache_size']) . ' (total size)<br/>';
echo 'Limit: ' . formatDataSize($data['query_cache_limit']) . ' (per query)<br/>';
echo 'Min result unit: ' . formatDataSize($data['query_cache_min_res_unit']) . '<br/>';
echo 'Wlock invalidate: ' . $data['query_cache_wlock_invalidate'] . '<br/><br/>';
// current query cache status
$data = Sql::pSelectMapped('SHOW STATUS LIKE "%Qcache%"');
echo '<h2>Query cache status</h2>';
echo 'Hits: ' . formatNumber($data['Qcache_hits']) . '<br/>';
echo 'Inserts: ' . formatNumber($data['Qcache_inserts']) . '<br/>';
echo 'Queries in cache: ' . formatNumber($data['Qcache_queries_in_cache']) . '<br/>';
echo 'Total blocks: ' . formatNumber($data['Qcache_total_blocks']) . '<br/>';
echo '<br/>';
echo 'Not cached: ' . formatNumber($data['Qcache_not_cached']) . '<br/>';
echo 'Free memory: ' . formatDataSize($data['Qcache_free_memory']) . '<br/>';
echo '<br/>';
echo 'Free blocks: ' . formatNumber($data['Qcache_free_blocks']) . '<br/>';
echo 'Lowmem prunes: ' . formatNumber($data['Qcache_lowmem_prunes']);
} else {
echo '<h2>MySQL query cache is disabled</h2>';
}示例2: getStats
/** Get statistics for specified poll */
static function getStats($type, $id)
{
$q = 'SELECT t1.categoryName, ' . '(SELECT COUNT(*) FROM ' . self::$tbl_name . ' WHERE type = ? AND value = t1.categoryId) AS cnt' . ' FROM tblCategories AS t1' . ' WHERE t1.ownerId = ?';
return Sql::pSelectMapped($q, 'ii', $type, $id);
}