connect_error) {
die("Conexión fallida: " . $conn->connect_error);
}
mysqli_query($conn, 'TRUNCATE TABLE boton_promo_productos;');
mysqli_query($conn, 'TRUNCATE TABLE boton_promo_caracteristicas;');
mysqli_query($conn, 'TRUNCATE TABLE boton_promo_imagen_principal;');
$apiUrl = "https://esferos.com/site/api/products?output_format=JSON&ws_key=6QW5T3HTWPMREMYZQ8TW8FH3JY45YGGZ";
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// Obtener la lista de productos
curl_setopt($ch, CURLOPT_URL, $apiUrl);
$response = curl_exec($ch);
if (curl_errno($ch)) {
echo 'Error en cURL: ' . curl_error($ch);
}
$productList = json_decode($response, true);
if (isset($productList['products'])) {
$totalProducts = count($productList['products']);
$i = 0;
foreach ($productList['products'] as $product) {
$i++;
$porcentaje = $i * 100 / $totalProducts;
echo "";
flush();
ob_flush();
$productId = $product['id'];
$productDetailsUrl = "https://esferos.com/site/api/products/$productId?output_format=JSON&ws_key=6QW5T3HTWPMREMYZQ8TW8FH3JY45YGGZ";
// Obtener los detalles del producto
curl_setopt($ch, CURLOPT_URL, $productDetailsUrl);
$productDetailsResponse = curl_exec($ch);
if (curl_errno($ch)) {
echo 'Error en cURL: ' . curl_error($ch);
}
$productDetails = json_decode($productDetailsResponse, true);
// Extraer la información necesaria
$reference = $productDetails['product']['reference'];
$price = $productDetails['product']['price'];
$availableForOrder = $productDetails['product']['available_for_order'];
$visibility = $productDetails['product']['visibility'];
$metaTitle = $productDetails['product']['meta_title'];
$name = $productDetails['product']['name'];
$description = $conn->real_escape_string($productDetails['product']['description']);
$descriptionShort = $conn->real_escape_string($productDetails['product']['description_short']);
// Ejecutar la consulta preparada
$stmt->bind_param("ississsss", $productId, $reference, $price, $availableForOrder, $visibility, $metaTitle, $name, $description, $descriptionShort);
$stmt->execute();
// Actualizar el progreso
$counter++;
$progress = ($counter / $totalProducts) * 100;
echo "";
flush();
ob_flush();
}
}
curl_close($ch);
$conn->close();
?>