MDB2 Connection

Following an example how to create a MDB2 via PHP:

<?php
class bx_helpers_saveDataInDB {
    public function __construct() {
        $this->db= $GLOBALS['POOL']->db;
    }

    public static function saveData(/*$query*/) {
        $prefix = $GLOBALS['POOL']->config->getTablePrefix();
        $item = array();
        $db= $GLOBALS['POOL']->db;
        
	$query = 'INSERT INTO ' . $prefix . 'mytable(field1, field2, field3, field4, field5) VALUES (' . $GLOBALS['POOL']->db->quote($field1) . ', ' . $GLOBALS['POOL']->db->quote($field2) . ', ' . $GLOBALS['POOL']->db->quote($field3) . ', ' . $GLOBALS['POOL']->db->quote($field4) . ', ' . $GLOBALS['POOL']->db->quote($field5) . ');';
	//for needed quote: $GLOBALS['POOL']->db->quote('$field1');        

	$res = $db->query($query);
        
        //bx_helpers_debug::webdump($res);
        //error_log($query);
        
        if (!MDB2::isError($res)) {
            return $res->fetchRow(MDB2_FETCHMODE_ASSOC);
        }
        return $res;
    }

The id-field of the table is generated, you do not have to insert it manually.

To give out data out of your db, the easiest way ist to create a XML-file (see Structure2XML-Plugin) , then give out the data with XSL.

MDB2 Connection

MDB2 Connection

Labels: