MVC directory and Database Structure in CRUD Project
In this part, we will take a look at the project's directory structure and database structure. In the overall project, we are going to use Sublime Text 3 as an editor and Xampp server for the database and run the application. So I hope you have installed them in your system. As we have CodeIgniter running successfully in our system. We need to create the below files in the directory. You can see how many files we have in controllers, models, and views directory. Now we need to add a database table in MySQL. Open PHPMyAdmin and go inside the created database. Here you need to open SQL editor from your database. Create tables and insert values as given in the below query. Table structure for table product CREATE TABLE product ( p_code varchar(255) NOT NULL, p_category varchar(255) DEFAULT NULL, p_party varchar(255) DEFAULT NULL, p_rate varchar(255) DEFAULT NULL, p_type int(11) NOT NULL, in_purchase float NOT NULL, in_sold float NOT NULL, ...