read_from_xml.php - master - StudentSp3/office_goods

read_from_xml.php
66 строк2 KB
Room405_admin
Initial commit
11 мар 2025, 10:50
11 мар 2025, 10:509169967
<?php
try{
    $conn_server = new PDO("mysql:host=localhost", "root", "" );
    echo "<br> ___Connected to server___ <br>";

    $conn_bd = new PDO("mysql:host=localhost;dbname=admin_test", "root", "" );
    echo "<br> ___ Connected to DB 'admin_test' ___ <br>";


    $xmlFile = 'c:/webdev/xampp/htdocs/test_bd/xml_test.xml';

    $tr = $conn_bd->beginTransaction();
    echo 'beginTransaction:'.$tr.'<br>'; 

    if (file_exists($xmlFile)) {
        $xml = simplexml_load_file($xmlFile);
        echo 'File:__   '.$xmlFile.'   ___ OPENED <br>';
    } else {
        exit('Не удалось открыть файл: '.$xmlFile.'<br>');
    }


    foreach ($xml->brands->value as $value) {
        echo 'BRAND :  '.$value["name"].' '.$value["id"].' '.$value["image"].'<br>';
        $stmt = $conn_bd->prepare("INSERT INTO catalog (name, id, description, image ) VALUES (:value1, :value2, :value3, :value4)");

        $stmt->bindParam(':value1', $value["name"]);
        $stmt->bindParam(':value2', $value["id"]);
        $stmt->bindParam(':value3', $value["description"]);
        $stmt->bindParam(':value4', $value["image"]);

        if($stmt->execute()){
            echo 'Записано в таблицу BRAND';
        }else {
            echo 'Ошибка записи в таблицу BRAND';
        };
    } 

    foreach ($xml->Country->value as $value) {
        echo 'Country :  '.$value["id"].' '.$value["name"].'<br>';
        $stmt = $conn_bd->prepare("INSERT INTO countries (id, name) VALUES (:value1, :value2)");

        $stmt->bindParam(':value1', $value["id"]);
        $stmt->bindParam(':value2', $value["name"]);

        $stmt->execute();
    } 

    foreach ($xml->specs->value as $value) {
        echo 'Specs :  '.$value["id"].' '.$value["name"].'<br>';
        $stmt = $conn_bd->prepare("INSERT INTO specs (id, name) VALUES (:value1, :value2)");

        $stmt->bindParam(':value1', $value["id"]);
        $stmt->bindParam(':value2', $value["name"]);

        $stmt->execute();
    }

    $tr_end=$conn_bd->commit();
    echo 'StopTransaction:'.$tr_end.'<br>';

}
catch (PDOException $e){
    echo "Database error: ".$e->getMessage();
}
?>