"TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/dbal/handlers/class.tx_dbal_handler_rawmysql.php Source File", "datetime" => "Sat Dec 2 19:22:30 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

class.tx_dbal_handler_rawmysql.php

<?php
/***************************************************************
*  Copyright notice
*  
*  (c) 2004 Kasper Skaarhoj (kasper@typo3.com)
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*  A copy is found in the textfile GPL.txt and important notices to the license
*  from the author is found in LICENSE.txt distributed with these scripts.
*
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
class tx_dbal_handler_rawmysql extends t3lib_sqlengine {

        var $config = array();  
        var $link;
        var $pObj;      // Set from DBAL class.

        function init($config,&$pObj)   {
                $this->config = $config['config'];
                $this->pObj = &$pObj;
                $this->link = mysql_pconnect(
                                                        $this->config['host'], 
                                                        $this->config['username'], 
                                                        $this->config['password']
                                                );

                        // Select database as well:
                if (mysql_select_db($this->config['database'], $this->link))    {
                        $output = TRUE;
                }

                return $output;
        }

        function exec_INSERTquery($table,$fields_values)        {
                return mysql_query($GLOBALS['TYPO3_DB']->INSERTquery($table,$fields_values), $this->link);
        }

        function exec_UPDATEquery($table,$where,$fields_values) {
                return mysql_query($GLOBALS['TYPO3_DB']->UPDATEquery($table,$where,$fields_values), $this->link);
        }

        function exec_DELETEquery($table,$where)        {
                return mysql_query($GLOBALS['TYPO3_DB']->DELETEquery($table,$where), $this->link);
        }

        function exec_SELECTquery($select_fields,$from_table,$where_clause,$groupBy,$orderBy,$limit)    {
                $res = t3lib_div::makeInstance('tx_dbal_handler_rawmysql_sqlObj');              // Create result object
                $this->pObj->lastQuery = $GLOBALS['TYPO3_DB']->SELECTquery($select_fields,$from_table,$where_clause,$groupBy,$orderBy,$limit);
                $res->result = mysql(TYPO3_db, $this->pObj->lastQuery, $this->link);    // Execute query
                return $res;
        }

        function sql_error()    {
                return mysql_error();
        }

        function sql_insert_id()        {
                return mysql_insert_id();
        }

        function sql_affected_rows()    {
                return mysql_affected_rows();
        }

        function sql_query($query)      {
                $res = t3lib_div::makeInstance('tx_dbal_handler_rawmysql_sqlObj');
                $res->result = mysql_query($query, $this->link);
                return $res;
        }

        function quoteStr($str) {
                return addslashes($str);
        }
        
        
        






        /**************************************
         *
         * SQL admin functions
         * (For use in the Install Tool and Extension Manager)
         *
         **************************************/

        function admin_get_tables()     {
                $whichTables = array();
                $tables_result = mysql_list_tables($this->config['database'], $this->link);
                if (!mysql_error())     {
                        while ($theTable = mysql_fetch_assoc($tables_result)) {
                                $whichTables[current($theTable)] = current($theTable);
                        }
                }
                return $whichTables;
        }

        function admin_get_fields($tableName)   {
                $output = array();
                
                if ($columns_res = @mysql_query('SHOW columns FROM '.$tableName, $this->link))  {
                        while($fieldRow = mysql_fetch_assoc($columns_res))      {
                                $output[$fieldRow["Field"]] = $fieldRow;
                        }
                }

                return $output;
        }

        function admin_get_keys($tableName)     {
                $output = array();

                if ($keyRes = @mysql_query('SHOW keys FROM '.$tableName, $this->link))  {
                        while($keyRow = mysql_fetch_assoc($keyRes))     {
                                $output[] = $keyRow;
                        }
                }

                return $output;
        }               

        function admin_query($query)    {
                return $this->sql_query($query);
        }       
}







class tx_dbal_handler_rawmysql_sqlObj extends t3lib_sqlengine_resultobj {

        var $result = '';                       // Not array here, but resource pointer.

        function sql_num_rows() {
                return mysql_num_rows($this->result);
        }

        function sql_fetch_assoc()      {
                return mysql_fetch_assoc($this->result);
        }

        function sql_fetch_row()        {
                return mysql_fetch_row($this->result);
        }

        function sql_data_seek($pointer)        {
                return mysql_data_seek($this->result,$pointer);
        }
}


if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/dbal/handlers/class.tx_dbal_handler_rawmysql.php'])    {
        include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/dbal/handlers/class.tx_dbal_handler_rawmysql.php']);
}
?>