PHP/MySQL : Creating a MySQL Table
Contents ]
Jean-Guillaume Birot

Data Input

Are you still on the confirmation screen? Fine. Then click on the link which reads your base name located at upper left of the page, in order to return to the main page. This latter indicates that there is now a table in your database. Click on the link Insert to access the input form.

Here are a few useful details regarding data input:

  • The id column is auto-incremented. So no value needs to be entered.

  • Columns of the ENUM type propose their valid values through a drop-down list in order to avoid mistakes.

  • The Functions column allows you to use built-in MySQL functions to calculate values. For instance, the NOW function can be used to assign the current date to the Date column.

You can now create your first article by entering the corresponding values in the various table columns. Validate it by clicking on Save. Repeat these steps for all the articles you want to create.

To view your articles, click on Browse from the main page. You can see all your articles displayed in a table. Through the Edit link, to the right of each article's columns, you can change any article by reverting to the input form.