How to Import MySQL Database from SQL File using PHP

Importing SQL script via programming will be useful when we need to create database structure dynamically. For example, if we provide APP or plugin to download and install from online, the dynamic SQL import will be used to setup the application database at the time of installing the APP or plugin. To import SQL file in the database, you have to login to your hosting server or phpMyAdmin. Also, you can import the database from PHP script without login to your hosting server or phpMyAdmin. Import database from PHP script…

Read More

How to Create Dynamic Category Subcategory Tree using PHP and MySQL

category-subcategory-tree-dropdown

Category and subcategory tree view structure gives an easy to use approach to list the parent and child categories. The category and their subcategory are effectively isolated by a tree structure. The categories tree view is constantly recommended to display a boundless level of categories and subcategories. In this instructional exercise, we will show you industry standards to make dynamic category subcategory tree using PHP and MySQL. The recursive category tree is extremely helpful to list n level categories in a dropdown. The code help you to make n level…

Read More

How to update PHP version in Xampp

Your search for the Xampp tutorial has finally got an end. As in this blog post of how to update php version in Xampp, we will make you come across the learning’s you were looking for. We understand it requires a lot of time to use multiple versions of php for your various projects. In this situation, sometimes you end up with installing xampp on different port or you can install one xampp and update php. Through this blog post, you will come across how you can update php version…

Read More

How to create PHP Text Captcha without google captcha API

php captcha code

PHP Text Captcha is a image of text which is generated by free captcha script. It is used to protect your login form, register form or any forms from spam ,abuse and hackers. In this article, we will learn How to create PHP Text Captacha without google captcha API. PHP Text Captcha is open source script which is used to create complex images. Features of PHP Text Captcha: Code Structure is small. phpTextClass is used to create captcha image Code is fully customizable Security features with random lines and noise…

Read More

How to Integrate Paypal Payment System with Paypal API in PHP and MySql

paypal-integration

In this article, you will learn about How to Integrate PayPal Payment System with PayPal API in PHP and MySQL. Here i will show you how to use PayPal Sandbox test account for payment system development and passing arguments while click on buy now button. It’s a simple and easy way to integrate in your own web projects to process payment with PayPal gateway. You need to follow our step by step process: Step-1: Create a Sandbox account at https://developer.paypal.com/ Step-2: Now signup a test account for payment system. Take a look at…

Read More

How to POST and Receive JSON Data using cURL in PHP

POST and Receive JSON Data using cURL in PHP

In this article you will learn about how to create web services APIs using PHP. Iif you are working with web services, you need to know about how we can POST and Receive JSON Data using cURL in PHP. Sending and Receiving JSON data via POST Request is most important functionality in PHP. It’s make easy to POST JSON data to APIs url and receive response in JSON data format. So, Today we will learn about “How to POST and Receive JSON Data using cURL in PHP”. Let’s Start to…

Read More

How to Export database records to CSV File using PHP and MySQL

export data to csv file using php and mysql

Import and export CSV file data is mostly used in web based application. Generally, CSV file data is used to import and export tabular data between programs because CSV is most popular file format to store tabular data in plain text. In this article, i will show you how to export mysqldatabase table records to CSV file using PHP. Also , you will get the knowledge to create CSV file in PHP and download the save MySQL data in CSV file. Before start export to CSV functionality, we will create…

Read More

How to Capture website Screenshot through website URL using Google PageSpeed Insights API and PHP

screenshot-capture

In this article you will learn “How to Capture website Screenshot through website URL using Google PageSpeed Insights API and PHP” Usually, Google PageSpeed Insight API is used to check the performance and speed of any website or webpage. But you never used Google PageSpeed Insights API to get website screenshot using URL. Website page screenshot capture functionality is used for many purposes in the web application. Now you can also use Google PageSpeed Insights API to capture a screenshot of webpage from URL. There are various third party APIs…

Read More

How to remove .php or .html extension using .htaccess file

how-to-remove-php-html-extension-using-htaccess

In this tutorial you will run “How to remove .php, .html extension using .htaccess file”. Many time we try to make our website more user friendly and search engine friendly. If you want to increase indexing of your website with google search engine then you need to make your website search engine friendly. In this tutorials, i will show you easy step by editing the .htaccess file. What is an .htaccess file First of all i want to tell you, what is an .htaccess file and why i will use?…

Read More

Send Email via SMTP Server in PHP using PHPMailer

Remove term: php mail smtp authentication php mail smtp authentication

In this article you will get the knowledge about Send Email via SMTP Server in PHP using PHPMailer. Send email from PHP Script is the most popular feature for the web application. Basically mail() is used to send email in php. When you try to send email using the php mail() function, the mail is sent from your web server. Sometimes it may create issue on sending an email and fails to deliver mail to recipient email id. But with the help of SMTP you can overcome this issue, SMTP…

Read More