PHP Autobahn Examples

Example #1

File: index.php Project: bogue89/Autobahn

<?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:

Example #2

File: autobahn.php Project: soska/Autobahn

 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);
         }
     }
 }

Example #3

File: index.php Project: soska/Autobahn

<?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();