|
Class mysql {
Private $ host; // ��
Private $ name; // ��
Private $ pass; // ��
Private $ database; //
Private $ ut; // �� 뷽 ʽ
Function _ construct ($ host, $ name, $ pass, $ database, $ ut ){
$ This-> host = $ host;
$ This-> name = $ name;
$ This-> pass = $ pass;
$ This-> database = $ database;
$ This-> ut = $ ut;
$ This-> connect ();
}
Function connect (){
$ Link = mysql_connect ($ this-> host, $ this-> name, $ this-> pass) or die ($ this-> error ());
Mysql_select_db ($ this-> database, $ link) or die ("û � ⣺". $ this-> database );
Mysql_query ("set names '$ this-> ut '");
}
Function query ($ SQL, $ type = ''){
If (! ($ Query = mysql_query ($ SQL) $ this-> show ('say: ', $ SQL );
Return $ query;
}
Function show ($ message = '', $ SQL = ''){
If (! $ SQL) echo $ message;
Else echo $ message .'
'. $ SQL;
}
Function affected_rows (){
Return mysql_affected_rows ();
}
Function result ($ query, $ row ){
Return mysql_result ($ query, $ row );
}
Function num_rows ($ query ){
Return @ mysql_num_rows ($ query );
}
Function num_fields ($ query ){
Return mysql_num_fields ($ query );
}
Function free_result ($ query ){
Return mysql_free_result ($ query );
}
Function insert_id (){
Return mysql_insert_id ();
}
Function fetch_row ($ query ){
Return mysql_fetch_row ($ query );
}
Function version (){
Return mysql_get_server_info ();
}
Function close (){
Return mysql_close ();
}
Function htmtocode ($ content ){
$ Content = str_replace ("n ","
", Str_replace (" "," ", $ content ));
Return $ content;
}
}
$ Db = new mysql ("localhost", "root", "", "database", "utf8 ");
?>
|