How do I use the DB functionality?

by Stephan Borg
Friday, July 01, 2005
Posted to Developer's FAQ
Ok,
  • The $this object is usually a class from BitSystem parent.
  • First of all, you should quote your field names in backticks '`'. This is used to ensure portability between different database vendors.
  • Next, you want to prefix your table names with BIT_DB_PREFIX to allow multiple installs of Bitweaver under one database.
  • We use parameterised queries, by using '?' for our values. This also helps remove quoting problems between vendors.
  • Lastly, our sort mode is a function, in the format of field_direction - for example, last_modified in descending order is shown below.

<?php
$query 
"select * from `".BIT_DB_PREFIX."tiki_history` where `page_id`=? order by ".$this->convert_sortmode("last_modified_desc");
$result $this->query($query, array( $this->mPageId ), 520 );
?>

The query() function has the following:
  • The $query string
  • All bind variables are fed through an array of variables
  • The '5' is to limit the number of rows return from the results
  • The '20' is the offset, where the limit begins

If you're encoding or decoding blobs, we use the following escape functions respectively:

<?php
$blob_data 
$this->mDb->db_byte_encode$imgdata );
$imgdata $this->mDb->db_byte_decode$blob_data )
?>