cvs: phpdoc-de /reference/mysql/functions mysql-affected-rows.xml mysql-close.xml mysql-connect.xml mysql-create-db.xml mysql-data-seek.xml
mysql-fetch-array.xml mysql-fetch-assoc.xml mysql-fetch-field.xml mysql-field-name.xml mysql-get-host-info.xml mysql-get-proto-info.xml
mysql-get-server-info.xml mysql-insert-id.xml mysql-query.xml mysql-stat.xml
| From: | Friedhelm Betz | Date: | Wed, 22 Jan 2003 00:45:40 +0000 |
| Subject: | cvs: phpdoc-de /reference/mysql/functions mysql-affected-rows.xml mysql-close.xml mysql-connect.xml mysql-create-db.xml mysql-data-seek.xml mysql-fetch-array.xml mysql-fetch-assoc.xml mysql-fetch-field.xml mysql-field-name.xml mysql-get-host-info.xml mysql-get-proto-info.xml mysql-get-server-info.xml mysql-insert-id.xml mysql-query.xml mysql-stat.xml |
||
| Groups: | php.doc.de | ||
| Request: | Send a blank email to doc-de+get-446@lists.php.net to get a copy of this message | ||
betz Tue Jan 21 19:45:40 2003 EDT
Modified files:
/phpdoc-de/reference/mysql/functions mysql-affected-rows.xml
mysql-close.xml
mysql-connect.xml
mysql-create-db.xml
mysql-data-seek.xml
mysql-fetch-array.xml
mysql-fetch-assoc.xml
mysql-fetch-field.xml
mysql-field-name.xml
mysql-get-host-info.xml
mysql-get-proto-info.xml
mysql-get-server-info.xml
mysql-insert-id.xml
mysql-query.xml mysql-stat.xml
Log:
sync to en
Index: phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml diff -u phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml:1.4 Sun Jun 9 06:55:56 2002 +++ phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.6 Maintainer: betz Status: ready --> <refentry id="function.mysql-affected-rows"> <refnamediv> @@ -63,7 +63,7 @@ <?php /* Verbindung zur Datenabank */ mysql_pconnect("localhost", "mysql_user", "mysql_password") or - die ("Keine Verbindung möglich"); + die ("Keine Verbindung möglich: " : . mysql_error()); /* Das sollte die korrekte Anzahl gelöschter Datensätze liefern */ mysql_query("DELETE FROM mytable WHERE id < 10"); @@ -92,7 +92,7 @@ <?php /* Verbindung zur Datenabank */ mysql_pconnect("localhost", "mysql_user", "mysql_password") or - die ("Could not connect"); + die ("Keine Verbindung möglich: " : . mysql_error()); /* Update von Datensätzen */ mysql_query("UPDATE mytable SET used=1 WHERE id < 10"); @@ -113,7 +113,7 @@ </para> <para> Siehe auch: <function>mysql_num_rows</function>, - <function>mysql_info</function>. + <function>mysql_info</function>. </para> </refsect1> </refentry> Index: phpdoc-de/reference/mysql/functions/mysql-close.xml diff -u phpdoc-de/reference/mysql/functions/mysql-close.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-close.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-close.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-close.xml Tue Jan 21 19:45:39 2003 @@ -1,9 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- splitted from ./de/functions/mysql.xml, last change in rev 1.2 --> -<!-- last change to 'mysql-close' in en/ tree in rev 1.2 --> -<!-- EN-Revision: 1.2 Maintainer: betz Status: ready --> -<!-- OLD-Revision: 1.82/EN.1.2 --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> <refentry id="function.mysql-close"> <refnamediv> <refname>mysql_close</refname> @@ -45,7 +42,7 @@ <![CDATA[ <?php $link = mysql_connect ("localhost", "mysql_user", "mysql_password") - or exit ("keine Verbindung möglich"); + or exit ("keine Verbindung möglich: " .mysql_error()); print ("Verbindung erfolgreich"); mysql_close ($link); ?> Index: phpdoc-de/reference/mysql/functions/mysql-connect.xml diff -u phpdoc-de/reference/mysql/functions/mysql-connect.xml:1.5 phpdoc-de/reference/mysql/functions/mysql-connect.xml:1.6 --- phpdoc-de/reference/mysql/functions/mysql-connect.xml:1.5 Sat Jul 20 07:21:31 2002 +++ phpdoc-de/reference/mysql/functions/mysql-connect.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.6 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-connect"> <refnamediv> @@ -85,7 +85,7 @@ <![CDATA[ <?php $link = mysql_connect ("localhost", "mysql_user", "mysql_password") - or die ("keine Verbindung möglich"); + or die ("keine Verbindung möglich: " .mysql_error()); print ("Verbindung erfolgreich"); mysql_close ($link); ?> Index: phpdoc-de/reference/mysql/functions/mysql-create-db.xml diff -u phpdoc-de/reference/mysql/functions/mysql-create-db.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-create-db.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-create-db.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-create-db.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-create-db"> <refnamediv> @@ -29,7 +29,7 @@ <![CDATA[ <?php $link = mysql_pconnect ("localhost", "mysql_user", "mysql_password") - or exit ("keine Verbindung möglich"); + or die ("keine Verbindung möglich: ". mysql_error()); if (mysql_create_db ("meine_db")) { print ("Datenbank erfolgreich angelegt\n"); Index: phpdoc-de/reference/mysql/functions/mysql-data-seek.xml diff -u phpdoc-de/reference/mysql/functions/mysql-data-seek.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-data-seek.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-data-seek.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-data-seek.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-data-seek"> <refnamediv> @@ -42,10 +42,10 @@ <![CDATA[ <?php $link = mysql_pconnect ("localhost", "mysql_user", "mysql_password") - or die ("Keine Verbindung möglich"); + or die ("Keine Verbindung möglich: " . mysql_error()); mysql_select_db ("samp_db") - or die ("Auswahl der Datenbank nicht möglich"); + or die ("Auswahl der Datenbank nicht möglich: " . mysql_error()); $query = "SELECT nach_name, vor_name FROM freunde"; $result = mysql_query ($query) @@ -55,7 +55,7 @@ for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) { if (!mysql_data_seek ($result, $i)) { - echo "Cannot seek to row $i\n"; + echo "Cannot seek to row $i . mysql_error() . "\n"; continue; } Index: phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml diff -u phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.6 Maintainer: betz Status: ready --> <refentry id="function.mysql-fetch-array"> <refnamediv> @@ -72,7 +72,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); @@ -92,7 +92,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); @@ -112,7 +112,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); Index: phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml diff -u phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-fetch-assoc"> <refnamediv> @@ -47,19 +47,56 @@ sichtlichen Mehrwert bietet. </para> <example> - <title><function>mysql_fetch_assoc</function> Beispiel</title> + <title> + Ein ausführliches Beispiel zu<function>mysql_fetch_assoc</function> + </title> <programlisting role="php"> <![CDATA[ <?php - mysql_connect("localhost", "mysql_user", "mysql_password"); - mysql_select_db("mydb"); - $query = "select * from table"; - $result = mysql_query($query); + + $conn = mysql_connect("localhost", "mysql_user", "mysql_password"); + + if (!$conn) { + echo "Keine Verbindung zur DB: " . mysql_error(); + exit; + } + + if (!mysql_select_db("mydbname")) { + echo "Kann mydbname nicht auswählen: " . mysql_error(); + exit; + } + + $sql = "SELECT id as userid, fullname, userstatus + FROM sometable + WHERE userstatus = 1"; + + $result = mysql_query($sql); + + if (!$result) { + echo "Anfrage ($sql) konnte nicht ausgeführt werden : " . mysql_error(); + exit; + } + + if (mysql_num_rows($result) == 0) { + echo "Keine Zeilen gefunden, nichts auszugeben, daher Abbruch"; + exit; + } + + // Solange eine Zeile mit Daten existiert, wird dies in dem + // assoziativen Array $row abgelegt. + // Anmerkung: Wenn Sie nur eine Zeile erwarten, brauchen Sie keine Schleife. + // Anmerkung: Wenn Sie extract($row) inner halb der folgenden + // Schleife verwenden, können Sie damit die Variablen + // $userid, $fullname und $userstatus erzeugen. + while ($row = mysql_fetch_assoc($result)) { - echo $row["user_id"]; + echo $row["userid"]; echo $row["fullname"]; + echo $row["userstatus"]; } + mysql_free_result($result); + ?> ]]> </programlisting> @@ -67,8 +104,9 @@ <para> Für weitere Details, siehe auch <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function> und - <function>mysql_query</function>. + <function>mysql_fetch_array</function>, + <function>mysql_query</function> und + <function>mysql_error</function> </para> </refsect1> </refentry> Index: phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml diff -u phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-fetch-field"> <refnamediv> @@ -98,10 +98,10 @@ <![CDATA[ <?php mysql_connect('localhost:3306', $user, $password) - or die ("Keine Verbindung möglich"); + or die ("Keine Verbindung möglich: ". mysql_error()); mysql_select_db("database"); $result = mysql_query("select * from table") - or die("Anfrage fehlgeschlagen"); + or die("Anfrage fehlgeschlagen: " . mysql_error()); /* Metadaten der Felder */ $i = 0; while ($i < mysql_num_fields($result)) { Index: phpdoc-de/reference/mysql/functions/mysql-field-name.xml diff -u phpdoc-de/reference/mysql/functions/mysql-field-name.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-field-name.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-field-name.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-field-name.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.2 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> <refentry id="function.mysql-field-name"> <refnamediv> @@ -40,11 +40,11 @@ /* Die Tabelle users enthält drei Felder: user_id username - password. + password */ $link = mysql_connect('localhost', "mysql_user", "mysql_password"); mysql_select_db($dbname, $link) - or die("Kann die Datenbank $dbname nicht auswählen"); + or die("Auswahl der Datenabnk $dbname fehlgeschlagen: " . mysql_error()); $res = mysql_query("select * from users", $link); echo mysql_field_name($res, 0) . "\n"; Index: phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml diff -u phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-get-host-info"> <refnamediv> @@ -27,7 +27,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); printf ("MySQL host info: %s\n", mysql_get_host_info()); ?> ]]> Index: phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml diff -u phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-get-proto-info"> <refnamediv> @@ -25,7 +25,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . myslq_error()); printf ("MySQL protocol version: %s\n", mysql_get_proto_info()); ?> ]]> Index: phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml diff -u phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml:1.3 phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml:1.4 --- phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml:1.3 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.3 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.4 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-get-server-info"> <refnamediv> @@ -25,7 +25,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); printf ("MySQL server version: %s\n", mysql_get_server_info()); ?> ]]> Index: phpdoc-de/reference/mysql/functions/mysql-insert-id.xml diff -u phpdoc-de/reference/mysql/functions/mysql-insert-id.xml:1.5 phpdoc-de/reference/mysql/functions/mysql-insert-id.xml:1.6 --- phpdoc-de/reference/mysql/functions/mysql-insert-id.xml:1.5 Sat Jul 20 07:21:31 2002 +++ phpdoc-de/reference/mysql/functions/mysql-insert-id.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> -<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> +<!-- $Revision: 1.6 $ --> +<!-- EN-Revision: 1.6 Maintainer: betz Status: ready --> <refentry id="function.mysql-insert-id"> <refnamediv> @@ -48,8 +48,27 @@ <literal>LAST_INSERT_ID()</literal> in einer SQL-Abfrage. </para> </warning> + <example> + <title>mysql_insert_id Beispiel</title> + <programlisting role="php"> +<![CDATA[ +<?php + mysql_connect("localhost", "mysql_user", "mysql_password") or + die("Keine Verbindung möglich: " . mysql_error()); + mysql_select_db("mydb"); + + mysql_query("INSERT INTO mytable (product) values ('kossu')"); + printf ("Der letzte eingefügte Datensatz hat die ID %d\n", mysql_insert_id()); +?> +]]> + </programlisting> + </example> + <para> + Siehe auch: <function>mysql_query</function>. + </para> </refsect1> </refentry> + <!-- Keep this comment at the end of the file Local variables: Index: phpdoc-de/reference/mysql/functions/mysql-query.xml diff -u phpdoc-de/reference/mysql/functions/mysql-query.xml:1.5 phpdoc-de/reference/mysql/functions/mysql-query.xml:1.6 --- phpdoc-de/reference/mysql/functions/mysql-query.xml:1.5 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-query.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.6 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-query"> <refnamediv> @@ -62,7 +62,7 @@ <![CDATA[ <php $result = mysql_query ("SELECT * WHERE 1=1") - or die ("Invalid query"); + or die ("Ungültige Abfrage: " . mysql_error()); ?> ]]> </programlisting> @@ -79,7 +79,7 @@ <![CDATA[ <?php $result = mysql_query ("SELECT my_col FROM my_tbl") - or die ("Invalid query"); + or die ("Ungültige Abfrage: " . mysql_error()); ?> ]]> </programlisting> Index: phpdoc-de/reference/mysql/functions/mysql-stat.xml diff -u phpdoc-de/reference/mysql/functions/mysql-stat.xml:1.6 phpdoc-de/reference/mysql/functions/mysql-stat.xml:1.7 --- phpdoc-de/reference/mysql/functions/mysql-stat.xml:1.6 Mon Nov 11 11:20:28 2002 +++ phpdoc-de/reference/mysql/functions/mysql-stat.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.6 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.7 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-stat"> <refnamediv> @@ -31,7 +31,7 @@ <![CDATA[ <?php $link = mysql_connect('localhost', "mysql_user", "mysql_password"); -$status = explode(' ',mysql_stat($link)); +$status = explode(' ', mysql_stat($link)); print_r($status); ?> ]]>
Index: phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml diff -u phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml:1.4 Sun Jun 9 06:55:56 2002 +++ phpdoc-de/reference/mysql/functions/mysql-affected-rows.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.6 Maintainer: betz Status: ready --> <refentry id="function.mysql-affected-rows"> <refnamediv> @@ -63,7 +63,7 @@ <?php /* Verbindung zur Datenabank */ mysql_pconnect("localhost", "mysql_user", "mysql_password") or - die ("Keine Verbindung möglich"); + die ("Keine Verbindung möglich: " : . mysql_error()); /* Das sollte die korrekte Anzahl gelöschter Datensätze liefern */ mysql_query("DELETE FROM mytable WHERE id < 10"); @@ -92,7 +92,7 @@ <?php /* Verbindung zur Datenabank */ mysql_pconnect("localhost", "mysql_user", "mysql_password") or - die ("Could not connect"); + die ("Keine Verbindung möglich: " : . mysql_error()); /* Update von Datensätzen */ mysql_query("UPDATE mytable SET used=1 WHERE id < 10"); @@ -113,7 +113,7 @@ </para> <para> Siehe auch: <function>mysql_num_rows</function>, - <function>mysql_info</function>. + <function>mysql_info</function>. </para> </refsect1> </refentry> Index: phpdoc-de/reference/mysql/functions/mysql-close.xml diff -u phpdoc-de/reference/mysql/functions/mysql-close.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-close.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-close.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-close.xml Tue Jan 21 19:45:39 2003 @@ -1,9 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- splitted from ./de/functions/mysql.xml, last change in rev 1.2 --> -<!-- last change to 'mysql-close' in en/ tree in rev 1.2 --> -<!-- EN-Revision: 1.2 Maintainer: betz Status: ready --> -<!-- OLD-Revision: 1.82/EN.1.2 --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> <refentry id="function.mysql-close"> <refnamediv> <refname>mysql_close</refname> @@ -45,7 +42,7 @@ <![CDATA[ <?php $link = mysql_connect ("localhost", "mysql_user", "mysql_password") - or exit ("keine Verbindung möglich"); + or exit ("keine Verbindung möglich: " .mysql_error()); print ("Verbindung erfolgreich"); mysql_close ($link); ?> Index: phpdoc-de/reference/mysql/functions/mysql-connect.xml diff -u phpdoc-de/reference/mysql/functions/mysql-connect.xml:1.5 phpdoc-de/reference/mysql/functions/mysql-connect.xml:1.6 --- phpdoc-de/reference/mysql/functions/mysql-connect.xml:1.5 Sat Jul 20 07:21:31 2002 +++ phpdoc-de/reference/mysql/functions/mysql-connect.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.6 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-connect"> <refnamediv> @@ -85,7 +85,7 @@ <![CDATA[ <?php $link = mysql_connect ("localhost", "mysql_user", "mysql_password") - or die ("keine Verbindung möglich"); + or die ("keine Verbindung möglich: " .mysql_error()); print ("Verbindung erfolgreich"); mysql_close ($link); ?> Index: phpdoc-de/reference/mysql/functions/mysql-create-db.xml diff -u phpdoc-de/reference/mysql/functions/mysql-create-db.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-create-db.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-create-db.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-create-db.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-create-db"> <refnamediv> @@ -29,7 +29,7 @@ <![CDATA[ <?php $link = mysql_pconnect ("localhost", "mysql_user", "mysql_password") - or exit ("keine Verbindung möglich"); + or die ("keine Verbindung möglich: ". mysql_error()); if (mysql_create_db ("meine_db")) { print ("Datenbank erfolgreich angelegt\n"); Index: phpdoc-de/reference/mysql/functions/mysql-data-seek.xml diff -u phpdoc-de/reference/mysql/functions/mysql-data-seek.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-data-seek.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-data-seek.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-data-seek.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-data-seek"> <refnamediv> @@ -42,10 +42,10 @@ <![CDATA[ <?php $link = mysql_pconnect ("localhost", "mysql_user", "mysql_password") - or die ("Keine Verbindung möglich"); + or die ("Keine Verbindung möglich: " . mysql_error()); mysql_select_db ("samp_db") - or die ("Auswahl der Datenbank nicht möglich"); + or die ("Auswahl der Datenbank nicht möglich: " . mysql_error()); $query = "SELECT nach_name, vor_name FROM freunde"; $result = mysql_query ($query) @@ -55,7 +55,7 @@ for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) { if (!mysql_data_seek ($result, $i)) { - echo "Cannot seek to row $i\n"; + echo "Cannot seek to row $i . mysql_error() . "\n"; continue; } Index: phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml diff -u phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-fetch-array.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.6 Maintainer: betz Status: ready --> <refentry id="function.mysql-fetch-array"> <refnamediv> @@ -72,7 +72,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); @@ -92,7 +92,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); @@ -112,7 +112,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); Index: phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml diff -u phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-fetch-assoc.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-fetch-assoc"> <refnamediv> @@ -47,19 +47,56 @@ sichtlichen Mehrwert bietet. </para> <example> - <title><function>mysql_fetch_assoc</function> Beispiel</title> + <title> + Ein ausführliches Beispiel zu<function>mysql_fetch_assoc</function> + </title> <programlisting role="php"> <![CDATA[ <?php - mysql_connect("localhost", "mysql_user", "mysql_password"); - mysql_select_db("mydb"); - $query = "select * from table"; - $result = mysql_query($query); + + $conn = mysql_connect("localhost", "mysql_user", "mysql_password"); + + if (!$conn) { + echo "Keine Verbindung zur DB: " . mysql_error(); + exit; + } + + if (!mysql_select_db("mydbname")) { + echo "Kann mydbname nicht auswählen: " . mysql_error(); + exit; + } + + $sql = "SELECT id as userid, fullname, userstatus + FROM sometable + WHERE userstatus = 1"; + + $result = mysql_query($sql); + + if (!$result) { + echo "Anfrage ($sql) konnte nicht ausgeführt werden : " . mysql_error(); + exit; + } + + if (mysql_num_rows($result) == 0) { + echo "Keine Zeilen gefunden, nichts auszugeben, daher Abbruch"; + exit; + } + + // Solange eine Zeile mit Daten existiert, wird dies in dem + // assoziativen Array $row abgelegt. + // Anmerkung: Wenn Sie nur eine Zeile erwarten, brauchen Sie keine Schleife. + // Anmerkung: Wenn Sie extract($row) inner halb der folgenden + // Schleife verwenden, können Sie damit die Variablen + // $userid, $fullname und $userstatus erzeugen. + while ($row = mysql_fetch_assoc($result)) { - echo $row["user_id"]; + echo $row["userid"]; echo $row["fullname"]; + echo $row["userstatus"]; } + mysql_free_result($result); + ?> ]]> </programlisting> @@ -67,8 +104,9 @@ <para> Für weitere Details, siehe auch <function>mysql_fetch_row</function>, - <function>mysql_fetch_array</function> und - <function>mysql_query</function>. + <function>mysql_fetch_array</function>, + <function>mysql_query</function> und + <function>mysql_error</function> </para> </refsect1> </refentry> Index: phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml diff -u phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-fetch-field.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-fetch-field"> <refnamediv> @@ -98,10 +98,10 @@ <![CDATA[ <?php mysql_connect('localhost:3306', $user, $password) - or die ("Keine Verbindung möglich"); + or die ("Keine Verbindung möglich: ". mysql_error()); mysql_select_db("database"); $result = mysql_query("select * from table") - or die("Anfrage fehlgeschlagen"); + or die("Anfrage fehlgeschlagen: " . mysql_error()); /* Metadaten der Felder */ $i = 0; while ($i < mysql_num_fields($result)) { Index: phpdoc-de/reference/mysql/functions/mysql-field-name.xml diff -u phpdoc-de/reference/mysql/functions/mysql-field-name.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-field-name.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-field-name.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-field-name.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.2 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> <refentry id="function.mysql-field-name"> <refnamediv> @@ -40,11 +40,11 @@ /* Die Tabelle users enthält drei Felder: user_id username - password. + password */ $link = mysql_connect('localhost', "mysql_user", "mysql_password"); mysql_select_db($dbname, $link) - or die("Kann die Datenbank $dbname nicht auswählen"); + or die("Auswahl der Datenabnk $dbname fehlgeschlagen: " . mysql_error()); $res = mysql_query("select * from users", $link); echo mysql_field_name($res, 0) . "\n"; Index: phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml diff -u phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-get-host-info.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-get-host-info"> <refnamediv> @@ -27,7 +27,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); printf ("MySQL host info: %s\n", mysql_get_host_info()); ?> ]]> Index: phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml diff -u phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml:1.4 phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml:1.5 --- phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml:1.4 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-get-proto-info.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.5 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-get-proto-info"> <refnamediv> @@ -25,7 +25,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . myslq_error()); printf ("MySQL protocol version: %s\n", mysql_get_proto_info()); ?> ]]> Index: phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml diff -u phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml:1.3 phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml:1.4 --- phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml:1.3 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-get-server-info.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.3 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.4 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-get-server-info"> <refnamediv> @@ -25,7 +25,7 @@ <![CDATA[ <?php mysql_connect("localhost", "mysql_user", "mysql_password") or - die("Keine Verbindung möglich"); + die("Keine Verbindung möglich: " . mysql_error()); printf ("MySQL server version: %s\n", mysql_get_server_info()); ?> ]]> Index: phpdoc-de/reference/mysql/functions/mysql-insert-id.xml diff -u phpdoc-de/reference/mysql/functions/mysql-insert-id.xml:1.5 phpdoc-de/reference/mysql/functions/mysql-insert-id.xml:1.6 --- phpdoc-de/reference/mysql/functions/mysql-insert-id.xml:1.5 Sat Jul 20 07:21:31 2002 +++ phpdoc-de/reference/mysql/functions/mysql-insert-id.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> -<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> +<!-- $Revision: 1.6 $ --> +<!-- EN-Revision: 1.6 Maintainer: betz Status: ready --> <refentry id="function.mysql-insert-id"> <refnamediv> @@ -48,8 +48,27 @@ <literal>LAST_INSERT_ID()</literal> in einer SQL-Abfrage. </para> </warning> + <example> + <title>mysql_insert_id Beispiel</title> + <programlisting role="php"> +<![CDATA[ +<?php + mysql_connect("localhost", "mysql_user", "mysql_password") or + die("Keine Verbindung möglich: " . mysql_error()); + mysql_select_db("mydb"); + + mysql_query("INSERT INTO mytable (product) values ('kossu')"); + printf ("Der letzte eingefügte Datensatz hat die ID %d\n", mysql_insert_id()); +?> +]]> + </programlisting> + </example> + <para> + Siehe auch: <function>mysql_query</function>. + </para> </refsect1> </refentry> + <!-- Keep this comment at the end of the file Local variables: Index: phpdoc-de/reference/mysql/functions/mysql-query.xml diff -u phpdoc-de/reference/mysql/functions/mysql-query.xml:1.5 phpdoc-de/reference/mysql/functions/mysql-query.xml:1.6 --- phpdoc-de/reference/mysql/functions/mysql-query.xml:1.5 Sun Jun 9 06:55:57 2002 +++ phpdoc-de/reference/mysql/functions/mysql-query.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> -<!-- EN-Revision: 1.3 Maintainer: betz Status: ready --> +<!-- $Revision: 1.6 $ --> +<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> <refentry id="function.mysql-query"> <refnamediv> @@ -62,7 +62,7 @@ <![CDATA[ <php $result = mysql_query ("SELECT * WHERE 1=1") - or die ("Invalid query"); + or die ("Ungültige Abfrage: " . mysql_error()); ?> ]]> </programlisting> @@ -79,7 +79,7 @@ <![CDATA[ <?php $result = mysql_query ("SELECT my_col FROM my_tbl") - or die ("Invalid query"); + or die ("Ungültige Abfrage: " . mysql_error()); ?> ]]> </programlisting> Index: phpdoc-de/reference/mysql/functions/mysql-stat.xml diff -u phpdoc-de/reference/mysql/functions/mysql-stat.xml:1.6 phpdoc-de/reference/mysql/functions/mysql-stat.xml:1.7 --- phpdoc-de/reference/mysql/functions/mysql-stat.xml:1.6 Mon Nov 11 11:20:28 2002 +++ phpdoc-de/reference/mysql/functions/mysql-stat.xml Tue Jan 21 19:45:39 2003 @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.6 $ --> -<!-- EN-Revision: 1.4 Maintainer: betz Status: ready --> +<!-- $Revision: 1.7 $ --> +<!-- EN-Revision: 1.5 Maintainer: betz Status: ready --> <refentry id="function.mysql-stat"> <refnamediv> @@ -31,7 +31,7 @@ <![CDATA[ <?php $link = mysql_connect('localhost', "mysql_user", "mysql_password"); -$status = explode(' ',mysql_stat($link)); +$status = explode(' ', mysql_stat($link)); print_r($status); ?> ]]>