예제 #1
0
// Fetch all
$arr_books = $obj_book_store->fetchAll("SELECT * FROM Book");
describeResult($arr_books);
// Fetch paginated
$obj_book_store->query('SELECT * FROM Book');
while ($arr_page = $obj_book_store->fetchPage(50)) {
    describeResult($arr_page);
}
// Retrieve multiple rows by ID
echo "Multi fetch:", PHP_EOL;
$arr_books = $obj_book_store->fetchByIds(['5692592335355904', '5149586599444480']);
foreach ($arr_books as $obj_book) {
    describeResult($obj_book);
}
$obj_store = new GDS\Store('Contact', $obj_gateway);
$arr_contacts = $obj_store->fetchByNames(['*****@*****.**', '*****@*****.**']);
foreach ($arr_contacts as $obj_contact) {
    echo "  Found: {$obj_contact->first_name}, {$obj_contact->last_name}", PHP_EOL;
}
/**
 * Helper function to simplify results display
 *
 * @param $mix_result
 * @param bool $bol_recurse
 */
function describeResult($mix_result, $bol_recurse = FALSE)
{
    if ($mix_result instanceof GDS\Entity) {
        $str_class = get_class($mix_result);
        echo "Found single result: [{$str_class}] {$mix_result->getKeyId()}, {$mix_result->title}, {$mix_result->isbn}, {$mix_result->author}", PHP_EOL;
    } elseif (is_array($mix_result)) {
예제 #2
0
파일: fetch.php 프로젝트: tomwalder/php-gds
// Fetch all
$arr_books = $obj_book_store->fetchAll("SELECT * FROM Book");
describeResult($arr_books);
// Fetch paginated
$obj_book_store->query('SELECT * FROM Book');
while ($arr_page = $obj_book_store->fetchPage(50)) {
    describeResult($arr_page);
}
// Retrieve multiple rows by ID
echo "Multi fetch:", PHP_EOL;
$arr_books = $obj_book_store->fetchByIds(['5692592335355904', '5149586599444480']);
foreach ($arr_books as $obj_book) {
    describeResult($obj_book);
}
$obj_store = new GDS\Store('Contact', $obj_gateway);
$arr_contacts = $obj_store->fetchByNames(['*****@*****.**', '*****@*****.**']);
foreach ($arr_contacts as $obj_contact) {
    echo "  Found: {$obj_contact->first_name}, {$obj_contact->last_name}", PHP_EOL;
}
/**
 * Helper function to simplify results display
 *
 * @param $mix_result
 * @param bool $bol_recurse
 */
function describeResult($mix_result, $bol_recurse = FALSE)
{
    if ($mix_result instanceof GDS\Entity) {
        $str_class = get_class($mix_result);
        echo "Found single result: [{$str_class}] {$mix_result->getKeyId()}, {$mix_result->title}, {$mix_result->isbn}, {$mix_result->author}", PHP_EOL;
    } elseif (is_array($mix_result)) {