Run Apache As "Specific User" in Ubuntu

Access Below Command From Terminal

       

         sudo nano /etc/apache2/envvars

       
 

Modify Below Lines

       

         export APACHE_RUN_USER=specific_user
 export APACHE_RUN_GROUP=specific_user

       
 

Convert Mysql Time Stamp To Formatted Date

       

         Select DATE_FORMAT(FROM_UNIXTIME(`created_date`), '%e %b %Y') AS 'date_formatted';

       
 

Find The Distance Between Two Lat/Long using mysql functions

       

CREATE DEFINER=`root`@`localhost` FUNCTION `mm_calc_distance`(`lat1` double, `long1` double, `lat2` double, `long2` double) RETURNS double
BEGIN
 DECLARE distance_in_km double;
        SELECT 
           111.1111 *
           DEGREES(ACOS(COS(RADIANS(lat1))
           * COS(RADIANS(lat2))
           * COS(RADIANS(long1 - long2))
           + SIN(RADIANS(lat1))
           * SIN(RADIANS(lat2)))) into distance_in_km;


        RETURN distance_in_km;
END

       
 

Gist Github Url For Source Code