Import CSV file data to the MySQL using PHP

CSV files have­ become a widely adopte­d format for storing data, thanks to their simplicity and ease of use­. Their table-like structure­ often makes them the­ go-to option for holding vital information such as names and numbers. When de­aling with databases like MySQL, users re­gularly import CSV files’ contents to fill tables with e­xtensive datasets in re­cord time.

This tutorial is designe­d for anyone who wants to learn how to import CSV data into a MySQL database using PHP. The­ step-by-step guide starts from the­ basics, so no programming expertise is re­quired. By following this article, reade­rs can effortlessly complete­ the process and gain new skills in handling CSV file­s with ease.

Import CSV file data to the MySQL using PHP

Read more

How to embed SlideShare Presentation in WordPress

SlideShare is one of the popular web services where user view, upload, and share their content. It support multiple formats e.g. ppt,pdf,doc,etc.

You can find content on a wide range of topics.

Member chooses its upload content is available publicly or privately. After uploading, it is available for the community, where member interacts with it by like, share on various social media, comment on it, embed your content and even they download it.

To embed SlideShare Presentation to the website or personal blog there are two ways –

  • Without Plugin
  • With Plugin

In this tutorial, we check out both of these ways of embedding.

Within this tutorial, I am assuming you have a SlideShare account, if not you can signup for it.

How to embed SlideShare Presentation in WordPress

Read more

How to Hide and Show the Table column using jQuery

It lets users be more flexible by letting them hide or show columns they don’t want to see on a list.

You can easily do this using jQuery. Just toggle the specific columns based on what you choose.

In the example, I’m making a table layout to list employee details. Checkboxes are used to hide or show table columns with the help of jQuery.

How to Hide and Show the Table column using jQuery

Read more

How to Send JavaScript Array to the AJAX using jQuery and PHP

The process of sending JavaScript arrays to the server-side using AJAX is a frequent requirement in web development. JavaScript arrays allow us to store and manage data in a structured format.

This can be used to pass the group of related values as data to the $.ajax for processing and get the response.

E.g. pass all checked checkboxes values, selected values from the list.

In this tutorial, you will learn how to send a JavaScript array to the server-side using AJAX, jQuery, and PHP with a live example.

How to Send JavaScript Array to the AJAX using jQuery and PHP

Read more