Continued the modification of the web application for the development of the add location query saving the data in the database, modified the add location blade to set the fields who are required when adding location same on the edit location blade as well, set the field required as this is important on blue yonder part. Added library information table in the database for the blue yonder, this is where the environment and connection is to be restored, this is needed, as when adding location, selection of the environment is needed first before the user can add location, there are multiple environments thus this will be the basis which environment the location data will be added in the blue yonder. created the function for calling the connection for the selected environment. continued to create the query that will be used in saving the data in the MySQL database. created a function that will call the data for some dropdown fields from blue yonder, the selection is directly extracted from blue yonder because if it is added to MySQL database, this should be included in the maintenance or the tables should be maintained as there might be new data needed to be added on the tables, test the created function if it will call the values expected on the dropdowns, as per checking, the value is showing and it is all the expected data for each dropdown. Tested the created saving location function for checking if no error will be encountered and the data will be saved in the database, as per checking, an error is encountered, the data is not saved in the database, the error now yet checks and fix but I added the saving of edited data function with a query for starting the development.