Archive

Blog Archives

CRUD Query using JSON Column

Code snippets for performing CRUD operations usng JSON data type.

Consuming WCF in ASP.NET MVC 5 with Entity Framework 6 using Visual Studio 2017

Create WCF service with Entity Framework then consume it on a ASP.NET MVC application

Connecting an ASP.NET MVC Application to MySQL

Learn how to connect an ASP.NET MVC application to MySQL

AJAX Pagination with Search and Sort in ASP.NET MVC 5

A simple tutorial which demonstrates how you can paginate your data using AJAX and apply search and sort features using Entity Framework in ASP.NET MVC 5.

Generate CSV file and send as Email attachment PHP

Querying reports from SQL database then generate a CSV File containing all the queried data then send the CSV File to the admin email.

Simple Database Connection using MySQLi OOP and Procedural

This tutorial demonstrates the use of MySQLi in OOP and Procedural Approach

Post Class for Resume Database

Functions from my most recent Resume Database project

Optimize WordPress Database by Disabling and Removing Revisions

Disable the saving of revisions in your WordPress blog to optimize your Wordpress database.

Understanding SQL Joins

A very good graphical representation of SQL Joins

Select Box with Search Filter

Integrating a custom select box with search filter using Select2 plugin.

WordPress Frontend AJAX Pagination

Create a Front-end AJAX pagination in your WordPress blog