< Ocs-server | Gfx4Revision as of 13:37, 28 July 2015 by Snizzo (talk | contribs) (Created page with "In Gfx there's the static class EDatabase which, if enabled, loads at the start of the script. It makes uses of a configuration file called ''database.conf.php'' that must con...")(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff) In Gfx there's the static class EDatabase which, if enabled, loads at the start of the script. It makes uses of a configuration file called database.conf.php that must contain correct values of a MySQL database. Works on more db drivers is in the roadmap. Small reference: EDatabase::q($sql_query) -> execute $sql_query EDatabase::sq($sql_query) -> execute $sql_query and returns the first result. Useful for counts etc. EDatabase::table_exists($table) -> check if table exists and return boolean. EDatabase::last_insert_id() -> returns the id of the last inserted row. Database functionalities can be enabled/disabled in the generic config file ("config/generic.conf.php"): Example: <?php die("You cannot see config in here."); ?> database|yes database|no database.conf.php Example of a valid configuration file: <?php die(); ?> name|test host|localhost user|root password|asd Retrieved from "https://community.kde.org/index.php?title=Ocs-server/Gfx4/Database&oldid=43486" Content is available under Creative Commons License SA 4.0 unless otherwise noted.