PHPBuilder.com, the best resource for PHP tutorials, templates, PHP manuals, content management systems, scripts, classes and more.

Index: phpdoc/en/functions/mysql.xml diff -u phpdoc/en/functions/mysql.xml:1.59 phpdoc/en/functions/mysql.xml:1.60 --- phpdoc/en/functions/mysql.xml:1.59 Sun Aug 19 07:47:42 2001 +++ phpdoc/en/functions/mysql.xml Thu Aug 30 12:35:09 2001 @@ -1,79 +1,44 @@ - - + - MySQL functions + MySQL f�ggv�nyek MySQL - These functions allow you to access MySQL database servers. In - order to have these functions available, you must compile php - with MySQL support by using the - option. If you - use this option without specifying the path to MySQL, php will - use the built-in MySQL client libraries. Users who run other - applications that use MySQL (for example, running php3 and php4 - as concurrent apache modules, or auth-mysql) should always - specify the path to MySQL: - . - This will force php to use the client libraries installed by - MySQL, avoiding any conflicts. + E f�ggv�nyek seg�ts�g�vel �rheted el a MySQL adatb�zisokat. Ahhoz, hogy + ezeket a f�ggv�nyeket haszn�lhasd, a php-t a + opci�val kell leford�tanod. + Ha nem adod meg az opci� ut�n a mysql el�r�si �tvonal�t, akkor a php a + be�p�tett mysql kliens k�nyvt�rat fogja haszn�lni. Ha a felhaszn�l�k m�s + alkalmaz�sokat is haszn�lnak, amelyek mysql-t haszn�lnak (p�ld�ul a php + 3-as �s 4-es verzi�j�t, vagy az auth-mysql-t), akkor mindig meg kell adni + a mysql el�r�si �tvonal�t a + form�ban. + Ez ki fogja k�nyszer�teni, hogy a megl�v� mysql kliens k�nyvt�rat + haszn�lja a php, elker�lve az ebb�l ad�d� �tk�z�seket. - More information about MySQL can be found at &url.mysql;. + A MySQL-r�l tov�bbi inform�ci�t a + &url.mysql; c�men tal�lsz. - Documentation for MySQL can be found at &url.mysql.docs;. - - This simple example shows how to connect, execute a query, print - resulting rows and disconnect from MySQL Database. - - MySQL extension overview example - -<?php - $link = mysql_connect("mysql_host", "mysql_login", "mysql_password") - or die ("Could not connect"); - print ("Connected successfully"); - mysql_select_db ("my_database") - or die ("Could not select database"); - - $query = "SELECT * FROM my_table"; - $result = mysql_query ($query) - or die ("Query failed"); - - // printing HTML result - - print "<table>\n"; - while($line = mysql_fetch_array($result)){ - print "\t<tr>\n"; - while(list($col_name, $col_value) = each($line)){ - print "\t\t<td>$col_value</td>\n"; - } - print "\t</tr>\n"; - } - print "</table>\n"; - - mysql_close($link); -?> - - - + mysql_affected_rows - Get number of affected rows in previous MySQL - operation + Az el�z� MySQL m�veletben �rintett sorok sz�m�t adja + meg - Description + Le�r�s int mysql_affected_rows - resource + int link_identifier @@ -81,44 +46,31 @@ - mysql_affected_rows returns the number - of rows affected by the last INSERT, UPDATE or DELETE query - associated with link_identifier. If the - link identifier isn't specified, the last link opened by - mysql_connect is assumed. - - - - If you are using transactions, you need to call - mysql_affected_rows after your INSERT, - UPDATE, or DELETE query, not after the commit. - - - - If the last query was a DELETE query with no WHERE clause, all - of the records will have been deleted from the table but this - function will return zero. + A mysql_affected_rows f�ggv�ny az el�z� + link_identifier-rel azonos�tott kapcsolatban kiadott INSERT, + UPDATE vagy DELETE k�r�sben �rintett sorok sz�m�t adja vissza. + Ha nem adsz meg kapcsolat-azonos�t�t, akkor az utolj�ra megnyitott + kapcsolatr�l kapsz inform�ci�t. - When using UPDATE, MySQL will not update columns where the new - value is the same as the old value. This creates the possiblity - that mysql_affected_rows may not actually - equal the number of rows matched, only the number of rows that - were literally affected by the query. + Ha transzakci�kezel�st hasznn�lsz, akkor a + mysql_affected_rows f�ggv�nyt az INSERT, UPDATE, + vagy DELETE k�r�s ut�n k�zvetlen�l, nem a kommit ut�n kell megh�vni. - mysql_affected_rows does not work with - SELECT statements; only on statements which modify records. To - retrieve the number of rows returned by a SELECT, use - mysql_num_rows. + Ha az utols� lek�rdez�s egy WHERE felt�tel n�lk�li DELETE volt, akkor b�r + a t�bl�b�l minden sor t�rl�dik, a f�ggv�ny null�t fog visszaadni. - If the last query failed, this function will return -1. + Ez a parancs nem hat�kony a lek�rdez� SELECT k�r�ssel egy�tt haszn�lva, + csak azokkal a lek�rdez�sekkel, melyek m�dos�tj�k a t�bl�zat sorait. + Ha egy SELECT lek�rdez�sben kapott sorok sz�m�t szeretn�d megkapni, + akkor haszn�ld a mysql_num_rows f�ggv�nyt. - See also: mysql_num_rows. + Ha az utols� k�r�s meghiusul, akkor a f�ggv�ny -1-gyel t�r vissza. @@ -127,11 +79,11 @@ mysql_change_user - Change logged in user of the active connection + Akt�v kapcsolat felhaszn�l�j�nak m�dos�t�sa - Description + Le�r�s int mysql_change_user @@ -142,7 +94,7 @@ database - resource + int link_identifier @@ -150,17 +102,13 @@ - mysql_change_user changes the logged in user - of the current active connection, or the connection given by the - optional parameter link_identifier. If a database is - specified, this will default or current database after the user - has been changed. If the new user and password authorization fails, - the current connected user stays active. - - - - This function was introduced in PHP 3.0.13 and - requires MySQL 3.23.3 or higher. + A mysql_change_user f�ggv�ny megv�ltoztatja az + aktu�lis, vagy az opcion�lis param�terben megadott azonos�t�j� kapcsolat + felhaszn�l�j�t. Ha egy adatb�zis nev�t megadod, akkor ez lesz az + alap�rtelmezett adatb�zis. Ha az �j n�v-jelsz� p�ros helytelen, akkor a + f�ggv�nyh�v�s el�tti kapcsolat �l tov�bb. + A f�ggv�ny a PHP 3.0.13 v�ltozat�val ker�lt a nyelvbe �s + MySQL 3.23.3, vagy k�s�bbi v�ltozata sz�ks�ges a haszn�lat�hoz. @@ -168,14 +116,14 @@ mysql_close - Close MySQL connection + Lez�r egy MySQL kapcsolatot - Description + Le�r�s - bool mysql_close - resource + int mysql_close + int link_identifier @@ -183,40 +131,38 @@ - Returns: &true; on success, &false; on error. + A f�ggv�ny �rt�ke igaz, ha a m�velet siker�lt, hamis, ha nem. - mysql_close closes the connection to - the MySQL server that's associated with the specified link - identifier. If link_identifier isn't - specified, the last opened link is used. + A mysql_close f�ggv�ny bez�rja az adott + azonos�t�j� MySQL kapcsolatot. Ha nem adsz meg + link_identifier param�tert, akkor az utolj�ra + megnyitott kapcsolatot z�rja le. - Using mysql_close isn't usually necessary, - as non-persistent open links are automatically closed at the end - of the script's execution. See also - freeing - resources. + A mysql_close f�ggv�ny haszn�lata �ltal�ban + sz�ks�gtelen, mert a nem perzisztens kapcsolatok a szkript v�g�n + bez�r�dnak. - mysql_close will not close persistent links - created by mysql_pconnect. + A mysql_close f�ggv�ny nem z�rja be a + mysql_pconnect f�ggv�nnyel megnyitott kapcsolatokat. - MySQL close example + MySQL close p�lda <?php - $link = mysql_connect ("kraemer", "marliesle", "secret") - or die ("Could not connect"); - print ("Connected successfully"); + $link = mysql_connect ("kraemer", "marliesle", "titok") + or die ("Nem lehet csatlakozni"); + print ("A csatlakoz�s siker�lt"); mysql_close ($link); ?> - See also: mysql_connect, and - mysql_pconnect. + L�sd m�g a mysql_connect �s a + mysql_pconnect f�ggv�nyeket! @@ -224,13 +170,13 @@ mysql_connect - Open a connection to a MySQL Server + Kapcsolatot nyit meg egy MySQL szerverhez - Description + Le�r�s - resource mysql_connect + int mysql_connect string hostname @@ -252,61 +198,60 @@ - Returns a MySQL link identifier on success, or &false; on failure. - - - mysql_connect establishes a connection - to a MySQL server. The following defaults are assumed for - missing optional parameters: host:port = - 'localhost:3306', username = name of the - user that owns the server process and - password = empty password. + Pozit�v MySQL azonos�t�val t�r vissza, ha a csatlakoz�s siker�lt. Hiba + eset�n pedig hiba�zenetet �r a kimenetre �s 0-val t�r vissza. - The hostname string can also include a port - number. eg. "hostname:port" or a path to a socket - eg. ":/path/to/socket" for the localhost. + A mysql_connect f�ggv�ny kapcsolatot nyit meg egy + MySQL szerverhez. A param�tereket elhagyhatod. Az alap�rtelmezett + �rt�kek: host:port = 'localhost:3306', + username = a folyamat tulajdonos�nak bel�p�si neve + password = �res karakterl�nc. + + + A hostname param�ter tartalmazhat egy portsz�mot is, p�ld�ul: + "hostname:port" vagy tartalmazhatja a MySQL socket el�r�si + �tvonal�t, p�ld�ul: ":/path/to/socket". Az ut�bbi hostname + param�tert haszn�lva is a helyi MySQL szerverhez pr�b�l majd kapcsol�dni + a f�ggv�ny. - Support for ":port" was added in PHP 3.0B4. + A ":port" form�tum� kieg�sz�t�s a PHP 3.0B4-es v�ltozat�ban + ker�lt a nyelvbe. - Support for ":/path/to/socket" was added in - PHP 3.0.10. + A ":/path/to/socket" form�t pedig a PHP 3.0.10-es verzi�j�t�l + kezdve haszn�lhatjuk. - You can suppress the error message on failure by prepending '@' - to the function name. + A sikertelen kapcsolatkor ki�rt hiba�zenetet elnyomhatod, ha '@' jelet + �rsz a f�ggv�ny el�. - If a second call is made to mysql_connect - with the same arguments, no new link will be established, but - instead, the link identifier of the already opened link will be - returned. + Ha a mysql_connect f�ggv�nyt k�tszer ugyanazokkal a + param�terekkel h�vod meg, akkor nem j�n l�tre �jabb kapcsolat; a f�ggv�ny + a m�r megl�v� kapcsolat azonos�t�j�t fogja visszaadni. - The link to the server will be closed as soon as the execution of - the script ends, unless it's closed earlier by explicitly calling - mysql_close. + A kapcsolat a PHP program v�g�n bez�rul, ha el�bb nem z�rtuk volna le a + mysql_close f�ggv�nnyel. - MySQL connect example + MySQL connect p�lda <?php - - $link = mysql_connect ("localhost", "username", "secret") - or die ("Could not connect"); - print ("Connected successfully"); + $link = mysql_connect ("kraemer", "marliesle", "titok") + or die ("Nem lehet csatlakozni"); + print ("A csatlakoz�s siker�lt"); mysql_close ($link); - ?> - See also - mysql_pconnect, and - mysql_close. + L�sd m�g a + mysql_pconnect �s + mysql_close f�ggv�nyeket. @@ -314,15 +259,15 @@ mysql_create_db - Create a MySQL database + L�trehoz egy MySQL adatb�zist - Description + Le�r�s int mysql_create_db string database name - resource + int link_identifier @@ -330,31 +275,29 @@ - mysql_create_db attempts to create a new - database on the server associated with the specified link - identifier. + A mysql_create_db f�ggv�ny megk�s�rel l�trehozni egy + �j adatb�zist a megadott kapcsolatazonos�t�n kereszt�l. - - MySQL create database example + MySQL 'create database' p�lda <?php $link = mysql_pconnect ("kron", "jutta", "geheim") - or die ("Could not connect"); + or die ("Nem lehet csatlakozni") if (mysql_create_db ("my_db")) { - print ("Database created successfully\n"); + print ("Az adatb�zist l�trehoztam\n"); } else { - printf ("Error creating database: %s\n", mysql_error ()); + printf ("Hiba az adatb�zis l�trehoz�sakor: %s\n", mysql_error ()); } ?> - For downwards compatibility mysql_createdb - can also be used. + Kompat�bilit�si okokb�l a mysql_createdb f�ggv�ny is + haszn�lhat�. - See also: mysql_drop_db. + L�sd m�g a: mysql_drop_db f�ggv�nyt. @@ -362,59 +305,60 @@ mysql_data_seek - Move internal result pointer + Bels� eredm�nymutat� mozgat�sa - Description + Le�r�s - bool mysql_data_seek - resource result_identifier + int mysql_data_seek + int result_identifier int row_number - Returns: &true; on success, &false; on failure. + Igazzal t�r vissza, ha a m�velet siker�lt - mysql_data_seek moves the internal row - pointer of the MySQL result associated with the specified result - identifier to point to the specified row number. The next call - to mysql_fetch_row would return that row. + A mysql_data_seek f�ggv�ny az adott azonos�t�j� + erem�nyhalmazban ugrik a megadott poz�ci�ra. + A mysql_fetch_row f�ggv�ny k�vetkez� h�v�sakor ezt a + sorsz�m� sort kapod meg. - Row_number starts at 0. + Ha az els� sorra akarsz pozicion�lni, akkor + Row_number 0 legyen! - MySQL data seek example + MySQL data seek p�lda <?php $link = mysql_pconnect ("kron", "jutta", "geheim") - or die ("Could not connect"); + or die ("Nem tudok csatlakozni"); mysql_select_db ("samp_db") - or die ("Could not select database"); + or die ("Nem tudok bel�pni az adatb�zisba"); $query = "SELECT last_name, first_name FROM friends"; - $result = mysql_query ($query) - or die ("Query failed"); + $eredmeny = mysql_query ($query) + or die ("Rossz k�r�s"); # fetch rows in reverse order - for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) { - if (!mysql_data_seek ($result, $i)) { - echo "Cannot seek to row $i\n"; + for ($i = mysql_num_rows ($eredmeny) - 1; $i >=0; $i--) { + if (!mysql_data_seek ($eredmeny, $i)) { + printf ("Nem tudok a %d. sorra ugorni\n", $i); continue; } - if(!($row = mysql_fetch_object ($result))) + if(!($sor = mysql_fetch_object ($eredmeny))) continue; - echo ("$row->last_name $row->first_name \n"; + printf ("%s %s \n", $sor->last_name, $sor->first_name); } - mysql_free_result ($result); + mysql_free_result ($eredmeny); ?> @@ -427,11 +371,11 @@ Get result data - Description + Le�r�s - string mysql_db_name - resource result + int mysql_db_name + int result int row mixed @@ -441,27 +385,26 @@ - mysql_db_name takes as its first parameter - the result pointer from a call to - mysql_list_dbs. The - row parameter is an index into the result - set. + A mysql_db_name f�ggv�ny els� param�tere egy + mysql_list_dbs �ltal visszaadott �rt�k. A + row param�ter az eredm�nyhalmaz indexe. - If an error occurs, &false; is returned. Use - mysql_errno and - mysql_error to determine the nature of the - error. + Ha hiba t�rt�nt, a f�ggv�ny FALSE-szal t�r vissza. + Haszn�ld a + mysql_errno �s a + mysql_error f�ggv�nyeket a hiba eredet�nek + meg�llap�t�s�ra! - <function>mysql_db_name</function> example + <function>Mysql_db_name</function> p�lda <?php error_reporting(E_ALL); -mysql_connect('dbhost', 'username', 'password'); +mysql_connect('dbhost', 'n�v', 'jelsz�'); $db_list = mysql_list_dbs(); $i = 0; @@ -475,8 +418,8 @@ - For backward compatibility, mysql_dbname is - also accepted. This is deprecated, however. + Kompat�bilit�si okokb�l a mysql_dbname f�ggv�ny is + haszn�lhat�, de haszn�lata nem javasolt. @@ -485,16 +428,16 @@ mysql_db_query - Send a MySQL query + MySQL k�r�st k�ld az adatb�zisnak - Description + Le�r�s - resource mysql_db_query + int mysql_db_query string database string query - resource + int link_identifier @@ -502,29 +445,22 @@ - Returns: A positive MySQL result resource to the query result, - or &false; on error. + Visszat�r�si �rt�ke egy pozit�v MySQL eredm�ny-azonos�t�, ha a k�r�s + sikeres volt, hamissal, ha a k�r�s hib�s volt. - mysql_db_query selects a database and - executes a query on it. If the optional link identifier isn't - specified, the function will try to find an open link to the - MySQL server and if no such link is found it'll try to create one - as if mysql_connect was called with no - arguments + A mysql_db_query f�ggv�ny kiv�laszt egy adatb�zist, + majd azon v�grehajt egy k�r�st. Ha a kapcsolat azonos�t� nincs megadva, + akkor a f�ggv�ny keres egyet. Ha nem tal�l ilyet, akkor megpr�b�l + l�trehozni egyet oly m�don, mintha megh�vta volna a + mysql_connect f�ggv�nyt param�terek n�lk�l. - See also mysql_connect and - mysql_query. + L�sd m�g a mysql_connect f�ggv�nyt. - - - This function has been deprecated since PHP 4.0.6. - Do not use this function. Use mysql_select_db - and mysql_query instead. - - + Kompat�bilit�si okokb�l a mysql f�ggv�ny is + haszn�lhat�. @@ -532,15 +468,15 @@ mysql_drop_db - Drop (delete) a MySQL database + T�r�l egy MySQL adatb�zist - Description + Le�r�s - bool mysql_drop_db + int mysql_drop_db string database_name - resource + int link_identifier @@ -548,16 +484,16 @@ - Returns: &true; on success, &false; on failure. + Visszat�r�si �rt�ke: igaz, ha sikeres, hamis, ha nem - mysql_drop_db attempts to drop (remove) an - entire database from the server associated with the specified - link identifier. + A mysql_drop_db f�ggv�ny megpr�b�lja az eg�sz + adatb�zist kit�r�lni, melyet az adott kapcsolat-azonos�t� hat�roz meg. - See also: mysql_create_db. For downward - compatibility mysql_dropdb can also be used. + L�sd m�g a mysql_create_db f�ggv�nyt. + Kompat�bilit�si okokb�l mysql_dropdb n�ven is + h�vhat� a f�ggv�ny. [�s hallgat is a nev�re] @@ -565,15 +501,14 @@ mysql_errno - Returns the numerical value of the error message from previous - MySQL operation + Az el�z� MySQL m�velet hibak�dj�t tartalmazza - Description + Le�r�s int mysql_errno - resource + int link_identifier @@ -581,18 +516,20 @@ - Returns the error number from the last MySQL function, or - 0 (zero) if no error occurred. + Az utolj�ra v�grehajtott MySQL hiba k�dj�val t�r vissza, vagy ha az + sikeres volt, akkor 0-t (null�t) ad vissza. - Errors coming back from the MySQL database backend no longer - issue warnings. Instead, use mysql_errno to - retrieve the error code. Note that this function only returns the - error code from the most recently executed MySQL function (not - including mysql_error and - mysql_errno), so if you want to use it, - make sure you check the value before calling another mySQL - function. + A MySQL hib�i m�r nem jelennek meg figyelmeztet�sk�nt. [orig.: + Errors coming back from the mySQL database backend no longer + issue warnings.] + Ha szeretn�d megkapni a hiba k�dj�t, haszn�ld a + mysql_errno f�ggv�nyt! + Ez a f�ggv�ny csak az utols� MySQL m�velet hibak�dj�t adja vissza + [(not including mysql_error and + mysql_errno)], ha haszn�lni szeretn�d, �gyelj r�, + hogy m�g azel�tt h�vd meg a f�ggv�nyt, miel�tt egy m�sik MySQL f�ggv�nyt + megh�vsz. <?php @@ -607,7 +544,7 @@ - See also: mysql_error + L�sd m�g a mysql_error f�ggv�nyt @@ -615,15 +552,14 @@ mysql_error - Returns the text of the error message from previous - MySQL operation + Az el�z� MySQL m�velet hibasz�veg�t adja - Description + Le�r�s string mysql_error - resource + int link_identifier @@ -631,17 +567,20 @@ - Returns the error text from the last MySQL function, or - '' (the empty string) if no error occurred. + Az utols� MySQL m�velet hibasz�veg�vel t�r vissza, vagy + '' (�res karakterl�nccal) ha nem volt hiba. - Errors coming back from the MySQL database backend no longer - issue warnings. Instead, use mysql_error to - retrieve the error text. Note that this function only returns the - error text from the most recently executed MySQL function (not - including mysql_error and - mysql_errno), so if you want to use it, make - sure you check the value before calling another MySQL function. + A MySQL hib�i m�r nem jelennek meg figyelmeztet�sk�nt. [orig.: + Errors coming back from the mySQL database backend no longer + issue warnings.] + Ha szeretn�d megkapni a hiba k�dj�t, haszn�ld a + mysql_error f�ggv�nyt! + Ez a f�ggv�ny csak az utols� MySQL m�velet hibak�dj�t adja vissza + [(not including mysql_error and + mysql_errno)], ha haszn�lni szeretn�d, �gyelj r�, + hogy m�g azel�tt h�vd meg a f�ggv�nyt, miel�tt egy m�sik MySQL f�ggv�nyt + megh�vsz. <?php @@ -656,52 +595,24 @@ - See also: mysql_errno + L�sd m�g a mysql_errno f�ggv�nyt! - - - mysql_escape_string - - Escapes a string for use in a mysql_query. - - - - Description - - - string mysql_escape_string - string unescaped_string - - - - This function will escape the unescaped_string, - so that it is safe to place it in a mysql_query. - - - - mysql_escape_string does not escape % - and _. - - - - - mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both. + K�r�s egy sor�t adja vissza (tetsz�leges) t�mb form�j�ban. - Description + Le�r�s array mysql_fetch_array - resource result + int result int result_type @@ -710,54 +621,54 @@ - Returns an array that corresponds to the fetched row, or &false; - if there are no more rows. + Az eredm�ny k�vetkez� sor�val t�r vissza t�mb form�j�ban, vagy hamissal, + ha m�r nincs t�bb sor. - mysql_fetch_array is an extended version of - mysql_fetch_row. In addition to storing the - data in the numeric indices of the result array, it also stores - the data in associative indices, using the field names as keys. + A mysql_fetch_array f�ggv�ny a + mysql_fetch_row f�ggv�ny kiterjesztett v�ltozata. + R�ad�sul az eredm�nyt nem csak sz�mokkal indexelt t�mbbe �rja, hanem + asszociat�v t�mbbe is, ahol a mez� nevei a kulcsok. - If two or more columns of the result have the same field names, - the last column will take precedence. To access the other column(s) - of the same name, you must the numeric index of the column or - make an alias for the column. + Ha az eredm�ny t�bb sor�nak ugyanaz a neve, akkor a k�s�bb szerepl� + oszlop marad meg. Ha szeretn�d az �sszes mez�t el�rni ilyenkor is, akkor + sz�mmal indexeld a t�mb�t, vagy az SQL parancsban k�rj aliast az + oszlopra. -select t1.f1 as foo t2.f1 as bar from t1, t2 +select t1.f1 as ize t2.f1 as bigyo from t1, t2 - An important thing to note is that using - mysql_fetch_array is NOT significantly - slower than using mysql_fetch_row, while it - provides a significant added value. + J� tudni, hogy a mysql_fetch_array f�ggv�ny + haszn�lata NEM jelent�sen lassabb a mysql_fetch_row + haszn�lat�n�l, de a kapott eredm�ny feldolgoz�sa j�val k�nyelmesebb. - The optional second argument result_type - in mysql_fetch_array is a constant and can - take the following values: MYSQL_ASSOC, MYSQL_NUM, and - MYSQL_BOTH. (This feature was added in PHP 3.0.7) + A mysql_fetch_array f�ggv�ny elhagyhat� + result_type param�tere a k�vetkez� lehet: + MYSQL_ASSOC, MYSQL_NUM, vagy MYSQL_BOTH. + (Ez a lehet�s�g a PHP 3.0.7-es v�ltozat�ban ker�lt a nyelvbe.) - For further details, see also - mysql_fetch_row and mysql_fetch_assoc. + Tov�bbi r�szletek�rt olvasd m�g a + mysql_fetch_row �s a + mysql_fetch_assoc f�ggv�nyeket! - <function>mysql_fetch_array</function> example + <function>Mysql_fetch_array</function> <?php -mysql_connect ($host, $user, $password); -$result = mysql_db_query ("database","select user_id, fullname from table"); -while ($row = mysql_fetch_array ($result)) { - echo "user_id: ".$row["user_id"]." \n"; - echo "user_id: ".$row[0]." \n"; - echo "fullname: ".$row["fullname"]." \n"; - echo "fullname: ".$row[1]." \n"; +mysql_connect ($host, $felhasznalo, $jelszo); +$eredmeny = mysql_db_query ("adatb�zis","select user_id, teljesnev from table"); +while ($sor = mysql_fetch_array ($eredmeny)) { + echo "user_id: ".$sor["user_id"]." \n"; + echo "user_id: ".$sor[0]." \n"; + echo "fullname: ".$sor["fullname"]." \n"; + echo "fullname: ".$sor[1]." \n"; } -mysql_free_result ($result); +mysql_free_result ($eredmeny); ?> @@ -768,74 +679,76 @@ mysql_fetch_assoc - Fetch a result row as an associative array + Az eredm�ny egy sor�t asszociat�v t�mbk�nt adja vissza. - Description + Le�r�s array mysql_fetch_assoc - resource result + int result - Returns an associative array that corresponds to the fetched row, - or &false; if there are no more rows. + Az eredm�ny k�vetkez� sor�val, mint asszociat�v t�mbbel t�r vissza, vagy + hamissal, ha nincs t�bb sor. - mysql_fetch_assoc is equivalent to calling - mysql_fetch_array with MYSQL_ASSOC for the - optional second parameter. It only returns an associative array. - This is the way mysql_fetch_array originally - worked. If you need the numeric indices as well as the - associative, use mysql_fetch_array. + A mysql_fetch_assoc f�ggv�ny h�v�s�val ugyanazt + �rj�k el, mintha a mysql_fetch_array f�ggv�nyt + h�vtuk volna meg MYSQL_ASSOC m�sodik param�terrel. Ez a f�ggv�ny egy + tiszt�n asszociat�v t�mb�t ad vissza. Eredetileg a + mysql_fetch_array f�ggv�ny �gy m�k�d�tt. Ha a + sz�mokkal indexelt elemekre is sz�ks�ged van, akkor haszn�ld a + mysql_fetch_array f�ggv�nyt. - If two or more columns of the result have the same field names, - the last column will take precedence. To access the other column(s) - of the same name, you must use mysql_fetch_array and - have it return the numeric indices as well. + Ha az eredm�ny t�bb sor�nak ugyanaz a neve, akkor a k�s�bb szerepl� + oszlop marad meg. Ha szeretn�d az �sszes mez�t el�rni ilyenkor is, akkor + az SQL parancsban k�rj aliast az oszlopra, vagy haszn�ld a + mysql_fetch_array f�ggv�nyt �gy, hogy a sz�mmal + indexelt elemeket is k�red. - An important thing to note is that using - mysql_fetch_assoc is NOT significantly - slower than using mysql_fetch_row, while it - provides a significant added value. + J� tudni, hogy a mysql_fetch_assoc f�ggv�ny + haszn�lata NEM jelent�sen lassabb a mysql_fetch_row + haszn�lat�n�l, de a kapott eredm�ny feldolgoz�sa j�val k�nyelmesebb. - For further details, see also - mysql_fetch_row and mysql_fetch_array. + Tov�bbi r�szletek�rt l�sd m�g a + mysql_fetch_row �s a + mysql_fetch_array f�ggv�nyeket. - <function>mysql_fetch_assoc</function> + <function>Mysql_fetch_assoc</function> <?php -mysql_connect ($host, $user, $password); -$result = mysql_db_query ("database","select * from table"); -while ($row = mysql_fetch_assoc ($result)) { - echo $row["user_id"]; - echo $row["fullname"]; +mysql_connect ($host, $felhasznalo, $jelszo); +$eredmeny = mysql_db_query ("adatb�zis","select * from table"); +while ($sor = mysql_fetch_assoc ($eredmeny)) { + echo $sor["user_id"]; + echo $sor["fullname"]; } -mysql_free_result ($result); +mysql_free_result ($eredmeny); ?> - + mysql_fetch_field - Get column information from a result and return as an object + Eredm�nyhalmaz egy oszlop�r�l ad inform�ci�t objektum form�j�ban - Description + Le�r�s object mysql_fetch_field - resource result + int result int field_offset @@ -844,117 +757,118 @@ - Returns an object containing field information. + Egy mez�inform�ci�t tartalmaz� objektummal t�r vissza. - mysql_fetch_field can be used in order to - obtain information about fields in a certain query result. If - the field offset isn't specified, the next field that wasn't yet - retrieved by mysql_fetch_field is retrieved. + A mysql_fetch_field f�ggv�nyt arra haszn�lhatod, + hogy az eredm�ny egy oszlop�r�l inform�ci�t kaphass. Ha a mez� sorsz�m�t + nem adod meg, akkor a k�vetkez� olyan oszlopr�l kapsz inform�ci�t, + amelyre m�g nem h�vtad meg a + mysql_fetch_field f�ggv�nyt. - The properties of the object are: + Az objektum tulajdons�gai: - name - column name + name - az oszlop neve - table - name of the table the column belongs to + table - a t�bla neve, amelyhez az oszlop tartozik - max_length - maximum length of the column + max_length - az oszlop maxim�lis hossza - not_null - 1 if the column cannot be &null; + not_null - �rt�ke 1, ha az oszlop nem veheti fel a NULL �rt�ket - primary_key - 1 if the column is a primary key + primary_key - �rt�ke 1, ha az oszlop els�dleges kulcs - unique_key - 1 if the column is a unique key + unique_key - �rt�ke 1, ha az oszlop egyszer� kulcs - multiple_key - 1 if the column is a non-unique key + multiple_key - �rt�ke 1, ha az oszlop �sszetett kulcs r�sze - numeric - 1 if the column is numeric + numeric - �rt�ke 1, ha az oszlop sz�m - blob - 1 if the column is a BLOB + blob - �rt�ke 1, ha az oszlop BLOB t�pus� - type - the type of the column + type - az oszlop t�pusa - unsigned - 1 if the column is unsigned + unsigned - �rt�ke 1, ha az oszlop nem el�jeles - zerofill - 1 if the column is zero-filled + zerofill - �rt�ke 1, ha az oszlop null�val felt�lt�tt - <function>mysql_fetch_field</function> + <function>Mysql_fetch_field</function> <?php -mysql_connect ($host, $user, $password) - or die ("Could not connect"); -$result = mysql_db_query ("database", "select * from table") - or die ("Query failed"); -# get column metadata +mysql_connect ($host, $felhasznalo, $jelszo) + or die ("Nem lehet csatlakozni az adatb�zishoz"); +$eredmeny = mysql_db_query ("adatb�zis", "select * from table") + or die ("Hib�s k�r�s"); +# oszlopinform�ci� lek�r�se $i = 0; -while ($i < mysql_num_fields ($result)) { - echo "Information for column $i: \n"; - $meta = mysql_fetch_field ($result); +while ($i < mysql_num_fields ($eredmeny)) { + echo "Inform�ci� a $i. oszlopr�l: \n"; + $meta = mysql_fetch_field ($eredmeny); if (!$meta) { - echo "No information available \n"; + echo "Nem tudok inform�ci�t lek�rni gt;\n"; } - echo "<PRE> -blob: $meta->blob -max_length: $meta->max_length -multiple_key: $meta->multiple_key -name: $meta->name -not_null: $meta->not_null -numeric: $meta->numeric -primary_key: $meta->primary_key -table: $meta->table -type: $meta->type -unique_key: $meta->unique_key -unsigned: $meta->unsigned -zerofill: $meta->zerofill -</PRE>"; + echo "<PRE> +blob: $meta->blob +max_length: $meta->max_length +multiple_key: $meta->multiple_key +name: $meta->name +not_null: $meta->not_null +numeric: $meta->numeric +primary_key: $meta->primary_key +table: $meta->table +type: $meta->type +unique_key: $meta->unique_key +unsigned: $meta->unsigned +zerofill: $meta->zerofill +</PRE>"; $i++; } -mysql_free_result ($result); +mysql_free_result ($eredmeny); ?> - See also mysql_field_seek. + L�sd m�g a mysql_field_seek f�ggv�nyt! @@ -963,32 +877,31 @@ mysql_fetch_lengths - Get the length of each output in a result + Az eredm�ny oszlopainak hossz�r�l ny�jt inform�ci�t - Description + Le�r�s array mysql_fetch_lengths - resource result + int result - Returns: An array that corresponds to the lengths of each field - in the last row fetched by mysql_fetch_row, - or &false; on error. + Egy t�mbbel t�r vissza. A t�mb elemei az utols� + mysql_fetch_row f�ggv�ny �ltal bet�lt�tt oszlopok + hosszait tartalmazza, vagy hiba eset�n hamisat. - mysql_fetch_lengths stores the lengths of - each result column in the last row returned by + A mysql_fetch_lengths f�ggv�ny a mysql_fetch_row, - mysql_fetch_array, and - mysql_fetch_object in an array, starting at - offset 0. + mysql_fetch_array vagy a + mysql_fetch_object �ltal bet�lt�tt sor hosszait adja + vissza sz�mmal indexelt t�mb form�j�ban. - See also: mysql_fetch_row. + L�sd m�g a mysql_fetch_row f�ggv�nyt! @@ -996,14 +909,15 @@ mysql_fetch_object - Fetch a result row as an object + Az eredm�ny k�vetkez� sor�t objektum form�j�ban adja + vissza - Description + Le�r�s object mysql_fetch_object - resource result + int result int result_type @@ -1012,44 +926,44 @@ - Returns an object with properties that correspond to the fetched - row, or &false; if there are no more rows. + Egy objektummal t�r vissza, amelynek tulajdons�gai a bet�lt�tt sor + oszlopait tartalmazz�k. Ha nincs t�bb sor, a f�ggv�ny hamisat ad + eredm�ny�l. - mysql_fetch_object is similar to - mysql_fetch_array, with one difference - an - object is returned, instead of an array. Indirectly, that means - that you can only access the data by the field names, and not by - their offsets (numbers are illegal property names). + A mysql_fetch_object f�ggv�ny hasonl� a + mysql_fetch_array f�ggv�nyhez, egy k�l�nbs�ggel: nem + t�mb�t, hanem objektumot ad vissza a f�ggv�ny. Ez azt jelenti, hogy a + mez�ket csak a nev�k alapj�n tudod el�rni, mivel a sz�mok nem + �rv�nyes tulajdons�gnevek. - The optional argument result_type is a - constant and can take the following values: MYSQL_ASSOC, - MYSQL_NUM, and MYSQL_BOTH. + Az elhagyhat� result_type parm�ter egy konstans, + ami MYSQL_ASSOC, MYSQL_NUM vagy MYSQL_BOTH lehet. - Speed-wise, the function is identical to - mysql_fetch_array, and almost as quick as - mysql_fetch_row (the difference is - insignificant). + Sebess�g szempontj�b�l a mysql_fetch_array + f�ggv�nnyel azonos sebess�g� �s majdnem olyan gyors, mint a + mysql_fetch_row f�ggv�ny (a k�l�nbs�g + elhanyagolhat�) - <function>mysql_fetch_object</function> example + <function>mysql_fetch_object</function> p�lda <?php -mysql_connect ($host, $user, $password); -$result = mysql_db_query ("database", "select * from table"); -while ($row = mysql_fetch_object ($result)) { - echo $row->user_id; - echo $row->fullname; +mysql_connect ($host, $felhasznalo, $jelszo); +$eredmeny = mysql_db_query ("adatb�zis", "select * from table"); +while ($sor = mysql_fetch_object ($eredmeny)) { + echo $sor->user_id; + echo $sor->fullname; } -mysql_free_result ($result); +mysql_free_result ($eredmeny); ?> - See also: mysql_fetch_array and - mysql_fetch_row. + L�sd m�g a mysql_fetch_array �s a + mysql_fetch_row f�ggv�nyt! @@ -1057,37 +971,37 @@ mysql_fetch_row - Get a result row as an enumerated array + Az eredm�ny k�vetkez� sor�t adja vissza sz�mmal indexelt t�mb + form�j�ban - Description + Le�r�s array mysql_fetch_row - resource result + int result - Returns: An array that corresponds to the fetched row, or &false; - if there are no more rows. + Egy sz�mmal indexelt t�mbbel t�r vissza, ami a bet�lt�tt sorokat + tartalmazza, vagy hamissal, ha nincs t�bb sor. - mysql_fetch_row fetches one row of data from - the result associated with the specified result identifier. The - row is returned as an array. Each result column is stored in an - array offset, starting at offset 0. + A mysql_fetch_row f�ggv�ny bet�lt egy sort a + megadott eredm�ny-azonos�t�j� eredm�nyhalmazb�l. A sort (sz�mmal + indexelt) t�mb form�j�ban adja vissza. Az oszlopok sz�moz�sa 0-t�l indul. - Subsequent call to mysql_fetch_row would - return the next row in the result set, or &false; if there are no - more rows. + A mysql_fetch_row t�bbsz�ri alkamaz�s�val v�gig + tudjuk j�rni az eredm�nyhalmazt, mivel az mindig a k�vetkez� sort t�lti + be, majd ha elfogytak a sorok, hamisat ad vissza. - See also: mysql_fetch_array, + L�sd m�g a mysql_fetch_array, mysql_fetch_object, mysql_data_seek, - mysql_fetch_lengths, and - mysql_result. + mysql_fetch_lengths �s a + mysql_result f�ggv�nyeket! @@ -1096,32 +1010,32 @@ mysql_field_flags - Get the flags associated with the specified field in a result + Adott eredm�ny adott mezej�nek flagjeit adja vissza. - Description + Le�r�s string mysql_field_flags - resource result + int result int field_offset - mysql_field_flags returns the field flags of - the specified field. The flags are reported as a single word - per flag separated by a single space, so that you can split the - returned value using explode. + A mysql_field_flags f�ggv�ny az adott mez� flagjeit + adja vissza. A flagek egyszer� szavak, melyeket egyetlen sz�k�z v�laszt + el, �gy a kapott �rt�ket feldolgozhatod a explode + f�ggv�ny seg�ts�g�vel. - The following flags are reported, if your version of MySQL - is current enough to support them: "not_null", "primary_key", + A MySQL a k�vetkez� flageket t�mogatja (felt�ve, hogy el�g friss a + haszn�lt MySQL, amit haszn�lsz): "not_null", "primary_key", "unique_key", "multiple_key", "blob", "unsigned", "zerofill", "binary", "enum", "auto_increment", "timestamp". - For downward compatibility mysql_fieldflags - can also be used. + Kompat�bilit�si okokb�l a mysql_fieldflags f�ggv�ny + is haszn�lhat�. @@ -1130,43 +1044,42 @@ mysql_field_name - Get the name of the specified field in a result + Adott mez� nev�t adja vissza - Description + Le�r�s string mysql_field_name - resource result + int result int field_index - mysql_field_name returns the name of the - specified field index. result must be a - valid result identifier and field_index is - the numerical offset of the field. + A mysql_field_name f�ggv�ny az eredm�nyben szerepl� + megadott index� mez� nev�t adja vissza. A result + param�ternek �rv�nyes eredm�nyazonos�t�nak kell lennie, + a field_index param�ter pedig a mez� indexe. - field_index starts at 0. + A field_index param�ter sz�moz�sa 0-t�l kezd�dik. - e.g. The index of the third field would actually be 2, the index - of the fourth field would be 3 and so on. + P�ld�ul a harmadik mez� indexe 2, a negyedik mez�� pedig 3. - <function>mysql_field_name</function> example + <function>mysql_field_name</function> p�lda -// The users table consists of three fields: +// A felhasznalok t�bla h�rom mez�b�l �ll: // user_id -// username -// password. +// felhasznalonev +// jelszo. -$res = mysql_db_query("users", "select * from users", $link); +$res = mysql_db_query("felhasznalok", "select * from felhasznalok", $link); echo mysql_field_name($res, 0) . "\n"; echo mysql_field_name($res, 2); @@ -1174,17 +1087,17 @@ - The above example would produce the following output: + A fenti p�lda ay al�bbi kimenetet eredm�nyezi: user_id -password +jelszo - For downwards compatibility mysql_fieldname - can also be used. + Kompat�bilit�si okokb�l a mysql_fieldname + f�ggv�ny is haszn�lhat�. @@ -1193,25 +1106,25 @@ mysql_field_len - Returns the length of the specified field + A k�rdezett mez� hossz�t adja vissza - Description + Le�r�s int mysql_field_len - resource result + int result int field_offset - mysql_field_len returns the length of the - specified field. + A mysql_field_len f�ggv�ny a k�rdezett mez� + hossz�val t�r vissza. - For downward compatibility mysql_fieldlen - can also be used. + Kompat�bilit�si okokb�l a mysql_fieldlen + f�ggv�ny is haszn�lhat�. @@ -1220,26 +1133,27 @@ mysql_field_seek - Set result pointer to a specified field offset + Az eredm�nymutat�t a k�v�nt poz�ci�ba mozgatja - Description + Le�r�s int mysql_field_seek - resource result + int result int field_offset - Seeks to the specified field offset. If the next call to - mysql_fetch_field doesn't include a field - offset, the field offset specified in - mysql_field_seek will be returned. + A megadott helyre mozgatja az eredm�ny-mutat�t. Ha a k�vetkez� + mysql_fetch_field f�ggv�nyh�v�s nem tartalmaz mez� + poz�ci�t, akkor a + mysql_field_seek f�ggv�ny �ltal visszaadott + mez�poz�ci�t fogja visszaadni. - See also: mysql_fetch_field. + L�sd m�g a mysql_fetch_field f�ggv�nyt! @@ -1248,25 +1162,25 @@ mysql_field_table - Get name of the table the specified field is in + Visszaadja annak a t�bl�nak a nev�t, melyben a megadott mez� tal�lhat� - Description + Le�r�s string mysql_field_table - resource result + int result int field_offset - Returns the name of the table that the specifed field is - in. + A f�ggv�ny annak a t�bl�nak a nev�vel t�r vissza, melyben a megadott mez� + szerepel. - For downward compatibility mysql_fieldtable - can also be used. + Kompat�bilit�si okokb�l a mysql_fieldtable + f�ggv�ny is haszn�lhat�. @@ -1275,56 +1189,56 @@ mysql_field_type - Get the type of the specified field in a result + Az eredm�ny adott mezej�nek t�pus�t adja vissza - Description + Le�r�s string mysql_field_type - iresource result + int result int field_offset - mysql_field_type is similar to the - mysql_field_name function. The arguments are - identical, but the field type is returned instead. The field type - will be one of "int", "real", "string", "blob", and others as - detailed in the MySQL - documentation. + A mysql_field_type f�ggv�ny hasonl� a + mysql_field_name f�ggv�nyhez. A param�terek + megegyeznek, de a f�ggv�ny a mez� t�pus�val t�r vissza. A mez�t�pus az + "int", "real", "string", "blob" vagy hasonl�, a + MySQL dokument�ci�ban tal�lhat� + t�pusok k�z�l val�. - MySQL field types + mysql mez�t�pusok <?php mysql_connect ("localhost:3306"); mysql_select_db ("wisconsin"); -$result = mysql_query ("SELECT * FROM onek"); -$fields = mysql_num_fields ($result); -$rows = mysql_num_rows ($result); +$eredmeny = mysql_query ("SELECT * FROM onek"); +$mezo = mysql_num_fields ($eredmeny); +$sor = mysql_num_rows ($eredmeny); $i = 0; -$table = mysql_field_table ($result, $i); -echo "Your '".$table."' table has ".$fields." fields and ".$rows." records "; -echo "The table has the following fields "; -while ($i < $fields) { - $type = mysql_field_type ($result, $i); - $name = mysql_field_name ($result, $i); - $len = mysql_field_len ($result, $i); - $flags = mysql_field_flags ($result, $i); - echo $type." ".$name." ".$len." ".$flags." "; +$table = mysql_field_table ($eredmeny, $i); +echo "A '$table' nev� t�bl�nak $mezo mez�je �s $sor sora van "; +echo "A t�bl�nak az al�bbi mez�i vannak "; +while ($i < $mezo) { + $tipus = mysql_field_type ($eredmeny, $i); + $nev = mysql_field_name ($eredmeny, $i); + $hossz = mysql_field_hossz ($eredmeny, $i); + $flags = mysql_field_flags ($eredmeny, $i); + echo "$tipus $nev $hossz $flags." "; $i++; } mysql_close(); -?> +?> - For downward compatibility mysql_fieldtype - can also be used. + Kompat�bilit�si okokb�l a mysql_fieldtype + f�ggv�ny is haszn�lhat�. @@ -1332,31 +1246,29 @@ mysql_free_result - Free result memory + Felszabad�tja az eredm�ny �ltal lefoglalt mem�ri�t - Description + Le�r�s int mysql_free_result - resource result + int result - mysql_free_result will free all memory - associated with the result identifier result. + A mysql_free_result f�ggv�ny az �sszes + result eredm�nyazonos�t� �ltal haszn�lt mem�ri�t + felszabad�tja. - mysql_free_result only needs to be called if - you are concerned about how much memory is being used for queries - that return large result sets. All associated result memory is - automatically freed at the end of the script's execution. - + A mysql_free_result f�ggv�nyt csak akkor kell + megh�vnod, ha nagyon agg�dsz a haszn�lt mem�ria mennyis�ge miatt. A + mem�ria a php program v�g�n �gyis felszabadul. - - For downward compatibility mysql_freeresult - can also be used. + Kompat�bilit�si okokb�l a mysql_freeresult + f�ggv�ny is haszn�lhat�. @@ -1365,15 +1277,16 @@ mysql_insert_id + Visszaadja az el�z� INSERT m�velet �ltal el��ll�tott id-t adja vissza. Get the id generated from the previous INSERT operation - Description + Le�r�s int mysql_insert_id - resource + int link_identifier @@ -1381,36 +1294,35 @@ - mysql_insert_id returns the ID generated for - an AUTO_INCREMENT column by the previous INSERT query using the - given link_identifier. If - link_identifier isn't specified, the last - opened link is assumed. + A mysql_insert_id f�ggv�ny az el�z� INSERT + m�veletben szerepl� AUTO_INCREMENT tulajdons�g� mez� �rt�k�t adja vissza. + Ha megadjuk link_identifier-t az adott + linkkel rendelekez�, ha nem adunk meg param�tert, az utols� megnyitott + linkhez tartoz� eredm�nyt szolg�ltatja. - mysql_insert_id returns 0 if the previous - query does not generate an AUTO_INCREMENT value. If you need to - save the value for later, be sure to call mysql_insert_id() - immediately after the query that generates the value. + A mysql_insert_id f�ggv�ny 0-val t�r vissza, ha az + el�z� k�r�sben nem j�tt l�tre AUTO_INCREMENT �rt�k. Ha sz�ks�ged van + k�s�bb az �rt�kre, h�vd meg a mysql_insert_id + f�ggv�nyt r�gt�n az �rt�ket gener�l� lek�rdez�s ut�n! - The value of the MySQL SQL function - LAST_INSERT_ID() always contains the most - recently generated AUTO_INCREMENT value, and is not reset - between queries. + A LAST_INSERT_ID() f�ggv�ny �rt�ke mindig az utolj�ra + el��ll�tott AUTO_INCREMENT �rt�ket tartalmazza, nem t�rl�dik az �rt�ke + lek�rdez�sek k�z�tt. - mysql_insert_id converts the return type of - the native MySQL C API function - mysql_insert_id() to a type of - long. If your AUTO_INCREMENT column has - a column type of BIGINT, the value returned by - mysql_insert_id will be incorrect. - Instead, use the internal MySQL SQL function - LAST_INSERT_ID(). + A mysql_insert_id f�ggv�ny a MySQL C API f�ggv�ny + mysql_insert_id() visszat�r�si �rt�k�t + long-g� konvert�lja. Ha az AUTO_INCREMENT mez�d + mondjuk BIGINT t�pus�, akkor a + mysql_insert_id f�ggv�ny rossz eredm�nyt adhat + vissza. Ez�rt ink�bb a bels� + LAST_INSERT_ID() MySQL f�ggv�nyt haszn�ld! @@ -1420,15 +1332,15 @@ mysql_list_dbs - List databases available on a MySQL server + Kilist�zza a MySQL szerveren el�rhet� adatb�zisokat - Description + Le�r�s - resource mysql_list_dbs - resource + int mysql_list_dbs + int link_identifier @@ -1436,62 +1348,62 @@ - mysql_list_dbs will return a result pointer - containing the databases available from the current mysql - daemon. Use the mysql_tablename function to - traverse this result pointer. + A mysql_list_dbs f�ggv�ny egy eredm�nymutat�t ad + vissza, ami a mysql d�mont�l el�rhet� adatb�zisokat tartalmazza. + Haszn�ld a mysql_tablename f�ggv�nyt, hogy az �sszes + t�bl�t el�rd! - <function>mysql_list_dbs</function> example + <function>mysql_list_dbs</function> p�lda -$link = mysql_connect('localhost', 'myname', 'secret'); +$link = mysql_connect('localhost', 'nevem', 'titok'); $db_list = mysql_list_dbs($link); -while ($row = mysql_fetch_object($db_list)) { - echo $row->Database . "\n"; +while ($sor = mysql_fetch_object($db_list)) { + echo $sor->Database . "\n"; } - The above example would produce the following output: + A fenti p�lda az al�bbi kimenetet eredm�nyezi. -database1 -database2 -database3 +adatb�zis1 +adatb�zis2 +adatb�zis3 ... - The above code would just as easily work with - mysql_fetch_row or other similar functions. + A fenti program egyszer�en b�v�thet� a + mysql_fetch_row f�ggv�nnyel vagy m�s hasonl� + f�ggv�nnyel. - For downward compatibility mysql_listdbs can - also be used. + Kompat�bilit�si okokb�l a mysql_listdbs f�ggv�ny + is haszn�lhat�. - See also mysql_db_name mysql_list_fields - List MySQL result fields + Kilist�zza a MySQL eredm�ny mez�it - Description + Le�r�s - resource mysql_list_fields + int mysql_list_fields string database_name string table_name - resource + int link_identifier @@ -1499,72 +1411,67 @@ - mysql_list_fields retrieves information - about the given tablename. Arguments are the database name and - the table name. A result pointer is returned which can be used - with mysql_field_flags, + A mysql_list_fields f�ggv�ny az adott t�bl�r�l + szolg�ltat inform�ci�t. A param�terek az adatb�zis �s a t�bla neve. A + f�ggv�ny egy eredm�ny-azonos�t� t�r vissza, amit a + mysql_field_flags, mysql_field_len, - mysql_field_name, and - mysql_field_type. + mysql_field_name, �s a + mysql_field_type f�ggv�nyekkel h�mozhatsz meg. - + Az eredm�ny-azonos�t� egy pozit�v eg�sz sz�m. A f�ggv�ny hiba eset�n + -1-gyel t�r vissza. A hiba sz�veges le�r�sa a + $phperrmsg v�ltoz�ban tal�lhat�, �s ha nem + <email protected>() <- �gy h�vtad meg a f�ggv�nyt, akkor a + hiba ki�r�sra ker�l [m�r ha nem pl. egy Javascript k�d belsej�ben, vagy + egy keretrendszer tetej�n akarn� ki�rni szeg�ny PHP...]. + - <function>mysql_list_fields</function> example + <function>mysql_list_fields</function> p�lda -$link = mysql_connect('localhost', 'myname', 'secret'); +$link = mysql_connect('localhost', 'nevem', 'titok'); -$fields = mysql_list_fields("database1", "table1", $link); -$columns = mysql_num_fields($fields); +$mezo = mysql_list_fields("adatb�zis1", "tabla1", $link); +$oszlop = mysql_num_fields($mezo); -for ($i = 0; $i < $columns; $i++) { - echo mysql_field_name($fields, $i) . "\n";; +for ($i = 0; $i < $oszlop; $i++) { + echo mysql_field_name($mezo, $i) . "\n";; } - The above example would produce the following output: + A fenti p�lda az al�bbi kimenetet eredm�nyezi: -field1 -field2 -field3 +mezo1 +mezo2 +mezo3 ... - For downward compatibility mysql_listfields - can also be used. + Kompat�bilit�si okokb�l a mysql_listfields + f�ggv�ny is haszn�lhat�. - mysql_list_tables - List tables in a MySQL database + Adott adatb�zisbeli t�blaneveket list�zza - Description + Le�r�s - resource mysql_list_tables + int mysql_list_tables string database - resource + int link_identifier @@ -1572,15 +1479,15 @@ - mysql_list_tables takes a database name and - returns a result pointer much like the - mysql_db_query function. The - mysql_tablename function should be used to - extract the actual table names from the result pointer. + A mysql_list_tables f�ggv�ny veszi az + adatb�zisnevet, �s egy eredm�ny-mutat�t ad vissza, a + mysql_db_query f�ggv�nyhez hasonl�an. A + mysql_tablename f�ggv�ny haszn�lhat� arra, hogy az + eredm�ny-mutat�b�l a t�nyleges t�blaneveket meg�llap�tsd. - For downward compatibility mysql_listtables - can also be used. + Kompat�bilit�si okokb�l a mysql_listtables + f�ggv�ny is haszn�lhat�. @@ -1588,29 +1495,29 @@ mysql_num_fields - Get number of fields in result + Az eredm�nyben szerepl� mez�k sz�m�t adja - Description + Le�r�s int mysql_num_fields - resource result + int result - mysql_num_fields returns the number of - fields in a result set. + A mysql_num_fields f�ggv�ny az eredm�nyhalmazban + lev� mez�k sz�m�t adja vissza. - See also: + L�sd m�g a mysql_db_query, mysql_query, - mysql_fetch_field, - mysql_num_rows. + mysql_fetch_field �s a + mysql_num_rows f�ggv�nyeket! - For downward compatibility mysql_numfields - can also be used. + Kompat�bilit�si okokb�l a mysql_numfields + f�ggv�ny is haszn�lhat�. @@ -1618,47 +1525,47 @@ mysql_num_rows - Get number of rows in result + Az eredm�nyben szerepl� sorok sz�m�t adja vissza. - Description + Le�r�s int mysql_num_rows - resource result + int result - mysql_num_rows returns the number of rows in - a result set. This command is only valid for SELECT statements. - To retrieve the number of rows returned from a INSERT, UPDATE or - DELETE query, use mysql_affected_rows. + A mysql_num_rows f�ggv�ny az eredm�nyhalmazban + szerepl� sorok sz�m�t adja vissza. A f�ggv�ny csak SELECT k�r�sre + haszn�lhat�. Ha egy INSERT, UPDATE vagy DELETE k�r�sben �rintett sorok + sz�m�t szeretn�d megtudni, haszn�ld a + DELETE, use mysql_affected_rows f�ggv�nyt! - <function>mysql_num_rows</function> example + + <function> + mysql_num_rows p�lda Szerz�: crubel <email protected> + </function> + <?php - -$link = mysql_connect("localhost", "username", "password"); -mysql_select_db("database", $link); - -$result = mysql_query("SELECT * FROM table1", $link); -$num_rows = mysql_num_rows($result); - -echo "$num_rows Rows\n"; - -?> +$conn = mysql_connect("hostcim", "juzer", "jelszo"); +mysql_select_db("adatb�zis",$conn); // kell, ha t�bb adatb�zis van +$Eredmenytagokszama = mysql_query("SELECT * FROM Szamla",$conn); +$Tagokszama = mysql_num_rows($Eredmenytagokszama); +echo "$Tagokszama tag van"; +?> - See also: - mysql_affected_rows, - mysql_connect, - mysql_select_db and - mysql_query. + L�sd m�g a + mysql_db_query, + mysql_query �s a + mysql_fetch_row f�ggv�nyeket! - For downward compatibility mysql_numrows can + Kompat�bilit�si okokb�l a mysql_numrows can also be used. @@ -1668,14 +1575,14 @@ mysql_pconnect - Open a persistent connection to a MySQL Server + Perzisztens kapcsolatot nyit meg a MySQL szerverhez - Description + Le�r�s - resource mysql_pconnect + int mysql_pconnect string hostname @@ -1693,51 +1600,52 @@ - Returns: A positive MySQL persistent link identifier on success, - or &false; on error. + Visszat�r�si �rt�ke: Egy pozit�v MySQL perzisztens kapcsolatazonos�t� + siker eset�n, vagy false, ha hiba t�rt�nt. - mysql_pconnect establishes a connection - to a MySQL server. The following defaults are assumed for - missing optional parameters: host:port = - 'localhost:3306', username = name of the - user that owns the server process and - password = empty password. - - - The hostname string can also include a port - number. eg. "hostname:port" or a path to a socket - eg. ":/path/to/socket" for the localhost. + A mysql_pconnect f�ggv�ny l�trehoz egy kapcsolatot a + MySQL szerverhez. Az elhagyott param�terek az al�bbi �rt�keket veszik + fel: + host:port = + 'localhost:3306', username = annak a + felhaszn�l�nak a neve, aki� a szerver folyamat �s v�g�l: + password = �res jelsz�. + + + A hostname karakterl�nc a port sz�m�t is + tartalmazhatja; pl.: "hostname:port" vagy a socket teljes + el�r�si �tvonal�t pl.: ":/path/to/socket". Ez persze csak a + helyi g�pen m�k�dik. - Support for ":port" was added in 3.0B4. + A ":port" haszn�lata a 3.0B4-es verzi� �ta lehets�ges. - Support for the ":/path/to/socket" was added in - 3.0.10. + A ":/path/to/socket" forma haszn�lata a 3.0.10-es verzi� �ta + t�mogatott. - - - mysql_pconnect acts very much like - mysql_connect with two major differences. + A mysql_pconnect f�ggv�ny a + mysql_connect f�ggv�nyhez hasonl�an m�k�dik, csup�n + k�t nagyobb k�l�nbs�g van: - First, when connecting, the function would first try to find a - (persistent) link that's already open with the same host, - username and password. If one is found, an identifier for it - will be returned instead of opening a new connection. + El�sz�r is, a kapcsolat felv�telekor a f�ggv�ny el�sz�r megpr�b�l egy + (perzisztens) kapcsolatot tal�lni, amely m�r nyitva van arra a hostra + ugyanazzal a n�v/jelsz� p�rossal. Ha tal�l ilyet, akkor ennek a kapocsnak + az azonos�t�j�t adja vissza �s nem nyit �jat. - Second, the connection to the SQL server will not be closed when - the execution of the script ends. Instead, the link will remain - open for future use (mysql_close will not - close links established by mysql_pconnect). + M�sodszor pedig a kapcsolat az SQL szerverhez nem ker�l bez�r�sra, amikor + a php program v�get �r, hanem megmarad k�s�bbi felhaszn�l�sra. + (A mysql_close f�ggv�ny nem fogja neked lez�rni a + mysql_pconnect f�ggv�nnyel megnyitott kapcsolatokat). - This type of links is therefore called 'persistent'. + Az ilyen t�pus� kapcsolatot ez�rt h�vj�k 'perzisztensnek'. @@ -1745,143 +1653,99 @@ mysql_query - Send a MySQL query + MySQL k�r�st k�ld a szervernek - Description + Le�r�s - resource mysql_query + int mysql_query string query - resource + int link_identifier - mysql_query sends a query to the currently - active database on the server that's associated with the - specified link identifier. If - link_identifier isn't specified, the last - opened link is assumed. If no link is open, the function tries - to establish a link as if mysql_connect was - called with no arguments, and use it. + A mysql_query f�ggv�ny k�r�st k�ld a megadott + kapcsolat-azonos�t�j� szerver akt�v adatb�zis�hoz. + Ha nem adsz meg link_identifier-t, akkor a + legut�bb megnyitott kapcsolatot haszn�lja a f�ggv�ny. Ha nincs nyitva + ilyen kapcsolat, akkor a f�ggv�ny megpr�b�l nyitni egyet, mintha a + mysql_connect f�ggv�nyt h�vtuk volna param�terek + n�lk�l. - The query string should not end with a semicolon. + A k�r�snek nem szabad pontosvessz�re v�gz�dnie. - mysql_query returns &true; (non-zero) or &false; - to indicate whether or not the query succeeded. A return value - of &true; means that the query was legal and could be executed by - the server. It does not indicate anything about the number of - rows affected or returned. It is perfectly possible for a query - to succeed but affect no rows or return no rows. + A mysql_query f�ggv�ny TRUE-val (nemnulla) vagy + FALSE-szal t�r vissza, att�l f�gg�en, hogy a k�r�s teljes�t�se sikeres + volt-e. A TRUE visszat�r�si �rt�k azt jelenti, hogy a k�r�s + szintaktikailag helyes volt, �s lefuttatta a szerver. Az �rintett sorok + sz�m�r�l azonban nem mond semmit. El�fordulhat ugyanis, hogy a k�r�s + sikeresen lefutott, de nem �rintett egyetlen sort sem, vagy az + eredm�nyben egyetlen sor sincs. - The following query is syntactically invalid, so - mysql_query fails and returns &false;: + A k�vetkez� k�r�s szintaktikailag rossz, igy a + mysql_query f�ggv�ny meghi�sul �s FALSE eredm�nyt + ad: <function>mysql_query</function> <?php -$result = mysql_query ("SELECT * WHERE 1=1") - or die ("Invalid query"); -?> +$eredmeny = mysql_query ("SELECT * WHERE 1=1") + or die ("�rv�nytelen lek�rdez�s"); +?> - The following query is semantically invalid if - my_col is not a column in the table - my_tbl, so mysql_query - fails and returns &false;: + Az al�bbi k�r�s szemantikailag helytelen, ha nincs + my_col nev� oszlop a + my_tbl nev� t�bl�ban, �gy a + mysql_query meghi�sul �s FALSE �rt�kkel t�r vissza. <function>mysql_query</function> <?php -$result = mysql_query ("SELECT my_col FROM my_tbl") - or die ("Invalid query"); -?> +$eredmeny = mysql_query ("SELECT my_col FROM my_tbl") + or die ("�rv�nytelen k�r�s"); +?> - mysql_query will also fail and return &false; - if you don't have permission to access the table(s) referenced by - the query. + A mysql_query f�ggv�ny akkor is meghi�sul �s FALSE + �rt�kkel t�r vissza, ha nincs megfelel� enged�lyed a k�r�s �ltal + hivatkozott t�bl�(k)hoz. - Assuming the query succeeds, you can call - mysql_num_rows to find out how many rows - were returned for a SELECT statment or - mysql_affected_rows to find out how many - rows were affected by a DELETE, INSERT, REPLACE, or UPDATE - statement. + Felt�ve, hogy a k�r�s sikeres, megh�vhatod a + mysql_num_rows f�ggv�nyt, hogy kider�tsd, h�ny sort + kapt�l vissza a SELECT k�r�sedre, vagy a + mysql_affected_rows f�ggv�nyt, hogy megtudd h�ny + sort �rintett a DELETE, NSERT, REPLACE vagy UPDATE k�r�sed. - For SELECT statements, mysql_query returns a - new result identifier that you can pass to - mysql_result. When you are done with the - result set, you can free the resources associated with it by - calling mysql_free_result. Although, the - memory will automatically be freed at the end of the script's - execution. + SELECT k�r�s eset�ben a mysql_query f�ggv�ny + egy �j eredm�ny-azonos�t�t ad vissza, amit k�s�bb a + mysql_result f�ggv�nnyel haszn�lhatsz. + Ha az eredm�nyre m�r nincs sz�ks�g �s mem�riaf�bi�d van, akkor a + mysql_free_result f�ggv�nnyel a foglalt mem�ri�t + felszabad�thatod, norm�l esetben megv�rod a program v�g�t �s a mem�ria + felszabadul. - See also: mysql_affected_rows, + L�sd m�g a mysql_affected_rows, mysql_db_query, - mysql_unbuffered_query, mysql_free_result, mysql_result, - mysql_select_db, and - mysql_connect. - - - - - - - mysql_unbuffered_query - Send an SQL query to MySQL, without fetching and buffering the result rows - - - Description - - - resource mysql_unbuffered_query - string query - resource - link_identifier - - int - result_mode - - - - - mysql_unbuffered_query sends a SQL query to MySQL, - without fetching and buffering the result rows automatically, as - mysql_query does. - On the one hand, this saves a considerable amount of me