Extraer datos de otra web

[tdcp]

Gracias ocp001a por tu respuesta... y disculpa si no he utilizado la herramienta, ahora lo hago. Pero díme, en qué ciclo incluirias tu el insert para que tome todos los datos?

Código PHP:

<?php
require("phpsqlsearch_dbinfo.php");
$connection=mysql_connect (localhost, $username, $password);
if (!$connection) {
die("Not connected : " . mysql_error());
}
 
// Set the active mySQL database
$db_selected = mysql_select_db($database, $connection);
mysql_query("SET NAMES utf8");
if (!$db_selected) {
die ("Can\'t use db : " . mysql_error());
}
 
$extrae = $_POST['url'];
$provincias = $_POST['county'];
$paises = $_POST['country'];
// Use internal libxml errors -- turn on in production, off for debugging
libxml_use_internal_errors(true);
// Createa a new DomDocument object
$dom = new DomDocument;
// Load the HTML
$dom->loadHTMLFile($extrae);
// Create a new XPath object
$xpath = new DomXPath($dom);
//Query all <td> nodes containing specified class name
$titulos = $xpath->query('//a[@class="url"]');
$telefonos = $xpath->query('//p[@class="tel"]');
$direcciones = $xpath->query('//span[@class="street-address"]');
$ciudades = $xpath->query('//a[@class="locality"]');
$lats = $xpath->query('//span[@class="latitude hidden"]');
$lngs = $xpath->query('//span[@class="longitude hidden"]');
// Set HTTP response header to text/html for debugging output
header('Content-type: text/html; charset=utf-8');
//Traverse the DOMNodeList object to output each DomNode's nodeValue
foreach ($titulos as $titulo) {
$name = ltrim($titulo->nodeValue);
echo $name."<br>";
}
foreach ($direcciones as $direccion) {
$address = $direccion->nodeValue;
echo $address."<br>";
}
foreach ($ciudades as $ciudad) {
$city = $ciudad->nodeValue;
echo $city." ".$provincias." ".$paises."<br>";
}
foreach ($telefonos as $telefono) {
$phone = $telefono->nodeValue;
echo $phone."<br>";
}
foreach ($lats as $lat) {
$latitud = $lat->nodeValue;
echo $latitud."<br>";
}
foreach ($lngs as $lng) {
$longitud = $lng->nodeValue;
echo $longitud."<br>";
}
$sqlins = "INSERT INTO markersprueba (name, address, city, county, country, phone, lat, lng, fecAlta) ".
"VALUES ('$name', '$address', '$city', '$provincias', '$paises', '$phone', '$latidud', '$longitud', CURDATE())";
$resultins = mysql_query($sqlins) or die("No se ha podido insertar el log".mysql_error());
?>