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”
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”
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”
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”
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”
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”
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”
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”
The Josephus problem or Josephus permutations is a theoretical problem related to a certain counting-out game.
If you need to solve the Josephus problem using Java, please read here Solving Josephus Problem using Java
Josephus problem could be explained similar to below situation:
Continue reading “Solving Josephus Problem using PHP”
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
Please follow the below steps one by one in order to create React application.
Continue reading “Create React JS Application on Windows”