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 I will create new record, read existing records, update the existing record and delete the existing record. I will use MySQL database as a permanent storage for performing such basic CRUD operations. I will use Flask module to handle the requests and responses from end user or clients and this module will work as a web application framework…

Continue

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 short (or nonexistent) learning curve during implementation. It allows you to use templates and formulas to aggregate data. It has very easy-to-use charting functionality compared to other software, and several helpful built-in features. It is…

Continue

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 is a “read only” document that cannot be altered without leaving an electronic footprint whereas other formats like image, word, excel etc. can easily be altered without leaving an electronic footprint. PDF files are compatible…

Continue

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 to generate HTML table from MySQL database using Codeigniter. We will create a table in MySQL database and retrieve the records from the table and display on a view in table format.

Continue

Username availability check using Servlet, AJAX and MySQL

Introduction This tutorial shows how to check username availability using Servlet, 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 with any technologies like PHP, Codeigniter, Servlet, Struts, JSF, Spring etc. for checking whether the input username is avaialable or already occupied by someone else. So if we give instant result to the user for username availability then sometimes it makes more sensible than while pressing the submit…

Continue

Username availability check using Codeigniter, AJAX and MySQL

Introduction 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, JSF, Spring etc. for checking whether the input username is available for creating new user account or it has already been taken by someone else. So if we give instant result to the user…

Continue

Save Files to MySQL using PHP

I have shown file upload example using PHP in previous tutorials¬†PHP file upload¬†but in this tutorial I will show you how to save the uploaded 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 put entire file then the preferred method would be to put the file into server’s file system and save the file path into the database. However in situations, where an application…

Continue

Multi-step Registration form using Codeigniter, MySQL, jQuery

Introduction Here we will see example on multi-step registration form using Codeigniter, MySQL, jQuery. Here we will insert data into database using multi-step registration step. Sometimes we need to capture lots of user details during registration process and as a result we got long forms on web page. So the best solution is to break the form into smaller logical section and present it into a multi-step registration form. This type of mult-step registration form always improves usability on web page comparing to very long form. I am going to…

Continue

Call Stored Procedure using Codeigniter

This tutorial will show you how to call stored procedure using CodeIgniter framework. Here I will use MySQL database server to store the data. Stored procedure is used when you want to execute multiple SQL statements in a group to perform certain actions. Related Posts: Call Stored Procedure using CodeIgniter 4 Codeigniter MySQL Stored procedure CRUD Example How to call stored procedure using Python

Continue

Spring Data JPA Entity Graphs

One of the important features in Spring Data JPA or simply JPA is the ability to specify fetch plans using Entity Graphs. This is useful since it allows you to customize the data, which is retrieved with a query or find operation. It is expected to display data from the same entity in different and several ways when working with mid to large size applications. In other cases, you just need to select a smallest set of information to optimize the performance of your application. Typically you do not have…

Continue