鼠标宏编写脚本代码教程
We are going to create a simple login system using PHP code on our pages, and a MySQL database to store our users' information. We will track the users who are logged in with cookies.
我们将使用页面上PHP代码创建一个简单的登录系统,并使用一个MySQL数据库来存储我们的用户信息。 我们将跟踪使用cookie登录的用户。
数据库 ( The Database )
Before we can create a login script, we first need to create a database to store users. For the purpose of this tutorial we will simply need the fields "username" and "password", however, you can create as many fields as you wish.
在创建登录脚本之前,我们首先需要创建一个数据库来存储用户。 就本教程而言,我们只需要字段“用户名”和“密码”,但是,您可以根据需要创建任意多个字段。
CREATE TABLE users (ID MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(60), password VARCHAR(60))
This will create a database called users with 3 fields: ID, username, and password.
这将创建一个名为users的数据库,其中包含3个字段:ID,用户名和密码。
注册页面1 ( Registration Page 1 )
<?php
// Connects to your Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
//This code runs if the form has been submitted
if (isset($_POST['submit'])) {
//This makes sure they did not leave any fields blank
if (!$_POST['username'] | !$_POST['pass'] | !$_POST['p