PHP opdGuardian 예제들

예제 #1

파일: test_querycache_2.php 프로젝트: BackupTheBerlios/openpb-svn

<?php

define('OPD_DIR', '../lib/');
require '../lib/opd.class.php';
try {
    $pdo = new opdClass('mysql:host=localhost;dbname=test', 'root', 'root');
    $pdo->debugConsole = true;
    $pdo->cacheDirectory = './cache/';
    $guard = new opdGuardian($pdo);
    $guard->lock('people READ');
    $guard->setCache('people2');
    $stmt = $guard->prepare('SELECT * FROM people WHERE id = :id ORDER BY id');
    $stmt->bindValue(':id', 5, PDO::PARAM_INT);
    $stmt->execute();
    echo '<ol>';
    while ($row = $stmt->fetch()) {
        echo '<li>' . $row['name'] . ' ' . $row['surname'] . '</li>';
    }
    echo '</ol>';
    $stmt->closeCursor();
    $guard->unlock();
} catch (PDOException $exception) {
    die('Exception: ' . $exception->getMessage());
}

예제 #2

파일: test_querycache_1.php 프로젝트: BackupTheBerlios/openpb-svn

<?php

define('OPD_DIR', '../lib/');
require '../lib/opd.class.php';
try {
    $pdo = new opdClass('mysql:host=localhost;dbname=test', 'root', 'root');
    $pdo->debugConsole = true;
    $pdo->cacheDirectory = './cache/';
    $guard = new opdGuardian($pdo);
    $guard->lock('people READ');
    $guard->setCache('people');
    $stmt = $guard->query('SELECT * FROM people ORDER BY id');
    echo '<ol>';
    while ($row = $stmt->fetch()) {
        echo '<li>' . $row['name'] . ' ' . $row['surname'] . '</li>';
    }
    echo '</ol>';
    $stmt->closeCursor();
    $guard->unlock();
} catch (PDOException $exception) {
    die('Exception: ' . $exception->getMessage());
}