登陆界面 login.php
01.<form action="logincheck.php" method="post">
02. 用户名:<input type="text" name="username" />
03. <br />
04. 密码:<input type="password" name="password" />
05. <br />
06. <input type="submit" name="submit" value="登陆" />
07.
08. <a href="register.php">注册</a>
09.</form>
登录处理界面 logincheck.php
01.<?php
02. if(isset($_POST["submit"]) && $_POST["submit"] == "登陆")
03. {
04. $user = $_POST["username"];
05. $psw = $_POST["password"];
06. if($user == "" || $psw == "")
07. {
08. echo "<script>alert('请输入用户名或密码!'); history.go(-1);</script>";
09. }
10. else
11. {
12. mysql_connect("localhost","root","sixx");
13. mysql_select_db("vt");
14. mysql_query("set names 'gbk'");
15. $sql = "select username,password from user where username = '$_POST[username]' and password = '$_POST[password]'";
16. $result = mysql_query($sql);
17. $num = mysql_num_rows($result);
18. if($num)
19. {
20. $row = mysql_fetch_array($result); //将数据以索引方式储存在数组中
21. echo $row[0];
22. }
23. else
24. {
25. echo "<script>alert('用户名或密码不正确!');history.go(-1);</script>";
26. }
27. }
28. }
29. else
30. {
31. echo "<script>alert('提交未成功!'); history.go(-1);</script>";
32. }
33.
34.?>
注册界面 register.php
01.<form action="regcheck.php" method="post">
02. 用户名:<input type="text" name="username"/>
03. <br/>
04. 密 码:<input type="password" name="password"/>
05. <br/>
06. 确认密码:<input type="password" name="confirm"/>
07. <br/>
08. <input type="Submit" name="Submit" value="注册"/>
09.</form>
注册处理界面 regcheck.php
[php] view plaincopy在CODE上查看代码片派生到我的代码片
01.<?php
02. if(isset($_POST["Submit"]) && $_POST["Submit"] == "注册")
03. {
04. $user = $_POST["username"];
05. $psw = $_POST["password"];
06. $psw_confirm = $_POST["confirm"];
07. if($user == "" || $psw == "" || $psw_confirm == "")
08. {
09. echo "<script>alert('请确认信息完整性!'); history.go(-1);</script>";
10. }
11. else
12. {
13. if($psw == $psw_confirm)
14. {
15. mysql_connect("localhost","root","sixx"); //连接数据库
16. mysql_select_db("vt"); //选择数据库
17. mysql_query("set names 'gdk'"); //设定字符集
18. $sql = "select username from user where username = '$_POST[username]'"; //SQL语句
19. $result = mysql_query($sql); //执行SQL语句
20. $num = mysql_num_rows($result); //统计执行结果影响的行数
21. if($num) //如果已经存在该用户
22. {
23. echo "<script>alert('用户名已存在'); history.go(-1);</script>";
24. }
25. else //不存在当前注册用户名称
26. {
27. $sql_insert = "insert into user (username,password,phone,address) values('$_POST[username]','$_POST[password]','','')";
28. $res_insert = mysql_query($sql_insert);
29. //$num_insert = mysql_num_rows($res_insert);
30. if($res_insert)
31. {
32. echo "<script>alert('注册成功!'); history.go(-1);</script>";
33. }
34. else
35. {
36. echo "<script>alert('系统繁忙,请稍候!'); history.go(-1);</script>";
37. }
38. }
39. }
40. else
41. {
42. echo "<script>alert('密码不一致!'); history.go(-1);</script>";
43. }
44. }
45. }
46. else
47. {
48. echo "<script>alert('提交未成功!'); history.go(-1);</script>";
49. }
50.?>