Here we come to a new appointment on this tutorial for the creation of a warehouse management system in PHP with data stored in a MySQL database and we called Cerberus . Last article we dealt with the structure to implement the tables in our database, this time we will build the page for editing data in a single inventory item . The aim of our work is to create a list of values from which you can select the record to edit . As always, our goal is to create the frame of the page, and then we will not take into consideration the look and feel or layout of the controls.
The first task we need to do is to create the . PHP file that will contain all the data of the database connection , then enter the project within our php class to manage MySQL connections that we have developed in this article of the course.
The project consists of several files :
- mysqlconn.php – The file which contains information about the connection to the data . The login user name , password , and the database to use the name of the server running MySQL . In this way, just change the login credentials in a file only and the entire project is portable to another server.
- mysql.php – The file which contains the class CMySQL for the management to a higher level of access to the database. This class is obviously reusable content of all projects that require access to MySQL database .
- article.php – The file which will handle the article in its detail. For now, we have included only a few controls that in the next round of this tutorial will be filled with the values in the database.
The first two files I have listed in the directory utility , which will then be included in all the other files that will need to access the database.
You can find the source code of the project in this link. In the next installment of the tutorial we will see how to fill with list controls the units and with the categories in the archive , and above all choose the one chosen at runtime .
As always, I invite you to write comments to the article to get more information , I personally think that the sources are quite clear.