PHP Simplon\Mysql\Mysql::executeSql 예제들

예제 #1

파일: dbUsersTableCreate.php 프로젝트: shavez00/groceryList

<?php

require '../core.php';
try {
    $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'adminadmin', 'database' => 'GroceryList', 'fetchMode' => \PDO::FETCH_ASSOC, 'charset' => 'utf8', 'port' => 3306, 'unixSocket' => null);
    // standard setup
    $dbh = new \Simplon\Mysql\Mysql($config['host'], $config['user'], $config['password'], $config['database']);
    $success = $dbh->executeSql("CREATE TABLE Users (\nUserId MEDIUMINT(8) UNSIGNED AUTO_INCREMENT PRIMARY KEY, \nemail VARCHAR(255) NOT NULL\n)");
    if ($success) {
        echo "Table \"Users\" created.";
    }
} catch (Exception $e) {
    $message = json_decode($e->getMessage());
    echo $message->errorInfo->message . "</br>dbFoodInfoTableCreate.php - line 41";
}

예제 #2

파일: dbCreate.php 프로젝트: shavez00/groceryList

<?php

require '../core.php';
try {
    $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'adminadmin', 'database' => 'mysql', 'fetchMode' => \PDO::FETCH_ASSOC, 'charset' => 'utf8', 'port' => 3306, 'unixSocket' => null);
    // standard setup
    $dbh = new \Simplon\Mysql\Mysql($config['host'], $config['user'], $config['password'], $config['database']);
    $success = $dbh->executeSql("CREATE DATABASE GroceryList");
    if ($success) {
        echo "Database \"GroceryList\" created </br>Current existing databases</br>";
        $show = $dbh->getDbh();
        $databases = $show->query("SHOW DATABASES");
        $iterator = new \Simplon\Mysql\MysqlQueryIterator($databases, "fetch", \PDO::FETCH_NUM);
        $iterator->rewind();
        while ($iterator->valid()) {
            $row = $iterator->current();
            echo $row[0] . "</br>";
            $iterator->next();
        }
    }
} catch (Exception $e) {
    $message = json_decode($e->getMessage());
    echo $message->errorInfo->message . "</br>dbCreate.php - line 45";
}

예제 #3

파일: test-mysql.php 프로젝트: robertblackwell/simplon_mysql

$results = $dbh->fetchRow($query, $conds);
var_dump($results);
// ############################################
echo '<h3>fetchMany</h3>';
$results = $dbh->fetchRowMany($query, $conds);
var_dump($results);
// ############################################
echo '<h3>fetchManyCursor</h3>';
$counter = 0;
foreach ($dbh->fetchRowManyCursor($query, $conds) as $result) {
    echo '<h4>#' . ++$counter . ' cursor</h4>';
    var_dump($result);
}
// ############################################
echo '<h3>execute sql: truncate</h3>';
$response = $dbh->executeSql('TRUNCATE import_dump');
var_dump($response);
// ############################################
echo '<h3>insert</h3>';
echo '<h4>with ID response</h4>';
$data = ['id' => null, 'dump' => '{"message":"#One"}'];
$results = $dbh->insert('import_dump', $data);
var_dump($results);
echo '<h4>with NO-ID response</h4>';
$data = ['dump' => '{"message":"#One"}'];
$results = $dbh->insert('import_dump_no_id', $data);
var_dump($results);
// ############################################
echo '<h3>insertMany</h3>';
echo '<h4>with ID response</h4>';
$data = [['id' => null, 'dump' => '{"message":"Hello"}'], ['id' => null, 'dump' => '{"message":"Foo"}'], ['id' => null, 'dump' => '{"message":"Bar"}']];

예제 #4

파일: dbFoodTableCreate.php 프로젝트: shavez00/groceryList

<?php

require '../core.php';
try {
    $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'adminadmin', 'database' => 'GroceryList', 'fetchMode' => \PDO::FETCH_ASSOC, 'charset' => 'utf8', 'port' => 3306, 'unixSocket' => null);
    // standard setup
    $dbh = new \Simplon\Mysql\Mysql($config['host'], $config['user'], $config['password'], $config['database']);
    $success = $dbh->executeSql("CREATE TABLE Food (\nfoodId MEDIUMINT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, \ndescription VARCHAR(255) NOT NULL, \nUPC BIGINT(12) NULL, \ncategory VARCHAR(255) NOT NULL, \nnutritionalInfoId MEDIUMINT(12) NOT NULL\n)");
    if ($success) {
        echo "Table \"Food\" created.";
    }
} catch (Exception $e) {
    $message = json_decode($e->getMessage());
    echo $message->errorInfo->message . "</br>dbFoodInfoTableCreate.php - line 41";
}

예제 #5

파일: dbUtil.php 프로젝트: shavez00/groceryList

<?php

require 'core.php';
try {
    $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'adminadmin', 'database' => 'GroceryList', 'fetchMode' => \PDO::FETCH_ASSOC, 'charset' => 'utf8', 'port' => 3306, 'unixSocket' => null);
    // standard setup
    $dbh = new \Simplon\Mysql\Mysql($config['host'], $config['user'], $config['password'], $config['database']);
    $success = $dbh->executeSql("DROP DATABASE GroceryList");
    if ($success) {
        echo "Database \"GroceryList\" created </br>Current existing databases</br>";
        $show = $dbh->getDbh();
        $databases = $show->query("SHOW DATABASES");
        $iterator = new \Simplon\Mysql\MysqlQueryIterator($databases, "fetch", \PDO::FETCH_NUM);
        $iterator->rewind();
        while ($iterator->valid()) {
            $row = $iterator->current();
            echo $row[0] . "</br>";
            $iterator->next();
        }
    }
} catch (Exception $e) {
    $message = json_decode($e->getMessage());
    echo $message->errorInfo->message . "</br>dbCreate.php - line 45";
}

예제 #6

파일: dbNutritionalInfoTableCreate.php 프로젝트: shavez00/groceryList

<?php

require '../core.php';
try {
    $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'adminadmin', 'database' => 'GroceryList', 'fetchMode' => \PDO::FETCH_ASSOC, 'charset' => 'utf8', 'port' => 3306, 'unixSocket' => null);
    // standard setup
    $dbh = new \Simplon\Mysql\Mysql($config['host'], $config['user'], $config['password'], $config['database']);
    $success = $dbh->executeSql("Create Table NutritionalInfo (\nNutrionalinfoid Tinyint(6) Unsigned Auto_Increment Primary Key,\nCalories MEDIUMINT(6) Null,\nCaloriesUnit Char(2) Null,\nProtein MEDIUMINT(6) Null,\nProteinUnit Char(2) Null,\nFat MEDIUMINT(6) Null,\nFatUnit Char(2) Null,\nCarbohydrates MEDIUMINT(6) Null,\nCarbohydratesUnit Char(2) Null,\nSugars MEDIUMINT(6) Null,\nSugarsUnit Char(2) Null,\nFiber MEDIUMINT(6) Null,\nFiberUnit Char(2) Null,\nCalcium MEDIUMINT(6) Null,\nCalciumUnit Char(2) Null,\nIron Decimal(6,2) Null,\nIronUnit Char(2) Null,\nMagnesium MEDIUMINT(6) Null,\nMagnesiumUnit Char(2) Null,\nPotassium MEDIUMINT(6) Null,\nPotassiumUnit Char(2) Null,\nSodium MEDIUMINT(6) Null,\nSodiumUnit Char(2) Null,\nZinc MEDIUMINT(6) Null,\nZincUnit Char(2) Null,\n`Vitamin C` MEDIUMINT(6) Null,\nCUnit Char(2) Null,\nThiamin Decimal(6,4) Null,\nThiaminUnit Char(2) Null,\nRiboflavin Decimal(6,4) Null,\nRiboflavinUnit Char(2) Null,\nNiacin Decimal(6,4) Null,\nNiacinUnit Char(2) Null,\n`Vitamin B-6` Decimal(6,4) Null,\n`B-6Unit` Char(2) Null,\nFolate Decimal(6,4) Null,\nFloateUnit Char(2) Null,\n`Vitamin B-12` Decimal(6,4) Null,\n`B-12Unit` Char(2) Null,\n`Vitamin A` Decimal(6,4) Null,\nAUnit Char(2) Null,\n`Vitamin E` Decimal(6,4) Null,\nEUnit Char(2) Null,\n`Vitamin D` Decimal(6,4) Null,\nDUnit Char(2) Null,\n`Vitamin K` Decimal(6,4) Null,\nKUnit Char(2) Null,\nSaturated Decimal(6,4) Null,\nSaturatedUnit Char(2) Null,\nMonounsaturated Decimal(6,4) Null,\nMonounsaturatedUnit Char(2) Null,\nPolyunsaturated Decimal(6,4) Null,\nPolyunsaturatedUnit Char(2) Null,\nCholesterol Decimal(6,4) Null,\nCholesterolUnit Char(2) Null,\nCaffeine Decimal(6,4) Null,\nCaffeineUnit Char(2) Null\n)");
    if ($success) {
        echo "Table \"NutrionalInfo\" created.";
    }
} catch (Exception $e) {
    $message = json_decode($e->getMessage());
    echo $message->errorInfo->message . "</br>dbNutritionalInfoTableCreate.php - line 93";
}

예제 #7

파일: parse.php 프로젝트: HarryLyu/npl-bigdata-test-app

    $members = $vk->api('groups.getMembers', ['group_id' => $config['group_id'], 'fields' => 'sex,bdate', 'offset' => $request_count * $i, 'count' => $request_count]);
    echo 'Inserting them to database' . PHP_EOL;
    foreach ($members['items'] as $member) {
        $birth_date = null;
        if (isset($member['bdate'])) {
            $bdateParts = explode('.', $member['bdate']);
            $birth_date = count($bdateParts) == 3 ? implode('-', array_reverse($bdateParts)) : null;
        }
        $putMemeber = ['vk_id' => $member['id'], 'sex' => $member['sex'], 'birth_date' => $birth_date];
        try {
            $dbConn->insert('members', $putMemeber);
        } catch (Exception $e) {
        }
    }
}
$dbConn->executeSql('TRUNCATE interests;');
$request_count = 200;
$members_count = $dbConn->fetchRow('SELECT count(*) as c from members;')['c'];
$iterations_count = $members_count / $request_count;
for ($i = 0; $i < $iterations_count; $i++) {
    echo 'Fetching users ' . $request_count * $i . ' - ' . ($request_count * $i + $request_count) . PHP_EOL;
    $members = $dbConn->fetchRowMany('SELECT vk_id from members ORDER by vk_id LIMIT :skip, :limit;', ['skip' => $request_count * $i, 'limit' => $request_count]);
    $vk_ids = [];
    foreach ($members as $member) {
        $vk_ids[] = $member['vk_id'];
    }
    $vk_ids_string = implode(',', $vk_ids);
    $users = $vk->api('users.get', ['user_ids' => $vk_ids_string, 'fields' => 'interests']);
    if (!count($users)) {
        echo 'error 1 ';
        var_dump($users);

예제 #8

파일: dbGroceryListTableCreate.php 프로젝트: shavez00/groceryList

<?php

require '../core.php';
try {
    $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'adminadmin', 'database' => 'GroceryList', 'fetchMode' => \PDO::FETCH_ASSOC, 'charset' => 'utf8', 'port' => 3306, 'unixSocket' => null);
    // standard setup
    $dbh = new \Simplon\Mysql\Mysql($config['host'], $config['user'], $config['password'], $config['database']);
    $success = $dbh->executeSql("CREATE TABLE GroceryList (\ngroceryListId MEDIUMINT(8) UNSIGNED AUTO_INCREMENT PRIMARY KEY, \nuserId MEDIUMINT(8) NOT NULL,\ngroceryList VARCHAR(10000) NOT NULL\n)");
    if ($success) {
        echo "Table \"GroceryList\" created.";
    }
} catch (Exception $e) {
    $message = json_decode($e->getMessage());
    echo $message->errorInfo->message . "</br>dbFoodInfoTableCreate.php - line 41";
}