Create a simple access database for the webpage

Open Microsoft Access, select File> create database, and then select a location to save your database file. Here we save the file according to its default db1.mdb name.



After saving the database, we can see the following interface. Double-click the designer to create a table. You only need to follow the steps to implement the application here. Even if you have never touched the database before, there is no problem. If you want to implement deep-level applications that involve relational structures, you 'd better find a database book.



Next, we will design a user information table for user registration. Double-click the designer to create a table. The Design page is displayed. Enter the user information you want to record in the field name column (it is recommended that the field name should not be named in Chinese, so that there will be no too much trouble in programming in the future, at the same time, be sure not to use the reserved words of the database itself, such as temp, which may conflict with the database program. Try to use the table name + slide line + name, such as tbl_userinfo_name, here we first use a simple name for processing ). We have created six fields: username, userpass, and usermail), reg_date (user registration time), homepage (user's personal homepage address), and phone (user's contact number ). The default text type of the data type is used. The field size is 50. First, we can process individual fields.
Generally, the username, password, email address, and contact number cannot exceed 50 characters (of course, if someone maliciously enters a long string, an error is returned, so we need to make some restrictions in the production of web pages), and personal home address, it may exceed --- such as http://www.netease.com /~ Cosix/html/... so we adjusted its field size to 200.



The time type of the registration date is changed to date/time, * _ 'of course. Then, we can call the function of access to add a default value = Now (). This indicates that when data is added, the database system automatically uses the current time of the server as the value of the reg_date field, in this way, we can skip the step of making an input registration date on the webpage.