MySQL数据库函数详解(3)

(12) array mysql_fetch_lengths(int result);

　　本函式将 mysql_fetch_row() 处理过的最后一列资料的各栏位资料最大长度放在阵列变数之中。若执行失败则传回 false 值。传回阵列的第一笔资料索引值是 0。


$link=mysql_pconnect("localhost","sunsoft","suixiang")
or die("Could not connect");

mysql_select_db("stamp_db") or die("Could not select database");


$query="SELECT * FROM president" or die("Query failed");

$row_num=0;

while(mysql_fetch_row($result))

{

++$row_num;

printf("Lengths of values in row %d:


",$row_num);

$len=mysql_fetch_lengths($result);

if(!$len)

{

print("No information available


");

break;

}

print("

"); 


for($i=0;$i

printf("Column %d: %s


",$i,$len[$i]); 


print("

");

}

?>

上一页  [1] [2] [3] [4] 下一页