Makitweb Posts

Sometimes, JavaScript modification doesn’t reflect on the page while running.

Need to clear browser cache manually each time when the file gets updated.

It makes the debugging process hard.

If the project contains some bug and you fix it but the user needs to clear the browser cache to reflect the changes.

In this tutorial, I show how you can prevent JavaScript file from Caching by the browser.

How to prevent browser from caching Javascript file

How To Javascript

Dropzone auto uploads the selected file or drag file to the server.

Sometimes, it requires to upload all selected files on single click instead of uploading it instantly.

With Dropzone options and method this can easily be implemented.

In this tutorial, I show how you upload drag files in Dropzone area on a single click.

Upload all files on button click - Dropzone and PHP

AJAX JQuery PHP

With Datatable you can easily implement pagination on the webpage in less time.

It gives all necessary features which require in the pagination like – searching, sorting, change the number of records display.

You only need to manage the AJAX file.

In this tutorial, I show how you can add Datatable pagination with PHP and PDO.

Datatable AJAX pagination with PHP and PDO

AJAX JQuery PHP

Taking the backup of the database is necessary whether it small or large project. You can easily revert the database if something went wrong.

Using phpMyAdmin you can easily export your MySQL database.

You can also Command Line to export selected MySQL database.

In this tutorial, I am using XAMPP in windows.

How to export MySQL database using Command Line

DataBase

phpMyAdmin allows importing file to the selected MySQL database but it takes time to import according to the file size.

If a file is too large then it will give Timeout error if it exceeds the time.

With the use of the Command Line, you can easily import your SQL file in less time.

In this tutorial, I am using XAMPP in Windows.

How to import SQL file to MySQL using Command Line

DataBase

In CKEditor by default file browser option is not enabled.

You can only add a file to an editor with URL.

To add file browser option require to update CKEditor configuration and use options while initialization.

In this tutorial, I show how you can add file browser option in CKEditor and upload it with PHP.

Custom file upload in CKEditor with PHP

AJAX Javascript PHP

An array is a special variable which allows storing one or more values in a single variable e.g. – holding usernames or details in an Array.

They are easier to manipulate.

Sometimes, require to store Array to MySQL database and retrieve it.

In this tutorial, I show how you can store an Array in the MySQL database and read it with PHP.

How to store Array in MySQL with PHP

How To PHP