array(17) {
[0]=>
array(3) {
["userid"]=>
string(1) "5"
["username"]=>
string(12) "qq17664ppp9"
["articles"]=>
array(9) {
[0]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(8) "aa123456"
["pwd"]=>
string(8) "bb123456"
["state"]=>
string(12) "开通成功"
["gnickname"]=>
string(6) "苦呀"
["regtime"]=>
string(10) "1436616315"
}
[1]=>
array(6) {
["gamename"]=>
string(8) "SK彩票"
["user"]=>
string(9) "aa123456a"
["pwd"]=>
string(9) "aa123456a"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(6) "累呀"
["regtime"]=>
string(10) "1436616315"
}
[2]=>
array(6) {
["gamename"]=>
string(6) "皇冠"
["user"]=>
string(8) "aa147258"
["pwd"]=>
string(8) "aa147258"
["state"]=>
string(12) "开通成功"
["gnickname"]=>
string(6) "水啊"
["regtime"]=>
string(10) "1436616315"
}
[3]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(7) "a789789"
["pwd"]=>
string(8) "aaa12374"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(12) "黑色的你"
["regtime"]=>
string(10) "1436622305"
}
[4]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(6) "a54545"
["pwd"]=>
string(6) "25e844"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(12) "黑色买眼"
["regtime"]=>
string(10) "1436622543"
}
[5]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(6) "a99999"
["pwd"]=>
string(6) "3def28"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(4) "ppdf"
["regtime"]=>
string(10) "1436622664"
}
[6]=>
array(6) {
["gamename"]=>
string(0) ""
["user"]=>
string(7) "mm78945"
["pwd"]=>
string(6) "61ad34"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(9) "白色式"
["regtime"]=>
string(10) "1436623045"
}
[7]=>
array(6) {
["gamename"]=>
string(26) "SK2(时时彩,3D彩)"
["user"]=>
string(5) "tt789"
["pwd"]=>
string(6) "ed20ec"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(9) "我我我"
["regtime"]=>
string(10) "1436623110"
}
[8]=>
array(6) {
["gamename"]=>
string(12) "皇冠体育"
["user"]=>
string(6) "zz789a"
["pwd"]=>
string(6) "e8f748"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(6) "小眼"
["regtime"]=>
string(10) "1436623324"
}
}
}
[1]=>
array(3) {
["userid"]=>
string(1) "6"
["username"]=>
string(8) "tztmt001"
["articles"]=>
array(1) {
[0]=>
array(6) {
["gamename"]=>
string(7) "游戏B"
["user"]=>
string(9) "aa1472587"
["pwd"]=>
string(9) "aa1472587"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(6) "火啊"
["regtime"]=>
string(10) "1436616315"
}
}
}
[2]=>
array(3) {
["userid"]=>
string(1) "7"
["username"]=>
string(8) "tztmt002"
["articles"]=>
array(0) {
}
}
[3]=>
array(3) {
["userid"]=>
string(1) "8"
["username"]=>
string(6) "qwe123"
["articles"]=>
array(0) {
}
}
[4]=>
array(3) {
["userid"]=>
string(1) "9"
["username"]=>
string(6) "zxc123"
["articles"]=>
array(0) {
}
}
[5]=>
array(3) {
["userid"]=>
string(2) "10"
["username"]=>
string(7) "zxc1234"
["articles"]=>
array(0) {
}
}
[6]=>
array(3) {
["userid"]=>
string(2) "11"
["username"]=>
string(8) "zxc12345"
["articles"]=>
array(0) {
}
}
[7]=>
array(3) {
["userid"]=>
string(2) "12"
["username"]=>
string(9) "zxc123456"
["articles"]=>
array(0) {
}
}
[8]=>
array(3) {
["userid"]=>
string(2) "13"
["username"]=>
string(6) "zxc147"
["articles"]=>
array(0) {
}
}
[9]=>
array(3) {
["userid"]=>
string(2) "14"
["username"]=>
string(9) "zxc123888"
["articles"]=>
array(0) {
}
}
[10]=>
array(3) {
["userid"]=>
string(2) "15"
["username"]=>
string(14) "zxc123dsafdsag"
["articles"]=>
array(0) {
}
}
[11]=>
array(3) {
["userid"]=>
string(2) "16"
["username"]=>
string(11) "tztmt789456"
["articles"]=>
array(0) {
}
}
[12]=>
array(3) {
["userid"]=>
string(2) "17"
["username"]=>
string(8) "tadflsal"
["articles"]=>
array(0) {
}
}
[13]=>
array(3) {
["userid"]=>
string(2) "18"
["username"]=>
string(11) "liangheizhi"
["articles"]=>
array(0) {
}
}
[14]=>
array(3) {
["userid"]=>
string(2) "19"
["username"]=>
string(9) "tztmt0789"
["articles"]=>
array(0) {
}
}
[15]=>
array(3) {
["userid"]=>
string(2) "20"
["username"]=>
string(10) "dfsaklfdjs"
["articles"]=>
array(0) {
}
}
[16]=>
array(3) {
["userid"]=>
string(2) "21"
["username"]=>
string(9) "tztmt123a"
["articles"]=>
array(0) {
}
}
}这应该算是二维数组了,亲,我只需要查询出 ["gamename"]= "太阳城" 的数据其它都不要。这个SQL如何写 $Uid=session('uid');
$where = array();
$where['userid'] = session('uid');
$User = D("Users");
$map = array();
$gamename['gamename']='太阳城';
$map['articles']=array('EQ',$gamename);

$arr = $User->where($where and $map)->relation(true)->field('userid,username')->select();
var_dump($arr);
die();这是我写的。但是查不出来,,大哥,大姐们,帮帮忙

最佳答案

评论() 相关

收藏

赞

二进制

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。