bbn/bbn

dev-master 2017-10-10 10:29 UTC

README

Join the chat at https://gitter.im/nabab/bbn

A simple PHP framework targeted at Single Page Application.

Check out the Documentation.

This library includes:

  • a Database class, working with mySQL and SQLite: supports database analysis and plenty of return methods
  • a History class allowing to store each change done in the database and revert them
  • files, images, and PDF files manipulation classes
  • HTML generation classes
  • various string classes
  • users management classes
  • an MVC framework
  • various tools

Usage

A quick example:

<?php
$db = new \bbn\db($cfg);

\bbn\x::hdump($db->modelize("my_table_name"));

\bbn\x::dump($db->get_rows("SELECT * FROM my_table_name WHERE status = ?", $var));

\bbn\x::hdump($db->select(
  "my_table_name", // table
  ["field1", "field2"], // columns
  ["id" => 25] // WHERE
));

\bbn\x::dump($db->rselect_all(
  "my_table_name", // table
  [], // all columns
  [["id", "<", 25], ["name", "LIKE", "tri%"]], // WHERE
  ["date" => DESC, "name"], // ORDER
  50, // LIMIT
  20 // START 
));

\bbn\x::hdump($db->get_var("SELECT id FROM mytable WHERE name LIKE ?", "tri%"));

API DOCS