PHP DB_connectionの例

コード例 #1

ファイル: category_id_up.php プロジェクト: ratVien/test

<?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        ");

コード例 #2

ファイル: index_sent.php プロジェクト: Bombiz/Resume

    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;

コード例 #3

ファイル: fill_offers_up.php プロジェクト: ratVien/test

<?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>";
}

コード例 #4

ファイル: fill_category_id_up.php プロジェクト: ratVien/test

<?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>";
}

コード例 #5

ファイル: offers_up.php プロジェクト: ratVien/test

<?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        ");

コード例 #6

ファイル: fill_offers_down.php プロジェクト: ratVien/test

<?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};");