php连接数据库

<?php
    header('Content-Type:text/html; charset=utf-8');
    
    define('DB_HOST', 'localhost');
    define('DB_USER', 'root');
    define('DB_PWD', '密码');
    define('DB_NAME', '数据库名');
    
    $conn = @mysql_connect(DB_HOST, DB_USER, DB_PWD) or die('数据库链接失败：'.mysql_error());
    
    @mysql_select_db(DB_NAME) or die('数据库错误：'.mysql_error());
    
    @mysql_query('SET NAMES UTF8') or die('字符集错误：'.mysql_error());
?>

/*****************************
*数据库连接
*****************************/

header("Content-Type:text/html;charset=utf-8");
$conn = @mysql_connect("localhost","root","123456");
if (!$conn){
    die("连接数据库失败：" . mysql_error());
}
mysql_select_db("数据库名", $conn);
//字符转换，读库
mysql_query("set character set 'utf-8'");
//写库
mysql_query("set names 'utf-8'");

mysql_query("create table user
    (id int(10) not null auto_increment, 
    name varchar(30) CHARACTER SET utf8 not null DEFAULT '', 
    password varchar(30) not null, 
    age int(2), 
    address varchar(30),
    primary key(id)
    )ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
");

 1 <?php
 2 require 'config.php';
 3 $_pass = sha1($_POST['login_pass']);
 4 $query = mysql_query("SELECT user,pass FROM user WHERE
 5 user='{$_POST['login_user']}' AND pass='{$_pass}'") or die('SQL 错误！');
 6 if (mysql_fetch_array($query, MYSQL_ASSOC)) {
 7 echo 'true';
 8 } else {
 9 echo 'false';
10 }
11 mysql_close();
12 ?>