Explain CodeIgniter architecture.
From a technical point of view, CodeIgniter is dynamically instantiation (light-weighted), loosely coupled (components rely very less on each other) and has a component singularity (each class and functions are…
Explain the folder structure of CodeIgniter.
If you download and unzip CodeIgniter, you get the following file structure/folder structure: Application cache Config Controllers core errors helpers hooks language libraries logs models third-party views system core database…
What are the most prominent features of CodeIgniter?
A list of most prominent features of CodeIgniter: It is an open source framework and free to use. It is extremely light weighted. It is based on the Model View…
What is CodeIgniter?
CodeIgniter is an open source and powerful framework used for developing web applications on PHP. It is loosely based on MVC pattern and similar to Cake PHP. CodeIgniter contains libraries,…
Explain Access Control Lists.
An ACL (Access Control List) is a list of permissions that is associated with an object. This list is the basis for MySQL server’s security model and it helps in…
What are all the Common SQL Function?
CONCAT(A, B) – Concatenates two string values to create a single string output. Often used to combine two or more fields into one single field. FORMAT(X, D) – Formats the…
What are the nonstandard string types?
Following are Non-Standard string types: TINYTEXT TEXT MEDIUMTEXT LONGTEXT
How many TRIGGERS are allowed in MySql table?
SIX triggers are allowed in MySql table. They are as follows: BEFORE INSERT AFTER INSERT BEFORE UPDATE AFTER UPDATE BEFORE DELETE and AFTER DELETE
What are the objects can be created using CREATE statement?
Following objects are created using CREATE statement: DATABASE EVENT FUNCTION INDEX PROCEDURE TABLE TRIGGER USER VIEW
What is the different between NOW() and CURRENT_DATE()?
NOW () command is used to show current year,month,date with hours,minutes and seconds. CURRENT_DATE() shows current year,month and date only.