**Course Title:** Mastering CodeIgniter Framework: Fast, Lightweight Web Development **Section Title:** Final Project and Scalability Techniques **Topic:** Begin working on the final project, integrating all learned techniques to build a complete web application.(Lab topic) **Objective:** In this lab topic, you will put all the concepts learned throughout the course into practice by building a complete web application using CodeIgniter. You will integrate all the learned techniques, from database interactions to API development, styling, and optimization. This will help you understand how to apply the concepts learned to real-world scenarios and gain hands-on experience with the CodeIgniter framework. **Prerequisites:** * Complete the previous topics in the course * Have a basic understanding of PHP, HTML, CSS, and JavaScript * Install CodeIgniter on your local machine **Step 1: Choose a Project Idea** Before starting the lab, choose a project idea that interests you and aligns with your skills and goals. Some ideas to get you started: * A simple blog with user authentication and CRUD functionality (using CodeIgniter's built-in Auth library) * A ecommerce platform with products, orders, and user management * A personal website or portfolio with about sections, contact, and portfolio showcase **Getting Started** 1. Create a new CodeIgniter project using the Command Line Interface (CLI) or a visual interface like Pagebuilder. 2. Install the required packages for your chosen project (e.g., CodeIgniter_URL, CodeIgniterCACHE, etc.). 3. Set up your database and configure the database connections in the CodeIgniter settings. **Database Setup** In this step, you will set up your database schema and connect it to your CodeIgniter application. 1. Create a new database and grant all privileges to the database user. 2. Design your database schema using the following tables: * Users (with columns for username, email, password, and role) * Products (with columns for product name, description, price, and image) * Orders (with columns for order date, total, status, and user ID) * Comments (with columns for comment content, user ID, and product ID) 3. Install the required database packages (e.g., CodeIgniter Database_Builder). **Model Development** In this step, you will create models for handling business logic and database interactions. 1. Create a new model for the user entity (e.g., `User_model.php`) and define the following methods: * `getAllUsers()`: retrieve all users * `getUser($id)`: retrieve a user by ID * `createUser($data)`: create a new user * `updateUser($id, $data)`: update a user * `deleteUser($id)`: delete a user 2. Create a new model for the product entity (e.g., `Product_model.php`) and define the following methods: * `getAllProducts()`: retrieve all products * `getProduct($id)`: retrieve a product by ID * `createProduct($data)`: create a new product * `updateProduct($id, $data)`: update a product * `deleteProduct($id)`: delete a product 3. Create a new model for the order entity (e.g., `Order_model.php`) and define the following methods: * `getAllOrders()`: retrieve all orders * `getOrder($id)`: retrieve an order by ID * `createOrder($data)`: create a new order * `updateOrder($id, $data)`: update an order * `deleteOrder($id)`: delete an order **Controller Development** In this step, you will create controllers for handling HTTP requests and interactions with the models. 1. Create a new controller for the user entity (e.g., `Users.php`) and define the following methods: * `index()`: display a list of users * `enedza($id)`: display a single user * `create()`: create a new user * `update($id)`: update a user * `delete($id)`: delete a user 2. Create a new controller for the product entity (e.g., `Products.php`) and define the following methods: * `index()`: display a list of products * `enedza($id)`: display a single product * `create()`: create a new product * `update($id)`: update a product * `delete($id)`: delete a product 3. Create a new controller for the order entity (e.g., `Orders.php`) and define the following methods: * `index()`: display a list of orders * `enedza($id)`: display a single order * `create()`: create a new order * `update($id)`: update a order * `delete($id)`: delete a order **Routing and URL Generation** In this step, you will define routes for your application and generate URLs for your controllers. 1. Open the `routes.php` file and add the following routes: * `/users` -> `Users::index()` * `/users/<id>` -> `Users::enedza($id)` * `/users/create` -> `Users::create()` * `/users/update/<id>` -> `Users::update($id)` * `/users/delete/<id>` -> `Users::delete($id)` * `/products` -> `Products::index()` * `/products/<id>` -> `Products::enedza($id)` * `/products/create` -> `Products::create()` * `/products/update/<id>` -> `Products::update($id)` * `/products/delete/<id>` -> `Products::delete($id)` * `/orders` -> `Orders::index()` * `/orders/<id>` -> `Orders::enedza($id)` * `/orders/create` -> `Orders::create()` * `/orders/update/<id>` -> `Orders::update($id)` * `/orders/delete/<id>` -> `Orders::delete($id)` **Additional Features** In this step, you will add additional features to your application such as authentication, search, and pagination. 1. Install the CodeIgniter Auth library and configure it to use your existing user model. 2. Create a search function for your application using the CodeIgnited filtered query library. 3. Implement pagination using the CodeIgniter Pagination library. **Testing and Deployment** In this step, you will test your application and deploy it to a production environment. 1. Test your application using the CodeIgniter Testing library to ensure it works as expected. 2. Deploy your application to a production environment such as AWS or DigitalOcean. **Conclusion** In this lab topic, you have built a complete web application using CodeIgniter. You have integrated all the learned techniques, from database interactions to API development, styling, and optimization. Your application should now be functional and ready for deployment. **Additional Resources** * CodeIgniter official documentation: <https://codeigniter.com/userguide3> * CodeIgniter github repository: <https://github.com/bcit-350/project2> * CodeIgniter issues: <https://github.com/bcit-350/project2/issues> **Leave a comment/Ask for help:**