Step 1: Create posts table In this step we will create new new table “posts” in database. You can use following SQL Query for create “posts” table. So let’s create using bellow sql query: item table: CREATE TABLE IF NOT…
codeigniter scripts CodeIgniter select query function is used to fetch the result from one table but, one or more table data fetch to use join query. SELECT operation is also called as READ and one among the database CRUD process.…
Let me explain about the CodeIgniter session flash message. It’s a temporarily stored value working like a session. This coding used to set success message and failure message through your controller. Let start to learn how to create CodeIgniter session…
In this tutorial, we will learn how to create a excel file in php Codeigniter with help of phpexcel library. The data of Excel will come through mysql database. Download the PHPExcel library Extract the zip file using winzip or…
In this tutorial i will show you how to partially hide email address using php. Many php project need this type speciality. like I want to display email from database and I want to only show some character not a…
In this tutorial, I will show you how to email address partially using PHP regex. Many PHP project needs this type of specialty. I want to display email from a database and I want to only show some character not…
CodeIgniter is a framework based on MVC principles. As a result, you would usually separate application logic, data abstraction and “output” into their respective areas for CodeIgniter use. In this case: controllers, models and views. I strongly advise you to read through…
here is an example of how you can Import Excel to MySQL using PHP. Import Excel to MySQL database is a very important method. Sometimes you have a very big list of items in an excel file and at sometimes…
Most of the time my clients need to download data from their database tables. Today, I decided to make a very small controller that is portable and efficient for exporting full MySQL tables to Excel using PHPExcel and CodeIgniter. Download…
In this tutorial, we will learn how to import or read an Excel sheet data and insert into database using PHPExcel in Codeigniter Library. For that, we will create a Database to insert an excel data into table, a form…