Skip to content

Instantly share code, notes, and snippets.

@kopiro
Created January 29, 2014 16:32
Show Gist options
  • Select an option

  • Save kopiro/8691719 to your computer and use it in GitHub Desktop.

Select an option

Save kopiro/8691719 to your computer and use it in GitHub Desktop.
<?php
$db = new PDO('mysql:host=localhost;dbname=randomplaces', 'root', '');
for ($i=0; $i<500; $i++) {
$lat = rand(35,47).'.'.rand();
$lng = rand(9,20).'.'.rand();
$url = "https://maps.googleapis.com/maps/api/geocode/json?sensor=false&latlng=".$lat.",".$lng;
$json = json_decode(file_get_contents($url),1);
if (empty($json['results'])) continue;
$title = $json['results'][0]['formatted_address'];
$q = $db->prepare("INSERT INTO places (title, image, content, location, lat, lng) VALUES (?,?,?,?,?,?)");
$q->execute([ explode(',', $title)[0], 'http://lorempixel.com/640/480/city/'.rand(0,9), 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim', $title, $lat, $lng ]);
sleep(0.5);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment