Advertisement
Guest User

Untitled

a guest
Jan 15th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.33 KB | None | 0 0
  1. foreach ($arr as $v) {
  2.  
  3.    
  4.     foreach ($v as $v) {
  5.         $time = new DateTime($v['timestamp']);
  6.              $region=$v[0]['v'];
  7.             $number=$v[1]['v'];
  8.             $street=$v[2]['v'];
  9.             $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]);
  10.             $date=$time->format("Y-m-d H:i:s");
  11.    
  12.             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";
  13.  
  14.             $file= $v[0]['v'] .";". $v[1]['v'] .";". $v[2]['v'] . "; ". get($arr2, $v['ref'][0]) .";". "\n";
  15.             $str = iconv('UTF-8', 'CP1251', $file);
  16.         $csv.= $str;
  17.  
  18.        
  19.         /*$region=$v[0]['v'];
  20.             $number=$v[1]['v'];
  21.             $street=$v[2]['v'];
  22.             $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]);
  23.             $date=$date->format("Y-m-d H:i:s");
  24.             */
  25.         $query = mysqli_query($link,"INSERT INTO adress (region,number,street,location,date)
  26.                     VALUES ('$region','$number','$street','$location','$date')");
  27.                 if(mysqli_query($link,$query)){
  28.                 echo "OK";
  29.                 }
  30.             else {
  31.                 echo "Ошибка подключения";
  32.             }
  33.     }
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement