random-places.php

<?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);
	
}