How to Store Array in MySQL with PHP

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

They are easier to access and manipulate.

Sometimes, require to store Array in the 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

Read more

Integrate CKEditor to HTML page and save to MySQL with 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

Read more

Load content on Page scroll with AngularJS and PHP

In infinite page scroll pagination data load dynamically and append at the end of existing content when the user reaches to the bottom while scrolling.

The user doesn’t have to click any button.

I am using ngInfiniteScroll directive for implementing with AngularJS.

With this directive detect page scroll and send AJAX request to get content.

Also, need to include the jQuery library for using it.

In this tutorial, I show how you can load content on page scroll using the ngInfiniteScroll directive in AngularJS.

Load content on Page scroll with AngularJS and PHP

Read more

Delete Multiple selected Records with jQuery AJAX in CodeIgniter 3

One by One record deletion from the list is time-consuming and frustrating when you need to delete many records.

With the use of the checkboxes on the list, you can allow selecting multiple records. Only required to add a single delete button.

In this tutorial, I show how you can delete multiple records using jQuery AJAX in CodeIgniter.

Delete multiple selected records with jQuery AJAX in CodeIgniter 3

 

Read more