print "testing updates...\n";
$testData['surname'] = 'design';
unset($testData['id']);
$adb->updateRecords('users', $testData, 'name');
$testData = $adb->fetchOne('users', ['surname' => 'design']);
if (!$testData) {
    goDead('Update test failed.');
}
if ($testData['surname'] != 'design') {
    goDead("Update test failed.\n");
}
$adb->deleteRecords('users', [1 => 1]);
$adb->insert('users', ['name' => 'Archangel', 'date' => '1']);
$adb->insert('users', ['name' => 'Design', 'date' => '1']);
$adb->updateRecords('users', ['name' => 'theName', 'surname' => 'theSurname', 'date' => '1'], 'date');
$records = $adb->fetchAll('users');
if (count($records) !== 2) {
    goDead("update failed. Wrong amount of records returned.");
}
foreach ($records as $record) {
    if ($record['name'] !== 'theName' || $record['surname'] !== 'theSurname') {
        goDead("update failed. Wrong data returned. " . print_r($records, true));
    }
}
print "[OK] updates work fine.\n";
/**
 *  ===== FETCH LIST =====
 */
print "running fetchList test...\n";
$adb->deleteRecords('users', ['1' => '1']);
$adb->insert('users', ['name' => 'Archangel', 'surname' => 'Design', 'date' => '791']);
Esempio n. 2
0
<?php

/**
 * Archangel DB 2
 * www.archangel-design.com
 * @author Rafal Martinez-Marjanski
 */
require 'autoload_register.php';
$adb = new \ArchangelDB\ADB2();
$res = $adb->tableExists('users');
die;
$res = $adb->insert('users', ['name' => 'Pascal', 'surname' => 'Picolo', 'date' => 'now()']);
var_dump($adb->getLastQuery());
var_dump($adb->lastInsertId());
var_dump($adb->updateRecords('users', ['id' => 34, 'name' => 'Pascal', 'date' => '321321321']));
var_dump($adb->getLastQuery());
var_dump($adb->fetchAll('users'));