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…
PHPExcel is a PHP library for reading and writing spreadsheet, csv, excel files. CodeIgniter is one of the well known PHP MVC framework. here is step How to Integrate PHPEXcel library in CodeIgniter. you can download php excel library form…
Getting data through Ajax is very cool, and when we can reuse the CodeIgniter views to get the Ajax data, the overall user experience become much more enhanced. So, in this tutorial I would show you how to call jquery…
Date is important function in php. This is a short guide on How to get last week date range monday to sunday in PHP. This is useful for whenever you need to figure out what date a particular date fell…
Have you ever seen a URL which looked like www.example.com/page.php?mode=1&style=red? Well, this page is being passed variables and their values through the query string, here the variables mode and style are being passed, with values 1 and red respectively. The question mark ?indicates the start of the query string and the…
Why CSS Gradient These are the following reasons to use CSS gradient. You don’t have to use images to display transition effects. The download time and bandwidth usage can also be reduced. It provides better look to the element when…
Remove Characters With ASCII Value > 127 The following example uses the filter_var() function to sanitize a string. It will both remove all HTML tags, and all characters with ASCII value > 127, from the string: <!DOCTYPE html> <html> <body>…
Definition and Usage The blur event occurs when an element loses focus. The blur() method triggers the blur event, or attaches a function to run when a blur event occurs. HTML Code <html> <head> <script src=””></script> <script> $(document).ready(function(){ $(“input”).blur(function(){ alert(“This…
For validating input, pressed key ASCII code and check it. If you don’t know the ASCII code of a character then you can view it from here and define your condition in keypress Event handler. Example <div class=”container”> <input type=’text’…
Set the Session just in case //Ensure that a session exists (just in case) if( !session_id() ) { session_start(); } The rest is as easy as it gets! The Function. /** * Function to create and display error and success…