cvs: phpdoc-cs /reference/mysql/functions mysql-fetch-assoc.xml mysql-fetch-field.xml

costra Thu Apr 17 11:43:51 2003 EDT Modified files: /phpdoc-cs/reference/mysql/functions mysql-fetch-assoc.xml mysql-fetch-field.xml Log: update from en Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml:1.3 phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml:1.4 --- phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml:1.3 Sat Jun 8 11:48:22 2002 +++ phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml Thu Apr 17 11:43:51 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-2"?> -<!-- splitted from ./cs/functions/mysql.xml, last change in rev 1.1 --> -<!-- last change to 'mysql-fetch-assoc' in en/ tree in rev 1.45 --> +<!-- EN-Revision: 1.5 Maintainer: costra Status: ready --> <refentry id="function.mysql-fetch-assoc"> <refnamediv> <refname>mysql_fetch_assoc</refname> @@ -41,19 +40,50 @@ hodnotou. </para> <example> - <title><function>mysql_fetch_assoc</function></title> + <title>Roz¹íøený pøíklad <function>mysql_fetch_assoc</function></title> <programlisting role="php"> <![CDATA[ <?php -mysql_connect($host, $user, $password); -mysql_select_db($databaze); -$query = "select * from tabulka"; -$result = mysql_query($query); -while ($row = mysql_fetch_assoc($result)) { - echo $row["uziv_id"]; - echo $row["celejmeno"]; -} -mysql_free_result($result); + + $conn = mysql_connect("localhost", "mysql_user", "mysql_password"); + + if (!$conn) { + echo "Nelze se spojit s DB: " . mysql_error(); + exit; + } + + if (!mysql_select_db("mydbname")) { + echo "Nelze vybrat mydbname: " . mysql_error(); + exit; + } + + $sql = "SELECT id as userid, fullname, userstatus + FROM sometable + WHERE userstatus = 1"; + + $result = mysql_query($sql); + + if (!$result) { + echo "Zpracování dotazu nebylo úspì¹né ($sql) na DB: " . mysql_error(); + exit; + } + + if (mysql_num_rows($result) == 0) { + echo "Nenalezeny ¾ádné øádky, nic k zobrazení, tak¾e konèím."; + exit; + } + + // Pokud nìjaké záznamy dat existují, vloz¾í ka¾dý záznam do asociativního pole $row. + // Tip: Oèekáváte-li pouze jeden záznam, mù¾ete vynechat smyèku. + // Tip: Pøidáte-li do následující smyèky extract($row);, vytvoøí se rovnou promìnné $userid, $fullname a $userstatus + while ($row = mysql_fetch_assoc($result)) { + echo $row["userid"]; + echo $row["fullname"]; + echo $row["userstatus"]; + } + + mysql_free_result($result); + ?> ]]> </programlisting> @@ -61,8 +91,9 @@ <para> Pro dal¹í detaily viz. také <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function> a - <function>mysql_query</function>. + <function>mysql_fetch_array</function>, + <function>mysql_query</function> a + <function>mysql_error</function>. </para> </refsect1> </refentry> Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml:1.4 phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml:1.5 --- phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml:1.4 Sat Jun 8 11:48:22 2002 +++ phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml Thu Apr 17 11:43:51 2003 @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="iso-8859-2"?> -<!-- splitted from ./cs/functions/mysql.xml, last change in rev 1.1 --> -<!-- last change to 'mysql-fetch-field' in en/ tree in rev 1.2 --> +<!-- EN-Revision: 1.4 Maintainer: costra Status: ready --> <refentry id="function.mysql-fetch-field"> <refnamediv> <refname>mysql_fetch_field</refname> @@ -97,19 +96,19 @@ <![CDATA[ <?php mysql_connect('localhost:3306', $user, $password) - or die ("Nelze se pøipojit"); + or die ("Nelze se pøipojit: " . mysql_error()); mysql_select_db("databaze"); $result = mysql_query("select * from tabulka") - or die("Chyba dotazu"); + or die("Chyba dotazu: " . mysql_error()); # vrátí informace o sloupci $i = 0; while ($i < mysql_num_fields($result)) { - echo "Informace pro sloupec $i:<BR>\n"; + echo "Informace pro sloupec $i:<br />\n"; $meta = mysql_fetch_field($result); if (!$meta) { - echo "Nejsou dostupné ¾ádné informace<BR>\n"; + echo "Nejsou dostupné ¾ádné informace<br />\n"; } - echo "<PRE> + echo "<pre> blob: $meta->blob max_length: $meta->max_length multiple_key: $meta->multiple_key @@ -122,7 +121,7 @@ unique_key: $meta->unique_key unsigned: $meta->unsigned zerofill: $meta->zerofill -</PRE>"; +</pre>"; $i++; } mysql_free_result($result);