连接数据库

<?php
echo "<a href='news_user_del.php'>返回删除页面</a>"."<br>";
echo "<a href='news_user_add.php'>返回添加页面</a>"."<br>";
echo "<a href='news_user_query.php'>返回查询页面</a>"."<br>";
echo "<a href='news_main.php'>返回主页面</a>"."<br>";
$news_bt=$_POST['news_bt'];
$news_nr=$_POST['news_nr'];

//header("Content-Type:text/html; charset=gbk");
//连接数据库
$a=mysql_connect("127.0.0.1","root","") or die("连接失败");
//if($a){
//echo"连接成功"."<br>";
//}else{
//echo"连接失败"."<br>";
//}
//打开数据库
mysql_select_db("news",$a) or die("数据库打开错误");
mysql_query("set names 'utf8'");//使用utf8编码，文件要另存为utf8格式
//执行插入语句
$sql="insert into user values(null,'".$news_bt."','".$news_nr."')";
//echo $sql;
//返回布尔值鉴定是否插入成功
mysql_query($sql,$a);
//执行查询语句
$sql1="select * from user order by id desc";
//执行sql
$query=mysql_query($sql1,$a);
//echo $sql1;
//循环数组
while($array=mysql_fetch_array($query)){
echo $array['Id']."&nbsp;".$array['news_bt']."&nbsp;".$array['news_nr']."<br><hr>";
}
?>