mysqlphp数据库
<code> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>注册</title>
<?php if(isset($_POST["Submit"]) && $_POST["Submit"] == "注册") { $user = $_POST["username"]; $psw = $_POST["password"]; $psw_confirm = $_POST["confirm"]; if($user == "" || $psw == "" || $psw_confirm == "") { echo "<script>alert('请确认信息完整性！'); history.go(-1);"; } else { if($psw == $psw_confirm) { mysql_connect("localhost","root",""); //连接数据库 mysql_select_db("用户表"); //选择数据库 mysql_query("set names 'gdk'"); //设定字符集 $sql = "select username from user where username = '$_POST[username]'"; //SQL语句 $result = mysql_query($sql); //执行SQL语句 $num = mysql_num_rows($result);</code>
<code> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>登陆</title>
<?php if(isset($_POST["submit"]) && $_POST["submit"] == "登陆") { $user = $_POST["username"]; $psw = $_POST["password"]; if($user == "" || $psw == "") { echo "<script>alert('请输入用户名或密码！'); history.go(-1);"; } else { mysql_connect("localhost","root",""); mysql_select_db("用户表"); mysql_query("set names 'gbk'"); $sql = "select username,password from user where username = '$_POST[username]' and password = '$_POST[password]'"; $result = mysql_query($sql); $num = mysql_num_rows($result);</code>
