So far, we have implemented capabilities related to basic features of the application. From now on, we will start implementing the application's core features, starting with the MySQL table management. What exactly is this? Every application has information that is not directly related with the core business, but this information is used by the core business somehow. For example, types of categories, languages, cities, and countries can exist independently of the core business and can be used by the core business information as well. We can treat this information as they are independent MySQL tables (because we are using MySQL as database server), and we can perform all the actions we can do on a MySQL table.
So in this chapter, we will cover:
Creating a new system module called Static Data
Listing all information in a MySQL table
Creating new records on the tables
Live search on the tables
Filter information
Editing and deleting records
Creating an abstract component...