MySQL

DataTable CRUD Example using Codeigniter, MySQL and AJAX

Introduction In this post we will see Datatable CRUD example using Codeigniter, MySQL and AJAX. We have seen in our previous post on DataTable using Codeigniter, MySQL and AJAX, where we have the following features: Loading data from MySQL database in HTML table Pagination – each page shows 10 records Searching Filtering Sorting

Codeigniter MySQL Stored Procedure CRUD Example

Here we will see Codeigniter MySQL Stored Procedure CRUD Example. In my previous example on Call Stored Procedure using Codeigniter, someone had requested me to write an example on Codeigniter MySQL Stored Procedure CRUD, so I am presenting here the same. CRUD means, Create, Read, Update Delete operations.

Python REST API CRUD Example using Flask and MySQL

Introduction Here we will see Python REST API CRUD Example using Flask and MySQL. We have also seen how to create web application CRUD example using Python, Flak and MySQL. You may also like to read REST APIs in Java and Spring Technologies. What is REST or RESTful? The most important concept in REST is […]

Call Stored Procedure using Python

Introduction This tutorial will show you how to call stored procedure using Python programming language. Here we will use MySQL database server to store the data for this example. You may also want to read How to call stored procedure using Codeigniter framework. A stored procedure is a set of Structured Query Language (SQL) statements with […]

Python Web Application CRUD Example using Flask and MySQL

Introduction The tutorial on Python web application CRUD example using Flask and MySQL will show you the basic CRUD operations. CRUD means Create, Read, Update and Delete operations. In the below example we will create new record, read existing records, update the existing record and delete the existing record. We will use MySQL database as […]

Generate Excel Report from MySQL Database using Codeigniter

Here we will see how to generate excel report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications and it’s easy to work with Codeigniter for building web applications. Why excel reporting? Most people in your organization are likely to be familiar with excel, hence it ensures a […]

Generate PDF Report from MySQL Database using Codeigniter

Here we will see how to generate pdf report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications. PDF format reports allows professionals to edit, share, collaborate and ensure the security of the content within digital documents. Reports are mostly generated in PDF format because a PDF file […]

Generate HTML Table from MySQL database using Codeigniter

Here is an example showing you how to generate HTML table from MySQL database using Codeigniter. We will write here an example to create a table from a multi-dimensional array. The Table Class provides functions that enable you to auto-generate HTML tables from arrays or database result sets. Here we will create a web application […]

Username availability check using Codeigniter, AJAX and MySQL

This tutorial will show you how you can check username availability using Codeigniter, AJAX and MySQL. Sometimes we need to check username availability instantly before a user presses the submit button after filling a long-sized signup form. In this case we can use AJAX technique with any server side technologies like PHP, Codeigniter, Servlet, Struts, […]

Save Files to MySQL using PHP

We have seen file upload using PHP in previous tutorials PHP file upload but in this tutorial we will see how to save files to MySQL database using PHP. You may be wonder why you would need to save file content into database rather than just into the file system. In situations where PHP application needs to […]

Scroll to top