In this tutorial, you will learn How to Export MySQL Data into CSV and Download it as a Zip File using PHP Language. Here, I will show to the steps on how to achieve the said feature for your current or future PHP Projects. The main goal of this tutorial is to give the IT Students or new programmers that are new in PHP Language an idea for exporting data to CSV and zipping files in PHP.
In this tutorial, I will show you a way how to upload images in PHP with reduced quality and resized resolution. This kind of feature might be helpful to your current or future project that uploads and displays lots of images. It will help your project load the pages faster even there are a lot of images are being shown because instead of displaying the original size and quality of the images is optimized. For example, you are developing a Blog Site and each blog or article has a thumbnail or banner image.
In this tutorial, we will tackle Inserting the Data from Array in MySQL Database using PHP. Here, I will show you a technique to easily insert multiple data rows into the database. This technique or idea can be helpful for mass data insertion of a form for some feature of a PHP Projects such as POS or Cashiering System, Shopping Cart, and more.
In this tutorial, you will learn how to sort a PHP Array by its Key and Value. PHP have different built-in function on sorting an Array. There is sort(), rsort(), asort(), arsort(), ksort(), and krsort(). Each of the listed functions has same goal of returning the array which sorting them but the difference are how they are being sorted.
In this tutorial, you will learn how to create a Export MySQL Data to CSV File. With the use of some built-in PHP Functions such as PHP fopen() and fputcsv() we can create a CSV file with data. This tutorial can be useful for your future projects that requires a CSV Exportation Functionality.
Here, we will create a simple PHP application with dummy MySQL data and has an anchor/button that triggers to export the data to CSV File.
In this tutorial, we will tackle about creating a Simple Web Application with CRUD Operation and preventing duplication input value. We will be using PHP Language as the back-end and MySQL Database. The Duplication Validation that we'll be creating, is a real-time or live function using jQuery, and by using Ajax Request, data validation will be automatically triggers without leaving the page or submitting the form yet.
This is simple Tutorial Code that tackles about Managing Page Content on a Web Application. This tutorial will help you to understand and have an idea of how to create a Page Content Management Feature for a CMS Website. This kind of feature can give your end-users a way to create or manage page content through the front-end or without managing the actual source code files. This can be useful for those who are planning to develop a Content Management System (CMS) using PHP Language.
In this tutorial, we will tackle about how limit the data to display from database and load automatically when scrolled to bottom using PHP and jQuery. This technique is very useful especially to optimize the speed of loading bulk data. This feature is commonly used in social network sites like the Facebook news feed, it shows limited posts at first and when you reached the bottom of the page, it will automatically load another data. To meet our goal for this tutorial, we will be using MySQL LIMIT and OFFSET Clause.
