Bug #2661: mysql_fetch_field maxlength returns length of data, not max length of field
| From: | mbritton at verinet dot com | Date: | Thu, 04 Nov 1999 07:05:16 +0000 |
| Subject: | Bug #2661: mysql_fetch_field maxlength returns length of data, not max length of field | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-12114@lists.php.net to get a copy of this message | ||
From: mbritton@verinet.com
Operating system: Linux
PHP version: 3.0.12
PHP Bug Type: MySQL related
Bug description: mysql_fetch_field maxlength returns length of data, not max length of field
<?php
$host = "localhost";
$user = "nobody";
$database = "varsity";
$password = "";
$conn = mysql_connect($host,$user,$password);
$result = mysql_db_query($database,"select * from people");
while ($row = mysql_fetch_row($result)) {
for ( $i = 0; $i < mysql_num_fields($result); $i++ ) {
$field_info = mysql_fetch_field($result,$i);
print "field,len,value =
$field_info->name,$field_info->max_length,$row[$i]<BR>";
}
}
?>
---------------
OUTPUT:
field,len,value = person_id,1,1
field,len,value = lname,7,Britton
field,len,value = fname,5,Sandi
field,len,value = position,3,Mgr
---------------
Table Desc from mySQL:
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| person_id | int(11) | | PRI | 0 | auto_increment |
| lname | varchar(50) | YES | | NULL | |
| fname | varchar(50) | YES | | NULL | |
| position | varchar(50) | YES | | NULL | |
+-----------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql>