Class db

db

Classes extended from db:

Located in File: Program_Root/mysql_db_class.php


class mysql_db_class
Trida urcena pro pristup k MySQL databazi. Obsahuje vsechny zname PHP
 funkce pro praci s MySQL + mnoho dalsich uzitecnych funkci, ktere jsou
 bud kopii jinych PHP funkci, nebo jsou vytvoreny z existujicich funkci
 a slouzi k ulehceni programatorske prace. Posledni aktualni verzi tridy
 naleznete na homepage tridy.

Class Variable Summary

Inherited Class Variable Summary

Inherited Method Summary

Method Summary
class db ( $server, $user, $pass, [$new = false], $db )
Konstruktor tridy
bool db_field_seek ( $polozka, $sql )
Ekvivalent mysql_field_seek()
string db_field_table ( $polozka, $sql )
Ekvivalent mysql_field_table()
string db_field_len ( $polozka, $sql )
Ekvivalent mysql_field_len()
object db_fetch_object ( $sql )
Ekvivalent mysql_fetch_object()
string db_field_flags ( $polozka, $sql )
Ekvivalent mysql_field_flags()
bool db_drop_db ( $database, $conn )
Ekvivalent mysql_drop_db()
bool db_free_result ( $sql )
Ekvivalent mysql_free_result()
string db_create_db ( $database, $conn )
Ekvivalent mysql_create_db()
string db_dbname ( $radek, $sql )
Ekvivalent mysql_dbname()
string db_field_type ( $polozka, $sql )
Ekvivalent mysql_field_type()
object db_fetch_field ( $polozka, $sql )
Ekvivalent mysql_fetch_field()
resource db_list_fields ( $table, $db, $conn )
Ekvivalent mysql_list_fields()
string db_get_host_info ( $conn )
Ekvivalent mysql_get_host_info()
string db_get_proto_info ( $conn )
Ekvivalent mysql_get_proto_info()
string db_get_server_info ( $conn )
Ekvivalent mysql_get_server_info()
double getPHPVersion ( )
Vraci ciselne vyjadreni verze PHP
string db_get_client_info ( )
Ekvivalent mysql_get_client_info()
integer db_fetch_lengths ( $sql )
Ekvivalent mysql_fetch_lengths()
string db_list_dbs ( $conn )
Ekvivalent mysql_list_dbs()
bool db_list_tables ( $db, $conn )
Ekvivalent mysql_list_tables()
string db_tablename ( $radek, $sql )
Ekvivalent mysql_tablename()
string db_escape_string ( $tmp )
Ekvivalent mysql_escape_string()
integer db_num_fields ( $sql )
Ekvivalent mysql_num_fields()
void db_Close ( $conn )
Ekvivalent mysql_close()
ResourceID &db_pConnect ( $server, $user, $pass )
Ekvivalent mysql_pconnect()
ResourceID &db_Connect ( $server, $user, $pass, [$new = false] )
Ekvivalent mysql_connect()
bool &db_Select_DB ( $db, $conn )
Ekvivalent mysql_select_db()
resource &db_Query ( $query, $conn )
Ekvivalent mysql_query()
void debug ( [$DEBUG = 1], [$SHOW_ERROR = 1], $LOG_ERROR, $ERRORLOG )
Zapinani / vypinani debug modu Zapinani / vypinani debug modu. Zapne, vypne a nastavi moznost logovani a zobrazovani chyb.
void explain ( $query )
Funkce provede EXPLAIN SQL dotazu a zobrazi jej v HTML tabulce
string show_data ( $result, $from, $to, [$csv = FALSE], $separator, [$crlf = "\r\n"] )
Funkce pripravi data ziskane SQL dotazem. Data lze nafirmatovat bud do jednoduche HTML tabulky nebo do CSV formatu. Pripadne lze definovat vlastni separator a CRLF - prechod na dalsi radek.
void userLog ( $ULOG, $SHOW_MESSAGE, $LOG_MESSAGE, $USERLOG, [$PRECISION = 5] )
Zapinani / vypinani userlogu Zapinani / vypinani userlogu. Zapne, vypne a nastavi moznost logovani a zobrazovani SQL dotazu vcetne casu provadeni.
false _error ( $_errorNo, $_errorStr, $_query )
Interni funkce zapisuje chybovou hlášku do error logu
false _writeUserLog ( $_query, $_time )
Interni funkce zapisuje hlášku do user logu
resource &db_Db_Query ( $query, $db, $conn )
Ekvivalent mysql_db_query()
resource &db_Unbuffered_Query ( $query, $conn )
Ekvivalent mysql_unbuffered_query()
integer db_Fetch_All_Into ( &$pole, $sql )
Obdoba db_fetch_into().
string db_Result ( $radek, $sloupec, $sql )
Ekvivalent mysql_result()
integer db_Insert_Id ( )
Ekvivalent mysql_insert_id()
bool db_Data_Seek ( $radek, $sql )
Ekvivalent mysql_data_seek()
integer db_Fetch_Into ( $sloupec, &$pole, $sql )
Ekvivalent odbc_fetch_into()
array db_Fetch_Assoc ( $sql )
Ekvivalent mysql_fetch_assoc()
integer db_Num_Rows ( $sql )
Ekvivalent mysql_num_rows()
integer db_Affected_Rows ( $conn )
Ekvivalent mysql_affected_rows()
array db_Fetch_Row ( $sql )
Ekvivalent mysql_fetch_row()
array db_Fetch_Array ( $sql )
Ekvivalent mysql_fetch_array()
string db_field_name ( $sloupec, $sql )
Ekvivalent mysql_field_name()
Variable Detail

Method Detail

constructor db

class db ( $server, $user, $pass, [$new = false], $db )

Konstruktor tridy
Konstruktor tridy vytvori pripojeni k databazi a pripadne zvoli zadanou databazi
Function Parameters:
- $server string databazovy server
- $user string databazovy user
- $pass string databazove heslo
- $new bool vytvaret nove spojeni (pouze v PHP 4.2+)
- $db string nazev databaze
Function Info:
Return - link
Access - public

db_field_seek

bool db_field_seek ( $polozka, $sql )

Ekvivalent mysql_field_seek()

Function Parameters:
- $polozka integer cislo sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_field_table

string db_field_table ( $polozka, $sql )

Ekvivalent mysql_field_table()

Function Parameters:
- $polozka integer cislo sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_field_len

string db_field_len ( $polozka, $sql )

Ekvivalent mysql_field_len()

Function Parameters:
- $polozka integer cislo sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_fetch_object

object db_fetch_object ( $sql )

Ekvivalent mysql_fetch_object()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_field_flags

string db_field_flags ( $polozka, $sql )

Ekvivalent mysql_field_flags()

Function Parameters:
- $polozka integer cislo sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_drop_db

bool db_drop_db ( $database, $conn )

Ekvivalent mysql_drop_db()

Function Parameters:
- $database string nazev databaze
- $conn resource identifikator databazoveho spojeni
Function Info:
Access - public

db_free_result

bool db_free_result ( $sql )

Ekvivalent mysql_free_result()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_create_db

string db_create_db ( $database, $conn )

Ekvivalent mysql_create_db()

Function Parameters:
- $database string nazev databaze
- $conn resource identifikator pripojeni k databazi
Function Info:
Access - public

db_dbname

string db_dbname ( $radek, $sql )

Ekvivalent mysql_dbname()

Function Parameters:
- $radek integer poradi ve vysledku
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_field_type

string db_field_type ( $polozka, $sql )

Ekvivalent mysql_field_type()

Function Parameters:
- $polozka integer cislo sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_fetch_field

object db_fetch_field ( $polozka, $sql )

Ekvivalent mysql_fetch_field()

Function Parameters:
- $polozka integer cislo polozky vysledku
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_list_fields

resource db_list_fields ( $table, $db, $conn )

Ekvivalent mysql_list_fields()

Function Parameters:
- $table string nazev tabulky
- $db string nazev databaze
- $conn resource identifikator pripojeni k databazi
Function Info:
Access - public

db_get_host_info

string db_get_host_info ( $conn )

Ekvivalent mysql_get_host_info()

Function Parameters:
- $conn resource identifikator databazoveho spojeni
Function Info:
Access - public

db_get_proto_info

string db_get_proto_info ( $conn )

Ekvivalent mysql_get_proto_info()

Function Parameters:
- $conn resource identifikator databazoveho spojeni
Function Info:
Access - public

db_get_server_info

string db_get_server_info ( $conn )

Ekvivalent mysql_get_server_info()

Function Parameters:
- $conn resource identifikator databazoveho spojeni
Function Info:

getPHPVersion

double getPHPVersion ( )

Vraci ciselne vyjadreni verze PHP

Function Parameters:
Function Info:

db_get_client_info

string db_get_client_info ( )

Ekvivalent mysql_get_client_info()

Function Parameters:
- 0 void
Function Info:
Access - public

db_fetch_lengths

integer db_fetch_lengths ( $sql )

Ekvivalent mysql_fetch_lengths()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_list_dbs

string db_list_dbs ( $conn )

Ekvivalent mysql_list_dbs()

Function Parameters:
- $conn resource identifikator databazoveho spojeni
Function Info:
Access - public

db_list_tables

bool db_list_tables ( $db, $conn )

Ekvivalent mysql_list_tables()

Function Parameters:
- $db string nazev databaze
- $conn resource identifikator databazoveho spojeni
Function Info:
Access - public

db_tablename

string db_tablename ( $radek, $sql )

Ekvivalent mysql_tablename()

Function Parameters:
- $radek integer cislo radku
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_escape_string

string db_escape_string ( $tmp )

Ekvivalent mysql_escape_string()

Function Parameters:
- $tmp string retezec ktery bude opatren escape sekvencemi
Function Info:
Access - public

db_num_fields

integer db_num_fields ( $sql )

Ekvivalent mysql_num_fields()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Close

void db_Close ( $conn )

Ekvivalent mysql_close()

Function Parameters:
- $conn resource identifikator databazoveho spojeni
Function Info:
Access - public

db_pConnect

ResourceID &db_pConnect ( $server, $user, $pass )

Ekvivalent mysql_pconnect()

Function Parameters:
- $server string SQL server
- $user string SQL user
- $pass string SQL heslo
Function Info:
Access - public

db_Connect

ResourceID &db_Connect ( $server, $user, $pass, [$new = false] )

Ekvivalent mysql_connect()

Function Parameters:
- $server string SQL server
- $user string SQL user
- $pass string SQL heslo
- $new bool vytvaret novy link
Function Info:
Access - public

db_Select_DB

bool &db_Select_DB ( $db, $conn )

Ekvivalent mysql_select_db()

Function Parameters:
- $db string nazev databaze
- $conn resource identifikator pripojeni
Function Info:
Access - public

db_Query

resource &db_Query ( $query, $conn )

Ekvivalent mysql_query()

Function Parameters:
- $query string SQL dotaz
- $conn resource identifikator pripojeni
Function Info:
Access - public

debug

void debug ( [$DEBUG = 1], [$SHOW_ERROR = 1], $LOG_ERROR, $ERRORLOG )

Zapinani / vypinani debug modu Zapinani / vypinani debug modu. Zapne, vypne a nastavi moznost logovani a zobrazovani chyb.

Function Parameters:
- $DEBUG bool 1 = zapnuty debug mod, 0 = vypnuty
- $SHOW_ERROR bool 1 = zobrazuhe chyby na strance
- $LOG_ERROR bool 1 = loguje chyby do souboru
- $ERRORLOG string cesta k errorlogu. Neni li zadana, pouzije se defaultni. Vhodne uvadet absolutni cestu.
Function Info:
Access - public

explain

void explain ( $query )

Funkce provede EXPLAIN SQL dotazu a zobrazi jej v HTML tabulce

Function Parameters:
- $query string SQL dotaz
Function Info:
Access - public

show_data

string show_data ( $result, $from, $to, [$csv = FALSE], $separator, [$crlf = "\r\n"] )

Funkce pripravi data ziskane SQL dotazem. Data lze nafirmatovat bud do jednoduche HTML tabulky nebo do CSV formatu. Pripadne lze definovat vlastni separator a CRLF - prechod na dalsi radek.
Pripravena data budou v navratove hodnote.
Function Parameters:
- $result ResourceID identifikator SQL vysledku
- $from integer radek od ktereho zacne zpracovani dat
- $to integer radek na kterem konci zobrazeni dat. Je-li rovny 0 budou se data zpracovavat az po posledni radek vysledku
- $csv bool FALSE pro HTML, TRUE pro CSV
- $separator string separator sloupcu ve vyslednem CSV
- $crlf string oddelovac radku
Function Info:
Access - public

userLog

void userLog ( $ULOG, $SHOW_MESSAGE, $LOG_MESSAGE, $USERLOG, [$PRECISION = 5] )

Zapinani / vypinani userlogu Zapinani / vypinani userlogu. Zapne, vypne a nastavi moznost logovani a zobrazovani SQL dotazu vcetne casu provadeni.

Function Parameters:
- $ULOG bool 1 = zapnuty log mod, 0 = vypnuty
- $SHOW_MESSAGE bool 1 = zobrazuhe dotazy a casy provadeni ve strance
- $LOG_MESSAGE bool 1 = loguje dotazy a casy provadeni ve strance do souboru
- $USERLOG string cesta k userlogu. Neni li zadana, pouzije se defaultni. Vhodne uvadet absolutni cestu
- $PRECISION int zaokrouhleni casu vykonavani na $PRECISION desetinnych mist
Function Info:
Access - public

_error

false _error ( $_errorNo, $_errorStr, $_query )

Interni funkce zapisuje chybovou hlášku do error logu

Function Parameters:
- $_errorNo string cislo SQL chyby
- $_errorStr string popis SQL chyby
- $_query string SQL dotaz
Function Info:

_writeUserLog

false _writeUserLog ( $_query, $_time )

Interni funkce zapisuje hlášku do user logu

Function Parameters:
- $_query string SQL dotaz
- $_time string cas provadeni dotazu
Function Info:

db_Db_Query

resource &db_Db_Query ( $query, $db, $conn )

Ekvivalent mysql_db_query()

Function Parameters:
- $query string SQL dotaz
- $db string nazev databaze
- $conn resource identifikator pripojeni
Function Info:
Access - public

db_Unbuffered_Query

resource &db_Unbuffered_Query ( $query, $conn )

Ekvivalent mysql_unbuffered_query()

Function Parameters:
- $query string SQL dotaz
- $conn resource identifikator pripojeni
Function Info:
Access - public

db_Fetch_All_Into

integer db_Fetch_All_Into ( &$pole, $sql )

Obdoba db_fetch_into().
Obdoba db_fetch_into(). Funkce vlozi do pole vsechny hodnoty z dotazu.
Function Parameters:
- $pole array jmeno pole do ktereho se naliji data
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Result

string db_Result ( $radek, $sloupec, $sql )

Ekvivalent mysql_result()

Function Parameters:
- $radek integer cislo radku
- $sloupec mixed cislo nebo nazev sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Insert_Id

integer db_Insert_Id ( )

Ekvivalent mysql_insert_id()

Function Parameters:
- 0 void
Function Info:
Access - public

db_Data_Seek

bool db_Data_Seek ( $radek, $sql )

Ekvivalent mysql_data_seek()

Function Parameters:
- $radek integer cislo radku
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Fetch_Into

integer db_Fetch_Into ( $sloupec, &$pole, $sql )

Ekvivalent odbc_fetch_into()
Ekvivalent odbc_fetch_into(). Funkce vlozi do pole vsechny
 hodnoty z definovaneho sloupce.
Function Parameters:
- $sloupec mixed nazev nebo poradi sloupce ve vysledku
- $pole array jmeno pole do ktereho se naliji data
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Fetch_Assoc

array db_Fetch_Assoc ( $sql )

Ekvivalent mysql_fetch_assoc()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Num_Rows

integer db_Num_Rows ( $sql )

Ekvivalent mysql_num_rows()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Affected_Rows

integer db_Affected_Rows ( $conn )

Ekvivalent mysql_affected_rows()

Function Parameters:
- $conn resource identifikator pripojeni k databazi
Function Info:
Access - public

db_Fetch_Row

array db_Fetch_Row ( $sql )

Ekvivalent mysql_fetch_row()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_Fetch_Array

array db_Fetch_Array ( $sql )

Ekvivalent mysql_fetch_array()

Function Parameters:
- $sql resource identifikator SQL dotazu
Function Info:
Access - public

db_field_name

string db_field_name ( $sloupec, $sql )

Ekvivalent mysql_field_name()

Function Parameters:
- $sloupec integer cislo sloupce
- $sql resource identifikator SQL dotazu
Function Info:
Access - public