This site uses cookies in order for our service to work better. Learn more I understand

Database

Windu CMS database is made up of a number of tables, which you can use with the database engine.

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/.
 

Help Center

Do you have a technical problem?