21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
include_once "config.php";
header("Content-type: text/html; charset=utf8");
$mysql=mysqli_connect($db_host,$db_user,$db_password,$db_name);
mysql_select_db($db_name,$mysql);
mysql_query("SET NAMES 'utf8'");
mysql_query("set character_set_client='utf8'");
mysql_query("set character_results='utf8'");
mysql_query("set collation_connection='utf8'");
$user=$_GET['user'];
$lat=$_GET['lat'];
$lng=$_GET['lng'];
//获取地理地址
date_default_timezone_set('PRC');
$into_time=Date("Y-m-d H:i:s");
$url="http://api.map.baidu.com/geocoder/v2/?ak=E6f2d2e9e662917d0e6eee74ced3db24&callback=renderReverse&location=".$lat.",".$lng."&output=json&pois=1";
$json=file_get_contents($url);
$xjson = substr($json,29,-1);
$point = $lat.'_'.$lng;
$data=json_decode($xjson,true);
$dress = $data['result']['formatted_address'];
file_put_contents("localjson.txt",$data.'--dress--'.$dress);
// $g="select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid='".$user."')";
//多表查询
$g="select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '".$user."')";
$ids= mysql_query($g);
$n=@mysql_fetch_assoc($ids);
$f=$n['id'];
echo '--f--'.$f.'--g--'.$g;
?>
$mysql=mysqli_connect($db_host,$db_user,$db_password);
现在这个就是有i的阿[/quote]
谢谢,是这个错了,应该是mysql_query
$mysql=mysqli_connect($db_host,$db_user,$db_password);
现在这个就是有i的阿<?php
include_once "config.php";
header("Content-type: text/html; charset=utf8");
// $mysql=mysqli_connect($db_host,$db_user,$db_password,$db_name);
$mysql=mysqli_connect($db_host,$db_user,$db_password);
mysql_select_db($db_name,$mysql);
mysql_query("SET NAMES 'utf8'");
mysql_query("set character_set_client='utf8'");
mysql_query("set character_results='utf8'");
mysql_query("set collation_connection='utf8'");
$user=$_GET['user'];
$lat=$_GET['lat'];
$lng=$_GET['lng'];
trim($user);
//获取地理地址
date_default_timezone_set('PRC');
$into_time=Date("Y-m-d H:i:s");
$url="http://api.map.baidu.com/geocoder/v2/?ak=E6f2d2e9e66290e6eee74ced3db24&callback=renderReverse&location=".$lat.",".$lng."&output=json&pois=1";
$json=file_get_contents($url);
$xjson = substr($json,29,-1);
$point = $lat.'_'.$lng;
$data=json_decode($xjson,true);
$dress = $data['result']['formatted_address'];
// $g="select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid='".$user."')";
//多表查询
$g="select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '".$user."')";
// $g="select akw_user.mobile from akw_user left join user_group on akw_user.id=user_group.userid where user_group.sqlid='".$user."'";
$ids= mysql_query($g,$mysql) or die( $g .'<br>' . mysql_error());
$n=mysql_fetch_assoc($ids);
$f=$n['mobile'];
echo '--mobile--'.array($f).'--g--'.$g;
file_put_contents("localjson.txt",$data.'--dress--'.$dress.'-mobile-'.array($f));
?>
select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '1409203388')
Access denied for user 'root'@'localhost' (using password: NO)
[/quote][/quote]
那个我改为mobile了,现在的情况是Access denied for user 'root'@'localhost' (using password: NO)
select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '1409203388')
Access denied for user 'root'@'localhost' (using password: NO)
$ids= mysql_query($g,$mysql) or die( $g .'<br>' . mysql_error());
$g="select akw_user.mobile,akw_user.id from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '".$user."')";
$ids= mysql_query($g);
$n=@mysql_fetch_assoc($ids);
$f=$n['id'];
改这样试试。select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '1409203388')
Access denied for user 'root'@'localhost' (using password: NO)
[/quote]$g="select akw_user.mobile from akw_user where akw_user.id in (select user_group.userid from user_group where user_group.sqlid = '".$user."')";
$ids= mysql_query($g);
$n=@mysql_fetch_assoc($ids);
$f=$n['id'];
你的SQL查询里面仅仅获取了mobile 字段,但是你$f=$n['id'],貌似很不合理啊,获取一个没有select的字段,臣妾做不到啊