[MySQLi] MySQLi class - One2xs Forum

Milan · 2013-05-10T13:34:11.000Z

Hey, Hierbij een kleine MySQLi class: Codeblok: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 _mysqlUsername = $mysqlUsername ; $this -> _mysqlPassword = $mysqlPassword ; $this -> _mysqlDatabase = $mysqlDatabase ; $this -> _mysqlHost = $mysqlHost ; $this -> connect (); } private function connect () { $this -> _con = @ mysqli_connect ( $this -> _mysqlHost , $this -> _mysqlUsername , $this -> _mysqlPassword , $this -> _mysqlDatabase ); } public function query ( $query ) { $this -> tempQuery = @ mysqli_query ( $this -> _con , $query ); if ( $this -> tempQuery === false ) $this -> makeError (); else return $this -> tempQuery ; $this -> tempQuery = ; } public function fetch ( $query ) { $this -> tempFetch = @ mysqli_fetch_assoc ( $query ); if ( $this -> tempFetch === false ) $this -> makeError (); else return $this -> tempFetch ; $this -> tempFetch = ; } public function num_rows ( $query ) { $this -> tempNumRows = @ mysqli_num_rows ( $query ); if ( $this -> tempNumRows === false ) $this -> makeError (); else return $this -> tempNumRows ; $this -> tempNumRows = ; } public function escape ( $string ) { return mysqli_real_escape_string ( $this -> _con , $string ); } public function insert_id () { return mysqli_insert_id ( $this -> _con ); } private function makeError () { if ( $this -> developMode === true ) { echo MySQL ERROR: . mysqli_error ( $this -> _con ); exit ; } } } ?>

Milan

Lid · Topicstarter

Berichten: 8.602
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 12 jun 2025

10 mei 2013, 15:34

Hey,

Hierbij een kleine MySQLi class:

[COLOR= #0000BB]<?php[/COLOR]

[COLOR= #FF8000]/**
 * 
 * @author Milan Drossaerts
 * @copyright 2013 Milan Drossaerts
 * 
 */[/COLOR]
 
[URL="http://www.php.net/class"]class[/URL] mysql [COLOR= #007700]{[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$developMode[/COLOR] [COLOR= #007700]=[/COLOR] true[COLOR= #007700];[/COLOR]
    
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$_mysqlUsername[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$_mysqlPassword[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$_mysqlDatabase[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$_mysqlHost[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$_con[/COLOR][COLOR= #007700];[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$tempQuery[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$tempFetch[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$tempNumRows[/COLOR][COLOR= #007700];[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] __construct[COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysqlUsername[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$mysqlPassword[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$mysqlDatabase[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$mysqlHost[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]localhost[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlUsername    [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysqlUsername[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlPassword    [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysqlPassword[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlDatabase    [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysqlDatabase[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlHost        [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysqlHost[/COLOR][COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connect[COLOR= #007700]();
        
    }[/COLOR]
    
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #007700]function[/COLOR] connect[COLOR= #007700]()
    {[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_con [COLOR= #007700]= @[/COLOR]mysqli_connect[COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlHost[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlUsername[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlPassword[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_mysqlDatabase[COLOR= #007700]);
        
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempQuery [COLOR= #007700]= @[/COLOR]mysqli_query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_con[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempQuery [COLOR= #007700]===[/COLOR] false[COLOR= #007700])[/COLOR]
            [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]makeError[COLOR= #007700]();[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempQuery[COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempQuery [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
        
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempFetch [COLOR= #007700]= @[/COLOR]mysqli_fetch_assoc[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempFetch [COLOR= #007700]===[/COLOR] false[COLOR= #007700])[/COLOR]
            [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]makeError[COLOR= #007700]();[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempFetch[COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempFetch [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
        
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] num_rows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempNumRows [COLOR= #007700]= @[/COLOR]mysqli_num_rows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempNumRows [COLOR= #007700]===[/COLOR] false[COLOR= #007700])[/COLOR]
            [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]makeError[COLOR= #007700]();[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempNumRows[COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]tempNumRows [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
        
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$string[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/return"]return[/URL] mysqli_real_escape_string[COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_con[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$string[/COLOR][COLOR= #007700]);
        
    }[/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] mysqli_insert_id[COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_con[COLOR= #007700]);
        
    }[/COLOR]
    
    [URL="http://www.php.net/private"]private[/URL] [COLOR= #007700]function[/COLOR] makeError[COLOR= #007700]()
    {[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]developMode [COLOR= #007700]===[/COLOR] true[COLOR= #007700])
        {[/COLOR]
            
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<strong>MySQL ERROR:</strong><br /><br />[/COLOR] [COLOR= #007700].[/COLOR] mysqli_error[COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]_con[COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/exit"]exit[/URL][COLOR= #007700];
            
        }
        
    }
    
}[/COLOR]

?>