$node = [];
preg_match_all("/<span .*?\\/span>/", $info, $node);
foreach ($node[0] as $value) {
//var_dump( strpos($value,"dt"));
$data = [];
$data[] = preg_replace("/<.*?>/", '', $value);
if (strpos($value, "dt") === false) {
$data[] = 0;
} else {
$data[] = 1;
}
xiaok::log($data, '.node');
try {
$sth->execute($data);
} catch (Exception $ex) {
xiaok::log('[' . $ex->getCode() . ']' . $ex->getMessage(), '.node');
}
}
//exit;
}
//-------------------------------------------------------------导入站点信息
/*
//$db = new PDO("sqlite:data/17");
//$file = file("data/Content.csv");
//$sth = $db->prepare('INSERT INTO "main"."站点信息" ("站点名称", "附近有地铁") VALUES (?, ?)');
//foreach ($file as $line_num => $line) {
// $arr = explode(",",$line);
// // 插入站点信息
// $info = $arr[3];
<?php
require_once "xiaok.class.php";
//$path = "database/".$_REQUEST['sguid'].".log";
$sguid = isset($_REQUEST['sguid']) ? $_REQUEST['sguid'] : '';
//echo $path;
//var_dump($_REQUEST['sguid']);
if ($sguid == '' || is_null($sguid) || $sguid == 'null') {
$sguid = md5(uniqid());
//$path = "database/".$sguid.".log";
}
$data = [];
$data['sguid'] = $sguid;
$data['time'] = date("Y-m-d h:i:s", time());
$data['addr'] = isset($_REQUEST['addr']) ? $_REQUEST['addr'] : '';
$data['longitude'] = isset($_REQUEST['longitude']) ? $_REQUEST['longitude'] : '';
$data['latitude'] = isset($_REQUEST['latitude']) ? $_REQUEST['latitude'] : '';
$data['ug'] = $_SERVER['HTTP_USER_AGENT'];
xiaok::log($data, "INFO", '.geo');
echo $sguid;
