Insert Php Mysql Example

[orkuncaylar]

<?php
    ob_start();
    date_default_timezone_set('Europe/Istanbul');
    setlocale(LC_MONETARY, "tr_TR");
    ini_set('session.gc_maxlifetime', 11000);
    ini_set('memory_limit', '256M');
    error_reporting(E_ALL);
    ini_set("display_errors", 1);

    $user = '';
    $pass = ';
    $dbname = '';
    $host = 'localhost';

    try {
        $conn = new PDO('mysql:host=' . $host . ';dbname=' . $dbname . ';charset=utf8', $user, $pass, [
            PDO::ATTR_EMULATE_PREPARES => false,
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ
        ]);
        $conn->exec("SET NAMES 'utf8'; SET CHARSET 'utf8'");
    } catch (PDOException $e) {
        print "HATA!:" . $e->getMessage() . "<br>";
        die();
    }

    $jsonFilePath = 'countries+states+cities.json';
    $jsonString = file_get_contents($jsonFilePath);
    $jsonData = json_decode($jsonString, true);

    foreach ($jsonData as $countryData) {
        processCountry($countryData, $conn);
    }

    $conn = null;
    ob_end_flush();

    function processCountry($countryData, $conn)
    {
        $countryName = $countryData['name'];
        $countryIso3 = $countryData['iso3'];
        $sqlCountry = "INSERT INTO countries (name, iso3) VALUES (?, ?)";
        $stmtCountry = $conn->prepare($sqlCountry);
        $stmtCountry->execute([$countryName, $countryIso3]);
        $countryId = $conn->lastInsertId();

        foreach ($countryData['states'] as $state) {
            $stateName = $state['name'];
            $sqlState = "INSERT INTO provinces (name, country_id) VALUES (?, ?)";
            $stmtState = $conn->prepare($sqlState);
            $stmtState->execute([$stateName, $countryId]);
            $stateId = $conn->lastInsertId();

            foreach ($state['cities'] as $city) {
                $cityName = $city['name'];
                $cityLatitude = $city['latitude'];
                $cityLongitude = $city['longitude'];
                $sqlCity = "INSERT INTO districts (name, latitude, longitude, province_id) VALUES (?, ?, ?, ?)";
                $stmtCity = $conn->prepare($sqlCity);
                $stmtCity->execute([$cityName, $cityLatitude, $cityLongitude, $stateId]);
            }
        }
    }
?>