$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;