Downloading data
To download data you must first create an object for the specific table, then on the newly formed object call out one of the standard methods or other ones available for this table.List of basic methods you can use
- select($where = null, $order = null, $what = '*',$limit = null, $groupby = null, $bindValues = array() )
- insert(array $data = array())
- update($column, $value, $where, $bindValues = array() )
- updateRow($data, $where, $bindValues = array() )
- deleteRows($where, $bindValues = array() )
- delete($id)
- fetchRow($where = null, $order = null, $what = '*', $bindValues = array(), $fetchType = PDO::FETCH_OBJ)
- fetchAll($where = null, $order = null, $what = '*', $limit = null, $groupby = null, $bindValues = array(),$fetchType = PDO::FETCH_OBJ)
- fetchTextSearch($searchText,array $columns, $where = null, $order = null, $what = '*', $limit = null, $groupby = null, $bindValues = array() )
- fetchCount($where = null, $bindValues = array() )
- fetchCountGroup($groupBy,$where = null,$order = null,$what = '*', $limit = null, $bindValues = array() )
- fetchSum($sumColumn,$where = null,$order = null,$what = '*', $limit = null, $bindValues = array() )
- fetchGroup($groupBy, $where = null, $order = null, $what = '*', $limit = null, $bindValues = array())
- set($id,$column,$value)
- get($id,$column)
$pagesDB = new pagesDB(); $pages = $pagesDB->fetchAll("id>10");
Tables
Every table has it's own file with unique methods as well as regular methods that are available to any table using the database engine.The list of tables contains the following:
- banners
- bannersareas
- cache
- calendar
- calendarEvents
- comments
- config
- contact
- contactgroups
- cronlog
- firewall
- files
- forumGroups
- forumPosts
- forumTopics
- forumReadedLog
- forums
- images
- mailings
- mailingtemplates
- messages
- notes
- notify
- pages
- pagesbackups
- pollanswers
- pollAnswers
- pollQuestions
- polls
- rates
- redirect
- session
- systemStatus
- themes
- users
- usertypes
- widgets
To browse and edit tables, in the case of the SQLite database, we recommend the FireFox extension https://addons.mozilla.org/pl/firefox/addon/sqlite-manager/.