How to create and download a Zip file with PHP

PHP provides ZipArchive Class which allows us to create a Zip file. This class makes file creation easier.

Programmatically Zip creation is mainly required when preparing the group of files and folders for downloading.

In the example, I am creating a function that will read all files and folders from the specified directory and add them to the ZipArchive class object.

How to create and download a Zip file with PHP

Read more

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