【php开源代码栏目提醒】:以下是网学会员为您推荐的php开源代码-code7.5.1.php,希望本篇文章对您学习有所帮助。
<fieldset>
<legend>1.mysql_error()函数</legend>
<?php
mysql_connect("localhost","root","0");
mysql_select_db("MyStudent");
echo mysql_error()."<br/>";
$sqlText = "select * from Student";
mysql_query($sqlText);
echo mysql_error()."<br/>";
mysql_close();
?>
</fieldset>
<fieldset>
<legend>2.mysql_errno()函数</legend>
<?php
$con = mysql_connect("localhost","myroot","root");
if(!$con)
{
echo "不能连接数据的错误信息编号:".mysql_errno()."<br/>";
echo "不能连接数据库的错误信息为:".mysql_error();
}
?>
</fieldset>
<h2>获取字段信息</h2>
<fieldset>
<legend>2.mysql_num_fields()函数</legend>
<?php
$con = mysql_connect("localhost", "root", "0");
if (!$con)
{
die('连接数据库出错的原因: ' . mysql_error());
}
mysql_select_db("db_student");
$result = mysql_query("select * from student");
echo "表student中共有".mysql_num_fields($result)."个字段";
mysql_close();
?>
</fieldset>
<fieldset>
<legend>3.mysql_list_fields()函数</legend>
<?php
$con = mysql_connect('localhost', 'root', '0');
$fields = mysql_list_fields("db_student", "student", $con);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++)
{
echo mysql_field_name($fields, $i) . "<br>";
}
?>
</fieldset>
<fieldset>
<legend>4.mysql_field_flags()函数</legend>
<?php
$con = mysql_connect("localhost", "root", "0");
if (!$con)
{
die('连接数据库失败的原因是: ' . mysql_error());
}
$db_selected = mysql_select_db("db_student",$con);
$sql = "SELECT * from student";
$result = mysql_query($sql,$con);
$flags = mysql_field_flags($result, 0);
echo $flags;
mysql_close($con);
?>
</fieldset>