Hi User, Thanks for visiting this blog for your query. With the help of this article you will learn about how to generate PDF file in codeigniter with the help of mPDF Library. Steps for configuring mPDF in codeigniter to generate and download pdf 1. Download and extract mPDF Download…
MySQL Interview Question Set 5
41. How MySQL Optimizes DISTINCT? DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause. SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a; 42. How to enter Characters as HEX Numbers? If you want to enter characters as HEX numbers, you can…
MySQL Interview Question Set 4
31. How can we get the number of rows affected by query? Number of rows can be obtained by SELECT COUNT (user_id) FROM users; 32. Is Mysql query is case sensitive? No SELECT VERSION(), CURRENT_DATE; SeLect version(), current_date; seleCt vErSiOn(), current_DATE; All these examples are same. It is not case sensitive.…
MySQL Interview Question Set 3
21. How do you control the max size of a HEAP table? Maximum size of Heal table can be controlled by MySQL config variable called max_heap_table_size. 22. What is the difference between MyISAM Static and MyISAM Dynamic? In MyISAM static all the fields will have fixed width. The Dynamic MyISAM…
MySQL Interview Question Set 2
11. Define REGEXP? REGEXP is a pattern match in which matches pattern anywhere in the search value. 12. Difference between CHAR and VARCHAR? Following are the differences between CHAR and VARCHAR: CHAR and VARCHAR types differ in storage and retrieval CHAR column length is fixed to the length that is…
MySQL Interview Question Set 1
1. What is MySQL? MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle) 2. What are the technical features of MySQL? MySQL database software is a client or server system which includes Multithreaded SQL server supporting various client programs and…
Codeigniter Interview Questions for Fresher and Experienced Candidates – Set 2
11) Mention what is the default URL pattern used in Codeigniter framework? Codeigniter framework URL has four main components in default URL pattern. First we have the server name and next we have the controller class name followed by controller function name and function parameters at the end. Codeigniter can…
Codeigniter Interview Questions for Fresher and Experienced Candidates – Set 1
1) Explain what is CodeIgniter? Codeigniter is an open source framework for web application. It is used to develop websites on PHP. It is loosely based on MVC pattern, and it is easy to use compare to other PHP framework. 2) Explain what are hooks in CodeIgniter? Codeigniter’s hooks feature…
Understanding Codeigniter Directory Structure
CodeIgniter directory structure is divided into 3 folders − 1. Application 2. System 3. User_guide 1. Application As the name indicates the Application folder contains all the code of your application that you are building. This is the folder where you will develop your project. The Application folder contains several…
Understanding the application structure of codeigniter framework
CodeIgniter is an application development framework, which can be used to develop websites, using PHP. It is an Open Source framework. It has a very rich set of functionality, which will increase the speed of website development work. The architecture of CodeIgniter application is shown below. 1. As per the…