Unsere Haustiere » You may be wondering why

Before you actually start building your database scripts http://www.achetermax270pascher.fr/ , you must have a database to place information into and read it from. In this section I will show you how to create a database in MySQL and prepare it for the data. I will also begin to show you how to create the contacts management database.


Database Construction


MySQL databases have a standard setup. They are made up of a database, in which is contained tables. Each of these tables is quite separate and can have different fields etc. even though it is part of one database. Each table contains records which are made up of fields.


Databases And Logins


The process of setting up a MySQL database varies from host to host, you will however end up with a database name air max 270 soldes , a user name and a password. This information will be required to log in to the database.


If you have PHPMyAdmin (or a similar program) installed you can just go to it to log in with your user name and password. If not you must do all your database administration using PHP scripts.


Creating A Table


Before you can do anything with your database, you must create a table. A table is a section of the database for storing related information. In a table you will set up the different fields which will be used in that table. Because of this construction, nearly all of a site's database needs can be satisfied using just one database.


Creating a table in PHPMyAdmin is simple air max 270 pas cher soldes , just type the name, select the number of fields and click the button. You will then be taken to a setup screen where you must create the fields for the database. If you are using a PHP script to create your database, the whole creation and setup will be done in one command.


Fields


There are a wide variety of fields and attributes available in MySQL and I will cover a few of these here:


Field Type Description
======== ==========
TINYINT Small Integer Number
SMALLINT Small Integer Number
MEDIUMINT Integer Number
INT Integer Number

VARCHAR Text (maximum 256 characters)
TEXT Text



These are just a few of the fields which are available. A search on the internet will provide lists of all the field types allowed.


Creating A Table With PHP


To create a table in PHP is slightly more difficult than with MySQL. It takes the following format: -------------------------------------------------------------------------------------------------------------- CREATE TABLE tablename {


Fields


} -------------------------------------------------------------------------------------------------------------- The fields are defined as follows:


fieldname type(length) extra info air max 270 homme pas cher ,


The final field entered should not have a comma after it.


I will give full an example of using these later in the section.


The Contacts Database


The contacts database will contain all the conact information for the people you enter and the information will be able to be edited and viewed on the internet. The following fields will be used in the database:


Name Type Length Description
id INT 6 A unique identifier for each record
first VARCHAR 15 The person's first name
last VARCHAR 15 The person's last name
phone VARCHAR 20 The person's phone number
mobile VARCHAR 20 The person's mobile number
fax VARCHAR 20 The person's fax number
email VARCHAR 30 The person's e-mail address
web VARCHAR 30 The person's web address



You may be wondering why I have used VARCHAR fields for the phonefax numbers even though they are made up of digits. You could use INT fields but I prefer to use VARCHAR as it will allow dashes and spaces in the number, as well as textual numbers (like 1800-COMPANY) and as we will not be initiating phone calls from the web it is not a problem.