4.查询要的字段
<p><strong>1.使用field函数查询要的字段</strong>
字段名用逗号分隔</p>
<pre><code class="language-php">$fields = "wx_name,wx_gender";
$res = Db::name('member')->field($fields)->select();</code></pre>
<p>查询结果如下:</p>
<pre><code>array(3) {
[0] => array(2) {
["wx_name"] => string(6) "peiwei"
["wx_gender"] => int(1)
}
[1] => array(2) {
["wx_name"] => string(6) "jiawei"
["wx_gender"] => int(1)
}
}</code></pre>
<p><strong>2.设置查询出来字段的别名</strong></p>
<pre><code class="language-php">$fields = "wx_name as name,wx_gender";
$res = Db::name('member')->field($fields)->select();</code></pre>
<p>查询结果如下:</p>
<pre><code>array(3) {
[0] => array(2) {
["name"] => string(6) "peiwei"
["wx_gender"] => int(1)
}
[1] => array(2) {
["name"] => string(6) "jiawei"
["wx_gender"] => int(1)
}
}</code></pre>