php中创建用户和数据库的连接

来源：互联网发布：武汉天融信网络编辑：程序博客网时间：2024/05/23 02:00

1.数据库的连接问题

//数据库连接
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PWD','yangfan');
define('DB_NAME','testguest');

//创建数据库连接
$_conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD) or die('数据里连接失败');

//选择一款数据库
mysql_select_db(DB_NAME) or die('指定的数据库不存在');

//选择字符集
mysql_query('SET NAMES UTF8') or die('字符集错误');

2.新增用户

//测试新增用户

mysql_query("insert into tg_user(tg_username) values(‘小小’)")or die('执行失败');

//在新增之前，要判断用户名是否重复
   $query = mysql_query("SELECT tg_username FROM tg_user WHERE tg_username='{$_clean['username']}'") or die('SQL错误');
   if (mysql_fetch_array($query,MYSQL_ASSOC)) {
       _alert_back('对不起，此用户已被注册！');
   }
   //新增用户 //在双引号里，直接放变量是可以的，比如$_username,但如果是数组，就必须加上{} ，比如 {$_clean['username']}
   mysql_query(
                       "INSERT INTO tg_user (
                                                               tg_uniqid,
                                                               tg_active,
                                                               tg_username,
                                                               tg_password,
                                                               tg_question,
                                                               tg_answer,
                                                               tg_sex,
                                                               tg_face,
                                                               tg_email,
                                                               tg_qq,
                                                               tg_url,
                                                               tg_reg_time,
                                                               tg_last_time,
                                                               tg_last_ip
                                                               )
                                               VALUES (
                                                               '{$_clean['uniqid']}',
                                                               '{$_clean['active']}',
                                                               '{$_clean['username']}',
                                                               '{$_clean['password']}',
                                                               '{$_clean['question']}',
                                                               '{$_clean['answer']}',
                                                               '{$_clean['sex']}',
                                                               '{$_clean['face']}',
                                                               '{$_clean['email']}',
                                                               '{$_clean['qq']}',
                                                               '{$_clean['url']}',
                                                               NOW(),
                                                               NOW(),
                                                               '{$_SERVER["REMOTE_ADDR"]}'
                                                               )"
   ) or die('SQL执行错误');
   //关闭
   mysql_close();
   //跳转
   _location('恭喜你，注册成功！','index.php');
} else {
   $_SESSION['uniqid'] = $_uniqid = _sha1_uniqid();
}

0 0