<?php /** * Created by PhpStorm. * User: LIS * Date: 06.11.2015 * Time: 13:52 */ require __DIR__ . '/../data/functions.php'; DB_connection()->exec("CREATE TABLE IF NOT EXISTS `category_id` (\n `id` int(4) NOT NULL AUTO_INCREMENT,\n `category` varchar(128) NOT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `name` (`category`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n ");
exit; } $send = isset($_GET['send']) ? $_GET['send'] : ""; $incomplet_last_name = ""; $incomplet_first_name = ""; $incomplet_email = ""; $valid_forum = "no"; if ($send == "yes") { $last_name = $_POST["last_name"]; $first_name = $_POST["first_name"]; $email = $_POST["email"]; if (GET_telephone()) { $telephone = $_POST['telephone']; } $validation_mail = ""; $conn = DB_connection($DB['db_host'], $DB['db_user'], $DB['db_pass'], $DB['db_name']); $sqlselect = "SELECT email FROM " . $table . " WHERE email = :email"; $stmnt = $conn->prepare($sqlselect); $stmnt->bindParam(':email', $email, PDO::PARAM_STR); $stmnt->execute(); if ($stmnt->fetch()) { $validation_mail = "no"; } if ($last_name == "") { $incomplet_last_name = "<br/><span class='warning'>Last name can't be blank</span>"; } else { $field_last_name = $last_name; $last_name_ok = "yes"; } if (GET_telephone()) { $tely = true;
<?php /** * Created by PhpStorm. * User: LIS * Date: 06.11.2015 * Time: 15:23 */ require __DIR__ . '/../data/functions.php'; $xml = file_get_contents('http://www.dvaproraba.ru/newexport/ngs.xml'); $xml1 = new SimpleXMLElement($xml); $table = 'offers'; $result = $xml1->xpath('/yml_catalog/shop/offers/offer'); foreach ($result as $data) { DB_connection()->exec("INSERT INTO {$table} (id, url, price, currencyId, categoryId, picture, vendor, model)\nVALUES ('{$data['id']}', '{$data->url}', '{$data->price}', '{$data->currencyId}', '{$data->categoryId}', '{$data->picture}', '{$data->vendor}', '{$data->model}')"); // echo $data[id], "<br>"; }
<?php /** * Created by PhpStorm. * User: LIS * Date: 06.11.2015 * Time: 14:23 */ require __DIR__ . '/../data/functions.php'; $xml = file_get_contents('http://www.dvaproraba.ru/newexport/ngs.xml'); $xml1 = new SimpleXMLElement($xml); $table = 'category_id'; $result = $xml1->xpath('/yml_catalog/shop/categories/category'); foreach ($result as $data) { DB_connection()->exec("INSERT INTO {$table} (id, category) VALUES ('{$data['id']}','{$data}')"); // echo $data[id], "<br>"; }
<?php /** * Created by PhpStorm. * User: LIS * Date: 06.11.2015 * Time: 15:01 */ require __DIR__ . '/../data/functions.php'; DB_connection()->exec("CREATE TABLE IF NOT EXISTS `offers` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `url` varchar(256) NOT NULL,\n `price` int(9) NOT NULL,\n `currencyId` varchar(4) NOT NULL,\n `categoryId` int(5) NOT NULL,\n `picture` varchar(256) NOT NULL,\n `vendor` varchar(256) NOT NULL,\n `model` varchar(256) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n ");
<?php /** * Created by PhpStorm. * User: LIS * Date: 06.11.2015 * Time: 15:52 */ require __DIR__ . '/../data/functions.php'; $xml = file_get_contents('http://www.dvaproraba.ru/newexport/ngs.xml'); $xml1 = new SimpleXMLElement($xml); $table = 'offers'; DB_connection()->exec("TRUNCATE TABLE {$table};");