function readNew()
{
/*$content=file_get_contents("newest.wn");
$data=explode(";",$content);
//data[0]->longitude
//data[1]->latitude
$data[0]=explode("=",$data[0]);
$data[1]=explode("=",$data[1]);
$data[2]=explode("=",$data[2]);
$res[$data[0][0]]=$data[0][1];
$res[$data[1][0]]=$data[1][1];
$res[$data[2][0]]=$data[2][1];
return $res;*/
try {
$pdo = new PDO("mysql:host=localhost;dbname=ncu", $user, $password);
} catch (PDOException $e) {
echo $e->getMessage();
}
$lm = new locationManager($pdo);
$all = $lm->getAll();
$newest = 0;
$lat = $all[count($all) - 1]->getLat();
$long = $all[count($all) - 1]->getLong();
$res = array();
$res['longitude'] = $long;
$res['latitude'] = $lat;
$res['count'] = count($all) - 1;
return $res;
}
}
$count = 0;
do {
if (($msgsock = socket_accept($sock)) < 0) {
echo "socket_accept() failed: reason: " . socket_strerror($msgsock);
break;
} else {
//发到客户端
socket_write($msgsock, $msg, strlen($msg));
$buf = socket_read($msgsock, 8192);
//$talkback = "收到的信息:$buf\n";
//连接数据库进行存储
try {
$pdo = new PDO("mysql:host=localhost;dbname=ncu", $user, $password);
} catch (PDOException $e) {
echo $e->getMessage();
}
$lm = new locationManager($pdo);
//lat,long;
$buf_exploded = explode(";", $buf);
foreach ($buf_exploded as $key => $value) {
$locationDetail = explode(',', $value);
$lm->insertLocation($locationDetail[0], $locationDetail[1]);
}
if (++$count >= 5) {
break;
}
}
socket_close($msgsock);
} while (true);
socket_close($sock);
<?php
require 'mysql/usemysql.php';
try {
$pdo = new PDO("mysql:host=localhost;dbname=ncu", $user, $password);
} catch (PDOException $e) {
echo $e->getMessage();
}
$lm = new locationManager($pdo);
$all = $lm->getAll();
$newest = 0;
$lat = $all[count($all) - 1]->getLat();
$long = $all[count($all) - 1]->getLong();
header('location:req.php?latitude=' . $lat . '&longitude=' . $long);
