【php开源代码栏目提醒】:网学会员鉴于大家对php开源代码十分关注,论文会员在此为大家搜集整理了“code7.31.php”一文,供大家参考学习
<?php
$con = mysql_connect("localhost", "root", "0");
if (!$con)
{
die('连接数据库失败的原因是: ' . mysql_error());
}
mysql_select_db("db_student",$con);
$sql = "select * from student";
$result = mysql_query($sql);
$zd = mysql_field_name($result,1);
echo "字段".$zd."的长度是:".my
sql_field_len($result,1)."<br/>";
echo "字段".$zd."的类型是:".
mysql_field_type($result,1)."<br/>";
echo "字段".$zd."所在的表名:".$tableName=mysql_field_table($result,1);
echo "<br/>";
echo "表".$tableName."共有<font color='red'>".mysql_numfields($result)."</font>个字段<br/>";
$columns= mysql_list_fields("db_student","student",$con);
for ($i = 0; $i < $columns; $i++)
{
echo "字段".mysql_field_name($result, $i) . "关联的标志是:".mysql_field_flags($result,$i)."<br/>";
}
mysql_close($con);
?>