wchampi/Edu

Librerias que simplifican la programación de sitios WEB y scripts PHP.

Edu

Db Manager:

Examples:

Ini Connection:

$db = Edu_Db_Manager::getInstance('default', 'host', 'dbname', 'user', 'password');

Get Connection:

$db = Edu_Db_Manager::getInstance('default');

Insert:

$idMovie = $db->insert('movie', array(
    'link' => "http://example.com",
    'name' => "Avengers",
    'date_create' => date('Y-m-d H:i:s')
));

Update:

$db->update('movie', array(
    'link' => "http://example2.com",
    'name' => "Avengers 2"
), 'id = ?', $idMovie);

FetchAll:

$query = "SELECT * "
    . " FROM movie a";
$movies = $db->fetchAll($query, $idMovie); // array(array('id' => 1, 'name' => 'Avenger'), array('id' => 2, 'name' => 'Hobbit'));

FetchOneBy:

$movie = $db->fetchOneBy('movie', 'id = ?', $idMovie); // array('id' => 1, 'name' => 'Avenger');

queryKeyVal:

$query = "SELECT id, name"
    . " FROM movie a";
$movie = $db->queryKeyVal($query);  // array('1' => 'Avenger', '2' => 'Hobbit');