How to Get Latitude and Longitude from Image in PHP


Geographical location can be tagged with the photograph by geotagging. Generally, the latitude and longitude are assigned to the image to geotagged photograph. Geotagging is done by two ways, automatic or manual. There is an easy way to get Geotag data from the image using PHP. You can get the latitude and longitude where the picture was taken using PHP and mark the geolocation on Google map.

Pagination in PHP with MySQL


Pagination is a common functionality used almost every web application. When the huge data need to be retrieved from the database, it's not a good idea to display all result on one page. In that case, we can divide the records into pages instead of showing all at once. PHP Pagination class allows to paging data into pages and generates links to get data from MySQL database.

PHP CRUD Operations with MySQLi Extension


CRUD stands for Create, Read, Update and Delete. CRUD operations are commonly used to manipulate data in the database. Almost, all web application used Add, Edit, Update and Delete functionality for managing data. This tutorial will show how you can create a simple PHP CRUD application with MySQL to perform create (insert), read (select), update, and delete operations using MySQLi Extension and OOP.

Send Email with Attachment in PHP


Sending email from the script is the very useful functionality in the web application. If your web application uses PHP, it's very easy to send email from the script using PHP. PHP provides an easy way to send email from the website. Using mail() function in PHP, you can send text or HTML email. But sometimes email functionality needs to be extended for sending an attachment with the email from PHP script.

How to Export Data to CSV File using PHP and MySQL


CSV (comma-separated values) is the most popular file format to store tabular data in plain text. Generally, CSV file is used to import and export data for moving tabular data between programs. Import and export data is the most used feature in the web application, and CSV file format is a best chose for that. Here you will learn to create CSV file in PHP and download and save MySQL data in CSV file using PHP.

How to POST and Receive JSON Data using PHP cURL


When you working with web services and APIs, sending JSON data via POST request is the most required functionality. PHP cURL makes it easy to POST JSON data to URL. This tutorial shows you how to POST JSON data using PHP cURL and get JSON data in PHP. Our example code makes an HTTP POST request and send the JSON data to URL with cURL in PHP. Also, you can get or fetch the JSON POST data using PHP.

How to Capture Screenshot of Website from URL using PHP


Web page screenshot capture functionality is used for various purposes in the web application. There are many third party APIs are available to take a screenshot of the website. But if you wish to build your own script to get a screenshot from URL, you can do it easily using PHP and Google PageSpeed Insights API. Google PageSpeed Insights API can be used to get a screenshot of the website from URL.

Store and Retrieve Image from MySQL Database using PHP


Generally, when we upload an image file in PHP, the uploaded image is stored in a directory of the server and the respective image name is inserted into the database. But if you want to upload an image without storing on the server, it can be done using MySQL database. If you're concerned about the server space and need to free space on your server, insert the image file in the database without upload it to the directory.

Creating Dynamic Email Template in PHP


Mail sending feature is the most used functionality in the web application. When we sending email from our website, an email template is used to make email content attractive and user-friendly. Dynamic Email Template makes it easy to manage templates for different types of emails. The dynamic email template is most useful when you want to send email for multiple purposes with different templates.