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 ?>