cvs: phpdoc /kr/functions mysql.xml
| From: | Joong-yeon Choi | Date: | Tue, 23 Jan 2001 14:00:04 +0000 |
| Subject: | cvs: phpdoc /kr/functions mysql.xml | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969333874@lists.php.net to get a copy of this message | ||
pcraft Tue Jan 23 06:00:04 2001 EDT
Modified files:
/phpdoc/kr/functions mysql.xml
Log:
Index: phpdoc/kr/functions/mysql.xml diff -u phpdoc/kr/functions/mysql.xml:1.2 phpdoc/kr/functions/mysql.xml:1.3 --- phpdoc/kr/functions/mysql.xml:1.2 Fri Jan 12 06:16:40 2001 +++ phpdoc/kr/functions/mysql.xml Tue Jan 23 06:00:03 2001 @@ -1,28 +1,25 @@ - <reference id="ref.mysql"> - <title>MySQL functions</title> + <reference id="ref.mysql"> + <title>MySQL í¨ì</title> <titleabbrev>MySQL</titleabbrev> <partintro> <simpara> - 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 role="configure">--with-mysql</option> 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: + ìë í¨ìë¤ì MySQL ë°ì´í°ë² ì´ì¤ ìë²ì ì ê·¼í ì ìê² í´ì¤ë¤. + ì´ë¤ í¨ì를 ì¬ì©íë ¤ë©´ <option role="configure">--with-mysql</option> + ìµì ì¼ë¡ MySQLê³¼ í¨ê» PHP를 ì»´íì¼í´ì¼ íë¤. + ë§ì¼ ì ìµì ì MySQLì´ ì¤ì¹ë ê²½ë¡ ìì´ ì¬ì©íë¤ë©´ + PHPë ë´ì¥ë í´ë¼ì´ì¸í¸ ë¼ì´ë¸ë¬ë¦¬ë¥¼ ëì ì¬ì©í ê²ì´ë¤. + ìë¡ ë¤ë¥¸ ì´í리ì¼ì´ì ì ì´ì©íë ì¬ì©ìë¤ì´ MySQLì + ì¬ì©íë ¤ í ë(ì를ë¤ì´, PHP3ì PHP4ê° ëìì apache 모ëë¡ì¨ ëìê°ê±°ë, + auth-mysqlì¼ ê²½ì°) MySQL ê²½ë¡ë¥¼ ë°ëì ë¤ìê³¼ ê°ì´ ì¤ì í´ì¼ íë¤: <option role="configure">--with-mysql=/path/to/mysql</option>. - This will force php to use the client libraries installed by - mysql, avoiding any conflicts. + ì ìµì ì phpê° mysqlì ìí´ ì¤ì¹ë í´ë¼ì´ì¸í¸ ë¼ì´ë¸ë¬ë¦¬ë¥¼ ì¬ì©íëë¡ + íë©°, ì´ë í ì¶©ëë í¼í ì ìê² í´ì¤ë¤. </simpara> <simpara> - More information about MySQL can be found at <ulink - url="&url.mysql;">&url.mysql;</ulink>. + MySQLì ëí ë ìì¸í ì ë³´ë <ulink url="&url.mysql;">&url.mysql;</ulink>ìì ì»ì ì ìë¤. </simpara> <simpara> - Documentation for MySQL can be found at <ulink - url="&url.mysql.docs;">&url.mysql.docs;</ulink>. + MySQL 문ìë <ulink url="&url.mysql.docs;">&url.mysql.docs;</ulink>ì ìë¤. </simpara> </partintro> @@ -30,11 +27,10 @@ <refentry id="function.mysql-affected-rows"> <refnamediv> <refname>mysql_affected_rows</refname> - <refpurpose>Get number of affected rows in previous MySQL - operation</refpurpose> + <refpurpose>ìµê·¼ MySQL ìì ì¼ë¡ ì²ë¦¬ë ì¤(row) ê°ì를 ì»ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_affected_rows</function></funcdef> @@ -46,20 +42,19 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_affected_rows</function> returns the number of - rows affected by the last INSERT, UPDATE or DELETE query on the - server associated with the specified link identifier. If the - link identifier isn't specified, the last opened link is assumed. + <function>mysql_affected_rows</function>ë link identifierë¡ + ì ìëì´ ìë ìë²ìì ìµê·¼ ì¤íë INSERT, UPDATE, DELETE ì§ìë¡ + ì²ë¦¬ë ì¤ì ê°ì를 ëë ¤ì¤ë¤. ë§ì½ link identifier ì¸ì를 + ìëµíë©´, ìµê·¼ ì´ë ¤ì§ linkìì ì 보를 ì»ëë¤. </para> <para> - 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. + ë§ì§ë§ ì§ìê° WHERE ì ì´ ìë DELETE ì§ìë¼ë©´ í ì´ë¸ì 모ë ë ì½ëê° + ìì ëê² ì§ë§ ì´ í¨ìì ê²½ì° 0ê°ì ëë ¤ì¤ë¤. </para> <para> - This command is not effective for SELECT statements, only on - statements which modify records. To retrieve the number of rows - returned from a SELECT, use <function>mysql_num_rows</function>. + ì´ í¨ìë SELECT 문ìë ëìíì§ ìì¼ë©°, ë ì½ëê° ìì ëë ê²½ì°ìë§ ëìíë¤. + SELECT 구문ì¼ë¡ë¶í° ëë ¤ë°ì ì¤ì ê°ì를 ì»ì¼ë ¤ë©´, <function>mysql_num_rows</function>를 + ì°ë©´ ëë¤. </para> </refsect1> </refentry> @@ -68,11 +63,11 @@ <refnamediv> <refname>mysql_change_user</refname> <refpurpose> - Change logged in user of the active connection + íì¬ ì ììì ë¡ê·¸ì¸ë ì¬ì©ì를 ë³ê²½ </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_change_user</function></funcdef> @@ -91,14 +86,13 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_change_user</function> 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.</para> - <note><para>This function was introduced in PHP 3.0.13 and - requires MySQL 3.23.3 or higher. + <function>mysql_change_user</function>í¨ìë íì¬ ì¬ì©ì¤ì¸ ì ì ëë + link identifier ì¸ìë¡ ì£¼ì´ì§ ì ììì ë¡ê·¸ì¸ë ì¬ì©ì를 ë³ê²½íë¤. + ë°ì´í°ë² ì´ì¤ ì´ë¦ì´ ì§ì ëë©´, ì¬ì©ìê° ë³ê²½ë ë¤ì + ì´ ë°ì´í°ë² ì´ì¤ê° 기본ê°ì¼ë¡ ëë©°, ê·¸ë ì§ ìì ê²½ì° íì¬ ë°ì´í°ë² ì´ì¤ê° ì¬ì©ëë¤. + ë³ê²½í ì¬ì©ìì ë¹ë°ë²í¸ ì¸ì¦ì ì¤í¨íê²ëë©´, + íì¬ ì ìë ì¬ì©ìë ì ìì´ ê·¸ëë¡ ì ì§ëë¤.</para> + <note><para>ì´ í¨ìë PHP 3.0.13 ê³¼ MySQL 3.23.3 ì´ìììë§ ëìíë¤. </para></note> </refsect1> </refentry> @@ -106,10 +100,10 @@ <refentry id="function.mysql-close"> <refnamediv> <refname>mysql_close</refname> - <refpurpose>Close MySQL connection</refpurpose> + <refpurpose>MySQL ì ìì ë«ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_close</function></funcdef> @@ -121,37 +115,36 @@ </funcprototype> </funcsynopsis> <para> - Returns: true on success, false on error. + ë°íê°: ì±ê³µíë©´ TRUEê°ì ì¤í¨íë©´ FALSEê°ì ëë림 </para> - <para> <function>mysql_close</function> closes the connection to - the MySQL server that's associated with the specified link - identifier. If <parameter>link_identifier</parameter> isn't - specified, the last opened link is used. + <para> <function>mysql_close</function> link identifierì ê´ë ¨ë + MySQL ìë² ì ìì ë«ëë¤. <parameter>link identifier</parameter>를 + ì§ì íì§ ìì¼ë©´ ë§ì§ë§ ì´ë ¤ì§ link를 ì¬ì©íë¤. </para> <para> - Using <function>mysql_close</function> isn't usually necessary, - as non-persistent open links are automatically closed at the end - of the script's execution. + <function>mysql_close</function>ë ë¹ì구ì ì¼ë¡ + ì´ë ¤ì§ ë§í¬ììë ì¼ë°ì ì¼ë¡ ì¤í¬ë¦½í¸(script) ì¤í ë§ì§ë§ ë¶ë¶ìì + ìëì¼ë¡ ì¢ ë£ë기 ë문ì ì¬ì©í íìê° ìë¤. </para> <note> <para> - <function>mysql_close</function> will not close persistent links - created by <function>mysql_pconnect</function>. + <function>mysql_close</function>ì <function>mysql_pconnect</function>ë¡ + ìì±ë ì구ì ì¼ë¡ ì ìë ë§í¬ììë ì¢ ë£ê° ìë ê²ì´ë¤. </para> </note> <example> - <title>MySQL close example</title> + <title>MySQL close ìì </title> <programlisting role="php"> <?php $link = mysql_connect ("kraemer", "marliesle", "secret") - or die ("Could not connect"); - print ("Connected successfully"); + or die ("ì ìí ì ììµëë¤"); + print ("ì ìëììµëë¤"); mysql_close ($link); ?> </programlisting> </example> <para> - See also: <function>mysql_connect</function>, and + 참조: <function>mysql_connect</function>, <function>mysql_pconnect</function>. </para> </refsect1> @@ -160,10 +153,10 @@ <refentry id="function.mysql-connect"> <refnamediv> <refname>mysql_connect</refname> - <refpurpose>Open a connection to a MySQL Server</refpurpose> + <refpurpose>MySQL ìë²ì ì ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_connect</function></funcdef> @@ -188,59 +181,54 @@ </funcprototype> </funcsynopsis> <para> - Returns a positive MySQL link identifier on success, or an error - message on failure. + ì ìì ì±ê³µíë©´ MySQL link identifier를, ê·¸ë ì§ ìì¼ë©´ ìë¬ ë©ìì§ë¥¼ ë°ííë¤. </para> <para> - <function>mysql_connect</function> establishes a connection - to a MySQL server. The following defaults are assumed for - missing optional parameters: <parameter>host:port</parameter> = - 'localhost:3306', <parameter>username</parameter> = name of the - user that owns the server process and - <parameter>password</parameter> = empty password. + <function>mysql_connect</function>ì ì´ì©íì¬ MySQL ìë²ì ì ìì í ì ìë¤. + ìë ëì´ë 기본ê°ì ì¸ì를 ì ë ¥íì§ ììì ë ëì ì¬ì©ëë ê°ì´ë¤. + <parameter>host:port</parameter>ë 'localhost:3306'ë¡, <parameter>username</parameter>ì + ìë² íë¡ì¸ì¤(server process)ì ìì ìë¡, ê·¸ë¦¬ê³ <parameter>password</parameter>ë + 공백 ë¹ë°ë²í¸ë¡ ëì²´ëë¤. </para> <para> - 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. + hostnameì "hostname:port"ì ê°ì´ í¬í¸ ë²í¸ë¥¼ í¬í¨í ì ìë¤. + ëí ë¡ì»¬í¸ì¤í¸ìì ":/path/to/socket"ì ê°ì´ + ìì¼ë ì¬ì©í ì ìë¤. <note> <para> - Support for ":port" was added in PHP 3.0B4. + ":port"ë PHP 3.0B4ìì ì¶ê°ë 기ë¥ì´ë¤. </para> <para> - Support for ":/path/to/socket" was added in - PHP 3.0.10. + ":/path/to/socket"ì PHP 3.0.10ì ì¶ê°ë 기ë¥ì´ë¤. </para> <para> - You can suppress the error message on failure by prepending '@' - to the function name. + í¨ì ì´ë¦ ìì '@'를 ë¶ìì¼ë¡ì¨ ìë¬ ë©ìì§ê° ì¶ë ¥ëì§ ìëë¡ í ì ìë¤. </para> </note> </para> <para> - If a second call is made to <function>mysql_connect</function> - with the same arguments, no new link will be established, but - instead, the link identifier of the already opened link will be - returned. + ëì¼í ì¸ìë¡ <function>mysql_connect</function>ì ë¤ì í¸ì¶íë©´, + ìë¡ì´ linkê° ìì±ëì§ ìë ëì , ì´ë¯¸ ì´ë ¤ì§ link identifier ê°ì + ëë ¤ë°ê² ëë¤. </para> <para> - 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 - <function>mysql_close</function>. + ìë²ìì ë§í¬ë ì¤í¬ë¦½í¸ ëë¶ë¶ì´ ì¤íëë ì¦ì ì¢ ë£ê° ëì§ë§, + <function>mysql_close</function>ì ì¬ì©íë©´ ì¤í¬ë¦½í¸ ëë¶ë¶ì´ ìëëë¼ë + ì¢ ë£ê° ê°ë¥íë¤. </para> <example> - <title>MySQL connect example</title> + <title>MySQL ì ì ìì </title> <programlisting role="php"> <?php $link = mysql_connect ("kraemer", "marliesle", "secret") - or die ("Could not connect"); - print ("Connected successfully"); + or die ("ì ìí ì ììµëë¤"); + print ("ì ìëììµëë¤"); mysql_close ($link); ?> </programlisting> </example> - <para> See also - <function>mysql_pconnect</function>, and + <para> 참조: + <function>mysql_pconnect</function>, <function>mysql_close</function>. </para> </refsect1> @@ -249,10 +237,10 @@ <refentry id="function.mysql-create-db"> <refnamediv> <refname>mysql_create_db</refname> - <refpurpose>Create a MySQL database</refpurpose> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ë¥¼ ìì±</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_create_db</function></funcdef> @@ -265,30 +253,28 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_create_db</function> attempts to create a new - database on the server associated with the specified link - identifier. + <function>mysql_create_db</function>ë link identifierì ê´ë ¨ë ìë²ì + ìë¡ì´ ë°ì´í°ë² ì´ì¤ë¥¼ ìì±íëë¡ íë¤. </para> <example> - <title>MySQL create database example</title> + <title>MySQL ë°ì´í°ë² ì´ì¤ ìì± ìì </title> <programlisting role="php"> <?php $link = mysql_pconnect ("kron", "jutta", "geheim") or die ("Could not connect"); if (mysql_create_db ("my_db")) { - print ("Database created successfully\n"); + print ("ë°ì´í°ë² ì´ì¤ë¥¼ ìì±íììµëë¤\n"); } else { - printf ("Error creating database: %s\n", mysql_error ()); + printf ("ë°ì´í°ë² ì´ì¤ ìì± ìë¬: %s\n", mysql_error ()); } ?> </programlisting> </example> <para> - For downwards compatibility <function>mysql_createdb</function> - can also be used. + íì í¸íì±ì ê°ì§ë <function>mysql_createdb</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> <para> - See also: <function>mysql_drop_db</function>. + 참조: <function>mysql_drop_db</function>. </para> </refsect1> </refentry> @@ -296,10 +282,10 @@ <refentry id="function.mysql-data-seek"> <refnamediv> <refname>mysql_data_seek</refname> - <refpurpose>Move internal result pointer</refpurpose> + <refpurpose>ë´ë¶ì ì¸ ê²°ê³¼ í¬ì¸í°ë¥¼ ì´ë</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_data_seek</function></funcdef> @@ -308,37 +294,37 @@ </funcprototype> </funcsynopsis> <para> - Returns: true on success, false on failure. + ë°íê°: ì±ê³µíë©´ TRUE, ì¤í¨íë©´ FALSE.ì </para> <para> - <function>mysql_data_seek</function> 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 <function>mysql_fetch_row</function> would return that row. + <function>mysql_data_seek</function>í¨ìë MySQL ê²°ê³¼ì¤ + ì¸ìë¡ ì§ì ë íë²í¸ë¥¼ ì´ì©íì¬ ë´ë¶ì ì¸ í í¬ì¸í°ë¥¼ + ì´ëìì¼ì¤ë¤. + <function>mysql_fetch_row</function>를 ì¬ì©íì¬ íì ë´ì©ì ì»ì ì ìë¤. </para> <para> - <parameter>Row_number</parameter> starts at 0. + <parameter>Row_number</parameter>ë 0ë¶í° ììëë¤. </para> <example> - <title>MySQL data seek example</title> + <title>MySQL ë°ì´í° ê²ì ìì </title> <programlisting role="php"> <?php $link = mysql_pconnect ("kron", "jutta", "geheim") - or die ("Could not connect"); + or die ("ì ìí ì ììµëë¤"); mysql_select_db ("samp_db") - or die ("Could not select database"); + or die ("ë°ì´í°ë² ì´ì¤ë¥¼ ì íí ì ììµëë¤"); $query = "SELECT last_name, first_name FROM friends"; $result = mysql_query ($query) - or die ("Query failed"); + or die ("ì§ì ì¤í¨"); # fetch rows in reverse order for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) { if (!mysql_data_seek ($result, $i)) { - printf ("Cannot seek to row %d\n", $i); + printf ("%d ë² íì ê²ìí ì ììµëë¤\n", $i); continue; } @@ -358,10 +344,10 @@ <refentry id="function.mysql-db-name"> <refnamediv> <refname>mysql_db_name</refname> - <refpurpose>Get result data</refpurpose> + <refpurpose>ë°ì´í° 결과를 ì»ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_db_name</function></funcdef> @@ -375,22 +361,19 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_db_name</function> takes as its first parameter - the result pointer from a call to - <function>mysql_list_dbs</function>. The - <parameter>row</parameter> parameter is an index into the result - set. + <function>mysql_db_name</function>ì <function>mysql_list_dbs</function>를 ì¤íí + 결과를 첫ë²ì§¸ ì¸ìë¡ ê°ëë¤. <parameter>row</parameter> ì¸ìë + 첫ë²ì§¸ ì¸ìë¡ë¶í° ì»ì´ì§ ê²°ê³¼ê°ì ì»ê¸°ìí ìì¸ì´ë¤. </para> <para> - If an error occurs, FALSE is returned. Use - <function>mysql_errno</function> and - <function>mysql_error</function> to determine the nature of the - error. + ë§ì½ ìë¬ê° ë°ìíë©´ falseê°ì ëë ¤ì¤ë¤. + <function>mysql_errno</function>ì <function>mysql_error</function>를 + ì¬ì©íì¬ ìë¬ ë©ìì§ ì²ë¦¬ë¥¼ í ì ìë¤. </para> <example> - <title><function>Mysql_db_name</function> example</title> + <title><function>Mysql_db_name</function> ìì </title> <programlisting role="php"> <?php error_reporting(E_ALL); @@ -409,8 +392,8 @@ </example> <para> - For backward compatibility, <function>mysql_dbname</function> is - also accepted. This is deprecated, however. + íì í¸íì±ì´ ìë <function>mysql_dbname</function>를 ì¬ì©í ì ìì¼ë + íì¬ ì¬ì©ëì§ ìëë¤. </para> </refsect1> @@ -419,10 +402,10 @@ <refentry id="function.mysql-db-query"> <refnamediv> <refname>mysql_db_query</refname> - <refpurpose>Send a MySQL query</refpurpose> + <refpurpose>MySQL ì§ì문ì ì ì¡</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_db_query</function></funcdef> @@ -436,23 +419,21 @@ </funcprototype> </funcsynopsis> <para> - Returns: A positive MySQL result identifier to the query result, - or false on error. + ë°íê°: MySQL ì§ìë¡ ë°ìí result identifierê°ì, + ìë¬ê° ë°ìíì ê²½ì° false를 ëë ¤ì¤ë¤. </para> <para> - <function>mysql_db_query</function> 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 <function>mysql_connect</function> was called with no - arguments + <function>mysql_db_query</function>ë ë°ì´í°ë² ì´ì¤ë¥¼ ì ííê³ , + ëìì ì§ì문ì ì¤ííë¤. ë§ì½ link identifierê° ì§ì ëì§ ìëë¤ë©´, + í¨ìë MySQL ìë²ìì ì ìë ë§í¬ë¥¼ ì°¾ì ê²ì´ë©°, ì°¾ì§ ëª»í ê²½ì°ìë + ì¸ììì´ ì¤íë <function>mysql_connect</function>ê³¼ ê°ì´ + ë§í¬ë¥¼ ìì±íì¬ ì¬ì©íë¤. </para> <para> - See also <function>mysql_connect</function>. + 참조: <function>mysql_connect</function>. </para> <para> - For downwards - compatibility <function>mysql</function> can also be used. + íì í¸íì±ì ê°ì§ë <function>mysql</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> </refsect1> </refentry> @@ -460,10 +441,10 @@ <refentry id="function.mysql-drop-db"> <refnamediv> <refname>mysql_drop_db</refname> - <refpurpose>Drop (delete) a MySQL database</refpurpose> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ë¥¼ ìì </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_drop_db</function></funcdef> @@ -476,7 +457,7 @@ </funcprototype> </funcsynopsis> <para> - Returns: true on success, false on failure. + ë°íê°: ì±ê³µíë©´ true, ì¤í¨íë©´ false. </para> <para> <function>mysql_drop_db</function> attempts to drop (remove) an @@ -484,8 +465,8 @@ link identifier. </para> <para> - See also: <function>mysql_create_db</function>. For downward - compatibility <function>mysql_dropdb</function> can also be used. + 참조: <function>mysql_create_db</function>. + íì í¸íì±ì´ ìë <function>mysql_dropdb</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> </refsect1> </refentry> @@ -493,11 +474,10 @@ <refentry id="function.mysql-errno"> <refnamediv> <refname>mysql_errno</refname> - <refpurpose>Returns the numerical value of the error message from previous - MySQL operation</refpurpose> + <refpurpose>ìµê·¼ MySQL ìì ì¼ë¡ ë°ìí ìë¬ ë²í¸ë¥¼ ë°í</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_errno</function></funcdef> @@ -509,18 +489,15 @@ </funcprototype> </funcsynopsis> <para> - Returns the error number from the last mySQL function, or - <literal>0</literal> (zero) if no error occurred. + ìµê·¼ ì¤íë MySQL í¨ìì ìë¬ë²í¸ë¥¼, ìë¬ê° ìì ê²½ì° + <literal>0</literal> ê°ì ë°ííë¤. </para> <para> - Errors coming back from the mySQL database backend no longer - issue warnings. Instead, use <function>mysql_errno</function> to - retrieve the error code. Note that this function only returns the - error code from the most recently executed mySQL function (not - including <function>mysql_error</function> and - <function>mysql_errno</function>), so if you want to use it, - make sure you check the value before calling another mySQL - function. + íë² MySQL ë°ì´í°ë² ì´ì¤ë¡ë¶í°ì ë°ìë ìë¬ë ëë¤ì ê²½ê³ ë©ìì§ë¥¼ ëíë´ì§ ìëë¤. + ëì , <function>mysql_errno</function>를 ì¬ì©íë©´ ìë¬ ì½ë(code)를 ì»ì ì ìë¤. + ì´ í¨ìë ìµê·¼ì ì¤íë MySQL í¨ì(<function>mysql_error</function>ê³¼ + <function>mysql_errno</function>를 ì ì¸í)ë¡ ë°ìë ìë¬ ì½ëë§ ì»ì ì ìë¤. + ê·¸ë¬ë ì¬ì©í기 ìí´ìë ë¤ë¥¸ MySQL í¨ì를 ì¬ì©í기 ì´ì ì ì¬ì©í´ì¼ íë¤. <informalexample> <programlisting role="php"> <?php @@ -543,11 +520,10 @@ <refentry id="function.mysql-error"> <refnamediv> <refname>mysql_error</refname> - <refpurpose>Returns the text of the error message from previous - MySQL operation</refpurpose> + <refpurpose>ìµê·¼ ì¤íë MySQL ìì ì¼ë¡ ë°ìí ìë¬ ë©ìì§ë¥¼ ë°í</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>string <function>mysql_error</function></funcdef> @@ -559,17 +535,15 @@ </funcprototype> </funcsynopsis> <para> - Returns the error text from the last mySQL function, or - <literal>''</literal> (the empty string) if no error occurred. + MySQL í¨ìë¡ ë°ìë ìë¬ ë©ìì§ë¥¼ ì»ì ì ìì¼ë©°, + ìë¬ê° ë°ìíì§ ììì ê²½ì°ìë <literal>''</literal> (공백문ì)를 ì»ì ì ìë¤. </para> <para> - Errors coming back from the mySQL database backend no longer - issue warnings. Instead, use <function>mysql_error</function> to - retrieve the error text. Note that this function only returns the - error text from the most recently executed mySQL function (not - including <function>mysql_error</function> and - <function>mysql_errno</function>), so if you want to use it, make - sure you check the value before calling another mySQL function. + íë² MySQL ë°ì´í°ë² ì´ì¤ë¡ë¶í°ì ë°ìë ìë¬ë ëë¤ì ê²½ê³ ë©ìì§ë¥¼ ëíë´ì§ ìëë¤. + ëì , <function>mysql_error</function>를 ì¬ì©íë©´ ìë¬ ë©ìì§ë¥¼ ì»ì ì ìë¤. + ì´ í¨ìë ìµê·¼ì ì¤íë MySQL í¨ì(<function>mysql_error</function>ê³¼ + <function>mysql_errno</function>를 ì ì¸í)ë¡ ë°ìë ìë¬ ì½ëë§ ì»ì ì ìë¤. + ê·¸ë¬ë ì¬ì©í기 ìí´ìë ë¤ë¥¸ MySQL í¨ì를 ì¬ì©í기 ì´ì ì ì¬ì©í´ì¼ íë¤. <informalexample> <programlisting role="php"> <?php @@ -584,7 +558,7 @@ </informalexample> </para> <para> - See also: <function>mysql_errno</function> + 참조: <function>mysql_errno</function>. </para> </refsect1> </refentry> @@ -593,11 +567,11 @@ <refnamediv> <refname>mysql_fetch_array</refname> <refpurpose> - Fetch a result row as an associative array, a numeric array, or both. + 결과를 íëì´ë¦ ìì¸ ëë ì«ì ìì¸ì¼ë¡ ë ë°°ì´ë¡ ì»ì </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>array <function>mysql_fetch_array</function></funcdef> @@ -610,19 +584,17 @@ </funcprototype> </funcsynopsis> <para> - Returns an array that corresponds to the fetched row, or false - if there are no more rows.</para> + ë°ì´í°ë² ì´ì¤ í ì´ë¸ë¡ë¶í° ê°ì ¸ì¨ íì ëìëë ë°°ì´ë¡ ëë ¤ì£¼ê³ , + ëì´ì ê°ì ¸ì¬ íì´ ìì ê²½ì° false를 ë°ííë¤.</para> <para> - <function>mysql_fetch_array</function> is an extended version of - <function>mysql_fetch_row</function>. 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. + <function>mysql_fetch_array</function>ë <function>mysql_fetch_row</function>ìì + íì¥ë í¨ìì´ë¤. ê²°ê³¼ ë°°ì´ì ìë£ê° ì ì¥ëê³ ë°°ì´ì ìì¸ì¼ë¡ ë²í¸ê° ì¬ì©ëë¤. + ëí, ë°°ì´ì ìì¸ì¼ë¡ í ì´ë¸ì íë ì´ë¦ì¼ë¡ë ì¬ì©í ì ìë¤. </para> <para> - 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. + ê²°ê³¼ë¡ ëê° ì´ìì ëì¼í íë ì´ë¦ì ê°ì§ ì´ì´ ìë¤ë©´, + ë§ì§ë§ ì´ì´ ì°ì ê¶ì ê°ì§ë¤. ëì¼í ë¤ë¥¸ ì´ì ì¬ì©í기 ìí´ìë + ìì¸ ë²í¸ë¥¼ ì´ì©íê±°ë ì§ì 문ì¥ìì ì´ì ë³ëª ì ì£¼ì´ ì´ì©íì¬ì¼ íë¤. <informalexample> <programlisting> select t1.f1 as foo t2.f1 as bar from t1, t2 @@ -630,20 +602,16 @@ </informalexample> </para> <para> - An important thing to note is that using - <function>mysql_fetch_array</function> is NOT significantly - slower than using <function>mysql_fetch_row</function>, while it - provides a significant added value. + <function>mysql_fetch_array</function>ë íë ì´ë¦ì¼ë¡ ë ìì¸ì´ ì¶ê°ëì§ë§, + <function>mysql_fetch_row</function> ë³´ë¤ ëë ¤ì§ì§ë ìëë¤. </para> <para> - The optional second argument <parameter>result_type</parameter> - in <function>mysql_fetch_array</function> 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) + <function>mysql_fetch_array</function>ìì ëë²ì§¸ ìµì ì¸ì + <parameter>result_type</parameter>ì ììì´ê³ , MYSQL_ASSOC, MYSQL_NUM, + MYSQL_BOTHì ê°ì ê°ì ê°ì§ ì ìë¤(PHP 3.0.7ì ì¶ê°ëìì). </para> <para> - For further details, see also - <function>mysql_fetch_row</function> and <function>mysql_fetch_assoc</function>. + 참조: <function>mysql_fetch_row</function>, <function>mysql_fetch_assoc</function>. </para> <example> <title><function>Mysql_fetch_array</function></title> @@ -668,11 +636,11 @@ <refnamediv> <refname>mysql_fetch_assoc</refname> <refpurpose> - Fetch a result row as an associative array + 결과를 íëì´ë¦ ìì¸ì¼ë¡ ë ë°°ì´ë¡ ì»ì </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>array <function>mysql_fetch_assoc</function></funcdef> @@ -680,31 +648,28 @@ </funcprototype> </funcsynopsis> <para> - Returns an associative array that corresponds to the fetched row, - or false if there are no more rows.</para> + íëì´ë¦ì ìì¸ì ê°ì§ ë°°ì´ë¡ ëë ¤ì£¼ê³ , + ê°ì ¸ì¬ íì´ ìì ê²½ì° falseê°ì ë°ííë¤.</para> <para> - <function>mysql_fetch_assoc</function> is equivalent to calling - <function>mysql_fetch_array</function> with MYSQL_ASSOC for the - optional second parameter. It only returns an associative array. - This is the way <function>mysql_fetch_array</function> originally - worked. If you need the numeric indices as well as the - associative, use <function>mysql_fetch_array</function>. + <function>mysql_fetch_assoc</function>ë + <function>mysql_fetch_array</function>ì ëë²ì§¸ ì¸ìë¡ + MYSQL_ASSOC를 ì¬ì©í ê²½ì°ê³¼ ëì¼íê² ìëíë¤. + ì´ ë°©ìì <function>mysql_fetch_array</function>ì 본ëì ëì ë°©ë²ì´ë¤. + ë§ì¼ ì«ì ìì¸ ë°©ìê³¼ íëì´ë¦ ìì¸ì ëìì ì¬ì©íë ¤ë©´, + <function>mysql_fetch_array</function>를 ì¬ì©íë©´ ëë¤. </para> <para> - 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 <function>mysql_fetch_array</function> and - have it return the numeric indices as well. + ê²°ê³¼ë¡ ëê° ì´ìì ëì¼í íë ì´ë¦ì ê°ì§ ì´(column)ì´ ìë¤ë©´, + ë§ì§ë§ ì´ì´ ì°ì ê¶ì ê°ì§ë¤. ëì¼í ë¤ë¥¸ ì´ì ì¬ì©í기 ìí´ìë + ìì¸ ë²í¸ë ì¶ê°ë <function>mysql_fetch_array</function>를 + ì¬ì©í´ì¼í ê²ì´ë¤. </para> <para> - An important thing to note is that using - <function>mysql_fetch_assoc</function> is NOT significantly - slower than using <function>mysql_fetch_row</function>, while it - provides a significant added value. + <function>mysql_fetch_assoc</function>ë íëì´ë¦ì¼ë¡ ë ìì¸ì´ ì¶ê°ëì§ë§, + <function>mysql_fetch_row</function> ë³´ë¤ ëë ¤ì§ì§ë ìëë¤. </para> <para> - For further details, see also - <function>mysql_fetch_row</function> and <function>mysql_fetch_array</function>. + 참조: <function>mysql_fetch_row</function>, <function>mysql_fetch_array</function>. </para> <example> <title><function>Mysql_fetch_assoc</function></title> @@ -727,11 +692,11 @@ <refnamediv> <refname>mysql_fetch_field</refname> <refpurpose> - Get column information from a result and return as an object + ê²°ê³¼ë¡ë¶í° ì´ ì 보를 ì»ì´ì ê°ì²´ë¡ ëë ¤ì¤ </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>object <function>mysql_fetch_field</function></funcdef> @@ -744,94 +709,96 @@ </funcprototype> </funcsynopsis> <para> - Returns an object containing field information. + íë ì ë³´ê° í¬í¨ë ê°ì²´ë¡ ë°ííë¤. </para> <para> - <function>mysql_fetch_field</function> 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 <function>mysql_fetch_field</function> is retrieved. + <function>mysql_fetch_field</function>ë í¹ì ì§ì ê²°ê³¼ë¡ë¶í° + íë ì 보를 ì»ì 목ì ì¼ë¡ ì¬ì©í ì ìë¤. ë§ì¼ field_offsetì ì§ì íì§ ìì¼ë©´, + <function>mysql_fetch_field</function>ì ìí´ ìì§ ì»ì§ 못í ë¤ì íë ì 보를 + ì»ê² ëë¤. </para> - <para> - The properties of the object are: + <para> + ê°ì²´ì ëí í¹ì±ì ë¤ìê³¼ ê°ë¤. <itemizedlist> - <listitem> - <simpara> - name - column name + <listitem> + <simpara> + name - ì´(column) ì´ë¦ </simpara> - </listitem> - <listitem> - <simpara> - table - name of the table the column belongs to + </listitem> + <listitem> + <simpara> + table - ì´ì´ ìí´ìë í ì´ë¸ ì´ë¦ </simpara> - </listitem> - <listitem> - <simpara> - max_length - maximum length of the column + </listitem> + <listitem> + <simpara> + max_length - ì´ì ìµë ê¸¸ì´ </simpara> - </listitem> - <listitem> - <simpara> - not_null - 1 if the column cannot be null + </listitem> + <listitem> + <simpara> + not_null - ì´ ê°ì´ nullì´ ìëë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - primary_key - 1 if the column is a primary key + </listitem> + <listitem> + <simpara> + primary_key - ì´ì´ primary keyì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - unique_key - 1 if the column is a unique key + </listitem> + <listitem> + <simpara> + unique_key - ì´ì´ unique keyì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - multiple_key - 1 if the column is a non-unique key + </listitem> + <listitem> + <simpara> + multiple_key - ì´ì´ non-unique keyì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - numeric - 1 if the column is numeric + </listitem> + <listitem> + <simpara> + numeric - ì´ì´ ì«ìì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - blob - 1 if the column is a BLOB + </listitem> + <listitem> + <simpara> + blob - ì´ì´ BLOBì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - type - the type of the column + </listitem> + <listitem> + <simpara> + type - ì´ì íì </simpara> - </listitem> - <listitem> - <simpara> - unsigned - 1 if the column is unsigned + </listitem> + <listitem> + <simpara> + unsigned - ì´ì´ ë¶í¸ìì(unsigned)ì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - zerofill - 1 if the column is zero-filled + </listitem> + <listitem> + <simpara> + zerofill - ì´ì´ 0ì¼ë¡ ì±ì(zero-filled)ì´ë©´ 1 </simpara> - </listitem> - </itemizedlist> - </para> - <example> - <title><function>Mysql_fetch_field</function></title> - <programlisting role="php"> + </listitem> + </itemizedlist> + </para> + <example> + <title> + <function>Mysql_fetch_field</function> + </title> + <programlisting role="php"> <?php mysql_connect ($host, $user, $password) - or die ("Could not connect"); + or die ("ì ìí ì ììµëë¤"); $result = mysql_db_query ("database", "select * from table") - or die ("Query failed"); + or die ("ì§ì ì¤í¨"); # get column metadata $i = 0; while ($i < mysql_num_fields ($result)) { echo "Information for column $i:<BR>\n"; $meta = mysql_fetch_field ($result); if (!$meta) { - echo "No information available<BR>\n"; + echo "ì´ë í ì ë³´ë ììµëë¤.<BR>\n"; } echo "<PRE> blob: $meta->blob @@ -852,89 +819,88 @@ mysql_free_result ($result); ?> </programlisting> - </example> - <para> - See also <function>mysql_field_seek</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-fetch-lengths"> - <refnamediv> - <refname>mysql_fetch_lengths</refname> - <refpurpose> - Get the length of each output in a result + </example> + <para> + 참조: <function>mysql_field_seek</function>. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-fetch-lengths"> + <refnamediv> + <refname>mysql_fetch_lengths</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° ê° ì¶ë ¥ì 길ì´ë¥¼ ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>array <function>mysql_fetch_lengths</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: An array that corresponds to the lengths of each field - in the last row fetched by <function>mysql_fetch_row</function>, - or false on error. - </para> - <para> - <function>mysql_fetch_lengths</function> stores the lengths of - each result column in the last row returned by - <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function>, and - <function>mysql_fetch_object</function> in an array, starting at - offset 0. - </para> - <para> - See also: <function>mysql_fetch_row</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-fetch-object"> - <refnamediv> - <refname>mysql_fetch_object</refname> - <refpurpose>Fetch a result row as an object</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>object <function>mysql_fetch_object</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int - <parameter> - <optional>result_type</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns an object with properties that correspond to the fetched - row, or false if there are no more rows. - </para> - <para> - <function>mysql_fetch_object</function> is similar to - <function>mysql_fetch_array</function>, 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). - </para> - <para> - The optional argument <parameter>result_type</parameter> is a - constant and can take the following values: MYSQL_ASSOC, - MYSQL_NUM, and MYSQL_BOTH. - </para> - <para> - Speed-wise, the function is identical to - <function>mysql_fetch_array</function>, and almost as quick as - <function>mysql_fetch_row</function> (the difference is - insignificant). + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>array <function>mysql_fetch_lengths</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: ìµê·¼ <function>mysql_fetch_row</function>ë¡ ì»ì + í(row)ì ê° íë 길ì´ë¥¼ ë°°ì´ë¡ ì»ê±°ë, ìë¬ ë°ìììë falseê°ì + ì»ëë¤. + </para> + <para> + <function>mysql_fetch_lengths</function>ë + ìµê·¼ <function>mysql_fetch_row</function>, + <function>mysql_fetch_array</function>, + <function>mysql_fetch_object</function>ë¡ ì»ì íì¼ë¡ë¶í° + ê° ì´(column)ì 길ì´ë¥¼ ìì¸ê°ì´ 0ì¼ë¡ ììíë ë°°ì´ë¡ ì ì¥íì¬ ë°ííë¤. + </para> + <para> + 참조: <function>mysql_fetch_row</function>. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-fetch-object"> + <refnamediv> + <refname>mysql_fetch_object</refname> + <refpurpose>í(row)ì 결과를 ê°ì²´ë¡ ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>object <function>mysql_fetch_object</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>result_type</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + í(row)ì ëìëë ê°ì²´ë¡ ëë ¤ì£¼ê³ , + ê°ì ¸ì¬ íì´ ìì ê²½ì° false를 ë°ííë¤. + </para> + <para> + <function>mysql_fetch_object</function>ë + <function>mysql_fetch_array</function>ì ì ì¬íë, + ë°°ì´ ëì ê°ì²´ë¡ ì»ëë¤ë ì°¨ì´ì ì´ ìë¤. + ë¤ìë§í´, ì¤íì (offset)ì ìí´ìê° ìë íëì´ë¦ì¼ë¡ + ë°ì´í°ë¥¼ ì ê·¼í ì ìë¤ë ê²ì´ë¤. + </para> + <para> + ëë²ì§¸ ì¸ìì¸ <parameter>result_type</parameter>ìë + ììê° ì¤ë©°, MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH ê°ì ê°ì§ ì ìë¤. + </para> + <para> + ìëë©´ìì, ì´ í¨ìë <function>mysql_fetch_array</function>ì ë¹ì·íê³ , + <function>mysql_fetch_row</function>ë§í¼ì´ë ë¹ ë¥´ë¤. ê·¸ë¬ë í° ì°¨ì´ë ìë¤. <example> - <title><function>mysql_fetch_object</function> example</title> - <programlisting role="php"> + <title> + <function>mysql_fetch_object</function> ìì </title> + <programlisting role="php"> <?php mysql_connect ($host, $user, $password); $result = mysql_db_query ("database", "select * from table"); @@ -945,123 +911,123 @@ mysql_free_result ($result); ?> </programlisting> - </example> - </para> - <para> + </example> + </para> + <para> See also: <function>mysql_fetch_array</function> and <function>mysql_fetch_row</function>. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-fetch-row"> - <refnamediv> - <refname>mysql_fetch_row</refname> - <refpurpose>Get a result row as an enumerated array</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>array <function>mysql_fetch_row</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: An array that corresponds to the fetched row, or false - if there are no more rows. - </para> - <para> - <function>mysql_fetch_row</function> 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. - </para> - <para> - Subsequent call to <function>mysql_fetch_row</function> would - return the next row in the result set, or false if there are no - more rows. + </refsect1> + </refentry> + <refentry id="function.mysql-fetch-row"> + <refnamediv> + <refname>mysql_fetch_row</refname> + <refpurpose>결과를 ì«ììì¸ì¼ë¡ ë ë°°ì´ë¡ ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>array <function>mysql_fetch_row</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: í(row)ì ëìëë ê°ì²´ë¡ ëë ¤ì£¼ê³ , ê°ì ¸ì¬ ê°ì´ ìì ê²½ì° false를 ë°ííë¤. + </para> + <para> + <function>mysql_fetch_row</function>ë í¹ì result identifierë¡ë¶í° + í íì ë°ì´í°ë¥¼ ê°ì ¸ì¤ë©°, ë°°ì´ë¡ ì»ì ì ìë¤. ê° ê²°ê³¼ ì´(column)ì + 0ë¶í° ììíë ì«ììì¸ì¼ë¡ ì ì¥ëë¤. + </para> + <para> + <function>mysql_fetch_row</function>를 ì¤ííë©´, ë¤ì í ë°ì´í°ë¥¼ ëë ¤ì£¼ë©°, + ê°ì ¸ì¬ íì´ ìì ê²½ì° false를 ë°ííë¤. </para> - <para> - See also: <function>mysql_fetch_array</function>, + <para> + 참조: <function>mysql_fetch_array</function>, <function>mysql_fetch_object</function>, <function>mysql_data_seek</function>, - <function>mysql_fetch_lengths</function>, and + <function>mysql_fetch_lengths</function>, <function>mysql_result</function>. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-flags"> - <refnamediv> - <refname>mysql_field_flags</refname> - <refpurpose> - Get the flags associated with the specified field in a result + </refsect1> + </refentry> + <refentry id="function.mysql-field-flags"> + <refnamediv> + <refname>mysql_field_flags</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° í¹ì íë(field)ì ìíì ë³´(flag)를 ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_flags</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_flags</function> 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 <function>explode</function>. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_flags</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_flags</function>ì í¹ì íëì ìíì 보를 ë°ííë¤. + ìíì ë³´ë íê°ì 공백ì¼ë¡ 구ë¶ë ë¨ì¼ ë¨ì´ë¡ ì¶ë ¥ëë©°, + ì´ ê°ì <function>explode</function>ì ìí´ ëë ì ë³¼ ì ìë¤. </para> - <para>The following flags are reported, if your version of MySQL - is current enough to support them: "not_null", "primary_key", + <para> + ì¬ì©ì¤ì¸ MySQL ë²ì ì´ "not_null", "primary_key", "unique_key", "multiple_key", "blob", "unsigned", "zerofill", - "binary", "enum", "auto_increment", "timestamp". + "binary", "enum", "auto_increment", "timestamp"를 ì§ìíë¤ë©´, + íë ìíì ë³´ì ë°ë¼ ìì ë¨ì´ë¤ì´ ì¶ë ¥ë ê²ì´ë¤. </para> - <para> - For downward compatibility <function>mysql_fieldflags</function> - can also be used. + <para> + <function>mysql_fieldflags</function>ì íì í¸íì±ì´ ìë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-name"> - <refnamediv> - <refname>mysql_field_name</refname> - <refpurpose> - Get the name of the specified field in a result + </refsect1> + </refentry> + <refentry id="function.mysql-field-name"> + <refnamediv> + <refname>mysql_field_name</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° í¹ì íë ì´ë¦ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_name</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_index</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_name</function> returns the name of the - specified field index. <parameter>result</parameter> must be a - valid result identifier and <parameter>field_index</parameter> is - the numerical offset of the field. - </para> - <note> - <para> - <parameter>field_index</parameter> starts at 0. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_name</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_index</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_name</function>ì í¹ì íë ìì¸ê°ì ì»ëë¤. + <parameter>result</parameter>ë result identifierë ì í¨í ê²°ê³¼ê°ì´ì´ì¼ íê³ , + <parameter>field_index</parameter>ë íëì ì«ì ì¤íì (offset)ì´ì´ì¼ íë¤. + </para> + <note> + <para> + <parameter>field_index</parameter>ë 0ë¶í° ììíë ê°ì´ë¤. </para> - <para> - e.g. The index of the third field would actually be 2, the index - of the fourth field would be 3 and so on. + <para> + ì를ë¤ì´, ì¸ë²ì§¸ íëì ìì¸ì 2ì´ê³ , ë¤ë²ì§¸ íëì ìì¸ì 3ì´ ëë¤. </para> - </note> - <para> - <example> - <title><function>mysql_field_name</function> example</title> - <programlisting role="php"> -// The users table consists of three fields: + </note> + <para> + <example> + <title> + <function>mysql_field_name</function> example</title> + <programlisting role="php"> +// í ì´ë¸ì´ ì¸ê°ì íëë¡ ìëì ê°ì´ ì¸ê°ì íëë¡ ì´ë£¨ì´ì ¸ ìì ë: // user_id // username // password. @@ -1071,132 +1037,134 @@ echo mysql_field_name($res, 0) . "\n"; echo mysql_field_name($res, 2); </programlisting> - </example> - </para> - <para> - The above example would produce the following output: + </example> + </para> + <para> + ìì ìì ë ìëì ê°ì´ ì¶ë ¥ë ê²ì´ë¤: <informalexample> - <programlisting> + <programlisting> user_id password </programlisting> - </informalexample> - </para> - <para> - For downwards compatibility <function>mysql_fieldname</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-len"> - <refnamediv> - <refname>mysql_field_len</refname> - <refpurpose> - Returns the length of the specified field + </informalexample> + </para> + <para> + <function>mysql_fieldname</function>ì íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-len"> + <refnamediv> + <refname>mysql_field_len</refname> + <refpurpose> + í¹ì íëì 길ì´ë¥¼ ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_field_len</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_len</function> returns the length of the - specified field. - </para> - <para> - For downward compatibility <function>mysql_fieldlen</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-seek"> - <refnamediv> - <refname>mysql_field_seek</refname> - <refpurpose> - Set result pointer to a specified field offset + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_field_len</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_len</function>ì í¹ì íëì 길ì´ë¥¼ ì»ëë¤. + </para> + <para> + <function>mysql_fieldlen</function>ë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-seek"> + <refnamediv> + <refname>mysql_field_seek</refname> + <refpurpose> + í¹ì íëì ì¤íì (offset)ì¼ë¡ ìì¹(pointer)를 ì´ë </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_field_seek</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Seeks to the specified field offset. If the next call to - <function>mysql_fetch_field</function> doesn't include a field - offset, the field offset specified in - <function>mysql_field_seek</function> will be returned. - </para> - <para> - See also: <function>mysql_fetch_field</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-table"> - <refnamediv> - <refname>mysql_field_table</refname> - <refpurpose> - Get name of the table the specified field is in + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_field_seek</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + í¹ì íë ì¤íì ì ê²ìíëë° ì¬ì©ëë¤. + <function>mysql_fetch_field</function>ì ì¤ííë©´ì íë ì¤íì ì ì¤ì íì§ ìì¼ë©´, + <function>mysql_field_seek</function>ì´ ëë ¤ì¤ ê°ì¼ë¡ ì§ì ëë¤. + </para> + <para> + 참조: <function>mysql_fetch_field</function>. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-table"> + <refnamediv> + <refname>mysql_field_table</refname> + <refpurpose> + í¹ì íëê° ìí í ì´ë¸ ì´ë¦ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_table</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns the name of the table that the specifed field is - in. - </para> - <para> - For downward compatibility <function>mysql_fieldtable</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-type"> - <refnamediv> - <refname>mysql_field_type</refname> - <refpurpose> - Get the type of the specified field in a result + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_table</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + í¹ì íëê° ìí í ì´ë¸ ì´ë¦ì ì»ëë¤. + </para> + <para> + <function>mysql_fieldtable</function>ê³¼ íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-type"> + <refnamediv> + <refname>mysql_field_type</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° í¹ì íëì íì ì ë³´(type)ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_type</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_type</function> is similar to the - <function>mysql_field_name</function> 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 <ulink url="&url.mysql.docs;">MySQL - documentation</ulink>. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_type</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_type</function>ë + <function>mysql_field_name</function> í¨ìì + ì¬ì©ììê² ëë ¤ì£¼ë ê°ì ííììë ë¹ì·íë¤. + ê·¸ë¬ë, íëíì ì "int", "real", "string", "blob" ë±ê³¼ ê°ì + ë¨ì´ë¡ ë°ííë¤ë ê²ì´ ë¤ë¥´ë¤. íëíì ì ë ìì¸í ì¢ ë¥ë¥¼ ë³´ë ¤ë©´ + <ulink url="&url.mysql.docs;">MySQL 문ì</ulink>를 ë³´ë©´ ëë¤. <example> - <title>mysql field types</title> - <programlisting role="php"> + <title>mysql field types</title> + <programlisting role="php"> <?php mysql_connect ("localhost:3306"); @@ -1220,129 +1188,123 @@ ?> </programlisting> - </example> - </para> - <para> - For downward compatibility <function>mysql_fieldtype</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-free-result"> - <refnamediv> - <refname>mysql_free_result</refname> - <refpurpose>Free result memory</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_free_result</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_free_result</function> will free all memory - associated with the result identifier <parameter>result</parameter>. - </para> - <para> - <function>mysql_free_result</function> 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. - </para> - <para> - For downward compatibility <function>mysql_freeresult</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-insert-id"> - <refnamediv> - <refname>mysql_insert_id</refname> - <refpurpose> - Get the id generated from the previous INSERT operation + </example> + </para> + <para> + <function>mysql_fieldtype</function>ê³¼ íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-free-result"> + <refnamediv> + <refname>mysql_free_result</refname> + <refpurpose>Free result memory</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_free_result</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_free_result</function>ë +<parameter>result</parameter>ì ëí ë©ëª¨ë¦¬(memory)ì ìë +ë´ì©ì 모ë ì ê±°íë¤. + </para> + <para> + <function>mysql_free_result</function>ë ê²°ê³¼ë¡ë¶í° ì»ì ì§ì ê°ì´ +커ì ë§ì ë©ëª¨ë¦¬ë¥¼ ì¬ì©í ì¼ë ¤ê° ìì ë ì¬ì©ëë¤. +ê·¸ë¬ë, ì¤í¬ë¦½í¸(script) ì¤íë¶ ë§ì§ë§ìë ìëì ì¼ë¡ ê²°ê³¼ì ê´ë ¨ë ë©ëª¨ë¦¬ë ì§ìì§ë¤. + </para> + <para> + <function>mysql_freeresult</function>ìë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-insert-id"> + <refnamediv> + <refname>mysql_insert_id</refname> + <refpurpose> + ìµê·¼ INSERT ìì ì¼ë¡ë¶í° ìì±ë identifier ê°ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_insert_id</function></funcdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_insert_id</function> returns the ID generated for - an AUTO_INCREMENT column by the previous INSERT query using the - given <parameter>link_identifier</parameter>. If - <parameter>link_identifier</parameter> isn't specified, the last - opened link is assumed. - </para> - <para> - <function>mysql_insert_id</function> 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. - </para> - <note> - <para> - The value of the MySQL SQL function - <literal>LAST_INSERT_ID()</literal> always contains the most - recently generated AUTO_INCREMENT value, and is not reset - between queries. - </para> - </note> - <warning> - <para> - <function>mysql_insert_id</function> converts the return type of - the native MySQL C API function - <literal>mysql_insert_id()</literal> to a type of - <literal>long</literal>. If your AUTO_INCREMENT column has - a column type of BIGINT, the value returned by - <function>mysql_insert_id</function> will be incorrect. - Instead, use the internal MySQL SQL function - <literal>LAST_INSERT_ID()</literal>. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_insert_id</function> + </funcdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_insert_id</function>ë + <parameter>link_identifier</parameter>를 ì¬ì©íë©´, INSERT ì§ìë¡ í(row)를 ì¶ê°í ë¤ + AUTO_INCREMENTë¡ ìì±ë 컬ë¼ì ì¶ê°ë ê°ì ì»ì ì ìë¤. + <parameter>link_identifier</parameter>를 ì§ì íì§ ìì¼ë©´ ë§ì§ë§ì ì´ë ¤ì§ ë§í¬(link)를 + ì¬ì©íë¤. + </para> + <para> + <function>mysql_insert_id</function>ë ì´ì ì§ìê° AUTO_INCREMENTê°ì¼ë¡ + ìì±ëì§ ìì¼ë©´, 0ì ë°ííë¤. + ë§ì§ë§ì¼ë¡ ì ì¥ë ê°ì´ íìíë¤ë©´, ì§ìë¡ ê°ì ì¶ê°í ì§í mysql_insert_id()를 ì¬ì©íë©´ ëë¤. + </para> + <note> + <para> + <literal>LAST_INSERT_ID()</literal>ë +AUTO_INCREMENT ê°ì¼ë¡ ìì±ë ê°ì¥ ìµê·¼ ê°ì´ ë³´ê´ëë©° ì§ì ì¬ì´ìë ìì´ì§ì§ ìëë¤. + </para> + </note> + <warning> + <para> + <function>mysql_insert_id</function>ë MySQL C API ë´ì¥ í¨ìì¸ + <literal>mysql_insert_id()</literal>ë¡ë¶í° <literal>long</literal> íì ì¼ë¡ ë³ííë¤. + ë§ì¼, AUTO_INCREMENT ì´(column)ì íì ì´ BIGINTë¼ë©´, + <function>mysql_insert_id</function>ì ë¶ì íí ê°ì ë°íí ê²ì´ë¤. ê·¸ëì , ë´ë¶ MySQL í¨ìì¸ + <literal>LAST_INSERT_ID()</literal>를 ì¬ì©íë©´ ëë¤. </para> - </warning> - </refsect1> - </refentry> - - <refentry id="function.mysql-list-dbs"> - <refnamediv> - <refname>mysql_list_dbs</refname> - <refpurpose> - List databases available on a MySQL server + </warning> + </refsect1> + </refentry> + <refentry id="function.mysql-list-dbs"> + <refnamediv> + <refname>mysql_list_dbs</refname> + <refpurpose> + MySQL ìë²ì ìë ë°ì´í°ë² ì´ì¤ ì´ë¦ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_list_dbs</function></funcdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_list_dbs</function> will return a result pointer - containing the databases available from the current mysql - daemon. Use the <function>mysql_tablename</function> function to + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_list_dbs</function> + </funcdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_list_dbs</function>ë íì¬ MySQL ë°ëª¬(daemon)ì¼ë¡ë¶í° + ì¬ì©ê°ë¥í ë°ì´í°ë² ì´ì¤ë¥¼ í¬í¨í ê²°ê³¼ í¬ì¸í°ë¡ ë°íí ê²ì´ë¤. + Use the <function>mysql_tablename</function> function to traverse this result pointer. </para> - <para> - <example> - <title><function>mysql_list_dbs</function> example</title> - <programlisting role="php"> + <para> + <example> + <title> + <function>mysql_list_dbs</function> ìì </title> + <programlisting role="php"> $link = mysql_connect('localhost', 'myname', 'secret'); $db_list = mysql_list_dbs($link); @@ -1350,187 +1312,183 @@ echo $row->Database . "\n"; } </programlisting> - </example> - </para> - <para> - The above example would produce the following output: + </example> + </para> + <para> + ìì ì ê²°ê³¼ë ìëì ê°ë¤: <informalexample> - <programlisting> + <programlisting> database1 database2 database3 ... </programlisting> - </informalexample> - </para> - <note> - <para> - The above code would just as easily work with - <function>mysql_fetch_row</function> or other similar functions. + </informalexample> + </para> + <note> + <para> + ì ì½ëë <function>mysql_fetch_row</function>ë ì´ì ì ì¬í í¨ì를 ì¬ì©í ìë ìë¤. </para> - </note> - <para> - For downward compatibility <function>mysql_listdbs</function> can - also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-list-fields"> - <refnamediv> - <refname>mysql_list_fields</refname> - <refpurpose>List MySQL result fields</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_list_fields</function></funcdef> - <paramdef>string <parameter>database_name</parameter></paramdef> - <paramdef>string <parameter>table_name</parameter></paramdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_list_fields</function> 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 <function>mysql_field_flags</function>, + </note> + <para> + <function>mysql_listdbs</function>ë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-list-fields"> + <refnamediv> + <refname>mysql_list_fields</refname> + <refpurpose>MySQL ê²°ê³¼ì íë 리ì¤í¸ë¥¼ ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_list_fields</function> + </funcdef> + <paramdef>string <parameter>database_name</parameter> + </paramdef> + <paramdef>string <parameter>table_name</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_list_fields</function>ë 주ì´ì§ í ì´ë¸ ì´ë¦ì¼ë¡ë¶í° ì 보를 ê°ì ¸ì¨ë¤. + ì´ í¨ìë ë°ì´í°ë² ì´ì¤ ì´ë¦ê³¼ í ì´ë¸ ì´ë¦ì ì¸ì(argument)ë¡ ê°ëë¤. + ê·¸ë¦¬ê³ ì´ í¨ìë <function>mysql_field_flags</function>, <function>mysql_field_len</function>, - <function>mysql_field_name</function>, and - <function>mysql_field_type</function>. - </para> - <para> - A result identifier is a positive integer. The function returns - -1 if a error occurs. A string describing the error will be - placed in <literal>$phperrmsg</literal>, and unless the function - was called as <literal>@mysql()</literal> then this error string - will also be printed out. - </para> - <para> - <example> - <title><function>mysql_list_fields</function> example</title> - <programlisting role="php"> + <function>mysql_field_name</function>, + <function>mysql_field_type</function> ë±ì ì¬ì©í ì ìëë¡ + ê²°ê³¼ í¬ì¸í°ë¥¼ ë°ííë¤. + </para> + <para> + ê²°ê³¼ identifierë ìì ì ìì´ë©°, ìë¬ê° ë°ìíë©´ -1 ê°ì´ ë°íëë¤. + ìë¬ ë©ìì§ë <literal>$phperrmsg</literal>ì ì ì¥ë ê²ì´ë©°, + <literal>@mysql()</literal>ê³¼ ê°ì´ í¸ì¶íì§ ìëí íì íë©´ì + ìë¬ ë©ìì§ê° ì¶ë ¥ë ê²ì´ë¤. + </para> + <para> + <example> + <title> + <function>mysql_list_fields</function> ìì </title> + <programlisting role="php"> $link = mysql_connect('localhost', 'myname', 'secret'); $fields = mysql_list_fields("database1", "table1", $link); $columns = mysql_num_fields($fields); -for ($i = 0; $i < $columns; $i++) { +for ($i = 0; $i < $columns; $i++) { echo mysql_field_name($fields, $i) . "\n";; } </programlisting> - </example> - </para> - <para> - The above example would produce the following output: + </example> + </para> + <para> + ìì ìì ë ë¤ìê³¼ ê°ì´ ì¶ë ¥ë ê²ì´ë¤: <informalexample> - <programlisting> + <programlisting> field1 field2 field3 ... </programlisting> - </informalexample> + </informalexample> + </para> + <para> + <function>mysql_listfields</function>ë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-list-tables"> + <refnamediv> + <refname>mysql_list_tables</refname> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ì ìë í ì´ë¸ 목ë¡ì ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_list_tables</function> + </funcdef> + <paramdef>string <parameter>database</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_list_tables</function> ì§ì ë ë°ì´í°ë² ì´ì¤ ì´ë¦ì¼ë¡ +ê²°ê³¼ê°ì ì»ê³ <function>mysql_db_query</function>ë±ì í¨ìì ì¬ì©ëë ê²°ê³¼ í¬ì¸í°ë¥¼ ë°ííë¤. +<function>mysql_tablename</function> í¨ìë ê²°ê³¼ í¬ì¸í°ë¡ë¶í° ì¤ì í ì´ë¸ ì´ë¦ì ì¶ì¶íëë° ì¬ì©íë¤. + </para> + <para> +íì í¸íì±ì ê°ì§ë <function>mysql_listtables</function> í¨ì ìì ì¬ì© ê°ë¥íë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-num-fields"> + <refnamediv> + <refname>mysql_num_fields</refname> + <refpurpose>ê²°ê³¼ë¡ë¶í° íë ê°ì를 ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_num_fields</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_num_fields</function> í¨ìë ê²°ê³¼ì ì¼ë¡ë¶í° íë ê°ì를 ë°ííë¤. </para> - <para> - For downward compatibility <function>mysql_listfields</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-list-tables"> - <refnamediv> - <refname>mysql_list_tables</refname> - <refpurpose>List tables in a MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_list_tables</function></funcdef> - <paramdef>string <parameter>database</parameter></paramdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_list_tables</function> takes a database name and - returns a result pointer much like the - <function>mysql_db_query</function> function. The - <function>mysql_tablename</function> function should be used to - extract the actual table names from the result pointer. - </para> - <para> - For downward compatibility <function>mysql_listtables</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-num-fields"> - <refnamediv> - <refname>mysql_num_fields</refname> - <refpurpose>Get number of fields in result</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_num_fields</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_num_fields</function> returns the number of - fields in a result set. - </para> - <para> - See also: + <para> + 참조: <function>mysql_db_query</function>, <function>mysql_query</function>, <function>mysql_fetch_field</function>, <function>mysql_num_rows</function>.</para> - <para> - For downward compatibility <function>mysql_numfields</function> - can also be used. + <para> +íì í¸íì±ì ê°ì§ë <function>mysql_numfields</function> í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-num-rows"> - <refnamediv> - <refname>mysql_num_rows</refname> - <refpurpose>Get number of rows in result</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_num_rows</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_num_rows</function> 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, use <function>mysql_affected_rows</function>. + </refsect1> + </refentry> + <refentry id="function.mysql-num-rows"> + <refnamediv> + <refname>mysql_num_rows</refname> + <refpurpose>ê²°ê³¼ë¡ë¶í° ì´ ê°ì를 ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_num_rows</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_num_rows</function> í¨ìë ê²°ê³¼ì ì¼ë¡ë¶í° ì´ì ê°ì를 ë°ííë¤. +ì´ í¨ìë SELECTì ìì ë°íë ê²°ê³¼ì ë§ ì¬ì©ì´ ê°ë¥íë¤. +INSERT, UPDATE, DELETEë¡ë¶í° ì´ì ê°ì를 ì»ì¼ë ¤ë©´ <function>mysql_affected_rows</function>를 ì¬ì©íë©´ ëë¤. <example> - <title> - <function> - mysql_num_rows example by crubel@trilizio.org + <title> + <function> + mysql_num_rows ìì (crubel@trilizio.org ì ê³µ) </function> - </title> - <programlisting role="php"> + </title> + <programlisting role="php"> <?php $conn = mysql_connect("hostaddress", "username", "password"); mysql_select_db("database",$conn); // needed if you have m,ultiple db's @@ -1539,313 +1497,293 @@ echo "$NumMembers Members"; ?> </programlisting> - </example> - </para> - <para> - See also: + </example> + </para> + <para> + 참조: <function>mysql_db_query</function>, <function>mysql_query</function> and, <function>mysql_fetch_row</function>. </para> - <para> - For downward compatibility <function>mysql_numrows</function> can - also be used. + <para> +íì í¸íì±ì ê°ì§ë <function>mysql_numrows</function> í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-pconnect"> - <refnamediv> - <refname>mysql_pconnect</refname> - <refpurpose> - Open a persistent connection to a MySQL Server + </refsect1> + </refentry> + <refentry id="function.mysql-pconnect"> + <refnamediv> + <refname>mysql_pconnect</refname> + <refpurpose> + MySQL ìë²ì ì구ì ì¸ ë°ì´í°ë² ì´ì¤ ì ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_pconnect</function></funcdef> - <paramdef>string + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_pconnect</function> + </funcdef> + <paramdef>string <parameter> - <optional>hostname - <optional>:port</optional> - <optional>:/path/to/socket</optional> - </optional> - </parameter> - </paramdef> - <paramdef>string - <parameter><optional>username</optional></parameter> - </paramdef> - <paramdef>string - <parameter><optional>password</optional></parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: A positive MySQL persistent link identifier on success, - or false on error. - </para> - <para> - <function>mysql_pconnect</function> establishes a connection - to a MySQL server. The following defaults are assumed for - missing optional parameters: <parameter>host:port</parameter> = - 'localhost:3306', <parameter>username</parameter> = name of the - user that owns the server process and - <parameter>password</parameter> = empty password. - </para> - <para> - 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. + <optional>hostname + <optional>:port</optional> + <optional>:/path/to/socket</optional> + </optional> + </parameter> + </paramdef> + <paramdef>string + <parameter> + <optional>username</optional> + </parameter> + </paramdef> + <paramdef>string + <parameter> + <optional>password</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: ì ìì ì±ê³µíë©´ MySQL ì구ì link identifier를 ë°ííê³ , ì¤í¨íë©´ ìë¬ë¥¼ ì¶ë ¥. + </para> + <para> + <function>mysql_pconnect</function>ë MySQL ìë²ë¡ë¶í° ì ìì ì¤ì íë í¨ìì´ë¤. +ë¤ì 기본 ì¤ì ê°ì ìµì íë¼ë¯¸í°ë¥¼ ì¤ì íì§ ìì¼ë©´ ì¬ì©ëë¤: <parameter>host:port</parameter> = + 'localhost:3306', <parameter>username</parameter> = ìë² íë¡ì¸ì ìì ì, + <parameter>password</parameter> = 공백 ë¹ë°ë²í¸. + </para> + <para> +í¸ì¤í¸ëª ì í¬í¸ ë²í¸ë¥¼ í¬í¨ ê°ë¥íë¤. "hostname:port"ë ":/path/to/socket"ì + ê°ì´ ë¡ì»¬í¸ì¤í¸ì ìì¼ ê²½ë¡ ííë¡ ì¬ì©ì´ ê°ë¥íë¤. <note> - <para> - Support for ":port" wass added in 3.0B4. + <para> +":port"ë 3.0B4 ë²ì ë¶í° ì¬ì©ì´ ê°ë¥íë¤. </para> - <para> - Support for the ":/path/to/socket" was added in - 3.0.10. + <para> +":/path/to/socket"ë 3.0.10 ë²ì ë¶í° ì¬ì©ì´ ê°ë¥íë¤. </para> - </note> - </para> - <para> - <function>mysql_pconnect</function> acts very much like - <function>mysql_connect</function> with two major differences. - </para> - <para> - 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. - </para> - <para> - 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 (<function>mysql_close</function> will not - close links established by <function>mysql_pconnect</function>). - </para> - <para> - This type of links is therefore called 'persistent'. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-query"> - <refnamediv> - <refname>mysql_query</refname> - <refpurpose>Send a MySQL query</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_query</function></funcdef> - <paramdef>string <parameter>query</parameter></paramdef> - <paramdef>int - <parameter><optional>link_identifier</optional></parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_query</function> sends a query to the currently - active database on the server that's associated with the - specified link identifier. If - <parameter>link_identifier</parameter> isn't specified, the last - opened link is assumed. If no link is open, the function tries - to establish a link as if <function>mysql_connect</function> was - called with no arguments, and use it. - </para> - <note> - <para> - The query string should not end with a semicolon. + </note> + </para> + <para> + <function>mysql_pconnect</function>ì <function>mysql_connect</function>ê³¼ í¬ê² ëê°ì§ ë¶ë¶ìì ë¤ë¥´ë¤. + </para> + <para> +첫째, ì ìí ë, í¨ìë ëì¼í í¸ì¤í¸ì ì¬ì©ìì´ë¦, ë¹ë°ë²í¸ë¡ ì´ë¯¸ ì´ë ¤ì§ ì구ì ì ìë ë§í¬ê° ìëì§ ì°¾ì본ë¤. +ë§ì¼ ì°¾ê²ëë©´, ìë¡ì ì ìì ì¬ë ëì ì°¾ì ë§í¬ì identifier를 ë°ííë¤. + </para> + <para> +ë째, SQL ìë²ë¡ ì ìì ì¤í¬ë¦½í¸ ì¤íì´ ëëë ê³ì ì ì§ê° ëë©°, ì´íìë ì¬ì©ì´ ê°ë¥íë¤. +(주ì: <function>mysql_pconnect</function>ë¡ ì´ë ¤ì§ ë§í¬ë <function>mysql_close</function>í¨ìë¡ ë«ì§ë 못íë¤.) + </para> + <para> +ê·¸ë¬ë¯ë¡, ì´ ííì ë§í¬ë¥¼ 'ì구ì (persistent)'ì¼ë¡ ë¶ë¥¸ë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-query"> + <refnamediv> + <refname>mysql_query</refname> + <refpurpose>Send a MySQL query</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_query</function> + </funcdef> + <paramdef>string <parameter>query</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_query</function>ë íì¬ ìë²ìì ëìì¤ì¸ ë°ì´í°ë² ì´ì¤ë¡ë¶í° + í¹ì link identifierë¡ ì§ì를 ì ì¡íë¤. +ë§ì¼, <parameter>link_identifier</parameter>를 ì¤ì íì§ ìì¼ë©´ ê°ì¥ ìµê·¼ì ì´ë ¤ì§ link를 ì¬ì©íê² ëë¤. +ì´ë ¤ì§ linkê° ìì¼ë©´, ìµì ì¸ì ìì´ ì¤íë <function>mysql_connect</function>í¨ìì²ë¼ +link를 ìì±íì¬ ì¬ì©íë¤. + </para> + <note> + <para> +ì§ìì ì°ì´ë 문ìì´ ë§ì§ë§ì ì¸ë¯¸ì½ë¡ (;)를 ë¶ì´ë©´ ìëë¤. </para> - </note> - <para> - <function>mysql_query</function> 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. + </note> + <para> + <function>mysql_query</function>í¨ìë ì§ì ì±ê³µ ì¬ë¶ì ë°ë¼ TRUE(0ì´ ìëê°) ëë FALSE를 ë°ííë¤. +ìë²ë¡ë¶í° ì¤íë ì§ìê° ì¤íëê³ ê·¸ ì§ì ë´ì©ì 문ì ê° ìì´ì¼ë§, TRUEê°ì ë°ííë¤. +ì´ ë°í ê°ì ì§ìì í´ë¹íë ì´ ê°ì ë±ê³¼ë ê´ë ¨ì´ ìë¤. </para> - <para> - The following query is syntactically invalid, so - <function>mysql_query</function> fails and returns FALSE: + <para> +ë¤ì ì§ìë í린 문ì¥ì´ê¸° ë문ì <function>mysql_query</function>ë ì¤í¨íë©°, FALSEê°ì ë°ííë¤: <example> - <title><function>mysql_query</function></title> - <programlisting role="php"> + <title> + <function>mysql_query</function> + </title> + <programlisting role="php"> <?php $result = mysql_query ("SELECT * WHERE 1=1") - or die ("Invalid query"); + or die ("ì못ë ì§ì를 ì¤ííìµëë¤!!"); ?> </programlisting> - </example> - </para> - <para> - The following query is semantically invalid if - <literal>my_col</literal> is not a column in the table - <literal>my_tbl</literal>, so <function>mysql_query</function> - fails and returns FALSE: + </example> + </para> + <para> + ë¤ì ì§ìë 문ë²ì ë§ì§ë§ ì¤ì ë¡ í ì´ë¸ <literal>my_tbl</literal>ì + í <literal>my_col</literal>ì´ ì기 ë문ì + <function>mysql_query</function>í¨ìë ì¤í¨íë©°, FALSEê°ì ë°ííë¤: <example> - <title><function>mysql_query</function></title> - <programlisting role="php"> + <title> + <function>mysql_query</function> + </title> + <programlisting role="php"> <?php $result = mysql_query ("SELECT my_col FROM my_tbl") - or die ("Invalid query"); + or die ("ì못ë ì§ì를 ì¤ííìµëë¤!!"); ?> </programlisting> - </example> - </para> - <para> - <function>mysql_query</function> will also fail and return FALSE - if you don't have permission to access the table(s) referenced by - the query. - </para> - <para> - Assuming the query succeeds, you can call - <function>mysql_num_rows</function> to find out how many rows - were returned for a SELECT statment or - <function>mysql_affected_rows</function> to find out how many - rows were affected by a DELETE, INSERT, REPLACE, or UPDATE - statement. - </para> - <para> - For SELECT statements, <function>mysql_query</function> returns a - new result identifier that you can pass to - <function>mysql_result</function>. When you are done with the - result set, you can free the resources associated with it by - calling <function>mysql_free_result</function>. Although, the - memory will automatically be freed at the end of the script's - execution. + </example> + </para> + <para> + <function>mysql_query</function>ë ì§ìë¡ ì°¸ì¡°ëë í ì´ë¸ì ëí ì ê·¼ ê¶íì´ ìë¤ë©´ ì¤í¨íë©°, FALSEê°ì ë°ííë¤. + </para> + <para> +ì§ìê° ì±ê³µíë©´ <function>mysql_num_rows</function>í¨ì를 ì¬ì©íì¬ SELECT문ì¼ë¡ ë°íëë íì ê°ì를 ì»ì ì ìì¼ë©°, +<function>mysql_affected_rows</function>í¨ì를 ì¬ì©íë©´, DELETE, INSERT, REPLACE, UPDATEë¡ ì ì©ë íì ê°ì를 ì»ì ì ìë¤. + </para> + <para> +SELECT문ì ìí´ <function>mysql_query</function>í¨ìë +<function>mysql_result</function>í¨ììì ì¬ì©í ì ìë ìë¡ì´ result identifier를 ë°ííë¤. +ê²°ê³¼ì ì ì¬ì©í í, <function>mysql_free_result</function>í¨ì를 ì¬ì©íì¬ ë©ëª¨ë¦¬ìì ì ê±°í ì ìë¤. +ê·¸ë¬ë, ì¤í¬ë¦½í¸ê° ì¢ ë£ëë ìì ì ìëì ì¼ë¡ ë©ëª¨ë¦¬ìì ì ê±°ê° ëë¤. </para> - <para> - See also: <function>mysql_affected_rows</function>, + <para> + 참조: <function>mysql_affected_rows</function>, <function>mysql_db_query</function>, <function>mysql_free_result</function>, <function>mysql_result</function>, - <function>mysql_select_db</function>, and + <function>mysql_select_db</function>, <function>mysql_connect</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-result"> - <refnamediv> - <refname>mysql_result</refname> - <refpurpose>Get result data</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>mixed <function>mysql_result</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>row</parameter></paramdef> - <paramdef>mixed - <parameter> - <optional>field</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_result</function> returns the contents of one - cell from a MySQL result set. The field argument can be the - field's offset, or the field's name, or the field's table dot - field's name (fieldname.tablename). If the column name has been - aliased ('select foo as bar from...'), use the alias instead of - the column name. </para> - <para> - When working on large result sets, you should consider using one - of the functions that fetch an entire row (specified below). As - these functions return the contents of multiple cells in one - function call, they're MUCH quicker than - <function>mysql_result</function>. Also, note that specifying a - numeric offset for the field argument is much quicker than - specifying a fieldname or tablename.fieldname argument. + </refsect1> + </refentry> + <refentry id="function.mysql-result"> + <refnamediv> + <refname>mysql_result</refname> + <refpurpose>ê²°ê³¼ ë°ì´í°ë¥¼ ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>mysql_result</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>row</parameter> + </paramdef> + <paramdef>mixed + <parameter> + <optional>field</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_result</function>í¨ìë MySQL ê²°ê³¼ì ì¼ë¡ë¶í° íê°ì ì (cell) ë´ì©ì ë°ííë¤. +field ì¸ë¡ë íë offset ëë íëì´ë¦, í ì´ë¸ì´ë¦ê³¼ íëì´ë¦ ì¬ì´ì ì (í ì´ë¸ì´ë¦.íëì´ë¦)ì¼ë¡ ì°ê²°ë ì¸ì를 ì¬ì©í ì ìë¤. +ë§ì½, ì´(column)ì´ë¦ì´ ë³ëª ('select foo as bar from...')ì¼ë¡ ëì´ ìë¤ë©´ ì´ì´ë¦ ëì ë³ëª (alias)를 ì¬ì©í´ì¼íë¤. + </para> + <para> +í° ê²°ê³¼ì ì¼ë¡ ìì í ê²½ì°, ì ì²´ íì ì»ì´ì¤ë í¨ìì¤ íë를 ì¬ì©íë ê²ì´ ì¢ì ê²ì´ë¤. +ì´ í¨ìë¤ì í ë²ì í¨ì í¸ì¶ë¡ ë¤ì¤ ì ì ë´ì©ì ì»ì ì ìë ì¥ì ì´ ìì¼ë©°, +<function>mysql_result</function>í¨ìë³´ë¤ ë ë¹ ë¥´ë¤. +ëí íë ì¸ìë¡ ì«ì offsetì ì¬ì©íë©´ íëì´ë¦ ëë í ì´ë¸ì´ë¦.íëì´ë¦ ì¸ì를 ì¬ì©í ê²ë³´ë¤ ë ë¹ ë¥´ë¤. </para> - <para> - Calls to <function>mysql_result</function> should not be mixed - with calls to other functions that deal with the result set. + <para> + <function>mysql_result</function>í¨ì를 ì¬ì©íë©´ì ê²°ê³¼ì ì ë¤ë¥¸ í¨ììì í¨ê» ì¬ì©í ì ìë¤. </para> - <para> - Recommended high-performance alternatives: + <para> +ì±ë¥ í¥ìì ìí´ <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function>, and - <function>mysql_fetch_object</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-select-db"> - <refnamediv> - <refname>mysql_select_db</refname> - <refpurpose>Select a MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_select_db</function></funcdef> - <paramdef>string <parameter>database_name</parameter></paramdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: true on success, false on error. + <function>mysql_fetch_array</function>, + <function>mysql_fetch_object</function>í¨ì를 ì¬ì©íë ê²ì´ ì¢ë¤. </para> - <para> - <function>mysql_select_db</function> sets the current active - database on the server that's associated with the specified link - identifier. If no link identifier is specified, the last opened - link is assumed. If no link is open, the function will try to - establish a link as if <function>mysql_connect</function> was - called, and use it. + </refsect1> + </refentry> + <refentry id="function.mysql-select-db"> + <refnamediv> + <refname>mysql_select_db</refname> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ë¥¼ ì í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_select_db</function> + </funcdef> + <paramdef>string <parameter>database_name</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: ì±ê³µíë©´ TRUEê°, ì¤í¨íë©´ ìë¬ë°ì. + </para> + <para> + <function>mysql_select_db</function>í¨ìë link identifierë¡ ì§ì ë ì°ê²°ì ì´ì©íì¬ + ì¬ì©ê°ë¥í ë°ì´í°ë² ì´ì¤ë¥¼ ì ííë¤. + link identifier를 ì§ì íì§ ìì¼ë©´ ìµê·¼ ì´ë ¤ì§ link를 ì¬ì©íë¤. + ë§ì½ ì´ë ¤ì§ linkê° ìë¤ë©´, + <function>mysql_connect</function>를 í¸ì¶íë©´ + <function>mysql_connect</function>í¨ìê° í¸ì¶ëë©° link를 ìì±íë©°, ì´ë¥¼ ì¬ì©íë¤. </para> - <para> - Every subsequent call to <function>mysql_query</function> will be - made on the active database. + <para> + Every subsequent call to <function>mysql_query</function> will be made on the active database. </para> - <para> See also: + <para>참조: <function>mysql_connect</function>, - <function>mysql_pconnect</function>, and + <function>mysql_pconnect</function>, <function>mysql_query</function>. </para> - <para> - For downward compatibility <function>mysql_selectdb</function> - can also be used. + <para> + íì í¸íì±ì ê°ì§ë <function>mysql_selectdb</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-tablename"> - <refnamediv> - <refname>mysql_tablename</refname> - <refpurpose>Get table name of field</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_tablename</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>i</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_tablename</function> takes a result pointer - returned by the <function>mysql_list_tables</function> function - as well as an integer index and returns the name of a table. The - <function>mysql_num_rows</function> function may be used to - determine the number of tables in the result pointer. + </refsect1> + </refentry> + <refentry id="function.mysql-tablename"> + <refnamediv> + <refname>mysql_tablename</refname> + <refpurpose>íëì í ì´ë¸ì´ë¦ì ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_tablename</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>i</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_tablename</function>í¨ìë ì¸ìë¡ +<function>mysql_list_tables</function>í¨ìë¡ ë°íëë ê²°ê³¼ í¬ì¸í°ì ëìì +í ì´ë¸ì´ë¦ì ë°ííê³ ì ìí ì¸ë±ì¤ë¥¼ ê°ì§ë¤. +<function>mysql_num_rows</function>í¨ìë ê²°ê³¼ í¬ì¸í°ìì í ì´ë¸ ê°ì를 ì»ëë° ì¬ì©ëë¤. <example> - <title><function>Mysql_tablename</function> Example</title> - <programlisting role="php"> + <title> + <function>Mysql_tablename</function> ìì </title> + <programlisting role="php"> <?php mysql_connect ("localhost:3306"); $result = mysql_list_tables ("wisconsin"); @@ -1857,13 +1795,11 @@ } ?> </programlisting> - </example> - </para> - </refsect1> - </refentry> - - </reference> - + </example> + </para> + </refsect1> + </refentry> +</reference> <!-- Keep this comment at the end of the file Local variables: mode: sgml @@ -1879,4 +1815,4 @@ sgml-local-catalogs:nil sgml-local-ecat-files:nil End: ---> +--> \ No newline at end of file
Index: phpdoc/kr/functions/mysql.xml diff -u phpdoc/kr/functions/mysql.xml:1.2 phpdoc/kr/functions/mysql.xml:1.3 --- phpdoc/kr/functions/mysql.xml:1.2 Fri Jan 12 06:16:40 2001 +++ phpdoc/kr/functions/mysql.xml Tue Jan 23 06:00:03 2001 @@ -1,28 +1,25 @@ - <reference id="ref.mysql"> - <title>MySQL functions</title> + <reference id="ref.mysql"> + <title>MySQL í¨ì</title> <titleabbrev>MySQL</titleabbrev> <partintro> <simpara> - 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 role="configure">--with-mysql</option> 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: + ìë í¨ìë¤ì MySQL ë°ì´í°ë² ì´ì¤ ìë²ì ì ê·¼í ì ìê² í´ì¤ë¤. + ì´ë¤ í¨ì를 ì¬ì©íë ¤ë©´ <option role="configure">--with-mysql</option> + ìµì ì¼ë¡ MySQLê³¼ í¨ê» PHP를 ì»´íì¼í´ì¼ íë¤. + ë§ì¼ ì ìµì ì MySQLì´ ì¤ì¹ë ê²½ë¡ ìì´ ì¬ì©íë¤ë©´ + PHPë ë´ì¥ë í´ë¼ì´ì¸í¸ ë¼ì´ë¸ë¬ë¦¬ë¥¼ ëì ì¬ì©í ê²ì´ë¤. + ìë¡ ë¤ë¥¸ ì´í리ì¼ì´ì ì ì´ì©íë ì¬ì©ìë¤ì´ MySQLì + ì¬ì©íë ¤ í ë(ì를ë¤ì´, PHP3ì PHP4ê° ëìì apache 모ëë¡ì¨ ëìê°ê±°ë, + auth-mysqlì¼ ê²½ì°) MySQL ê²½ë¡ë¥¼ ë°ëì ë¤ìê³¼ ê°ì´ ì¤ì í´ì¼ íë¤: <option role="configure">--with-mysql=/path/to/mysql</option>. - This will force php to use the client libraries installed by - mysql, avoiding any conflicts. + ì ìµì ì phpê° mysqlì ìí´ ì¤ì¹ë í´ë¼ì´ì¸í¸ ë¼ì´ë¸ë¬ë¦¬ë¥¼ ì¬ì©íëë¡ + íë©°, ì´ë í ì¶©ëë í¼í ì ìê² í´ì¤ë¤. </simpara> <simpara> - More information about MySQL can be found at <ulink - url="&url.mysql;">&url.mysql;</ulink>. + MySQLì ëí ë ìì¸í ì ë³´ë <ulink url="&url.mysql;">&url.mysql;</ulink>ìì ì»ì ì ìë¤. </simpara> <simpara> - Documentation for MySQL can be found at <ulink - url="&url.mysql.docs;">&url.mysql.docs;</ulink>. + MySQL 문ìë <ulink url="&url.mysql.docs;">&url.mysql.docs;</ulink>ì ìë¤. </simpara> </partintro> @@ -30,11 +27,10 @@ <refentry id="function.mysql-affected-rows"> <refnamediv> <refname>mysql_affected_rows</refname> - <refpurpose>Get number of affected rows in previous MySQL - operation</refpurpose> + <refpurpose>ìµê·¼ MySQL ìì ì¼ë¡ ì²ë¦¬ë ì¤(row) ê°ì를 ì»ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_affected_rows</function></funcdef> @@ -46,20 +42,19 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_affected_rows</function> returns the number of - rows affected by the last INSERT, UPDATE or DELETE query on the - server associated with the specified link identifier. If the - link identifier isn't specified, the last opened link is assumed. + <function>mysql_affected_rows</function>ë link identifierë¡ + ì ìëì´ ìë ìë²ìì ìµê·¼ ì¤íë INSERT, UPDATE, DELETE ì§ìë¡ + ì²ë¦¬ë ì¤ì ê°ì를 ëë ¤ì¤ë¤. ë§ì½ link identifier ì¸ì를 + ìëµíë©´, ìµê·¼ ì´ë ¤ì§ linkìì ì 보를 ì»ëë¤. </para> <para> - 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. + ë§ì§ë§ ì§ìê° WHERE ì ì´ ìë DELETE ì§ìë¼ë©´ í ì´ë¸ì 모ë ë ì½ëê° + ìì ëê² ì§ë§ ì´ í¨ìì ê²½ì° 0ê°ì ëë ¤ì¤ë¤. </para> <para> - This command is not effective for SELECT statements, only on - statements which modify records. To retrieve the number of rows - returned from a SELECT, use <function>mysql_num_rows</function>. + ì´ í¨ìë SELECT 문ìë ëìíì§ ìì¼ë©°, ë ì½ëê° ìì ëë ê²½ì°ìë§ ëìíë¤. + SELECT 구문ì¼ë¡ë¶í° ëë ¤ë°ì ì¤ì ê°ì를 ì»ì¼ë ¤ë©´, <function>mysql_num_rows</function>를 + ì°ë©´ ëë¤. </para> </refsect1> </refentry> @@ -68,11 +63,11 @@ <refnamediv> <refname>mysql_change_user</refname> <refpurpose> - Change logged in user of the active connection + íì¬ ì ììì ë¡ê·¸ì¸ë ì¬ì©ì를 ë³ê²½ </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_change_user</function></funcdef> @@ -91,14 +86,13 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_change_user</function> 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.</para> - <note><para>This function was introduced in PHP 3.0.13 and - requires MySQL 3.23.3 or higher. + <function>mysql_change_user</function>í¨ìë íì¬ ì¬ì©ì¤ì¸ ì ì ëë + link identifier ì¸ìë¡ ì£¼ì´ì§ ì ììì ë¡ê·¸ì¸ë ì¬ì©ì를 ë³ê²½íë¤. + ë°ì´í°ë² ì´ì¤ ì´ë¦ì´ ì§ì ëë©´, ì¬ì©ìê° ë³ê²½ë ë¤ì + ì´ ë°ì´í°ë² ì´ì¤ê° 기본ê°ì¼ë¡ ëë©°, ê·¸ë ì§ ìì ê²½ì° íì¬ ë°ì´í°ë² ì´ì¤ê° ì¬ì©ëë¤. + ë³ê²½í ì¬ì©ìì ë¹ë°ë²í¸ ì¸ì¦ì ì¤í¨íê²ëë©´, + íì¬ ì ìë ì¬ì©ìë ì ìì´ ê·¸ëë¡ ì ì§ëë¤.</para> + <note><para>ì´ í¨ìë PHP 3.0.13 ê³¼ MySQL 3.23.3 ì´ìììë§ ëìíë¤. </para></note> </refsect1> </refentry> @@ -106,10 +100,10 @@ <refentry id="function.mysql-close"> <refnamediv> <refname>mysql_close</refname> - <refpurpose>Close MySQL connection</refpurpose> + <refpurpose>MySQL ì ìì ë«ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_close</function></funcdef> @@ -121,37 +115,36 @@ </funcprototype> </funcsynopsis> <para> - Returns: true on success, false on error. + ë°íê°: ì±ê³µíë©´ TRUEê°ì ì¤í¨íë©´ FALSEê°ì ëë림 </para> - <para> <function>mysql_close</function> closes the connection to - the MySQL server that's associated with the specified link - identifier. If <parameter>link_identifier</parameter> isn't - specified, the last opened link is used. + <para> <function>mysql_close</function> link identifierì ê´ë ¨ë + MySQL ìë² ì ìì ë«ëë¤. <parameter>link identifier</parameter>를 + ì§ì íì§ ìì¼ë©´ ë§ì§ë§ ì´ë ¤ì§ link를 ì¬ì©íë¤. </para> <para> - Using <function>mysql_close</function> isn't usually necessary, - as non-persistent open links are automatically closed at the end - of the script's execution. + <function>mysql_close</function>ë ë¹ì구ì ì¼ë¡ + ì´ë ¤ì§ ë§í¬ììë ì¼ë°ì ì¼ë¡ ì¤í¬ë¦½í¸(script) ì¤í ë§ì§ë§ ë¶ë¶ìì + ìëì¼ë¡ ì¢ ë£ë기 ë문ì ì¬ì©í íìê° ìë¤. </para> <note> <para> - <function>mysql_close</function> will not close persistent links - created by <function>mysql_pconnect</function>. + <function>mysql_close</function>ì <function>mysql_pconnect</function>ë¡ + ìì±ë ì구ì ì¼ë¡ ì ìë ë§í¬ììë ì¢ ë£ê° ìë ê²ì´ë¤. </para> </note> <example> - <title>MySQL close example</title> + <title>MySQL close ìì </title> <programlisting role="php"> <?php $link = mysql_connect ("kraemer", "marliesle", "secret") - or die ("Could not connect"); - print ("Connected successfully"); + or die ("ì ìí ì ììµëë¤"); + print ("ì ìëììµëë¤"); mysql_close ($link); ?> </programlisting> </example> <para> - See also: <function>mysql_connect</function>, and + 참조: <function>mysql_connect</function>, <function>mysql_pconnect</function>. </para> </refsect1> @@ -160,10 +153,10 @@ <refentry id="function.mysql-connect"> <refnamediv> <refname>mysql_connect</refname> - <refpurpose>Open a connection to a MySQL Server</refpurpose> + <refpurpose>MySQL ìë²ì ì ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_connect</function></funcdef> @@ -188,59 +181,54 @@ </funcprototype> </funcsynopsis> <para> - Returns a positive MySQL link identifier on success, or an error - message on failure. + ì ìì ì±ê³µíë©´ MySQL link identifier를, ê·¸ë ì§ ìì¼ë©´ ìë¬ ë©ìì§ë¥¼ ë°ííë¤. </para> <para> - <function>mysql_connect</function> establishes a connection - to a MySQL server. The following defaults are assumed for - missing optional parameters: <parameter>host:port</parameter> = - 'localhost:3306', <parameter>username</parameter> = name of the - user that owns the server process and - <parameter>password</parameter> = empty password. + <function>mysql_connect</function>ì ì´ì©íì¬ MySQL ìë²ì ì ìì í ì ìë¤. + ìë ëì´ë 기본ê°ì ì¸ì를 ì ë ¥íì§ ììì ë ëì ì¬ì©ëë ê°ì´ë¤. + <parameter>host:port</parameter>ë 'localhost:3306'ë¡, <parameter>username</parameter>ì + ìë² íë¡ì¸ì¤(server process)ì ìì ìë¡, ê·¸ë¦¬ê³ <parameter>password</parameter>ë + 공백 ë¹ë°ë²í¸ë¡ ëì²´ëë¤. </para> <para> - 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. + hostnameì "hostname:port"ì ê°ì´ í¬í¸ ë²í¸ë¥¼ í¬í¨í ì ìë¤. + ëí ë¡ì»¬í¸ì¤í¸ìì ":/path/to/socket"ì ê°ì´ + ìì¼ë ì¬ì©í ì ìë¤. <note> <para> - Support for ":port" was added in PHP 3.0B4. + ":port"ë PHP 3.0B4ìì ì¶ê°ë 기ë¥ì´ë¤. </para> <para> - Support for ":/path/to/socket" was added in - PHP 3.0.10. + ":/path/to/socket"ì PHP 3.0.10ì ì¶ê°ë 기ë¥ì´ë¤. </para> <para> - You can suppress the error message on failure by prepending '@' - to the function name. + í¨ì ì´ë¦ ìì '@'를 ë¶ìì¼ë¡ì¨ ìë¬ ë©ìì§ê° ì¶ë ¥ëì§ ìëë¡ í ì ìë¤. </para> </note> </para> <para> - If a second call is made to <function>mysql_connect</function> - with the same arguments, no new link will be established, but - instead, the link identifier of the already opened link will be - returned. + ëì¼í ì¸ìë¡ <function>mysql_connect</function>ì ë¤ì í¸ì¶íë©´, + ìë¡ì´ linkê° ìì±ëì§ ìë ëì , ì´ë¯¸ ì´ë ¤ì§ link identifier ê°ì + ëë ¤ë°ê² ëë¤. </para> <para> - 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 - <function>mysql_close</function>. + ìë²ìì ë§í¬ë ì¤í¬ë¦½í¸ ëë¶ë¶ì´ ì¤íëë ì¦ì ì¢ ë£ê° ëì§ë§, + <function>mysql_close</function>ì ì¬ì©íë©´ ì¤í¬ë¦½í¸ ëë¶ë¶ì´ ìëëë¼ë + ì¢ ë£ê° ê°ë¥íë¤. </para> <example> - <title>MySQL connect example</title> + <title>MySQL ì ì ìì </title> <programlisting role="php"> <?php $link = mysql_connect ("kraemer", "marliesle", "secret") - or die ("Could not connect"); - print ("Connected successfully"); + or die ("ì ìí ì ììµëë¤"); + print ("ì ìëììµëë¤"); mysql_close ($link); ?> </programlisting> </example> - <para> See also - <function>mysql_pconnect</function>, and + <para> 참조: + <function>mysql_pconnect</function>, <function>mysql_close</function>. </para> </refsect1> @@ -249,10 +237,10 @@ <refentry id="function.mysql-create-db"> <refnamediv> <refname>mysql_create_db</refname> - <refpurpose>Create a MySQL database</refpurpose> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ë¥¼ ìì±</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_create_db</function></funcdef> @@ -265,30 +253,28 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_create_db</function> attempts to create a new - database on the server associated with the specified link - identifier. + <function>mysql_create_db</function>ë link identifierì ê´ë ¨ë ìë²ì + ìë¡ì´ ë°ì´í°ë² ì´ì¤ë¥¼ ìì±íëë¡ íë¤. </para> <example> - <title>MySQL create database example</title> + <title>MySQL ë°ì´í°ë² ì´ì¤ ìì± ìì </title> <programlisting role="php"> <?php $link = mysql_pconnect ("kron", "jutta", "geheim") or die ("Could not connect"); if (mysql_create_db ("my_db")) { - print ("Database created successfully\n"); + print ("ë°ì´í°ë² ì´ì¤ë¥¼ ìì±íììµëë¤\n"); } else { - printf ("Error creating database: %s\n", mysql_error ()); + printf ("ë°ì´í°ë² ì´ì¤ ìì± ìë¬: %s\n", mysql_error ()); } ?> </programlisting> </example> <para> - For downwards compatibility <function>mysql_createdb</function> - can also be used. + íì í¸íì±ì ê°ì§ë <function>mysql_createdb</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> <para> - See also: <function>mysql_drop_db</function>. + 참조: <function>mysql_drop_db</function>. </para> </refsect1> </refentry> @@ -296,10 +282,10 @@ <refentry id="function.mysql-data-seek"> <refnamediv> <refname>mysql_data_seek</refname> - <refpurpose>Move internal result pointer</refpurpose> + <refpurpose>ë´ë¶ì ì¸ ê²°ê³¼ í¬ì¸í°ë¥¼ ì´ë</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_data_seek</function></funcdef> @@ -308,37 +294,37 @@ </funcprototype> </funcsynopsis> <para> - Returns: true on success, false on failure. + ë°íê°: ì±ê³µíë©´ TRUE, ì¤í¨íë©´ FALSE.ì </para> <para> - <function>mysql_data_seek</function> 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 <function>mysql_fetch_row</function> would return that row. + <function>mysql_data_seek</function>í¨ìë MySQL ê²°ê³¼ì¤ + ì¸ìë¡ ì§ì ë íë²í¸ë¥¼ ì´ì©íì¬ ë´ë¶ì ì¸ í í¬ì¸í°ë¥¼ + ì´ëìì¼ì¤ë¤. + <function>mysql_fetch_row</function>를 ì¬ì©íì¬ íì ë´ì©ì ì»ì ì ìë¤. </para> <para> - <parameter>Row_number</parameter> starts at 0. + <parameter>Row_number</parameter>ë 0ë¶í° ììëë¤. </para> <example> - <title>MySQL data seek example</title> + <title>MySQL ë°ì´í° ê²ì ìì </title> <programlisting role="php"> <?php $link = mysql_pconnect ("kron", "jutta", "geheim") - or die ("Could not connect"); + or die ("ì ìí ì ììµëë¤"); mysql_select_db ("samp_db") - or die ("Could not select database"); + or die ("ë°ì´í°ë² ì´ì¤ë¥¼ ì íí ì ììµëë¤"); $query = "SELECT last_name, first_name FROM friends"; $result = mysql_query ($query) - or die ("Query failed"); + or die ("ì§ì ì¤í¨"); # fetch rows in reverse order for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) { if (!mysql_data_seek ($result, $i)) { - printf ("Cannot seek to row %d\n", $i); + printf ("%d ë² íì ê²ìí ì ììµëë¤\n", $i); continue; } @@ -358,10 +344,10 @@ <refentry id="function.mysql-db-name"> <refnamediv> <refname>mysql_db_name</refname> - <refpurpose>Get result data</refpurpose> + <refpurpose>ë°ì´í° 결과를 ì»ì</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_db_name</function></funcdef> @@ -375,22 +361,19 @@ </funcprototype> </funcsynopsis> <para> - <function>mysql_db_name</function> takes as its first parameter - the result pointer from a call to - <function>mysql_list_dbs</function>. The - <parameter>row</parameter> parameter is an index into the result - set. + <function>mysql_db_name</function>ì <function>mysql_list_dbs</function>를 ì¤íí + 결과를 첫ë²ì§¸ ì¸ìë¡ ê°ëë¤. <parameter>row</parameter> ì¸ìë + 첫ë²ì§¸ ì¸ìë¡ë¶í° ì»ì´ì§ ê²°ê³¼ê°ì ì»ê¸°ìí ìì¸ì´ë¤. </para> <para> - If an error occurs, FALSE is returned. Use - <function>mysql_errno</function> and - <function>mysql_error</function> to determine the nature of the - error. + ë§ì½ ìë¬ê° ë°ìíë©´ falseê°ì ëë ¤ì¤ë¤. + <function>mysql_errno</function>ì <function>mysql_error</function>를 + ì¬ì©íì¬ ìë¬ ë©ìì§ ì²ë¦¬ë¥¼ í ì ìë¤. </para> <example> - <title><function>Mysql_db_name</function> example</title> + <title><function>Mysql_db_name</function> ìì </title> <programlisting role="php"> <?php error_reporting(E_ALL); @@ -409,8 +392,8 @@ </example> <para> - For backward compatibility, <function>mysql_dbname</function> is - also accepted. This is deprecated, however. + íì í¸íì±ì´ ìë <function>mysql_dbname</function>를 ì¬ì©í ì ìì¼ë + íì¬ ì¬ì©ëì§ ìëë¤. </para> </refsect1> @@ -419,10 +402,10 @@ <refentry id="function.mysql-db-query"> <refnamediv> <refname>mysql_db_query</refname> - <refpurpose>Send a MySQL query</refpurpose> + <refpurpose>MySQL ì§ì문ì ì ì¡</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_db_query</function></funcdef> @@ -436,23 +419,21 @@ </funcprototype> </funcsynopsis> <para> - Returns: A positive MySQL result identifier to the query result, - or false on error. + ë°íê°: MySQL ì§ìë¡ ë°ìí result identifierê°ì, + ìë¬ê° ë°ìíì ê²½ì° false를 ëë ¤ì¤ë¤. </para> <para> - <function>mysql_db_query</function> 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 <function>mysql_connect</function> was called with no - arguments + <function>mysql_db_query</function>ë ë°ì´í°ë² ì´ì¤ë¥¼ ì ííê³ , + ëìì ì§ì문ì ì¤ííë¤. ë§ì½ link identifierê° ì§ì ëì§ ìëë¤ë©´, + í¨ìë MySQL ìë²ìì ì ìë ë§í¬ë¥¼ ì°¾ì ê²ì´ë©°, ì°¾ì§ ëª»í ê²½ì°ìë + ì¸ììì´ ì¤íë <function>mysql_connect</function>ê³¼ ê°ì´ + ë§í¬ë¥¼ ìì±íì¬ ì¬ì©íë¤. </para> <para> - See also <function>mysql_connect</function>. + 참조: <function>mysql_connect</function>. </para> <para> - For downwards - compatibility <function>mysql</function> can also be used. + íì í¸íì±ì ê°ì§ë <function>mysql</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> </refsect1> </refentry> @@ -460,10 +441,10 @@ <refentry id="function.mysql-drop-db"> <refnamediv> <refname>mysql_drop_db</refname> - <refpurpose>Drop (delete) a MySQL database</refpurpose> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ë¥¼ ìì </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_drop_db</function></funcdef> @@ -476,7 +457,7 @@ </funcprototype> </funcsynopsis> <para> - Returns: true on success, false on failure. + ë°íê°: ì±ê³µíë©´ true, ì¤í¨íë©´ false. </para> <para> <function>mysql_drop_db</function> attempts to drop (remove) an @@ -484,8 +465,8 @@ link identifier. </para> <para> - See also: <function>mysql_create_db</function>. For downward - compatibility <function>mysql_dropdb</function> can also be used. + 참조: <function>mysql_create_db</function>. + íì í¸íì±ì´ ìë <function>mysql_dropdb</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> </refsect1> </refentry> @@ -493,11 +474,10 @@ <refentry id="function.mysql-errno"> <refnamediv> <refname>mysql_errno</refname> - <refpurpose>Returns the numerical value of the error message from previous - MySQL operation</refpurpose> + <refpurpose>ìµê·¼ MySQL ìì ì¼ë¡ ë°ìí ìë¬ ë²í¸ë¥¼ ë°í</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>int <function>mysql_errno</function></funcdef> @@ -509,18 +489,15 @@ </funcprototype> </funcsynopsis> <para> - Returns the error number from the last mySQL function, or - <literal>0</literal> (zero) if no error occurred. + ìµê·¼ ì¤íë MySQL í¨ìì ìë¬ë²í¸ë¥¼, ìë¬ê° ìì ê²½ì° + <literal>0</literal> ê°ì ë°ííë¤. </para> <para> - Errors coming back from the mySQL database backend no longer - issue warnings. Instead, use <function>mysql_errno</function> to - retrieve the error code. Note that this function only returns the - error code from the most recently executed mySQL function (not - including <function>mysql_error</function> and - <function>mysql_errno</function>), so if you want to use it, - make sure you check the value before calling another mySQL - function. + íë² MySQL ë°ì´í°ë² ì´ì¤ë¡ë¶í°ì ë°ìë ìë¬ë ëë¤ì ê²½ê³ ë©ìì§ë¥¼ ëíë´ì§ ìëë¤. + ëì , <function>mysql_errno</function>를 ì¬ì©íë©´ ìë¬ ì½ë(code)를 ì»ì ì ìë¤. + ì´ í¨ìë ìµê·¼ì ì¤íë MySQL í¨ì(<function>mysql_error</function>ê³¼ + <function>mysql_errno</function>를 ì ì¸í)ë¡ ë°ìë ìë¬ ì½ëë§ ì»ì ì ìë¤. + ê·¸ë¬ë ì¬ì©í기 ìí´ìë ë¤ë¥¸ MySQL í¨ì를 ì¬ì©í기 ì´ì ì ì¬ì©í´ì¼ íë¤. <informalexample> <programlisting role="php"> <?php @@ -543,11 +520,10 @@ <refentry id="function.mysql-error"> <refnamediv> <refname>mysql_error</refname> - <refpurpose>Returns the text of the error message from previous - MySQL operation</refpurpose> + <refpurpose>ìµê·¼ ì¤íë MySQL ìì ì¼ë¡ ë°ìí ìë¬ ë©ìì§ë¥¼ ë°í</refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>string <function>mysql_error</function></funcdef> @@ -559,17 +535,15 @@ </funcprototype> </funcsynopsis> <para> - Returns the error text from the last mySQL function, or - <literal>''</literal> (the empty string) if no error occurred. + MySQL í¨ìë¡ ë°ìë ìë¬ ë©ìì§ë¥¼ ì»ì ì ìì¼ë©°, + ìë¬ê° ë°ìíì§ ììì ê²½ì°ìë <literal>''</literal> (공백문ì)를 ì»ì ì ìë¤. </para> <para> - Errors coming back from the mySQL database backend no longer - issue warnings. Instead, use <function>mysql_error</function> to - retrieve the error text. Note that this function only returns the - error text from the most recently executed mySQL function (not - including <function>mysql_error</function> and - <function>mysql_errno</function>), so if you want to use it, make - sure you check the value before calling another mySQL function. + íë² MySQL ë°ì´í°ë² ì´ì¤ë¡ë¶í°ì ë°ìë ìë¬ë ëë¤ì ê²½ê³ ë©ìì§ë¥¼ ëíë´ì§ ìëë¤. + ëì , <function>mysql_error</function>를 ì¬ì©íë©´ ìë¬ ë©ìì§ë¥¼ ì»ì ì ìë¤. + ì´ í¨ìë ìµê·¼ì ì¤íë MySQL í¨ì(<function>mysql_error</function>ê³¼ + <function>mysql_errno</function>를 ì ì¸í)ë¡ ë°ìë ìë¬ ì½ëë§ ì»ì ì ìë¤. + ê·¸ë¬ë ì¬ì©í기 ìí´ìë ë¤ë¥¸ MySQL í¨ì를 ì¬ì©í기 ì´ì ì ì¬ì©í´ì¼ íë¤. <informalexample> <programlisting role="php"> <?php @@ -584,7 +558,7 @@ </informalexample> </para> <para> - See also: <function>mysql_errno</function> + 참조: <function>mysql_errno</function>. </para> </refsect1> </refentry> @@ -593,11 +567,11 @@ <refnamediv> <refname>mysql_fetch_array</refname> <refpurpose> - Fetch a result row as an associative array, a numeric array, or both. + 결과를 íëì´ë¦ ìì¸ ëë ì«ì ìì¸ì¼ë¡ ë ë°°ì´ë¡ ì»ì </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>array <function>mysql_fetch_array</function></funcdef> @@ -610,19 +584,17 @@ </funcprototype> </funcsynopsis> <para> - Returns an array that corresponds to the fetched row, or false - if there are no more rows.</para> + ë°ì´í°ë² ì´ì¤ í ì´ë¸ë¡ë¶í° ê°ì ¸ì¨ íì ëìëë ë°°ì´ë¡ ëë ¤ì£¼ê³ , + ëì´ì ê°ì ¸ì¬ íì´ ìì ê²½ì° false를 ë°ííë¤.</para> <para> - <function>mysql_fetch_array</function> is an extended version of - <function>mysql_fetch_row</function>. 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. + <function>mysql_fetch_array</function>ë <function>mysql_fetch_row</function>ìì + íì¥ë í¨ìì´ë¤. ê²°ê³¼ ë°°ì´ì ìë£ê° ì ì¥ëê³ ë°°ì´ì ìì¸ì¼ë¡ ë²í¸ê° ì¬ì©ëë¤. + ëí, ë°°ì´ì ìì¸ì¼ë¡ í ì´ë¸ì íë ì´ë¦ì¼ë¡ë ì¬ì©í ì ìë¤. </para> <para> - 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. + ê²°ê³¼ë¡ ëê° ì´ìì ëì¼í íë ì´ë¦ì ê°ì§ ì´ì´ ìë¤ë©´, + ë§ì§ë§ ì´ì´ ì°ì ê¶ì ê°ì§ë¤. ëì¼í ë¤ë¥¸ ì´ì ì¬ì©í기 ìí´ìë + ìì¸ ë²í¸ë¥¼ ì´ì©íê±°ë ì§ì 문ì¥ìì ì´ì ë³ëª ì ì£¼ì´ ì´ì©íì¬ì¼ íë¤. <informalexample> <programlisting> select t1.f1 as foo t2.f1 as bar from t1, t2 @@ -630,20 +602,16 @@ </informalexample> </para> <para> - An important thing to note is that using - <function>mysql_fetch_array</function> is NOT significantly - slower than using <function>mysql_fetch_row</function>, while it - provides a significant added value. + <function>mysql_fetch_array</function>ë íë ì´ë¦ì¼ë¡ ë ìì¸ì´ ì¶ê°ëì§ë§, + <function>mysql_fetch_row</function> ë³´ë¤ ëë ¤ì§ì§ë ìëë¤. </para> <para> - The optional second argument <parameter>result_type</parameter> - in <function>mysql_fetch_array</function> 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) + <function>mysql_fetch_array</function>ìì ëë²ì§¸ ìµì ì¸ì + <parameter>result_type</parameter>ì ììì´ê³ , MYSQL_ASSOC, MYSQL_NUM, + MYSQL_BOTHì ê°ì ê°ì ê°ì§ ì ìë¤(PHP 3.0.7ì ì¶ê°ëìì). </para> <para> - For further details, see also - <function>mysql_fetch_row</function> and <function>mysql_fetch_assoc</function>. + 참조: <function>mysql_fetch_row</function>, <function>mysql_fetch_assoc</function>. </para> <example> <title><function>Mysql_fetch_array</function></title> @@ -668,11 +636,11 @@ <refnamediv> <refname>mysql_fetch_assoc</refname> <refpurpose> - Fetch a result row as an associative array + 결과를 íëì´ë¦ ìì¸ì¼ë¡ ë ë°°ì´ë¡ ì»ì </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>array <function>mysql_fetch_assoc</function></funcdef> @@ -680,31 +648,28 @@ </funcprototype> </funcsynopsis> <para> - Returns an associative array that corresponds to the fetched row, - or false if there are no more rows.</para> + íëì´ë¦ì ìì¸ì ê°ì§ ë°°ì´ë¡ ëë ¤ì£¼ê³ , + ê°ì ¸ì¬ íì´ ìì ê²½ì° falseê°ì ë°ííë¤.</para> <para> - <function>mysql_fetch_assoc</function> is equivalent to calling - <function>mysql_fetch_array</function> with MYSQL_ASSOC for the - optional second parameter. It only returns an associative array. - This is the way <function>mysql_fetch_array</function> originally - worked. If you need the numeric indices as well as the - associative, use <function>mysql_fetch_array</function>. + <function>mysql_fetch_assoc</function>ë + <function>mysql_fetch_array</function>ì ëë²ì§¸ ì¸ìë¡ + MYSQL_ASSOC를 ì¬ì©í ê²½ì°ê³¼ ëì¼íê² ìëíë¤. + ì´ ë°©ìì <function>mysql_fetch_array</function>ì 본ëì ëì ë°©ë²ì´ë¤. + ë§ì¼ ì«ì ìì¸ ë°©ìê³¼ íëì´ë¦ ìì¸ì ëìì ì¬ì©íë ¤ë©´, + <function>mysql_fetch_array</function>를 ì¬ì©íë©´ ëë¤. </para> <para> - 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 <function>mysql_fetch_array</function> and - have it return the numeric indices as well. + ê²°ê³¼ë¡ ëê° ì´ìì ëì¼í íë ì´ë¦ì ê°ì§ ì´(column)ì´ ìë¤ë©´, + ë§ì§ë§ ì´ì´ ì°ì ê¶ì ê°ì§ë¤. ëì¼í ë¤ë¥¸ ì´ì ì¬ì©í기 ìí´ìë + ìì¸ ë²í¸ë ì¶ê°ë <function>mysql_fetch_array</function>를 + ì¬ì©í´ì¼í ê²ì´ë¤. </para> <para> - An important thing to note is that using - <function>mysql_fetch_assoc</function> is NOT significantly - slower than using <function>mysql_fetch_row</function>, while it - provides a significant added value. + <function>mysql_fetch_assoc</function>ë íëì´ë¦ì¼ë¡ ë ìì¸ì´ ì¶ê°ëì§ë§, + <function>mysql_fetch_row</function> ë³´ë¤ ëë ¤ì§ì§ë ìëë¤. </para> <para> - For further details, see also - <function>mysql_fetch_row</function> and <function>mysql_fetch_array</function>. + 참조: <function>mysql_fetch_row</function>, <function>mysql_fetch_array</function>. </para> <example> <title><function>Mysql_fetch_assoc</function></title> @@ -727,11 +692,11 @@ <refnamediv> <refname>mysql_fetch_field</refname> <refpurpose> - Get column information from a result and return as an object + ê²°ê³¼ë¡ë¶í° ì´ ì 보를 ì»ì´ì ê°ì²´ë¡ ëë ¤ì¤ </refpurpose> </refnamediv> <refsect1> - <title>Description</title> + <title>ì¤ëª </title> <funcsynopsis> <funcprototype> <funcdef>object <function>mysql_fetch_field</function></funcdef> @@ -744,94 +709,96 @@ </funcprototype> </funcsynopsis> <para> - Returns an object containing field information. + íë ì ë³´ê° í¬í¨ë ê°ì²´ë¡ ë°ííë¤. </para> <para> - <function>mysql_fetch_field</function> 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 <function>mysql_fetch_field</function> is retrieved. + <function>mysql_fetch_field</function>ë í¹ì ì§ì ê²°ê³¼ë¡ë¶í° + íë ì 보를 ì»ì 목ì ì¼ë¡ ì¬ì©í ì ìë¤. ë§ì¼ field_offsetì ì§ì íì§ ìì¼ë©´, + <function>mysql_fetch_field</function>ì ìí´ ìì§ ì»ì§ 못í ë¤ì íë ì 보를 + ì»ê² ëë¤. </para> - <para> - The properties of the object are: + <para> + ê°ì²´ì ëí í¹ì±ì ë¤ìê³¼ ê°ë¤. <itemizedlist> - <listitem> - <simpara> - name - column name + <listitem> + <simpara> + name - ì´(column) ì´ë¦ </simpara> - </listitem> - <listitem> - <simpara> - table - name of the table the column belongs to + </listitem> + <listitem> + <simpara> + table - ì´ì´ ìí´ìë í ì´ë¸ ì´ë¦ </simpara> - </listitem> - <listitem> - <simpara> - max_length - maximum length of the column + </listitem> + <listitem> + <simpara> + max_length - ì´ì ìµë ê¸¸ì´ </simpara> - </listitem> - <listitem> - <simpara> - not_null - 1 if the column cannot be null + </listitem> + <listitem> + <simpara> + not_null - ì´ ê°ì´ nullì´ ìëë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - primary_key - 1 if the column is a primary key + </listitem> + <listitem> + <simpara> + primary_key - ì´ì´ primary keyì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - unique_key - 1 if the column is a unique key + </listitem> + <listitem> + <simpara> + unique_key - ì´ì´ unique keyì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - multiple_key - 1 if the column is a non-unique key + </listitem> + <listitem> + <simpara> + multiple_key - ì´ì´ non-unique keyì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - numeric - 1 if the column is numeric + </listitem> + <listitem> + <simpara> + numeric - ì´ì´ ì«ìì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - blob - 1 if the column is a BLOB + </listitem> + <listitem> + <simpara> + blob - ì´ì´ BLOBì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - type - the type of the column + </listitem> + <listitem> + <simpara> + type - ì´ì íì </simpara> - </listitem> - <listitem> - <simpara> - unsigned - 1 if the column is unsigned + </listitem> + <listitem> + <simpara> + unsigned - ì´ì´ ë¶í¸ìì(unsigned)ì´ë©´ 1 </simpara> - </listitem> - <listitem> - <simpara> - zerofill - 1 if the column is zero-filled + </listitem> + <listitem> + <simpara> + zerofill - ì´ì´ 0ì¼ë¡ ì±ì(zero-filled)ì´ë©´ 1 </simpara> - </listitem> - </itemizedlist> - </para> - <example> - <title><function>Mysql_fetch_field</function></title> - <programlisting role="php"> + </listitem> + </itemizedlist> + </para> + <example> + <title> + <function>Mysql_fetch_field</function> + </title> + <programlisting role="php"> <?php mysql_connect ($host, $user, $password) - or die ("Could not connect"); + or die ("ì ìí ì ììµëë¤"); $result = mysql_db_query ("database", "select * from table") - or die ("Query failed"); + or die ("ì§ì ì¤í¨"); # get column metadata $i = 0; while ($i < mysql_num_fields ($result)) { echo "Information for column $i:<BR>\n"; $meta = mysql_fetch_field ($result); if (!$meta) { - echo "No information available<BR>\n"; + echo "ì´ë í ì ë³´ë ììµëë¤.<BR>\n"; } echo "<PRE> blob: $meta->blob @@ -852,89 +819,88 @@ mysql_free_result ($result); ?> </programlisting> - </example> - <para> - See also <function>mysql_field_seek</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-fetch-lengths"> - <refnamediv> - <refname>mysql_fetch_lengths</refname> - <refpurpose> - Get the length of each output in a result + </example> + <para> + 참조: <function>mysql_field_seek</function>. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-fetch-lengths"> + <refnamediv> + <refname>mysql_fetch_lengths</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° ê° ì¶ë ¥ì 길ì´ë¥¼ ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>array <function>mysql_fetch_lengths</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: An array that corresponds to the lengths of each field - in the last row fetched by <function>mysql_fetch_row</function>, - or false on error. - </para> - <para> - <function>mysql_fetch_lengths</function> stores the lengths of - each result column in the last row returned by - <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function>, and - <function>mysql_fetch_object</function> in an array, starting at - offset 0. - </para> - <para> - See also: <function>mysql_fetch_row</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-fetch-object"> - <refnamediv> - <refname>mysql_fetch_object</refname> - <refpurpose>Fetch a result row as an object</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>object <function>mysql_fetch_object</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int - <parameter> - <optional>result_type</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns an object with properties that correspond to the fetched - row, or false if there are no more rows. - </para> - <para> - <function>mysql_fetch_object</function> is similar to - <function>mysql_fetch_array</function>, 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). - </para> - <para> - The optional argument <parameter>result_type</parameter> is a - constant and can take the following values: MYSQL_ASSOC, - MYSQL_NUM, and MYSQL_BOTH. - </para> - <para> - Speed-wise, the function is identical to - <function>mysql_fetch_array</function>, and almost as quick as - <function>mysql_fetch_row</function> (the difference is - insignificant). + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>array <function>mysql_fetch_lengths</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: ìµê·¼ <function>mysql_fetch_row</function>ë¡ ì»ì + í(row)ì ê° íë 길ì´ë¥¼ ë°°ì´ë¡ ì»ê±°ë, ìë¬ ë°ìììë falseê°ì + ì»ëë¤. + </para> + <para> + <function>mysql_fetch_lengths</function>ë + ìµê·¼ <function>mysql_fetch_row</function>, + <function>mysql_fetch_array</function>, + <function>mysql_fetch_object</function>ë¡ ì»ì íì¼ë¡ë¶í° + ê° ì´(column)ì 길ì´ë¥¼ ìì¸ê°ì´ 0ì¼ë¡ ììíë ë°°ì´ë¡ ì ì¥íì¬ ë°ííë¤. + </para> + <para> + 참조: <function>mysql_fetch_row</function>. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-fetch-object"> + <refnamediv> + <refname>mysql_fetch_object</refname> + <refpurpose>í(row)ì 결과를 ê°ì²´ë¡ ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>object <function>mysql_fetch_object</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>result_type</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + í(row)ì ëìëë ê°ì²´ë¡ ëë ¤ì£¼ê³ , + ê°ì ¸ì¬ íì´ ìì ê²½ì° false를 ë°ííë¤. + </para> + <para> + <function>mysql_fetch_object</function>ë + <function>mysql_fetch_array</function>ì ì ì¬íë, + ë°°ì´ ëì ê°ì²´ë¡ ì»ëë¤ë ì°¨ì´ì ì´ ìë¤. + ë¤ìë§í´, ì¤íì (offset)ì ìí´ìê° ìë íëì´ë¦ì¼ë¡ + ë°ì´í°ë¥¼ ì ê·¼í ì ìë¤ë ê²ì´ë¤. + </para> + <para> + ëë²ì§¸ ì¸ìì¸ <parameter>result_type</parameter>ìë + ììê° ì¤ë©°, MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH ê°ì ê°ì§ ì ìë¤. + </para> + <para> + ìëë©´ìì, ì´ í¨ìë <function>mysql_fetch_array</function>ì ë¹ì·íê³ , + <function>mysql_fetch_row</function>ë§í¼ì´ë ë¹ ë¥´ë¤. ê·¸ë¬ë í° ì°¨ì´ë ìë¤. <example> - <title><function>mysql_fetch_object</function> example</title> - <programlisting role="php"> + <title> + <function>mysql_fetch_object</function> ìì </title> + <programlisting role="php"> <?php mysql_connect ($host, $user, $password); $result = mysql_db_query ("database", "select * from table"); @@ -945,123 +911,123 @@ mysql_free_result ($result); ?> </programlisting> - </example> - </para> - <para> + </example> + </para> + <para> See also: <function>mysql_fetch_array</function> and <function>mysql_fetch_row</function>. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-fetch-row"> - <refnamediv> - <refname>mysql_fetch_row</refname> - <refpurpose>Get a result row as an enumerated array</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>array <function>mysql_fetch_row</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: An array that corresponds to the fetched row, or false - if there are no more rows. - </para> - <para> - <function>mysql_fetch_row</function> 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. - </para> - <para> - Subsequent call to <function>mysql_fetch_row</function> would - return the next row in the result set, or false if there are no - more rows. + </refsect1> + </refentry> + <refentry id="function.mysql-fetch-row"> + <refnamediv> + <refname>mysql_fetch_row</refname> + <refpurpose>결과를 ì«ììì¸ì¼ë¡ ë ë°°ì´ë¡ ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>array <function>mysql_fetch_row</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: í(row)ì ëìëë ê°ì²´ë¡ ëë ¤ì£¼ê³ , ê°ì ¸ì¬ ê°ì´ ìì ê²½ì° false를 ë°ííë¤. + </para> + <para> + <function>mysql_fetch_row</function>ë í¹ì result identifierë¡ë¶í° + í íì ë°ì´í°ë¥¼ ê°ì ¸ì¤ë©°, ë°°ì´ë¡ ì»ì ì ìë¤. ê° ê²°ê³¼ ì´(column)ì + 0ë¶í° ììíë ì«ììì¸ì¼ë¡ ì ì¥ëë¤. + </para> + <para> + <function>mysql_fetch_row</function>를 ì¤ííë©´, ë¤ì í ë°ì´í°ë¥¼ ëë ¤ì£¼ë©°, + ê°ì ¸ì¬ íì´ ìì ê²½ì° false를 ë°ííë¤. </para> - <para> - See also: <function>mysql_fetch_array</function>, + <para> + 참조: <function>mysql_fetch_array</function>, <function>mysql_fetch_object</function>, <function>mysql_data_seek</function>, - <function>mysql_fetch_lengths</function>, and + <function>mysql_fetch_lengths</function>, <function>mysql_result</function>. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-flags"> - <refnamediv> - <refname>mysql_field_flags</refname> - <refpurpose> - Get the flags associated with the specified field in a result + </refsect1> + </refentry> + <refentry id="function.mysql-field-flags"> + <refnamediv> + <refname>mysql_field_flags</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° í¹ì íë(field)ì ìíì ë³´(flag)를 ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_flags</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_flags</function> 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 <function>explode</function>. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_flags</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_flags</function>ì í¹ì íëì ìíì 보를 ë°ííë¤. + ìíì ë³´ë íê°ì 공백ì¼ë¡ 구ë¶ë ë¨ì¼ ë¨ì´ë¡ ì¶ë ¥ëë©°, + ì´ ê°ì <function>explode</function>ì ìí´ ëë ì ë³¼ ì ìë¤. </para> - <para>The following flags are reported, if your version of MySQL - is current enough to support them: "not_null", "primary_key", + <para> + ì¬ì©ì¤ì¸ MySQL ë²ì ì´ "not_null", "primary_key", "unique_key", "multiple_key", "blob", "unsigned", "zerofill", - "binary", "enum", "auto_increment", "timestamp". + "binary", "enum", "auto_increment", "timestamp"를 ì§ìíë¤ë©´, + íë ìíì ë³´ì ë°ë¼ ìì ë¨ì´ë¤ì´ ì¶ë ¥ë ê²ì´ë¤. </para> - <para> - For downward compatibility <function>mysql_fieldflags</function> - can also be used. + <para> + <function>mysql_fieldflags</function>ì íì í¸íì±ì´ ìë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-name"> - <refnamediv> - <refname>mysql_field_name</refname> - <refpurpose> - Get the name of the specified field in a result + </refsect1> + </refentry> + <refentry id="function.mysql-field-name"> + <refnamediv> + <refname>mysql_field_name</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° í¹ì íë ì´ë¦ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_name</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_index</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_name</function> returns the name of the - specified field index. <parameter>result</parameter> must be a - valid result identifier and <parameter>field_index</parameter> is - the numerical offset of the field. - </para> - <note> - <para> - <parameter>field_index</parameter> starts at 0. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_name</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_index</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_name</function>ì í¹ì íë ìì¸ê°ì ì»ëë¤. + <parameter>result</parameter>ë result identifierë ì í¨í ê²°ê³¼ê°ì´ì´ì¼ íê³ , + <parameter>field_index</parameter>ë íëì ì«ì ì¤íì (offset)ì´ì´ì¼ íë¤. + </para> + <note> + <para> + <parameter>field_index</parameter>ë 0ë¶í° ììíë ê°ì´ë¤. </para> - <para> - e.g. The index of the third field would actually be 2, the index - of the fourth field would be 3 and so on. + <para> + ì를ë¤ì´, ì¸ë²ì§¸ íëì ìì¸ì 2ì´ê³ , ë¤ë²ì§¸ íëì ìì¸ì 3ì´ ëë¤. </para> - </note> - <para> - <example> - <title><function>mysql_field_name</function> example</title> - <programlisting role="php"> -// The users table consists of three fields: + </note> + <para> + <example> + <title> + <function>mysql_field_name</function> example</title> + <programlisting role="php"> +// í ì´ë¸ì´ ì¸ê°ì íëë¡ ìëì ê°ì´ ì¸ê°ì íëë¡ ì´ë£¨ì´ì ¸ ìì ë: // user_id // username // password. @@ -1071,132 +1037,134 @@ echo mysql_field_name($res, 0) . "\n"; echo mysql_field_name($res, 2); </programlisting> - </example> - </para> - <para> - The above example would produce the following output: + </example> + </para> + <para> + ìì ìì ë ìëì ê°ì´ ì¶ë ¥ë ê²ì´ë¤: <informalexample> - <programlisting> + <programlisting> user_id password </programlisting> - </informalexample> - </para> - <para> - For downwards compatibility <function>mysql_fieldname</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-len"> - <refnamediv> - <refname>mysql_field_len</refname> - <refpurpose> - Returns the length of the specified field + </informalexample> + </para> + <para> + <function>mysql_fieldname</function>ì íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-len"> + <refnamediv> + <refname>mysql_field_len</refname> + <refpurpose> + í¹ì íëì 길ì´ë¥¼ ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_field_len</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_len</function> returns the length of the - specified field. - </para> - <para> - For downward compatibility <function>mysql_fieldlen</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-seek"> - <refnamediv> - <refname>mysql_field_seek</refname> - <refpurpose> - Set result pointer to a specified field offset + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_field_len</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_len</function>ì í¹ì íëì 길ì´ë¥¼ ì»ëë¤. + </para> + <para> + <function>mysql_fieldlen</function>ë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-seek"> + <refnamediv> + <refname>mysql_field_seek</refname> + <refpurpose> + í¹ì íëì ì¤íì (offset)ì¼ë¡ ìì¹(pointer)를 ì´ë </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_field_seek</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Seeks to the specified field offset. If the next call to - <function>mysql_fetch_field</function> doesn't include a field - offset, the field offset specified in - <function>mysql_field_seek</function> will be returned. - </para> - <para> - See also: <function>mysql_fetch_field</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-table"> - <refnamediv> - <refname>mysql_field_table</refname> - <refpurpose> - Get name of the table the specified field is in + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_field_seek</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + í¹ì íë ì¤íì ì ê²ìíëë° ì¬ì©ëë¤. + <function>mysql_fetch_field</function>ì ì¤ííë©´ì íë ì¤íì ì ì¤ì íì§ ìì¼ë©´, + <function>mysql_field_seek</function>ì´ ëë ¤ì¤ ê°ì¼ë¡ ì§ì ëë¤. + </para> + <para> + 참조: <function>mysql_fetch_field</function>. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-table"> + <refnamediv> + <refname>mysql_field_table</refname> + <refpurpose> + í¹ì íëê° ìí í ì´ë¸ ì´ë¦ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_table</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns the name of the table that the specifed field is - in. - </para> - <para> - For downward compatibility <function>mysql_fieldtable</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-field-type"> - <refnamediv> - <refname>mysql_field_type</refname> - <refpurpose> - Get the type of the specified field in a result + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_table</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + í¹ì íëê° ìí í ì´ë¸ ì´ë¦ì ì»ëë¤. + </para> + <para> + <function>mysql_fieldtable</function>ê³¼ íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-field-type"> + <refnamediv> + <refname>mysql_field_type</refname> + <refpurpose> + ê²°ê³¼ë¡ë¶í° í¹ì íëì íì ì ë³´(type)ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_field_type</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_field_type</function> is similar to the - <function>mysql_field_name</function> 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 <ulink url="&url.mysql.docs;">MySQL - documentation</ulink>. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_field_type</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>field_offset</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_field_type</function>ë + <function>mysql_field_name</function> í¨ìì + ì¬ì©ììê² ëë ¤ì£¼ë ê°ì ííììë ë¹ì·íë¤. + ê·¸ë¬ë, íëíì ì "int", "real", "string", "blob" ë±ê³¼ ê°ì + ë¨ì´ë¡ ë°ííë¤ë ê²ì´ ë¤ë¥´ë¤. íëíì ì ë ìì¸í ì¢ ë¥ë¥¼ ë³´ë ¤ë©´ + <ulink url="&url.mysql.docs;">MySQL 문ì</ulink>를 ë³´ë©´ ëë¤. <example> - <title>mysql field types</title> - <programlisting role="php"> + <title>mysql field types</title> + <programlisting role="php"> <?php mysql_connect ("localhost:3306"); @@ -1220,129 +1188,123 @@ ?> </programlisting> - </example> - </para> - <para> - For downward compatibility <function>mysql_fieldtype</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-free-result"> - <refnamediv> - <refname>mysql_free_result</refname> - <refpurpose>Free result memory</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_free_result</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_free_result</function> will free all memory - associated with the result identifier <parameter>result</parameter>. - </para> - <para> - <function>mysql_free_result</function> 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. - </para> - <para> - For downward compatibility <function>mysql_freeresult</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-insert-id"> - <refnamediv> - <refname>mysql_insert_id</refname> - <refpurpose> - Get the id generated from the previous INSERT operation + </example> + </para> + <para> + <function>mysql_fieldtype</function>ê³¼ íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-free-result"> + <refnamediv> + <refname>mysql_free_result</refname> + <refpurpose>Free result memory</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_free_result</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_free_result</function>ë +<parameter>result</parameter>ì ëí ë©ëª¨ë¦¬(memory)ì ìë +ë´ì©ì 모ë ì ê±°íë¤. + </para> + <para> + <function>mysql_free_result</function>ë ê²°ê³¼ë¡ë¶í° ì»ì ì§ì ê°ì´ +커ì ë§ì ë©ëª¨ë¦¬ë¥¼ ì¬ì©í ì¼ë ¤ê° ìì ë ì¬ì©ëë¤. +ê·¸ë¬ë, ì¤í¬ë¦½í¸(script) ì¤íë¶ ë§ì§ë§ìë ìëì ì¼ë¡ ê²°ê³¼ì ê´ë ¨ë ë©ëª¨ë¦¬ë ì§ìì§ë¤. + </para> + <para> + <function>mysql_freeresult</function>ìë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-insert-id"> + <refnamediv> + <refname>mysql_insert_id</refname> + <refpurpose> + ìµê·¼ INSERT ìì ì¼ë¡ë¶í° ìì±ë identifier ê°ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_insert_id</function></funcdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_insert_id</function> returns the ID generated for - an AUTO_INCREMENT column by the previous INSERT query using the - given <parameter>link_identifier</parameter>. If - <parameter>link_identifier</parameter> isn't specified, the last - opened link is assumed. - </para> - <para> - <function>mysql_insert_id</function> 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. - </para> - <note> - <para> - The value of the MySQL SQL function - <literal>LAST_INSERT_ID()</literal> always contains the most - recently generated AUTO_INCREMENT value, and is not reset - between queries. - </para> - </note> - <warning> - <para> - <function>mysql_insert_id</function> converts the return type of - the native MySQL C API function - <literal>mysql_insert_id()</literal> to a type of - <literal>long</literal>. If your AUTO_INCREMENT column has - a column type of BIGINT, the value returned by - <function>mysql_insert_id</function> will be incorrect. - Instead, use the internal MySQL SQL function - <literal>LAST_INSERT_ID()</literal>. + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_insert_id</function> + </funcdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_insert_id</function>ë + <parameter>link_identifier</parameter>를 ì¬ì©íë©´, INSERT ì§ìë¡ í(row)를 ì¶ê°í ë¤ + AUTO_INCREMENTë¡ ìì±ë 컬ë¼ì ì¶ê°ë ê°ì ì»ì ì ìë¤. + <parameter>link_identifier</parameter>를 ì§ì íì§ ìì¼ë©´ ë§ì§ë§ì ì´ë ¤ì§ ë§í¬(link)를 + ì¬ì©íë¤. + </para> + <para> + <function>mysql_insert_id</function>ë ì´ì ì§ìê° AUTO_INCREMENTê°ì¼ë¡ + ìì±ëì§ ìì¼ë©´, 0ì ë°ííë¤. + ë§ì§ë§ì¼ë¡ ì ì¥ë ê°ì´ íìíë¤ë©´, ì§ìë¡ ê°ì ì¶ê°í ì§í mysql_insert_id()를 ì¬ì©íë©´ ëë¤. + </para> + <note> + <para> + <literal>LAST_INSERT_ID()</literal>ë +AUTO_INCREMENT ê°ì¼ë¡ ìì±ë ê°ì¥ ìµê·¼ ê°ì´ ë³´ê´ëë©° ì§ì ì¬ì´ìë ìì´ì§ì§ ìëë¤. + </para> + </note> + <warning> + <para> + <function>mysql_insert_id</function>ë MySQL C API ë´ì¥ í¨ìì¸ + <literal>mysql_insert_id()</literal>ë¡ë¶í° <literal>long</literal> íì ì¼ë¡ ë³ííë¤. + ë§ì¼, AUTO_INCREMENT ì´(column)ì íì ì´ BIGINTë¼ë©´, + <function>mysql_insert_id</function>ì ë¶ì íí ê°ì ë°íí ê²ì´ë¤. ê·¸ëì , ë´ë¶ MySQL í¨ìì¸ + <literal>LAST_INSERT_ID()</literal>를 ì¬ì©íë©´ ëë¤. </para> - </warning> - </refsect1> - </refentry> - - <refentry id="function.mysql-list-dbs"> - <refnamediv> - <refname>mysql_list_dbs</refname> - <refpurpose> - List databases available on a MySQL server + </warning> + </refsect1> + </refentry> + <refentry id="function.mysql-list-dbs"> + <refnamediv> + <refname>mysql_list_dbs</refname> + <refpurpose> + MySQL ìë²ì ìë ë°ì´í°ë² ì´ì¤ ì´ë¦ì ì»ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_list_dbs</function></funcdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_list_dbs</function> will return a result pointer - containing the databases available from the current mysql - daemon. Use the <function>mysql_tablename</function> function to + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_list_dbs</function> + </funcdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_list_dbs</function>ë íì¬ MySQL ë°ëª¬(daemon)ì¼ë¡ë¶í° + ì¬ì©ê°ë¥í ë°ì´í°ë² ì´ì¤ë¥¼ í¬í¨í ê²°ê³¼ í¬ì¸í°ë¡ ë°íí ê²ì´ë¤. + Use the <function>mysql_tablename</function> function to traverse this result pointer. </para> - <para> - <example> - <title><function>mysql_list_dbs</function> example</title> - <programlisting role="php"> + <para> + <example> + <title> + <function>mysql_list_dbs</function> ìì </title> + <programlisting role="php"> $link = mysql_connect('localhost', 'myname', 'secret'); $db_list = mysql_list_dbs($link); @@ -1350,187 +1312,183 @@ echo $row->Database . "\n"; } </programlisting> - </example> - </para> - <para> - The above example would produce the following output: + </example> + </para> + <para> + ìì ì ê²°ê³¼ë ìëì ê°ë¤: <informalexample> - <programlisting> + <programlisting> database1 database2 database3 ... </programlisting> - </informalexample> - </para> - <note> - <para> - The above code would just as easily work with - <function>mysql_fetch_row</function> or other similar functions. + </informalexample> + </para> + <note> + <para> + ì ì½ëë <function>mysql_fetch_row</function>ë ì´ì ì ì¬í í¨ì를 ì¬ì©í ìë ìë¤. </para> - </note> - <para> - For downward compatibility <function>mysql_listdbs</function> can - also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-list-fields"> - <refnamediv> - <refname>mysql_list_fields</refname> - <refpurpose>List MySQL result fields</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_list_fields</function></funcdef> - <paramdef>string <parameter>database_name</parameter></paramdef> - <paramdef>string <parameter>table_name</parameter></paramdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_list_fields</function> 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 <function>mysql_field_flags</function>, + </note> + <para> + <function>mysql_listdbs</function>ë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-list-fields"> + <refnamediv> + <refname>mysql_list_fields</refname> + <refpurpose>MySQL ê²°ê³¼ì íë 리ì¤í¸ë¥¼ ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_list_fields</function> + </funcdef> + <paramdef>string <parameter>database_name</parameter> + </paramdef> + <paramdef>string <parameter>table_name</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_list_fields</function>ë 주ì´ì§ í ì´ë¸ ì´ë¦ì¼ë¡ë¶í° ì 보를 ê°ì ¸ì¨ë¤. + ì´ í¨ìë ë°ì´í°ë² ì´ì¤ ì´ë¦ê³¼ í ì´ë¸ ì´ë¦ì ì¸ì(argument)ë¡ ê°ëë¤. + ê·¸ë¦¬ê³ ì´ í¨ìë <function>mysql_field_flags</function>, <function>mysql_field_len</function>, - <function>mysql_field_name</function>, and - <function>mysql_field_type</function>. - </para> - <para> - A result identifier is a positive integer. The function returns - -1 if a error occurs. A string describing the error will be - placed in <literal>$phperrmsg</literal>, and unless the function - was called as <literal>@mysql()</literal> then this error string - will also be printed out. - </para> - <para> - <example> - <title><function>mysql_list_fields</function> example</title> - <programlisting role="php"> + <function>mysql_field_name</function>, + <function>mysql_field_type</function> ë±ì ì¬ì©í ì ìëë¡ + ê²°ê³¼ í¬ì¸í°ë¥¼ ë°ííë¤. + </para> + <para> + ê²°ê³¼ identifierë ìì ì ìì´ë©°, ìë¬ê° ë°ìíë©´ -1 ê°ì´ ë°íëë¤. + ìë¬ ë©ìì§ë <literal>$phperrmsg</literal>ì ì ì¥ë ê²ì´ë©°, + <literal>@mysql()</literal>ê³¼ ê°ì´ í¸ì¶íì§ ìëí íì íë©´ì + ìë¬ ë©ìì§ê° ì¶ë ¥ë ê²ì´ë¤. + </para> + <para> + <example> + <title> + <function>mysql_list_fields</function> ìì </title> + <programlisting role="php"> $link = mysql_connect('localhost', 'myname', 'secret'); $fields = mysql_list_fields("database1", "table1", $link); $columns = mysql_num_fields($fields); -for ($i = 0; $i < $columns; $i++) { +for ($i = 0; $i < $columns; $i++) { echo mysql_field_name($fields, $i) . "\n";; } </programlisting> - </example> - </para> - <para> - The above example would produce the following output: + </example> + </para> + <para> + ìì ìì ë ë¤ìê³¼ ê°ì´ ì¶ë ¥ë ê²ì´ë¤: <informalexample> - <programlisting> + <programlisting> field1 field2 field3 ... </programlisting> - </informalexample> + </informalexample> + </para> + <para> + <function>mysql_listfields</function>ë íì í¸íì±ì´ ìë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-list-tables"> + <refnamediv> + <refname>mysql_list_tables</refname> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ì ìë í ì´ë¸ 목ë¡ì ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_list_tables</function> + </funcdef> + <paramdef>string <parameter>database</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_list_tables</function> ì§ì ë ë°ì´í°ë² ì´ì¤ ì´ë¦ì¼ë¡ +ê²°ê³¼ê°ì ì»ê³ <function>mysql_db_query</function>ë±ì í¨ìì ì¬ì©ëë ê²°ê³¼ í¬ì¸í°ë¥¼ ë°ííë¤. +<function>mysql_tablename</function> í¨ìë ê²°ê³¼ í¬ì¸í°ë¡ë¶í° ì¤ì í ì´ë¸ ì´ë¦ì ì¶ì¶íëë° ì¬ì©íë¤. + </para> + <para> +íì í¸íì±ì ê°ì§ë <function>mysql_listtables</function> í¨ì ìì ì¬ì© ê°ë¥íë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-num-fields"> + <refnamediv> + <refname>mysql_num_fields</refname> + <refpurpose>ê²°ê³¼ë¡ë¶í° íë ê°ì를 ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_num_fields</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_num_fields</function> í¨ìë ê²°ê³¼ì ì¼ë¡ë¶í° íë ê°ì를 ë°ííë¤. </para> - <para> - For downward compatibility <function>mysql_listfields</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-list-tables"> - <refnamediv> - <refname>mysql_list_tables</refname> - <refpurpose>List tables in a MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_list_tables</function></funcdef> - <paramdef>string <parameter>database</parameter></paramdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_list_tables</function> takes a database name and - returns a result pointer much like the - <function>mysql_db_query</function> function. The - <function>mysql_tablename</function> function should be used to - extract the actual table names from the result pointer. - </para> - <para> - For downward compatibility <function>mysql_listtables</function> - can also be used. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-num-fields"> - <refnamediv> - <refname>mysql_num_fields</refname> - <refpurpose>Get number of fields in result</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_num_fields</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_num_fields</function> returns the number of - fields in a result set. - </para> - <para> - See also: + <para> + 참조: <function>mysql_db_query</function>, <function>mysql_query</function>, <function>mysql_fetch_field</function>, <function>mysql_num_rows</function>.</para> - <para> - For downward compatibility <function>mysql_numfields</function> - can also be used. + <para> +íì í¸íì±ì ê°ì§ë <function>mysql_numfields</function> í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-num-rows"> - <refnamediv> - <refname>mysql_num_rows</refname> - <refpurpose>Get number of rows in result</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_num_rows</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_num_rows</function> 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, use <function>mysql_affected_rows</function>. + </refsect1> + </refentry> + <refentry id="function.mysql-num-rows"> + <refnamediv> + <refname>mysql_num_rows</refname> + <refpurpose>ê²°ê³¼ë¡ë¶í° ì´ ê°ì를 ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_num_rows</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_num_rows</function> í¨ìë ê²°ê³¼ì ì¼ë¡ë¶í° ì´ì ê°ì를 ë°ííë¤. +ì´ í¨ìë SELECTì ìì ë°íë ê²°ê³¼ì ë§ ì¬ì©ì´ ê°ë¥íë¤. +INSERT, UPDATE, DELETEë¡ë¶í° ì´ì ê°ì를 ì»ì¼ë ¤ë©´ <function>mysql_affected_rows</function>를 ì¬ì©íë©´ ëë¤. <example> - <title> - <function> - mysql_num_rows example by crubel@trilizio.org + <title> + <function> + mysql_num_rows ìì (crubel@trilizio.org ì ê³µ) </function> - </title> - <programlisting role="php"> + </title> + <programlisting role="php"> <?php $conn = mysql_connect("hostaddress", "username", "password"); mysql_select_db("database",$conn); // needed if you have m,ultiple db's @@ -1539,313 +1497,293 @@ echo "$NumMembers Members"; ?> </programlisting> - </example> - </para> - <para> - See also: + </example> + </para> + <para> + 참조: <function>mysql_db_query</function>, <function>mysql_query</function> and, <function>mysql_fetch_row</function>. </para> - <para> - For downward compatibility <function>mysql_numrows</function> can - also be used. + <para> +íì í¸íì±ì ê°ì§ë <function>mysql_numrows</function> í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-pconnect"> - <refnamediv> - <refname>mysql_pconnect</refname> - <refpurpose> - Open a persistent connection to a MySQL Server + </refsect1> + </refentry> + <refentry id="function.mysql-pconnect"> + <refnamediv> + <refname>mysql_pconnect</refname> + <refpurpose> + MySQL ìë²ì ì구ì ì¸ ë°ì´í°ë² ì´ì¤ ì ì </refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_pconnect</function></funcdef> - <paramdef>string + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_pconnect</function> + </funcdef> + <paramdef>string <parameter> - <optional>hostname - <optional>:port</optional> - <optional>:/path/to/socket</optional> - </optional> - </parameter> - </paramdef> - <paramdef>string - <parameter><optional>username</optional></parameter> - </paramdef> - <paramdef>string - <parameter><optional>password</optional></parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: A positive MySQL persistent link identifier on success, - or false on error. - </para> - <para> - <function>mysql_pconnect</function> establishes a connection - to a MySQL server. The following defaults are assumed for - missing optional parameters: <parameter>host:port</parameter> = - 'localhost:3306', <parameter>username</parameter> = name of the - user that owns the server process and - <parameter>password</parameter> = empty password. - </para> - <para> - 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. + <optional>hostname + <optional>:port</optional> + <optional>:/path/to/socket</optional> + </optional> + </parameter> + </paramdef> + <paramdef>string + <parameter> + <optional>username</optional> + </parameter> + </paramdef> + <paramdef>string + <parameter> + <optional>password</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: ì ìì ì±ê³µíë©´ MySQL ì구ì link identifier를 ë°ííê³ , ì¤í¨íë©´ ìë¬ë¥¼ ì¶ë ¥. + </para> + <para> + <function>mysql_pconnect</function>ë MySQL ìë²ë¡ë¶í° ì ìì ì¤ì íë í¨ìì´ë¤. +ë¤ì 기본 ì¤ì ê°ì ìµì íë¼ë¯¸í°ë¥¼ ì¤ì íì§ ìì¼ë©´ ì¬ì©ëë¤: <parameter>host:port</parameter> = + 'localhost:3306', <parameter>username</parameter> = ìë² íë¡ì¸ì ìì ì, + <parameter>password</parameter> = 공백 ë¹ë°ë²í¸. + </para> + <para> +í¸ì¤í¸ëª ì í¬í¸ ë²í¸ë¥¼ í¬í¨ ê°ë¥íë¤. "hostname:port"ë ":/path/to/socket"ì + ê°ì´ ë¡ì»¬í¸ì¤í¸ì ìì¼ ê²½ë¡ ííë¡ ì¬ì©ì´ ê°ë¥íë¤. <note> - <para> - Support for ":port" wass added in 3.0B4. + <para> +":port"ë 3.0B4 ë²ì ë¶í° ì¬ì©ì´ ê°ë¥íë¤. </para> - <para> - Support for the ":/path/to/socket" was added in - 3.0.10. + <para> +":/path/to/socket"ë 3.0.10 ë²ì ë¶í° ì¬ì©ì´ ê°ë¥íë¤. </para> - </note> - </para> - <para> - <function>mysql_pconnect</function> acts very much like - <function>mysql_connect</function> with two major differences. - </para> - <para> - 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. - </para> - <para> - 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 (<function>mysql_close</function> will not - close links established by <function>mysql_pconnect</function>). - </para> - <para> - This type of links is therefore called 'persistent'. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-query"> - <refnamediv> - <refname>mysql_query</refname> - <refpurpose>Send a MySQL query</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_query</function></funcdef> - <paramdef>string <parameter>query</parameter></paramdef> - <paramdef>int - <parameter><optional>link_identifier</optional></parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_query</function> sends a query to the currently - active database on the server that's associated with the - specified link identifier. If - <parameter>link_identifier</parameter> isn't specified, the last - opened link is assumed. If no link is open, the function tries - to establish a link as if <function>mysql_connect</function> was - called with no arguments, and use it. - </para> - <note> - <para> - The query string should not end with a semicolon. + </note> + </para> + <para> + <function>mysql_pconnect</function>ì <function>mysql_connect</function>ê³¼ í¬ê² ëê°ì§ ë¶ë¶ìì ë¤ë¥´ë¤. + </para> + <para> +첫째, ì ìí ë, í¨ìë ëì¼í í¸ì¤í¸ì ì¬ì©ìì´ë¦, ë¹ë°ë²í¸ë¡ ì´ë¯¸ ì´ë ¤ì§ ì구ì ì ìë ë§í¬ê° ìëì§ ì°¾ì본ë¤. +ë§ì¼ ì°¾ê²ëë©´, ìë¡ì ì ìì ì¬ë ëì ì°¾ì ë§í¬ì identifier를 ë°ííë¤. + </para> + <para> +ë째, SQL ìë²ë¡ ì ìì ì¤í¬ë¦½í¸ ì¤íì´ ëëë ê³ì ì ì§ê° ëë©°, ì´íìë ì¬ì©ì´ ê°ë¥íë¤. +(주ì: <function>mysql_pconnect</function>ë¡ ì´ë ¤ì§ ë§í¬ë <function>mysql_close</function>í¨ìë¡ ë«ì§ë 못íë¤.) + </para> + <para> +ê·¸ë¬ë¯ë¡, ì´ ííì ë§í¬ë¥¼ 'ì구ì (persistent)'ì¼ë¡ ë¶ë¥¸ë¤. + </para> + </refsect1> + </refentry> + <refentry id="function.mysql-query"> + <refnamediv> + <refname>mysql_query</refname> + <refpurpose>Send a MySQL query</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_query</function> + </funcdef> + <paramdef>string <parameter>query</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_query</function>ë íì¬ ìë²ìì ëìì¤ì¸ ë°ì´í°ë² ì´ì¤ë¡ë¶í° + í¹ì link identifierë¡ ì§ì를 ì ì¡íë¤. +ë§ì¼, <parameter>link_identifier</parameter>를 ì¤ì íì§ ìì¼ë©´ ê°ì¥ ìµê·¼ì ì´ë ¤ì§ link를 ì¬ì©íê² ëë¤. +ì´ë ¤ì§ linkê° ìì¼ë©´, ìµì ì¸ì ìì´ ì¤íë <function>mysql_connect</function>í¨ìì²ë¼ +link를 ìì±íì¬ ì¬ì©íë¤. + </para> + <note> + <para> +ì§ìì ì°ì´ë 문ìì´ ë§ì§ë§ì ì¸ë¯¸ì½ë¡ (;)를 ë¶ì´ë©´ ìëë¤. </para> - </note> - <para> - <function>mysql_query</function> 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. + </note> + <para> + <function>mysql_query</function>í¨ìë ì§ì ì±ê³µ ì¬ë¶ì ë°ë¼ TRUE(0ì´ ìëê°) ëë FALSE를 ë°ííë¤. +ìë²ë¡ë¶í° ì¤íë ì§ìê° ì¤íëê³ ê·¸ ì§ì ë´ì©ì 문ì ê° ìì´ì¼ë§, TRUEê°ì ë°ííë¤. +ì´ ë°í ê°ì ì§ìì í´ë¹íë ì´ ê°ì ë±ê³¼ë ê´ë ¨ì´ ìë¤. </para> - <para> - The following query is syntactically invalid, so - <function>mysql_query</function> fails and returns FALSE: + <para> +ë¤ì ì§ìë í린 문ì¥ì´ê¸° ë문ì <function>mysql_query</function>ë ì¤í¨íë©°, FALSEê°ì ë°ííë¤: <example> - <title><function>mysql_query</function></title> - <programlisting role="php"> + <title> + <function>mysql_query</function> + </title> + <programlisting role="php"> <?php $result = mysql_query ("SELECT * WHERE 1=1") - or die ("Invalid query"); + or die ("ì못ë ì§ì를 ì¤ííìµëë¤!!"); ?> </programlisting> - </example> - </para> - <para> - The following query is semantically invalid if - <literal>my_col</literal> is not a column in the table - <literal>my_tbl</literal>, so <function>mysql_query</function> - fails and returns FALSE: + </example> + </para> + <para> + ë¤ì ì§ìë 문ë²ì ë§ì§ë§ ì¤ì ë¡ í ì´ë¸ <literal>my_tbl</literal>ì + í <literal>my_col</literal>ì´ ì기 ë문ì + <function>mysql_query</function>í¨ìë ì¤í¨íë©°, FALSEê°ì ë°ííë¤: <example> - <title><function>mysql_query</function></title> - <programlisting role="php"> + <title> + <function>mysql_query</function> + </title> + <programlisting role="php"> <?php $result = mysql_query ("SELECT my_col FROM my_tbl") - or die ("Invalid query"); + or die ("ì못ë ì§ì를 ì¤ííìµëë¤!!"); ?> </programlisting> - </example> - </para> - <para> - <function>mysql_query</function> will also fail and return FALSE - if you don't have permission to access the table(s) referenced by - the query. - </para> - <para> - Assuming the query succeeds, you can call - <function>mysql_num_rows</function> to find out how many rows - were returned for a SELECT statment or - <function>mysql_affected_rows</function> to find out how many - rows were affected by a DELETE, INSERT, REPLACE, or UPDATE - statement. - </para> - <para> - For SELECT statements, <function>mysql_query</function> returns a - new result identifier that you can pass to - <function>mysql_result</function>. When you are done with the - result set, you can free the resources associated with it by - calling <function>mysql_free_result</function>. Although, the - memory will automatically be freed at the end of the script's - execution. + </example> + </para> + <para> + <function>mysql_query</function>ë ì§ìë¡ ì°¸ì¡°ëë í ì´ë¸ì ëí ì ê·¼ ê¶íì´ ìë¤ë©´ ì¤í¨íë©°, FALSEê°ì ë°ííë¤. + </para> + <para> +ì§ìê° ì±ê³µíë©´ <function>mysql_num_rows</function>í¨ì를 ì¬ì©íì¬ SELECT문ì¼ë¡ ë°íëë íì ê°ì를 ì»ì ì ìì¼ë©°, +<function>mysql_affected_rows</function>í¨ì를 ì¬ì©íë©´, DELETE, INSERT, REPLACE, UPDATEë¡ ì ì©ë íì ê°ì를 ì»ì ì ìë¤. + </para> + <para> +SELECT문ì ìí´ <function>mysql_query</function>í¨ìë +<function>mysql_result</function>í¨ììì ì¬ì©í ì ìë ìë¡ì´ result identifier를 ë°ííë¤. +ê²°ê³¼ì ì ì¬ì©í í, <function>mysql_free_result</function>í¨ì를 ì¬ì©íì¬ ë©ëª¨ë¦¬ìì ì ê±°í ì ìë¤. +ê·¸ë¬ë, ì¤í¬ë¦½í¸ê° ì¢ ë£ëë ìì ì ìëì ì¼ë¡ ë©ëª¨ë¦¬ìì ì ê±°ê° ëë¤. </para> - <para> - See also: <function>mysql_affected_rows</function>, + <para> + 참조: <function>mysql_affected_rows</function>, <function>mysql_db_query</function>, <function>mysql_free_result</function>, <function>mysql_result</function>, - <function>mysql_select_db</function>, and + <function>mysql_select_db</function>, <function>mysql_connect</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-result"> - <refnamediv> - <refname>mysql_result</refname> - <refpurpose>Get result data</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>mixed <function>mysql_result</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>row</parameter></paramdef> - <paramdef>mixed - <parameter> - <optional>field</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_result</function> returns the contents of one - cell from a MySQL result set. The field argument can be the - field's offset, or the field's name, or the field's table dot - field's name (fieldname.tablename). If the column name has been - aliased ('select foo as bar from...'), use the alias instead of - the column name. </para> - <para> - When working on large result sets, you should consider using one - of the functions that fetch an entire row (specified below). As - these functions return the contents of multiple cells in one - function call, they're MUCH quicker than - <function>mysql_result</function>. Also, note that specifying a - numeric offset for the field argument is much quicker than - specifying a fieldname or tablename.fieldname argument. + </refsect1> + </refentry> + <refentry id="function.mysql-result"> + <refnamediv> + <refname>mysql_result</refname> + <refpurpose>ê²°ê³¼ ë°ì´í°ë¥¼ ë°í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>mixed <function>mysql_result</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>row</parameter> + </paramdef> + <paramdef>mixed + <parameter> + <optional>field</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_result</function>í¨ìë MySQL ê²°ê³¼ì ì¼ë¡ë¶í° íê°ì ì (cell) ë´ì©ì ë°ííë¤. +field ì¸ë¡ë íë offset ëë íëì´ë¦, í ì´ë¸ì´ë¦ê³¼ íëì´ë¦ ì¬ì´ì ì (í ì´ë¸ì´ë¦.íëì´ë¦)ì¼ë¡ ì°ê²°ë ì¸ì를 ì¬ì©í ì ìë¤. +ë§ì½, ì´(column)ì´ë¦ì´ ë³ëª ('select foo as bar from...')ì¼ë¡ ëì´ ìë¤ë©´ ì´ì´ë¦ ëì ë³ëª (alias)를 ì¬ì©í´ì¼íë¤. + </para> + <para> +í° ê²°ê³¼ì ì¼ë¡ ìì í ê²½ì°, ì ì²´ íì ì»ì´ì¤ë í¨ìì¤ íë를 ì¬ì©íë ê²ì´ ì¢ì ê²ì´ë¤. +ì´ í¨ìë¤ì í ë²ì í¨ì í¸ì¶ë¡ ë¤ì¤ ì ì ë´ì©ì ì»ì ì ìë ì¥ì ì´ ìì¼ë©°, +<function>mysql_result</function>í¨ìë³´ë¤ ë ë¹ ë¥´ë¤. +ëí íë ì¸ìë¡ ì«ì offsetì ì¬ì©íë©´ íëì´ë¦ ëë í ì´ë¸ì´ë¦.íëì´ë¦ ì¸ì를 ì¬ì©í ê²ë³´ë¤ ë ë¹ ë¥´ë¤. </para> - <para> - Calls to <function>mysql_result</function> should not be mixed - with calls to other functions that deal with the result set. + <para> + <function>mysql_result</function>í¨ì를 ì¬ì©íë©´ì ê²°ê³¼ì ì ë¤ë¥¸ í¨ììì í¨ê» ì¬ì©í ì ìë¤. </para> - <para> - Recommended high-performance alternatives: + <para> +ì±ë¥ í¥ìì ìí´ <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function>, and - <function>mysql_fetch_object</function>. - </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-select-db"> - <refnamediv> - <refname>mysql_select_db</refname> - <refpurpose>Select a MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>int <function>mysql_select_db</function></funcdef> - <paramdef>string <parameter>database_name</parameter></paramdef> - <paramdef>int - <parameter> - <optional>link_identifier</optional> - </parameter> - </paramdef> - </funcprototype> - </funcsynopsis> - <para> - Returns: true on success, false on error. + <function>mysql_fetch_array</function>, + <function>mysql_fetch_object</function>í¨ì를 ì¬ì©íë ê²ì´ ì¢ë¤. </para> - <para> - <function>mysql_select_db</function> sets the current active - database on the server that's associated with the specified link - identifier. If no link identifier is specified, the last opened - link is assumed. If no link is open, the function will try to - establish a link as if <function>mysql_connect</function> was - called, and use it. + </refsect1> + </refentry> + <refentry id="function.mysql-select-db"> + <refnamediv> + <refname>mysql_select_db</refname> + <refpurpose>MySQL ë°ì´í°ë² ì´ì¤ë¥¼ ì í</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_select_db</function> + </funcdef> + <paramdef>string <parameter>database_name</parameter> + </paramdef> + <paramdef>int + <parameter> + <optional>link_identifier</optional> + </parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + ë°íê°: ì±ê³µíë©´ TRUEê°, ì¤í¨íë©´ ìë¬ë°ì. + </para> + <para> + <function>mysql_select_db</function>í¨ìë link identifierë¡ ì§ì ë ì°ê²°ì ì´ì©íì¬ + ì¬ì©ê°ë¥í ë°ì´í°ë² ì´ì¤ë¥¼ ì ííë¤. + link identifier를 ì§ì íì§ ìì¼ë©´ ìµê·¼ ì´ë ¤ì§ link를 ì¬ì©íë¤. + ë§ì½ ì´ë ¤ì§ linkê° ìë¤ë©´, + <function>mysql_connect</function>를 í¸ì¶íë©´ + <function>mysql_connect</function>í¨ìê° í¸ì¶ëë©° link를 ìì±íë©°, ì´ë¥¼ ì¬ì©íë¤. </para> - <para> - Every subsequent call to <function>mysql_query</function> will be - made on the active database. + <para> + Every subsequent call to <function>mysql_query</function> will be made on the active database. </para> - <para> See also: + <para>참조: <function>mysql_connect</function>, - <function>mysql_pconnect</function>, and + <function>mysql_pconnect</function>, <function>mysql_query</function>. </para> - <para> - For downward compatibility <function>mysql_selectdb</function> - can also be used. + <para> + íì í¸íì±ì ê°ì§ë <function>mysql_selectdb</function>í¨ì ìì ì¬ì© ê°ë¥íë¤. </para> - </refsect1> - </refentry> - - <refentry id="function.mysql-tablename"> - <refnamediv> - <refname>mysql_tablename</refname> - <refpurpose>Get table name of field</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcprototype> - <funcdef>string <function>mysql_tablename</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>i</parameter></paramdef> - </funcprototype> - </funcsynopsis> - <para> - <function>mysql_tablename</function> takes a result pointer - returned by the <function>mysql_list_tables</function> function - as well as an integer index and returns the name of a table. The - <function>mysql_num_rows</function> function may be used to - determine the number of tables in the result pointer. + </refsect1> + </refentry> + <refentry id="function.mysql-tablename"> + <refnamediv> + <refname>mysql_tablename</refname> + <refpurpose>íëì í ì´ë¸ì´ë¦ì ì»ì</refpurpose> + </refnamediv> + <refsect1> + <title>ì¤ëª </title> + <funcsynopsis> + <funcprototype> + <funcdef>string <function>mysql_tablename</function> + </funcdef> + <paramdef>int <parameter>result</parameter> + </paramdef> + <paramdef>int <parameter>i</parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_tablename</function>í¨ìë ì¸ìë¡ +<function>mysql_list_tables</function>í¨ìë¡ ë°íëë ê²°ê³¼ í¬ì¸í°ì ëìì +í ì´ë¸ì´ë¦ì ë°ííê³ ì ìí ì¸ë±ì¤ë¥¼ ê°ì§ë¤. +<function>mysql_num_rows</function>í¨ìë ê²°ê³¼ í¬ì¸í°ìì í ì´ë¸ ê°ì를 ì»ëë° ì¬ì©ëë¤. <example> - <title><function>Mysql_tablename</function> Example</title> - <programlisting role="php"> + <title> + <function>Mysql_tablename</function> ìì </title> + <programlisting role="php"> <?php mysql_connect ("localhost:3306"); $result = mysql_list_tables ("wisconsin"); @@ -1857,13 +1795,11 @@ } ?> </programlisting> - </example> - </para> - </refsect1> - </refentry> - - </reference> - + </example> + </para> + </refsect1> + </refentry> +</reference> <!-- Keep this comment at the end of the file Local variables: mode: sgml @@ -1879,4 +1815,4 @@ sgml-local-catalogs:nil sgml-local-ecat-files:nil End: ---> +--> \ No newline at end of file