cvs: phpdoc /en/reference/mysql/functions mysql-field-type.xml

georg Mon Apr 22 02:10:45 2002 EDT Modified files: /phpdoc/en/reference/mysql/functions mysql-field-type.xml Log: changed example and inserted <screen> section for output Index: phpdoc/en/reference/mysql/functions/mysql-field-type.xml diff -u phpdoc/en/reference/mysql/functions/mysql-field-type.xml:1.2 phpdoc/en/reference/mysql/functions/mysql-field-type.xml:1.3 --- phpdoc/en/reference/mysql/functions/mysql-field-type.xml:1.2 Wed Apr 17 02:41:11 2002 +++ phpdoc/en/reference/mysql/functions/mysql-field-type.xml Mon Apr 22 02:10:44 2002 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-field-type"> <refnamediv> @@ -27,28 +27,39 @@ <programlisting role="php"> <![CDATA[ <?php -mysql_connect("localhost:3306"); -mysql_select_db("wisconsin"); -$result = mysql_query("SELECT * FROM onek"); -$fields = mysql_num_fields($result); -$rows = mysql_num_rows($result); -$i = 0; -$table = mysql_field_table($result, $i); -echo "Your '".$table."' table has ".$fields." fields and ".$rows." records <br />"; -echo "The table has the following fields <br />"; -while ($i < $fields) { - $type = mysql_field_type($result, $i); - $name = mysql_field_name($result, $i); - $len = mysql_field_len($result, $i); - $flags = mysql_field_flags($result, $i); - echo $type." ".$name." ".$len." ".$flags."<br />"; - $i++; -} -mysql_close(); - + mysql_connect("localhost", "mysql_username", "mysql_password"); + mysql_select_db("mysql"); + $result = mysql_query("SELECT * FROM func"); + $fields = mysql_num_fields($result); + $rows = mysql_num_rows($result); + $table = mysql_field_table($result, 0); + echo "Your '".$table."' table has ".$fields." fields and ".$rows." record(s)\n"; + echo "The table has the following fields:\n"; + for ($i=0; $i < $fields; $i++) { + $type = mysql_field_type($result, $i); + $name = mysql_field_name($result, $i); + $len = mysql_field_len($result, $i); + $flags = mysql_field_flags($result, $i); + echo $type." ".$name." ".$len." ".$flags."\n"; + } + mysql_free_result($result); + mysql_close(); ?> ]]> </programlisting> + <para> + The abouve example would produce the following output: + </para> + <screen> +<![CDATA[ +Your 'func' table has 4 fields and 1 record(s) +The table has the following fields: +string name 64 not_null primary_key binary +int ret 1 not_null +string dl 128 not_null +string type 9 not_null enum +]]> + </screen> </example> </para> <para>