PHPize Online / SQLize Online  /  SQLtest Online

<?php try { $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die("Ошибка подключения к базе данных: " . $e->getMessage()); } $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, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); $data = json_decode($response, true); 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 "Нет данных для обработки."; } // use Carbon\Carbon; // $now = Carbon::now()->format('d/m/Y'); // printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); // $query = "SELECT VERSION() as version;"; // // get DB version using PDO // $stmt = $pdo->prepare($query); // $stmt->execute(); // $row = $stmt->fetch(PDO::FETCH_ASSOC); // printf('DB version (PDO): %s ' . PHP_EOL, $row['version']); // // Run query using mysqli // $result = $mysqli->query($query); // $version = $result->fetch_object(); // printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); // // Select using Laravel // $version = $db::select($query); // printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version);