Webwereld

[GRATIS] Database class met result class

Gestart doorJenner4 reacties16 weergaven
Log in om mee te praten

5 berichten · pagina 1 van 1

Jenner

Lid · Topicstarter

Berichten
1.544
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hallo,

Ik had nog een database class liggen die ik vaak gebruik in mijn eigen projecten. Ik wil deze graag gratis vrijgeven. Ik hoop dat je hem handig vind en graag reacties.

Voorbeeld:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/define"]define[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_HOST[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]localhost[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/define"]define[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_USER[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]root[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/define"]define[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_PASS[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]root[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/define"]define[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_DATABASE[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]Database[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]=[/COLOR] database[COLOR= #007700]:[/COLOR]SMILEYYYYYYYYYYYBEGIN[COLOR= #007700]:[/COLOR]singleton[COLOR= #007700]();[/COLOR]

[COLOR= #FF8000]//Voeg een gebruiker toe[/COLOR]
[COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]insert[COLOR= #007700]([/COLOR][COLOR= #DD0000]users[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]username[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #DD0000]admin[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]password[/COLOR] [COLOR= #007700]=>[/COLOR] [URL="http://www.php.net/sha1"]sha1[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]Je wachtwoord[/COLOR][COLOR= #007700])));[/COLOR]

[COLOR= #FF8000]//Haal alle gebruikers op[/COLOR]
[COLOR= #0000BB]$select[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]select[COLOR= #007700]([/COLOR][COLOR= #DD0000]users[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/var_dump"]var_dump[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$select[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]());[/COLOR]

[COLOR= #FF8000]//Update een gebruiker[/COLOR]
[COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]update[COLOR= #007700]([/COLOR][COLOR= #DD0000]users[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]username[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #DD0000]admin2[/COLOR][COLOR= #007700]),[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]id[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]));[/COLOR]

[COLOR= #FF8000]//Verwijder[/COLOR]
[COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]delete[COLOR= #007700]([/COLOR][COLOR= #DD0000]users[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]id[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]));[/COLOR]
?>


De database class:
Spoiler tonen
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/**
 * HitGo V1.0
 *
 * A Autohitter script. Simple and class based
 *
 * @package    HitGo
 * @author Jan Erik van Woerden <info@janerik.eu>
 * @copyright Copyright (c) 2011, Jan Erik van Woerden
 * @since V1.0
 * @subpackage Core
 */

// ------------------------------------------------------------------------

/**
 * The HitGo database class
 *
 * Use this class for querys to MySQLi and MySQL
 * Orgininal created for CustomFrame
 *
 * @version 1.0
 * @author Jan Erik van Woerden <info@janerik.eu>
 * @package HitGo
 * @subpackage Core
 */[/COLOR]
[URL="http://www.php.net/class"]class[/URL] database [COLOR= #007700]{[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * The MySQLi object
     * 
     * @var object
     * @access private
     * @static
     */[/COLOR]
    [URL="http://www.php.net/static"]static[/URL] [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #FF8000]/**
     * The last executed query result in function query()
     * 
     * @var MySQLi object
     * @access private
     * @static
     */[/COLOR]
    [URL="http://www.php.net/static"]static[/URL] [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$last[/COLOR][COLOR= #007700];[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Save all the results of querys
     * 
     * (default value: array())
     * 
     * @var array
     * @access private
     * @static
     */[/COLOR]
    [URL="http://www.php.net/static"]static[/URL] [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$cache[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]();[/COLOR]
    
    [COLOR= #FF8000]/**
     * The class in a static var for the singleton method
     * 
     * @var mixed
     * @access private
     * @static
     */[/COLOR]
    [URL="http://www.php.net/static"]static[/URL] [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$instance[/COLOR][COLOR= #007700];[/COLOR]
    
    
    
    [COLOR= #FF8000]/**
     * The construct function. (Its private because you must use the Singleton method)
     * 
     * @access private
     * @return void
     */[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #007700]function[/COLOR] __construct[COLOR= #007700]()
    {
        
        
        @[/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]= new[/COLOR] MySQLi[COLOR= #007700]([/COLOR]DB_HOST[COLOR= #007700],[/COLOR] DB_USER[COLOR= #007700],[/COLOR] DB_PASS[COLOR= #007700],[/COLOR] DB_DATABASE[COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]connect_error[COLOR= #007700]) {[/COLOR]
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]MySQLi connect error "[/COLOR][COLOR= #007700].[/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]connect_error[COLOR= #007700].[/COLOR][COLOR= #DD0000]" ([/COLOR][COLOR= #007700].[/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]connect_errno[COLOR= #007700].[/COLOR][COLOR= #DD0000])[/COLOR][COLOR= #007700]);
        }
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Return the current class.
     * 
     * @access public
     * @static
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] singleton[COLOR= #007700]()
    {[/COLOR]
    
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$instance[/COLOR][COLOR= #007700]))  
        {[/COLOR] 
        
            [COLOR= #0000BB]$obj[/COLOR] [COLOR= #007700]=[/COLOR] __CLASS__[COLOR= #007700];[/COLOR]  
            self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$instance[/COLOR] [COLOR= #007700]= new[/COLOR] [COLOR= #0000BB]$obj[/COLOR][COLOR= #007700];
            
        }[/COLOR]  
  
        [URL="http://www.php.net/return"]return[/URL] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$instance[/COLOR][COLOR= #007700];
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Execute a query with this function like: SELECT * FROM CF_Base WHERE id = 1
     * 
     * @access public
     * @param string $query A MySQLi query
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))
        {[/COLOR]
        
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$return[/COLOR] [COLOR= #007700]=[/COLOR] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$last[/COLOR] [COLOR= #007700]= new[/COLOR] DB_Query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$return[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$last[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
            
                throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Error in query "[/COLOR][COLOR= #007700].[/COLOR]htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]". ([/COLOR][COLOR= #007700].[/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]error[COLOR= #007700].[/COLOR][COLOR= #DD0000])[/COLOR][COLOR= #007700]);
            
            }
            
            
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Not correct value for query.[/COLOR][COLOR= #007700]);
        
        }
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Insert rows
     * 
     * @access public
     * @param string $table
     * @param mixed $array
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] insert[COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$array[/COLOR][COLOR= #007700])
    {[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR][COLOR= #007700]))
        {[/COLOR]
        
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]INSERT INTO [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700];[/COLOR]
            
            [COLOR= #0000BB]$keys[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array_keys"]array_keys[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR][COLOR= #007700]);[/COLOR]
            
            [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
            {[/COLOR]
                [COLOR= #0000BB]$values[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];
            }[/COLOR]
            
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]([/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$keys[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]) VALUES ([/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$values[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000])[/COLOR][COLOR= #007700];[/COLOR]
            
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
            
        
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Not correct table for insert().[/COLOR][COLOR= #007700]);
            
        }
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Update rows
     * 
     * @access public
     * @param string $table
     * @param mixed $array
     * @param mixed $where (default: false)
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] update[COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$array[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$where[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR][COLOR= #007700]))
        {[/COLOR]
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]))
            {[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]UPDATE [/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$table[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000] SET [/COLOR][COLOR= #007700];    
                
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]UPDATE [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] SET [/COLOR][COLOR= #007700];
            
            }[/COLOR]
            
            [COLOR= #0000BB]$keys[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array_keys"]array_keys[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$values[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]();[/COLOR]
            [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
            {[/COLOR]
            
                [COLOR= #0000BB]$values[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$key[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]=[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];
                
            }[/COLOR]
            
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$values[/COLOR][COLOR= #007700]);[/COLOR]
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]WHERE [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
                {[/COLOR]
                
                    [COLOR= #0000BB]$wheres[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$key[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]=[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];
                
                }[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]WHERE [/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000] AND [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$wheres[/COLOR][COLOR= #007700]);
            
            }[/COLOR]
            
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
            
        
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Not correct table for update().[/COLOR][COLOR= #007700]);
            
        }
        
    }[/COLOR]
    
    
    
    [COLOR= #FF8000]/**
     * Select rows
     * 
     * @access public
     * @param string $table
     * @param mixed $what (default: false)
     * @param mixed $where (default: false)
     * @param mixed $limit (default: false)
     * @param mixed $orderby (default: false)
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] select[COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$what[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$where[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$limit[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$orderby[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]))
        {[/COLOR]
        
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]SELECT [/COLOR][COLOR= #007700];[/COLOR]
        
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$what[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$what[/COLOR][COLOR= #007700]))
            {[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$what[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700];
                
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]( ![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$what[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$what[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #0000BB]$what[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]* [/COLOR][COLOR= #007700];
            
            }[/COLOR]
        
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]FROM [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700];[/COLOR]
            
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]WHERE [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
                {[/COLOR]
                
                    [COLOR= #0000BB]$wheres[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$key[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]=[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];
                
                }[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]WHERE [/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000] AND [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$wheres[/COLOR][COLOR= #007700]);
            
            }[/COLOR]
            
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]ORDER BY [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]2[/COLOR] [COLOR= #007700]&& ([/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]ASC[/COLOR] OR [COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]DESC[/COLOR][COLOR= #007700]))
            {[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]ORDER BY [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$orderby[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700];
            
            }[/COLOR]
            
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]LIMIT [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]))
            {[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]LIMIT [/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]);
            
            }[/COLOR]
            
            
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
            
        
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Not correct table for select().[/COLOR][COLOR= #007700]);
            
        }
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Delete some rows
     * 
     * @access public
     * @param string $table
     * @param mixed $where (default: false)
     * @param mixed $limit (default: false)
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] delete[COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$where[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$limit[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]))
        {[/COLOR]
        
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]DELETE FROM [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700];[/COLOR]
            
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]WHERE [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$where[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
                {[/COLOR]
                
                    [COLOR= #0000BB]$wheres[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$key[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]=[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];
                
                }[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]WHERE [/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000] AND [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$wheres[/COLOR][COLOR= #007700]);
            
            }[/COLOR]
            
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]))
            {[/COLOR]
            
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]LIMIT [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$where[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]))
            {[/COLOR]
                
                [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]LIMIT [/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000], [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$limit[/COLOR][COLOR= #007700]);
            
            }[/COLOR]
            
            
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
            
        
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Not correct table for delete().[/COLOR][COLOR= #007700]);
            
        }
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Empty a table
     * 
     * @access public
     * @param mixed $table
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] emptyTable[COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700])
    {[/COLOR]
    
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_string"]is_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]))
        {[/COLOR]
        
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]DELETE FROM [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700];
        
        }[/COLOR]
        [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR][COLOR= #007700]))
        {[/COLOR]
            
            [COLOR= #0000BB]$query_exploded[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]();[/COLOR]
            
            [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$table[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$table_single[/COLOR][COLOR= #007700])
            {[/COLOR]
            
                [COLOR= #0000BB]$query_exploded[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #DD0000]DELETE FROM [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$table_single[/COLOR][COLOR= #007700];
            
            }[/COLOR]
            
            [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000];[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$query_exploded[/COLOR][COLOR= #007700]);
            
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            throw [COLOR= #007700]new[/COLOR] Exception[COLOR= #007700]([/COLOR][COLOR= #DD0000]Not correct table for update().[/COLOR][COLOR= #007700]);
        
        }[/COLOR]
        
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
        
    }[/COLOR]    
    
    
    [COLOR= #FF8000]/**
     * Last ID of inserted rows
     * 
     * @access public
     * @return void
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] insert_id[COLOR= #007700]()
    {[/COLOR]
    
        [URL="http://www.php.net/return"]return[/URL] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]insert_id[COLOR= #007700];
    
    }[/COLOR]
    
    
    
    [COLOR= #FF8000]/**
     * Returned the affected_rows variable
     * 
     * @access public
     * @return interit
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] affected_rows[COLOR= #007700]()
    {[/COLOR]
        
        [URL="http://www.php.net/return"]return[/URL] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]affected_rows[COLOR= #007700];
        
    }[/COLOR]
    
    [COLOR= #FF8000]/**
     * Returned the MySQLi class.
     * 
     * @access public
     * @return void
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] custom[COLOR= #007700]()
    {[/COLOR]
        
        [URL="http://www.php.net/return"]return[/URL] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700];
        
    }
    
}[/COLOR]
?>
Result class
Spoiler tonen
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/**
 * HitGo V1.0
 *
 * A Autohitter script. Simple and class based
 *
 * @package    HitGo
 * @author Jan Erik van Woerden <info@janerik.eu>
 * @copyright Copyright (c) 2011, Jan Erik van Woerden
 * @since V1.0
 * @subpackage Core
 */

// ------------------------------------------------------------------------

/**
 * The HitGo result class of MySQLi querys
 *
 * The result of a MySQLi query
 * Orgininal created for CustomFrame
 *
 * @version 2.0
 * @author Jan Erik van Woerden <info@janerik.eu>
 * @package HitGo
 * @subpackage Sub-core
 */[/COLOR]
[URL="http://www.php.net/class"]class[/URL] DB_Query [COLOR= #007700]{[/COLOR]

    
    [COLOR= #FF8000]/**
     * Result of the Query
     * 
     * @var MySQLi object
     * @access private
     */[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700];[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Affected rows
     * 
     * @var MySQLi object
     * @access private
     */[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$affected[/COLOR][COLOR= #007700];[/COLOR]


    
    [COLOR= #FF8000]/**
     * The construct function
     * 
     * @access public
     * @param MySQLi Object $result
     * @return void
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] __construct[COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700])
    {[/COLOR]
            
            [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700];
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Multiple Result (Object Version)
     * 
     * @access public
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] result[COLOR= #007700]()
    {[/COLOR]
    
        [COLOR= #0000BB]$return[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]();[/COLOR]
    
        [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$obj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]->[/COLOR]fetch_object[COLOR= #007700]())
        {[/COLOR]
        
            [COLOR= #0000BB]$return[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$obj[/COLOR][COLOR= #007700];
            
        }[/COLOR]
    
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$return[/COLOR][COLOR= #007700];
    
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Multiple Result (Array Version)
     * 
     * @access public
     * @return array
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] result_array[COLOR= #007700]()
    {[/COLOR]
    
        [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$array[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]->[/COLOR]fetch_array[COLOR= #007700]())
        {[/COLOR]
        
            [COLOR= #0000BB]$return[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$array[/COLOR][COLOR= #007700];
            
        }[/COLOR]
    
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$return[/COLOR][COLOR= #007700];
    
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Single Result (Object Version)
     * 
     * @access public
     * @return object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] row[COLOR= #007700]()
    {[/COLOR]
    
        [COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR]  [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]->[/COLOR]fetch_object[COLOR= #007700]();[/COLOR]
    
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR] [URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
        {[/COLOR]
        
            [URL="http://www.php.net/return"]return[/URL] false[COLOR= #007700];
            
        }[/COLOR]
        [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR] [COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])
        {[/COLOR]
        
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700];
        
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]];
            
        }
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Single Result (Array Version)
     * 
     * @access public
     * @return array Result of the first array
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] row_array[COLOR= #007700]()
    {[/COLOR]
    
        [COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR]  [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]->[/COLOR]fetch_array[COLOR= #007700]();[/COLOR]
    
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
        {[/COLOR]
        
            [URL="http://www.php.net/return"]return[/URL] false[COLOR= #007700];
        
        }[/COLOR]
        [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])
        {[/COLOR]
        
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700];
            
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
        
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]];
            
        }
        
    }[/COLOR]
    
    
    [COLOR= #FF8000]/**
     * Result num rows
     * 
     * @access public
     * @return number
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] num_rows[COLOR= #007700]()
    {[/COLOR]
    
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]->[/COLOR]num_rows[COLOR= #007700];
    
    }[/COLOR]
    
    
    
    [COLOR= #FF8000]/**
     * Result the MySQLi result
     * 
     * @access public
     * @return object The result object
     */[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] data[COLOR= #007700]()
    {[/COLOR]
    
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700];
        
    }

}[/COLOR]
?>
0
Kyron

Lid

Berichten
3.314
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ten eerste, waarom static, ten 2de waarom een aparte result class?
0
Jenner

Lid · Topicstarter

Berichten
1.544
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Kyron schreef:
Ten eerste, waarom static, ten 2de waarom een aparte result class?
Kyron schreef:
Ten eerste, waarom static, ten 2de waarom een aparte result class?
Alleen ophalen is static wink Omdat ik normaal altijd maar 1 database gebruik en omdat ik met een framework werk is dat veel fijner smile en aparte result class is omdat ik het veel makkelijker vind werken. nu doe je als je even wilt kijken wat voor resultaat je hebt gewoon even

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/print_r"]print_r[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]->[/COLOR]result[COLOR= #007700]());[/COLOR]
?>
0
Skytop

Lid

Berichten
1.101
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Bedankt voor het delen,

Hier kan ik vast nog wel wat mee met mijn nieuwe project smile.
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Netjes smile
Kyron schreef:
Ten eerste, waarom static, ten 2de waarom een aparte result class?
Tenzij je met meerdere databases gaat verbinden in 1 script is er geen reden om geen static class te gebruiken. Result class apart is gewoon eigen keus, ik zou het bij 1 class houden maar als hij 2 classes fijner vindt werken, waarom niet?
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren