How to Convert XML to CSV using PHP

The example, convert xml to csv using PHP , shows conversion of xml data to csv data. As the title suggests to convert xml to csv using PHP, so we will convert either xml file to csv file or xml string to csv string. When we convert xml string to csv string you will see the output on the browser and when we convert xml file to csv file then you will see the csv document saved into a file on the physical drive location. So here in this example we will see both examples that may help you to choose the example according to your situations.

People working with different types of data may come across the problem that they need to convert between different data formats. Extensible Markup Language (XML) and Comma Separated Values (CSV) are the most widely used formats for data, and conversion between these two formats needs often to be accomplished. Especially to XML, because this format is very well supported by modern applications, and is very well suited for further data manipulation and customization.

Continue reading “How to Convert XML to CSV using PHP”

How to Convert XML to CSV using PHP was last modified: May 21st, 2018 by Soumitra Roy Sarkar

Generate PDF Report from MySQL Database using Codeigniter

Here we will see how to generate pdf report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications. PDF format reports allows professionals to edit, share, collaborate and ensure the security of the content within digital documents. Reports are mostly generated in PDF format because a PDF file is a “read only” document that cannot be altered without leaving an electronic footprint whereas other formats like image, word, excel etc. can easily be altered without leaving an electronic footprint. PDF files are compatible across multiple platforms whereas a word document may not be viewable easily in Mac system.

Here we will create a web application to generate report from MySQL database using Codeigniter. We will create a table in MySQL database and retrieve the records from the table and display on a view in table format. We will provide a hyper link to generate the PDF from the table data. You will be given a popup asking to save the generated pdf file. Then you can choose your convenient location for saving the file.

Continue reading “Generate PDF Report from MySQL Database using Codeigniter”

Generate PDF Report from MySQL Database using Codeigniter was last modified: May 14th, 2018 by Soumitra Roy Sarkar

Generate HTML Table from MySQL database using Codeigniter

Here is an example showing you how to generate HTML table from MySQL database using Codeigniter. We will write here an example to create a table from a multi-dimensional array. The Table Class provides functions that enable you to auto-generate HTML tables from arrays or database result sets.

Here we will create a web application to generate HTML table from MySQL database using Codeigniter. We will create a table in MySQL database and retrieve the records from the table and display on a view in table format.

Continue reading “Generate HTML Table from MySQL database using Codeigniter”

Generate HTML Table from MySQL database using Codeigniter was last modified: May 5th, 2018 by Soumitra Roy Sarkar

MongoDB PHP 7 CRUD Example

We know MongoDB is very popular open source, document based NoSQL database. In this tutorial we will create MongoDB PHP 7 CRUD Example.  CRUD means Create, Read, Update and Delete operations. So basically you will add new data (create), fetch data (read), edit existing data (update) and remove existing data (delete) from database.

Please make sure you have read how to configure MongoDB with PHP 7 for XAMPP before reading MongoDB PHP 7 CRUD Example.

Continue reading “MongoDB PHP 7 CRUD Example”

MongoDB PHP 7 CRUD Example was last modified: April 30th, 2018 by Soumitra Roy Sarkar

Search AutoComplete using Codeigniter jQuery

Here in Codeigniter jQuery AutoComplete example we will see how to do search AutoComplete using Codeigniter jQuery.  Autocomplete allows you to easily create autocomplete and auto-suggest boxes for text input fields. When you start a search on Google or other search engines, you can find the information you are looking for using search predictions. Search predictions are possible search terms you can use that are related to the terms you are typing and what other people are searching for.

Autocomplete is a feature in which an application predicts the rest of a word a user is typing. In graphical user interfaces, users can typically press the tab key to accept a suggestion or the down arrow key to accept one of several.
Autocomplete speeds up human-computer interactions when it correctly predicts the word a user intends to enter after only a few characters have been typed into a text input field. The autocomplete is a normal text input enhanced by a panel of suggested options.

Continue reading “Search AutoComplete using Codeigniter jQuery”

Search AutoComplete using Codeigniter jQuery was last modified: April 26th, 2018 by Soumitra Roy Sarkar

Configure MongoDB with PHP 7 for XAMPP on Windows

This tutorial will show you how to configure MongoDB PHP 7 for XAMPP on Windows. XAMPP is an open source, easy to install Apache distribution containing PHP, Perl and MySQL. It’s very easy to install after downloading the Windows exe inataller file.

MongoDB is one of the widely used NoSQL(Not only SQL) database in market today. MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need. Often we come across a situation where we end up using MongoDB with PHP in XAMPP stack.

Continue reading “Configure MongoDB with PHP 7 for XAMPP on Windows”

Configure MongoDB with PHP 7 for XAMPP on Windows was last modified: April 30th, 2018 by Soumitra Roy Sarkar

Disable Bitlocker Recovery on Windows Startup

This tutorial will show you how to disable Bitlocker Recovery option in Microsoft Windows 10 Home edition. If you have Microsoft account and if you used the same credentials while installing or factory resetting your Windows 10 operating system then you can easily get the Bitlocker Recovery key using your Microsoft account. But the problem is every time you start your system you have to input the Recovery key and it’s really annoying or irritating. So here I am going to tell you different solutions to turn off Bitlocker Recovery in Windows 10 Home edition.

Continue reading “Disable Bitlocker Recovery on Windows Startup”

Disable Bitlocker Recovery on Windows Startup was last modified: April 21st, 2018 by Soumitra Roy Sarkar

GEO location with HTML5 and jQuery

This tutorial shows you how to display the geographic location or Geo location of a user or device on a Google map, using your browser’s HTML5 Geolocation feature along with the Google Maps JavaScript API.

What is Geolocation?

Geolocation refers to the identification of the geographic location of a user or computing device via a variety of data collection mechanisms. Typically, most geolocation services use network routing addresses or internal GPS devices to determine this location. Geolocation is a device-specific API. This means that browsers or devices must support geolocation in order to use it through web applications. You may find about Geolocation here Google Geolocation Continue reading “GEO location with HTML5 and jQuery”

GEO location with HTML5 and jQuery was last modified: April 19th, 2018 by Soumitra Roy Sarkar

Create React JS Application on Windows

In this tutorial I am going to show you how we can create React JS application in Windows environment.

Before reading this tutorial please make sure you have installed the node.js in your system. Please have a look at this here for node.js installation

Prerequisites

I’ll assume you do have some familiarity with HTML and JavaScript, but you should be able to follow along even if you haven’t used them before.

Please follow the below steps one by one in order to create React application.

Continue reading “Create React JS Application on Windows”

Create React JS Application on Windows was last modified: April 11th, 2018 by Soumitra Roy Sarkar