Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
// $db_host = 'localhost';
// $db_user = 'username';
// $db_pass = 'password';
// $db_name = 'dbname';
// $route = isset($_GET['route']) ? $_GET['route'] : 'products';
// $queryParam = isset($_GET['search']) ? '&q=' . $_GET['search'] : '';
// $url = 'https://dummyjson.com/' . $route . '?limit=100' . $queryParam;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://dummyjson.com/docs/products');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
curl_close($ch);
print_r($response);
$data = json_decode($response, true);
// var_dump($data);
// if ($data && isset($data['products'])) {
// foreach ($data['products'] as $item) {
// $title = $item['title'];
// $brand = $item['brand'];
// $category = $item['category'];
// $thumbnail = $item['thumbnail'];
// $price = $item['price'];
// $sql = "INSERT INTO products (title, brand, category, thumbnail, price)
// VALUES (:title, :brand, :category, :thumbnail, :price)";
// try {
// $stmt = $pdo->prepare($sql);
// $stmt->execute(array(
// ":title" => $title,
// ":brand" => $brand,
// ":category" => $category,
// ":thumbnail" => $thumbnail,
// ":price" => $price
// ));
// } catch (PDOException $e) {
// echo "Ошибка при сохранении продукта: " . $e->getMessage() . "\n";
// }
// }
// echo "Данные успешно импортированы!";
// } else {
// echo "Нет данных для обработки.";
// }