MYSQL

This tutorial tackles on how to create an XML file from MySQL database using PHP/MySQLi. XML stands for eXtensible Markup Language which is designed to store or transport data. This is usually used as a database substitute or if you wanted to free some space in your database.

This tutorial tackles on how to export MySQL database into .csv/CSV file using PHP/MySQLi. Usually, we export MySQL database using our phpMyAdmin and it is in .sql format but if you want it in CSV format, this tutorial will help you on how to achieve this. CSV stands for Comma-separated Values which is a simple file format used to store tabular data such as database.

This tutorial tackles on how to import data from .csv file or CSV into MySQL database using PHP/MySQLi. CSV stands for Comma-separated Values which is a simple file format used to store tabular data such as database. As the name suggested, the data in this files are separated by commas and most of the time came from excel spreadsheets.

This tutorial tackles on how to create pagination in CodeIgniter. Pagination is a process of dividing data presented to page views. This is usually done if you have large amount of data to show to your page to avoid users having to scroll down repeatedly to view these data.

This tutorial tackles on how to connect multiple databases in single CodeIgniter Application. Normally, we used one database for our data but for cases that we needed to use multiple databases, this tutorial will teach you on how to have multiple databases in your CodeIgniter application.

This tutorial tackles oh how to ajax upload file in CodeIgniter using jQuery. In order for us to send the file via ajax request, where gonna be using FileReader and FormData. File reader reads the selected file then Formdata holds our file for ajax request. We use jQuery for our ajax request which is a javascript library that makes you handle javascript better.

This tutorial tackles on how to create a signup/register form in CodeIgniter. We use jQuery to handle our server side signup request. jQuery is a javascript library that makes you use javascript easier. CodeIgniter is a lightweight PHP framework that uses MVC(Model-View-Controller) architecture.

This tutorial tackles on how to create a simple registration with form validation using CodeIgniter. CodeIgniter is a lightweight PHP framework that uses the MVC(Model-View-Controller) architechture. Form validation is a process of checking user's input whether it is valid or not depending on the rules applied by creator.

This tutorial tackles on how to upload files in CodeIgniter with flashdata. CodeIgniter is a PHP framework that uses MVC(Model-View-Controller) architecture. Flashdata are a type of session but is just set one time means that after you reload the page, this data is removed. Flashdata are usually used when displaying action messages like success or errors.