Makitweb Posts

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

CKEditor is a WYSIWYG HTML editor.

It makes HTML textarea lot more user-friendly by providing various features like – adding images, writing HTML code, formatting text, etc.

This can also be added to HTML containers.

It does not depend on other libraries like – jQuery and can be used in 3 different modes – Article Editor, Document Editor, and Inline Editor.

Different options are available to customize the editor.

In this tutorial, I am adding Article and Inline mode CKEditor on the same page and save it to MySQL database on submit with PHP.

Integrate CKEditor to HTML page and save to MySQL with PHP

Javascript PHP