connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$truncateTableQuery = "TRUNCATE TABLE pd_rimotech";
$conn->query($truncateTableQuery);
$getLinksQuery = "SELECT link FROM pd_links";
$result = $conn->query($getLinksQuery);
$totalLinks = $result->num_rows;
$currentLink = 0;
if ($totalLinks > 0) {
while ($row = $result->fetch_assoc()) {
$currentLink++;
$url = $row['link'];
$html = file_get_html($url);
$productName = $html->find('h1[itemprop=name]', 0)->plaintext;
$availability = $html->find('span[itemprop=availability]', 0)->plaintext;
// Convertir el precio a número
$priceText = $html->find('span#price', 0)->plaintext;
$price = floatval(preg_replace('/[^0-9.]/', '', $priceText));
$sku = $html->find('span#product_id', 0)->plaintext;
$productAvailability = $html->find('span.product_availability.availability-item', 0)->plaintext;
echo "Product Name: $productName\n";
echo "Availability: $availability\n";
echo "Price: $price\n";
echo "SKU: $sku\n";
echo "Product Availability: $productAvailability\n";
$sql = "INSERT INTO pd_rimotech (ProductName, Availability, price, sku, productAvailability) VALUES ('$productName', '$availability', '$price', '$sku', '$productAvailability')";
if ($conn->query($sql) === TRUE) {
echo "Record inserted successfully\n";
} else {
echo "Error: " . $sql . "
" . $conn->error . "\n";
}
// Calcular y mostrar el porcentaje de progreso
$percentage = ($currentLink / $totalLinks) * 100;
echo "Progress: " . number_format($percentage, 2) . "%\n";
}
} else {
echo "No links found in pd_links table\n";
}
$conn->close();
?>