Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- foreach ($arr as $v) {
- foreach ($v as $v) {
- $time = new DateTime($v['timestamp']);
- $region=$v[0]['v'];
- $number=$v[1]['v'];
- $street=$v[2]['v'];
- $location=get($arr2, $v['ref'][0], $v['ref'][1], $v['ref'][2], $v['ref'][3],$v['ref'][4], $v['ref'][5], $v['ref'][6], $v['ref'][7], $v['ref'][8], $v['ref'][9], $v['ref'][10]);
- $date=$time->format("Y-m-d H:i:s");
- echo "<tr><td align='center'>". $region . "</td><td align='center'>" . $number . "</td><td align='center'>" . $street. "</td><td>".$location."</td><td align='center'>".$date."</td></tr>"."\n";
- $file= $v[0]['v'] .";". $v[1]['v'] .";". $v[2]['v'] . "; ". get($arr2, $v['ref'][0]) .";". "\n";
- $str = iconv('UTF-8', 'CP1251', $file);
- $csv.= $str;
- /*$region=$v[0]['v'];
- $number=$v[1]['v'];
- $street=$v[2]['v'];
- $location=get($arr2, $v['ref'][0], $v['ref'][1], $v['ref'][2], $v['ref'][3],$v['ref'][4], $v['ref'][5], $v['ref'][6], $v['ref'][7], $v['ref'][8], $v['ref'][9], $v['ref'][10]);
- $date=$date->format("Y-m-d H:i:s");
- */
- $query = mysqli_query($link,"INSERT INTO adress (region,number,street,location,date)
- VALUES ('$region','$number','$street','$location','$date')");
- if(mysqli_query($link,$query)){
- echo "OK";
- }
- else {
- echo "Ошибка подключения";
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement