development

3 minutes read
Get a list of user who are inside the circle or square of a given latitude and longitude with given distance or radius. For example my input Lat= 75.1545 and Long = 64.7643 and distance = 10 miles. I would like to get the list of users who are inside 10 miles distance from the point 75.1545 and 64.7643. Now its possible to solve this by single Mysql query. So we need  a user  table with user name, latitude and longitude of the users address. The Mysql query that will find the closest 50 l...
10 minutes read
How to manage international languages in MySQL database using php ? If you want to store multiple languages like Arabic, French, Hindi or Urdu to your MySQL database, default settings is not valid to do that to insert all languages in database. If you insert data in your database and database is not configured as I am going to show you in this tutorial then your data will be look like special characters निम and your data will lost .   So now i am going to tell you how to confi...
4 minutes read
cURL is a best library for file transfer via different types of protocols. cURL supports the transport via POST, GET, FTP upload and much more. cURL is also able to authenticate on the destination server or website. How to send files using PHP and cURL In this tutorial we want to upload a file to other (password protected) remote FTP server using a web form. <?php if (isset($_POST['Submit'])) { if (!empty($_FILES['file']['name'])) { $ch = curl...