[RELEASE] Static MySQL Class

Gestart doorBasDev10 mei 201113 reacties41 weergaven

14 berichten · pagina 1 van 1

Lid · Topicstarter

Berichten: 2.692
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 17 mei 2024

10 mei 2011, 18:00

Heuhj,
Ik verveelde me op school.. je mocht wat voor jezelf doen.. en ik had niks te doen dus ik dacht, laat ik es een mysql-class gaan maken.. so i did..

Ik heb een MySQL Class gemaakt die jullie gratis en gewoon mogen gebruiken (als jullie willen)

Verbinding Maken:

[COLOR= #0000BB]<?php
$gegevens[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/Array"]Array[/URL][COLOR= #007700]();[/COLOR]
[COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"Gebruikersnaam"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wachtwoord[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"Wachtwoord"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]host[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"Localhost"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]db[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]"Database"[/COLOR][COLOR= #007700];[/COLOR]

MySQL[COLOR= #007700]::[/COLOR]Init[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700]);[/COLOR]
?>

Wat kan het en hoe?
Uitgevoerde queries op het einde allemaal weergeven. [echo MySQL::ShowQueries();]
Een tabel als array ophalen [$array = MySQL::GetTable("Query hier");]
Gebruik: $data[0][gebruikersnaam] of gebruik foreach
Slechts 1 rij ophalen [$rij = MySQL::GetRow("Query hier");]
Gebruik: $gebruikersnaam = $rij[gebruikersnaam];
Normale Queries uitvoeren [$query = MySQL::Query("Query hier");
Fetch [assoc] [MySQL:

etch($query_resource);
Fetch [array] [MySQL:

etchArray($query_resource);
Fetch [object] [MySQL:

etchObject($query_resource);
Escapen [MySQL::Escape($string);]
num_rows [MySQL::NumRows($query);]
Aantal Queries laten zien [echo MySQL::$queries;]

Graag de copyright ect laten staan.. Das wel zo respectvol

(De super coole class)

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/*
 * @ Wees respectvol en laat de copyright en de onderstane info staan
 * @ Haal je dit weg, heb je geen respect voor de maker.
 * @
 * @ Product:        MySQL static class
 * @ Auteur:        Bas Milius
 * @ Datum:        10 Mei 2010
 * @ Namespace:        GLOBALSPACE
 * @ Copyright:     © 2008-2011 Bas Milius - Alle rechten voorbehouden
 * @ Classnaam:     MySQL
 * @ Rechten:        Alle, als mijn copyright maar blijft staan
 * @ Licentie aan:    Bas Milius
 * @ 
 * @ [CSS] .mysql_error: van hele error blok
 * @ [CSS] .mysql_error_titel: titel van het error blok
 * @ [CSS] .mysql_error_inner: inner van het error blok
 * @ [CSS] .mysql_list: van hele error
 * @ [CSS] .mysql_list_info: informatie, "Uitgevoerde Queries"
 * @ [CSS] .mysql_list_query: query binnen de list
 */[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/stristr"]stristr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_URI[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #DD0000]mysql.class.php[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Whoat?! Hier mag jij niet in komen.."[/COLOR][COLOR= #007700]);
}[/COLOR]

[URL="http://www.php.net/Class"]Class[/URL] MySQL [COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/private"]private[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #0000BB]$verbinding[/COLOR]     [COLOR= #007700]=[/COLOR] null[COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #0000BB]$gebruiker[/COLOR]     [COLOR= #007700]=[/COLOR] null[COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #0000BB]$queries[/COLOR]         [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #0000BB]$settings[/COLOR]     [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/Array"]Array[/URL][COLOR= #007700]([/COLOR]true[COLOR= #007700],[/COLOR] false[COLOR= #007700]);[/COLOR] [COLOR= #FF8000]//Eerste = queries onthouden; Tweede = debug mode[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #0000BB]$queriesb[/COLOR]        [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/Array"]Array[/URL][COLOR= #007700]();[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Init[COLOR= #007700]([/COLOR][URL="http://www.php.net/array"]array[/URL] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/array"]array[/URL] [COLOR= #0000BB]$settings[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/Array"]Array[/URL][COLOR= #007700]([/COLOR]true[COLOR= #007700],[/COLOR] false[COLOR= #007700])){[/COLOR]
        self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$settings[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$settings[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$verbinding[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]host[/COLOR][COLOR= #007700]],[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]],[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wachtwoord[/COLOR][COLOR= #007700]],[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]db[/COLOR][COLOR= #007700]])){[/COLOR]
            [COLOR= #0000BB]$range[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array_merge"]array_merge[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/range"]range[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]9[/COLOR][COLOR= #007700]),[/COLOR] [URL="http://www.php.net/range"]range[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]z[/COLOR][COLOR= #007700]),[/COLOR] [URL="http://www.php.net/range"]range[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]A[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]Z[/COLOR][COLOR= #007700]));[/COLOR]
            [COLOR= #0000BB]$error[/COLOR]  [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"Er kon geen verbinding gemaakt worden met de database!<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Gebruiker: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Wachtwoord: "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$range[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"*"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wachtwoord[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Host: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]host[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Database: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]db[/COLOR][COLOR= #007700]];[/COLOR]
            self[COLOR= #007700]::[/COLOR]Error[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Verbindings Error!"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$error[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](!@[/COLOR][URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]db[/COLOR][COLOR= #007700]],[/COLOR] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$verbinding[/COLOR][COLOR= #007700])){[/COLOR]
                [COLOR= #0000BB]$range[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array_merge"]array_merge[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/range"]range[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]9[/COLOR][COLOR= #007700]),[/COLOR] [URL="http://www.php.net/range"]range[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]z[/COLOR][COLOR= #007700]),[/COLOR] [URL="http://www.php.net/range"]range[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]A[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]Z[/COLOR][COLOR= #007700]));[/COLOR]
                [COLOR= #0000BB]$error[/COLOR]  [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"Er kon geen verbinding gemaakt worden met de database!<br/>"[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Gebruiker: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Wachtwoord: "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$range[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"*"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wachtwoord[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Host: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]host[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Database: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]db[/COLOR][COLOR= #007700]];[/COLOR]
                self[COLOR= #007700]::[/COLOR]Error[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Verbindings Error!"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$error[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
            }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$gebruiker[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];
            }
        }
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
        self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$queries[/COLOR][COLOR= #007700]++;[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$settings[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]]){[/COLOR]
            self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR]SaveQuery[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
        }[/COLOR]
        [COLOR= #0000BB]$quer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700],[/COLOR] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$verbinding[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]()){[/COLOR]
            [COLOR= #0000BB]$error[/COLOR]  [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"De query kon niet worden uitgevoerd!<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Query: "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Error: "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]();[/COLOR]
            self[COLOR= #007700]::[/COLOR]Error[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Kon Query niet uitvoeren"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$error[/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]$quer[/COLOR][COLOR= #007700];
        }
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] GetTable[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$quer[/COLOR] [COLOR= #007700]=[/COLOR] self[COLOR= #007700]::[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$ret[/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]$data[/COLOR] [COLOR= #007700]=[/COLOR] self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR]Fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$quer[/COLOR][COLOR= #007700])){[/COLOR]
            [COLOR= #0000BB]$ret[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$ret[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] GetRow[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]=[/COLOR] self[COLOR= #007700]::[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]::[/COLOR]NumRows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]){[/COLOR]
            [COLOR= #0000BB]$error[/COLOR]  [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"De data kon niet worden opgehaald omdat er meerdere rijen zijn gevonden!<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Query: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"<br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"Gebruik MySQL::GetTable() om meerdere rijen op te halen!"[/COLOR][COLOR= #007700];[/COLOR]
            self[COLOR= #007700]::[/COLOR]Error[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Kon data niet ophalen!"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$error[/COLOR][COLOR= #007700]);
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700]);
        }
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] NumRows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] RunQuery[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
        self[COLOR= #007700]::[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$string[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$string[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #007700]@[/COLOR][URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] FetchObject[COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] FetchArray[COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$resource[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Info[COLOR= #007700](){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_info"]mysql_info[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$verbinding[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Error[COLOR= #007700]([/COLOR][COLOR= #0000BB]$titel[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$error[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$out[/COLOR]  [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"
"[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$out[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"<div class="mysql_error">
"[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$out[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"    <div class="mysql_error_titel">"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$titel[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</div>
"[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$out[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"    <div class="mysql_error_inner">"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</div>
"[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$out[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"</div>
"[/COLOR][COLOR= #007700];[/COLOR]
        
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/print"]print[/URL] [COLOR= #0000BB]$out[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] SaveQuery[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
        self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$queriesb[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$query[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] ShowQueries[COLOR= #007700](){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"
"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<div class="mysql_list"></div>
"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<div class="mysql_list_info">Uitgevoerde Queries</div>
"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$queriesb[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"    <div class="mysql_list_query">"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</div>
"[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"</div>
"[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/public"]public[/URL] [URL="http://www.php.net/static"]static[/URL] [COLOR= #007700]function[/COLOR] Close[COLOR= #007700](){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_close"]mysql_close[/URL][COLOR= #007700]([/COLOR]self[COLOR= #007700]:[/COLOR][COLOR= #007700]:[/COLOR][COLOR= #0000BB]$verbinding[/COLOR][COLOR= #007700]);
    }
}[/COLOR]
?>

PS: MySQL verbinding sluiten is:
MySQL::Close();

Sebastiaanh

Lid

Berichten: 9.953
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 12 jun 2025

10 mei 2011, 18:04

Nice!

BasDev

Lid · Topicstarter

Berichten: 2.692
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 17 mei 2024

10 mei 2011, 18:05

Sebastiaanh schreef:
Nice!

Tja op school hea

Sebastiaanh

Lid

Berichten: 9.953
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 12 jun 2025

10 mei 2011, 18:09

Serieus, dat jij dit even op school doet. xD

BasDev

Lid · Topicstarter

Berichten: 2.692
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 17 mei 2024

10 mei 2011, 18:10

Sebastiaanh schreef:
Serieus, dat jij dit even op school doet. xD

Haha

Handel en Economie is zo saaaaaii..
En verder had ik alles af.. en leren hoefde ik niet..
Dus ik dacht..
MySQL Class

Shahiem

Lid

Berichten: 20.364
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 9 aug 2020

10 mei 2011, 18:27

Nice man, maar is de array niet zo beter?

$db = array(dbnaam => db,
            naam => db,
            wachtwoord => db,
            host => db);

BasDev

Lid · Topicstarter

Berichten: 2.692
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 17 mei 2024

10 mei 2011, 18:31

Shahiem schreef:
Nice man, maar is de array niet zo beter?
$db = array(dbnaam => db,
            naam => db,
            wachtwoord => db,
            host => db);

Jah idd.. maar dat was ik vergeten om te maken.. dat in dit topic is ff snelwerk

Sebastiaanh

Lid

Berichten: 9.953
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 12 jun 2025

10 mei 2011, 18:33

FF Offtopic, hoe doe je eigenlijk een spoiler titel?

Shahiem

Lid

Berichten: 20.364
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 9 aug 2020

10 mei 2011, 18:35

[spoiler=titel]ss[/spoiler]

Sebastiaanh

Lid

Berichten: 9.953
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 12 jun 2025

10 mei 2011, 18:39

#10

Oke ty

Kyron

Lid

Berichten: 3.314
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 12 jun 2025

10 mei 2011, 20:12

#11

Opzich leuk maar je hebt er nauwelijks wat aan, aangezien je ipv MySQL::query net zo goed de mysql functie kun gebruikten.Noem de class liever Database zodat het wat abstracter is en ook aanpasbaar is waar het voor bedoeld is. Anders stap je later op een andere db over en kun je alsnog alles hertypen

BasDev

Lid · Topicstarter

Berichten: 2.692
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 17 mei 2024

11 mei 2011, 07:39

#12

Kyron schreef:
Opzich leuk maar je hebt er nauwelijks wat aan, aangezien je ipv MySQL::query net zo goed de mysql functie kun gebruikten.Noem de class liever Database zodat het wat abstracter is en ook aanpasbaar is waar het voor bedoeld is. Anders stap je later op een andere db over en kun je alsnog alles hertypen

Je hebt er veel aan hoor?
Tenminste .. als je ehm goed gebruikt.
En waarom zou je de class moeten herschrijven als je overstapt op een andere db..
Je hoeft alleen de gegevens te veranderen

Luukvdo

Lid

Berichten: 18.482
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 21 mrt 2020

11 mei 2011, 12:39

#13

Als je naar een ander database type overgaat (PostgreSQL bijvoorbeeld) en je class heet MySQL dan klopt het niet echt meer

Verder best netjes alleen jammer dat het geen MySQLi is

Kyron

Lid

Berichten: 3.314
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 12 jun 2025

11 mei 2011, 15:53

#14

Luukvdo schreef:
Als je naar een ander database type overgaat (PostgreSQL bijvoorbeeld) en je class heet MySQL dan klopt het niet echt meer Verder best netjes alleen jammer dat het geen MySQLi is

Dit dus. Je naam klopt dan niet meer

Terwijl het idee van mysql via class doen nu juist is dat het aanpasbaar blijft.

Jouw reactie

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