PHP Archives - Page 67 of 72

How to delete file with jQuery AJAX

Last updated on July 2, 2021 by Yogesh Singh

Using Client-side scripts like – jQuery and JavaScript it is not possible to delete any files. Need to use Server-side scripting for doing it.

In PHP, you can simply use the unlink() function this removes a file from your server if it exists.

Sometimes you have the requirement to delete a resource file without reloading the page.

This cannot totally be done with PHP you need to use jQuery or JavaScript with it by which send AJAX request to your server for removing a file and according to the response make changes on your Client-side.

For demonstration purpose, I create some <img> elements with Delete Button. When the Button gets clicked then remove the file using jQuery AJAX and replace the <img> source with the default image.

How to delete file with jQuery AJAX

How to Export MySQL Table data as CSV file in PHP

Last updated on January 14, 2024 by Yogesh Singh

Exporting MySQL table data to a CSV file is a common need in web development. It provides the flexibility of converting your database records into an easily readable and shareable format.

Whether you want to generate reports, transfer data to another system, or create backups, knowing how to export MySQL data to CSV using PHP can be incredibly useful.

This article guides you through the process of exporting MySQL table data as a CSV file using PHP.

How to Export MySQL Table data as CSV file in PHP

Sorting the Table by clicking Header with AJAX

Last updated on August 21, 2021 by Yogesh Singh

With sorting the list it is easier for the user to locate items in a sorted list than unsorted. It rearranges the data in specific order (ascending or descending).

You can either use PHP or AJAX to get the sorted data.

I am using AJAX to sort the list in this tutorial.

In this tutorial, I am displaying the employee’s list and attach click event on the table column header. Whenever header gets clicked then send an AJAX request with column name to sort with.

Sorting the Table by clicking Header with AJAX

Step-by-Step: File Uploads Made Easy with Dropzone.js and PHP

Last updated on December 23, 2023 by Yogesh Singh

In web development, file upload functionality is a common requirement for many applications. PHP offers multiple choices for file uploads, but among them, Dropzone.js is widely favored. This JavaScript library streamlines the file upload process and offers an interface that can be customized and easily used by users.

Dropzone.js can be used with or without jQuery in your project, and it does not have any additional library requirements. This library does not handle file uploads to your server directly. In this tutorial, PHP will be used for uploading.

File upload can be done by either dragging and dropping or by using the file chooser dialog that opens when the drag n’ drop widget is clicked. While uploading, Dropzone.js displays a progress bar, generates a thumbnail image, and provides file size preview after uploading.

Step-by-Step: File Uploads Made Easy with Dropzone.js and PHP