Mysql queries in php and codeigniter

Codeigniter is the PHP framework that uses the pattern for database records. This pattern allows information to be retrieved, inserted and updated in your database with minimal scripting. Database connections are too easy to connect with database most of the things are already done in the framework we will show you that in later tutorials. This framework uses the pattern of MVC that means model, view, and controller.
We can use the crud by using the MVC method.

Selecting Data
Inserting Data
Updating Data
Deleting Data

Usage of Mysql queries

these are the main quires in a database in MySQL, code igniter or any other language every time most of the user interact with these quires.
Select Query: Select query is used for the selection of data from MySQL database table and use it in any other place where you require the data. Like in web application, the user profile data that displayed on this profile front end that is saved in the database and select query select the user profile data and bring in the view and developer show that data in appropriate place.
Insert Query: Insert query is used to insert/save the data in a database so that the user can retrieve and manipulate the data when he needed. Like in web applications the user came on the site and him sign-up on the website then he adds the data of a user in the database. He can access that data when he required it.
Update Query: Update query is used to update the records that are already inserted in the database when the user require this. Like in web applications the user have the access that he can edit his profile so the data need to be updated in the database also.
Delete Query: Delete query is used to delete the records from the database when data became raw for a user. Like if someone wants to close his account or he wants to cancel his order for some item that he ordered then the data needed to be deleted from the database.

All these queries have little bit different syntax in different languages but have the same concept and logic. Near about every web application uses the database for saving manipulating and retrieving the data from a user and perform actions on it. The database is the part of the application. You can search for reading more material about by just writing the queries MySQL w3, MySQL queries pdf, MySQL queries examples, MySQL queries interview questions, MySQL queries list, MySQL queries interview questions and answers pdf, MySQL join queries, MySQL queries tutorial and much more you will get the reading material of good quality. Next post of MySQL database queries.
Different types of queries with examples...!

This Post Was Last Updated On September 30, 2016, By Author: Mahira Khan.