MySQL数据库函数详解(5)


(17) string mysql_field_table(int result_id, int col_num);
返回结果集给定列的表名。对于计算列,此名为空。
col_num的范围为0到mysql_num_fields()-1.

1   
2$link=mysql_pconnect("localhost","sunsoft","suixiang") or die("Could not connect");   
3mysql_select_db("stamp_db");   
4$query="SELECT * FROM president";   
5$result=mysql_query($query) or die("Query failed");   
6for($i=0;$i

<mysql_num_fields($result);$i++) ",mysql_field_name($result,$i));="" ",mysql_field_nmae($result,$i));="" $d:",$i);="" %s="" print"<br="" print("column="" printf("name="" printf("table="" {="">
";

1  
2  
3(18) string mysql_field_type(int result_id, int col_num);   
4返回结果集给定列的类型名。类型名敬请等待参考本人的另外“MySQL列类型参考”。   
5col_num的范围为0到mysql_num_fields()-1.   
6  

$link=pconnect("localhost","sunsoft","suixiang") or die("Could not connect");
mysql_select_db("stamp_db");
$query="SELECT * FROM president";
$result=mysql_query($query) or die("Query failed");
for($i=0;$i<mysql_num_fields($result);$i++) ",mysql_field_len($result,$i));="" ",mysql_field_name($result,$i));="" ",mysql_field_type($result,$i));="" ",mysql_fields_flags($result,$i));="" ",mysql_fields_name($result,$i));="" $link='mysql_pconnect("localhost","sunsoft","suixiang")' $query="SELECT * FROM member" $result="mysql_query($query)" %d="" %d:",$i);="" %s="" %s,="" (19)="" (20)="" ;="" ```="" col_num);="" col_num的范围为0到mysql_num_fields()-1.="" connect");="" die("could="" die("query="" failed");="" field_offset);="" for($i="0;$i<mysql_num_fields($result);$i++)" int="" mysql_field_flags(int="" mysql_field_len(int="" mysql_select_db("stamp_db");="" not="" or="" print"<br="" printf("colum="" printf("column="" printf("flags="" printf("len="" printf("name="" printf("type="" result,="" result_id,="" string="" {="" }="" 作为字符串返回结果集中给定列的相关元数据信息,如果出现错误,则返回假。这个字符串由以空格分开的词="" 组成,说明哪个列的标记值为真。对于假的标记,在字符串中给出相应的词。="" 返回结果集给定列中值可能的最大长度。="">
";
}

Published At
Categories with 数据库类
comments powered by Disqus