[code="java"]<?php
$con = mysql_connect("localhost","root","5555555551");
//mysql_query("SET NAMES 'UTF-8'");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("zuobiao",$con); //选择数据库
for ($i=1;$i<=5;$i++){
$x= mysql_query("select x,y from t1 order by DrugSId asc limit 1,$i");
$rs = mysql_fetch_array($x);
$cc=$rs['y'].",".$rs['x'];
//echo $cc."
";
$url="https://maps.googleapis.com/maps/api/place/search/json?language=zh-CN&location=$cc&&radius=500&sensor=false&key=AIzaSyCxLAQfEbXSARI3UD7_Nkj0WbVvQqnQuX0";
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$body=curl_exec($curl);
curl_close($curl);
$place=json_decode($body,true);
foreach ($place as $b){
foreach((array)$b as $c){
if(!is_array($c))
continue;
$d=$c['name'].",";
//echo $d;
$sql=mysql_query("insert into t1(keywords) values ('$d')");
// echo $sql
// or die ('SLQ Syntax error '.mysql_error());
if ($d == null){
continue;}
}
}
}
?>
[/code]
数据库结构如下
[img]http://dl.iteye.com/upload/attachment/0073/0323/41ad7c14-c43d-3877-9bcc-6603a329135f.jpg[/img]
如果直接输出$d,是正常的,可以获得一串地名,但是如果插入数据库就只能获得一串地名中的一项.请问哪个地方写错了,如何修改?
为方便各位高手调试,给出1-5之内的数据
[img]http://dl.iteye.com/upload/attachment/0073/0340/f7b747fd-9bf0-3a2b-bc77-e3298e7f7a71.jpg[/img]