<?php /* Loading Autobahn -------------------------- */ require 'lib/autobahn.php'; $library = Autobahn::getConnection(array('driver' => 'mysql', 'host' => 'localhost', 'user' => 'root', 'password' => 'root', 'database' => 'spumer_db')); /* Classic SQL ---------------------------------------------------------- */ $users = $library->query('SELECT User.* FROM users User;'); /* Magic Find All --------------------------------- */ $users = $library->findAllUsers(); /* Magic Find Some ------------------------------------------------ */ $users = $library->findAllUsersById(array(1, 2)); /* Magic Find One ---------------------------------------------------------- */ $user = $library->findUsersByUsername('*****@*****.**'); /* Magic Insert ---------------------------------------------------------------------- */ $new_user = array('username' => '*****@*****.**', 'name' => 'Fake'); $library->insertUsers($new_user); /* Magic Update --------------------------------------------- */ $values = array('name' => 'Totally fake'); $conditions = array('username' => '*****@*****.**'); $library->updateUsers($values, $conditions); /* Magic Delete ---------------------------- */ $library->deleteUsersById(4); // TO-DO:
private static function getConfigClass() { if (!class_exists('DB_CONFIG')) { if (defined('AUTOBAHN_DB_CONFIG')) { require AUTOBAHN_DB_CONFIG; } else { trigger_error('No existe una base de datos configurada, tampoco un archivo de configuración definido.', E_ERROR); } } self::$__configs = get_class_vars('DB_CONFIG'); foreach (self::$__configs as $db => $config) { if (!isset($config['driver'])) { trigger_error('No "driver" in ' . $db . ' database configuration', E_ERROR); } if (!isset($config['host'])) { trigger_error('No "host" in ' . $db . ' database configuration', E_ERROR); } if (!isset($config['user'])) { trigger_error('No "user" in ' . $db . ' database configuration', E_ERROR); } if (!isset($config['password'])) { trigger_error('No "password" in ' . $db . ' database configuration', E_ERROR); } if (!isset($config['database'])) { trigger_error('No "database" name in ' . $db . ' configuration', E_ERROR); } } }
<?php require 'lib/autobahn.php'; define('AUTOBAHN_DB_CONFIG', AUTOBAHN_ROOT . 'db_config.php'); $library = Autobahn::getConnection('default'); // Classic SQL $authors = $library->query('SELECT Author.*, Book.* FROM authors Author, books Book WHERE Book.author_id = Author.id'); // Find (like Select) $book = $library->findBooksById(1); $books = $library->findAllBooks(); $favorite_books = $library->findAllBooksById(1, 2, 3, 4, 5); // Insert $newBook = array('id' => null, 'author_id' => 1, 'title' => 'Frameworks for languages'); $library->insertBooks($newBook); // Update $values = array('title' => 'Frameworks for PHP 5', 'description' => '...'); $conditions = array('id' => 1); $library->updateBooks($values, $conditions); // Delete $library->deleteBooksById(99); // Show stats of all queries :) ... only for CLI mode $library->showLogs();