Skip to content
This repository has been archived by the owner on Feb 2, 2018. It is now read-only.

Query builder

Anthony Pilloud edited this page Mar 15, 2016 · 3 revisions

How it's works

##select example

$query = $dbc->select("titre")
	     ->from("page")
	     ->where("ID_page", "=", 1)
	     ->get();

insert example

$dbc = \core\App::getDb();

$dbc->insert("titre", "test")
    ->insert("contenu", "test")
    ->insert("url", "ma super url")
    ->insert("meta_description", "ma super meta")
    ->insert("balise_title", "ma super title balise")
    ->into("page")
    ->set();

update example

$dbc = \core\App::getDb();

$dbc->update("titre", "test")
    ->from("page")
    ->where("ID_page", "=", 2)
    ->set();

delete example

$dbc = \core\App::getDb();

$dbc->delete()
    ->from("page")
    ->where("ID_page", "=", 7)
    ->del();
Clone this wiki locally