php - wordpress如何统计sql查询
问题描述
代码给出的输出如下:
1
1
它没有给出正确的答案。
<?php
global $wpdb;
$sql = "select gemeinde, count(*) as total from gemeinde where gemeinde= 'Barsbek' ";
$result = $wpdb->query($sql);
echo $result;
?>
解决方案
如果您想使用 puresql
而不是,wp_query
那么您的代码将是这样的:
global $wpdb;
$sql = "SELECT gemeinde FROM gemeinde WHERE gemeinde= 'Barsbek' ";
$result = $wpdb->get_results($sql);
echo $result->num_rows;
如果您希望您的结果以数组格式显示,那么您可以执行以下操作:
global $wpdb;
$sql = "SELECT gemeinde FROM gemeinde WHERE gemeinde= 'Barsbek' ";
$result = $wpdb->get_results($sql, ARRAY_A); // Notice you could pass ARRAY_A to get your results in array format
推荐阅读
- mysql - 谁能解释一下黑客等级二叉树节点的解决方案?
- arrays - 按升序对数组进行排序 - React js
- python - 一个不清楚的 requirements.txt 错误,导致无法安装
- angular - 错误在角度分量中显示两个不同的图像
- c - 如何使用 ncurses 获取所有当前可用的输入?
- javascript - SlickJS 功能仅适用于一张幻灯片
- python - Add roles command not working (discord.py rewrite)
- reactjs - Component not re-rendering after Context change
- css - How to create a div where it show a picture by default but transitions to some text details when you hover over it?
- python - Is it possible to modify/patch an unittest of odoo?