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);