Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define('MODX_API_MODE', true);
- require_once(dirname(dirname(dirname(__FILE__))).'/index.php');
- $qIns=$modx->prepare("
- INSERT INTO dev_docke_trades (article, name, unitname, unitkod, price)
- VALUES (:article, :name, :unitname, :unitkod, :price) ON DUPLICATE KEY
- UPDATE name=:name, unitname=:unitname, unitkod=:unitkod, price=:price
- ");
- $qUpd=$modx->prepare("
- UPDATE modx_ms2_products SET price=:price WHERE article=:article
- ");
- $file = dirname(__FILE__).'/data/data.xml';
- $reader = new XMLReader();
- $reader->open($file); // читаем файл
- $doc = new DOMDocument;
- while ($reader->read() && $reader->name !== 'product');
- // Парсим все ноды продуктов
- while ($reader->name === 'product')
- {
- // Парсим ноду продукта в объект
- $node = simplexml_import_dom($doc->importNode($reader->expand(), true));
- // Пишем данные товара в DB
- writeToDB($node, $qIns);
- updateDB($node, $qUpd);
- // Переход к сдледущей ноде
- $reader->next('product');
- }
- function writeToDB($node, $qIns) {
- $qIns->execute(array(
- ':article' => $node->article,
- ':name' => $node->name,
- ':unitname' => $node->unitname,
- ':unitkod' => $node->unitkod,
- ':price' => $node->price
- ));
- }
- function updateDB($node, $qUpd) {
- $qUpd->execute(array(
- ':price' => $node->price,
- ':article' => $node->article
- ));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement