PHP Tutorials

PHP Interview Questions and Answers Set – 4

In this tutorial we are providing some set of frequently asked PHP Interview Questions for experienced candidates which will help you to get success in interview. Read PHP MySQL Interview Questions and Answers Set – 3. How to find current date and time? The date() function provides you with a means of retrieving the current date and time, applying the format integer parameters indicated in your script to the timestamp …

Continue reading

PHP MySQL Interview Questions and Answers Set – 3

In this tutorial we are providing some set of frequently asked PHP MySQL Interview Questions which will help you to get success in interview. Read PHP interview questions and answers Set – 2. How can we connect to a MySQL database from a PHP script? To be able to connect to a MySQL database, we must use mysql_connect() function as follows: What is the function mysql_pconnect() usefull for? mysql_pconnect() ensure …

Continue reading

PHP interview questions and answers Set – 2

In this tutorial we are providing new set of some frequently asked PHP Interview Questions which will help you to get success in interview session easily. Read previous set PHP interview questions and answers. What should we do to be able to export data into an Excel file? The most common and used way is to get data into a format supported by Excel. For example, it is possible to …

Continue reading

PHP interview questions and answers

In this tutorial we are providing you some frequently asked PHP Interview Questions which will help you to get success in interview session easily. PHP is an important part of the web world, and every web developer should have the basic knowledge in PHP. Common PHP interview questions, which should help you become a best PHP developer. What is PHP? PHP is a server side scripting language commonly used for …

Continue reading

Convert Data from MySQL to JSON using PHP

Convert Data from MySQL to JSON using PHP

Converting data from MySQL to JSON format in PHP, is one of the most prominent task in web development. JSON is the most preferred data format over xml as data exchange between web and mobile applications. JSON format has it’s own advantages like light weight, ability to store complex data structures in plain text and human readability. In previous post we have already discussed about converting JSON data into MySQL …

Continue reading

How to Insert JSON Data into MySQL using PHP

How to Insert JSON Data into MySQL using PHP

In this tutorial I will show you How to Insert JSON Data into MySQL using PHP. To convert JSON to MySQL using PHP includes some steps like how to read JSON file, convert json to array and insert that json array into MySQL database. Here are the steps to Insert JSON data into MySQL using PHP. Step 1: Read the JSON file in PHP We have to read the JSON …

Continue reading

How to Convert XML into Associative Array in PHP

In this tutorial I will show you how to convert XML into associative array in php. I have found several methods and library to convert XML into array and following is a simple script to convert xml into array. I am using file_get_contents() php method to read xml file data into string. Steps to Convert XML into Associative Array Step 1: Following is a sample XML file books.xml Step 2: …

Continue reading

convert currency in PHP using Google Finance API

In this tutorial, I will show you how to convert currency in PHP using Google Finance API. Using the API you can easily convert any currency to your desired country currency. You have to send out http request to Google finance with three values – amount, from currency and to currency code. It sends back the response as HTML which you have to parse and extract the converted amount. PHP …

Continue reading