This is deadth, Move to Laravel ;-)

PHP-Ado framework is a very simple PHP framework made for fast PHP proccessing and development, ADO + Basic Helper Classes to get you going on a development fast. The finality its to make our life easier and be able to develop faster.

To use this framewrok, choose one of the following options to get started:

• Download the latest release on ado.sunnyface.com
• Fork this repository on GitHub

Like all the frameworks we have to call something to load the rest of the classes, in this case "Session".

We can call the Session with no need of authentification in the form of:

$s = new Session(false);

of we can block a script with the need of being authentificated user by Session

$s = new Session();

if you want to see what session has just do a

printR($s);

"Access" its the class thats pulls all the /lib/models/ classes in the directory and creates an object of each class in the way of an object class. Performs DB queries on the models, but can also perform wide used functions.

Backups to a given directory $dir the Full database or it can $exclude tables.

$a->backup_tables($dir, $exclude = [])

$a->getValue($id, $table, $value=(String|Array), $separator = ' ');
$a->getMultiple($post_name, $union = ','); // $_POST : Array => String (coma separated)

Function to iterate $input_string (ej.: 1,34,67,88) and will return $nombre from $table

$a->getSubValues($input_string, $nombre, $table, $delimitador, $union, $link_url = '')

This functions will return an Input Select

$a->getCombo($input_name, $model_table, $pre_defined_value = '', $where = '', $order = '', $item_value = 'id', $css = '', $item_display = '');

$a->getComboAny(&$tabindex, $input_name, $model, $value = '', $where = '', $order = '', $key = 'id', $css = '', $display = '', $empty = '', $alternate_sql = '');

$a->getComboArrays(&$tabindex, $input_name, $value, $values=[], $css = 'class="form-control"', $empty_value = '');

• Update /lib/config.inc.php for the database name user, password.
• Update the RootPath and the pathSteps to match your hosting root folder in order to autoload the model classes.
• Prepare your database models in /lib/models/ - this is the base database model classes, will create the tables if necesary and if it found the method.

$user = new User();     // Creates a new user object
or
$user = $a->user->get(1); // Gets user with id = 1
$user->name = "John";
$user->email = "john@email.com";
$a->user->save($user);    // CREATE the user or UPDATE if the ID >0

$a its the main CRUD class it contains the model clasess, this way, using the ADO we can do a simple select with the following function:

$books = $a->books->select($where, $order);
$books = $a->books->select("manufacturer='Vintage'","creation_date ASC")

To perform a loop in the record we can do this simple with the following:

if ($books && $books->nr()>0){
  while($books->fetch($book)){
    echo $book->id . "\r";
    echo $book->name . "\r";
  }
}

Have a bug or an issue with this framework? Open a new issue here on GitHub or leave a comment on the contact page at Sunnyface.com.

Sunny PHP-ADO was created by and is maintained by Kiko Seijo, Managing Parter at Sunnyface.com.

Copyright 2011-2015 Sunnyface.com. Code released under the Apache 2.0 license.