MySQL & PHP References: April 2020

Thursday, April 30, 2020

Show Hide DIV using Bootstrap without Javascript

This neat & clean way to SHOW/HIDE DIV without JAVASCRIPT but only BOOTSTRAP CLASS

<!DOCTYPE html>
<html>
    <head>
        <meta name="format-detection" content="telephone=no">
        <meta name="msapplication-tap-highlight" content="no">
        <meta name="viewport" content="initial-scale=1, width=device-width">
        <link rel="stylesheet" type="text/css" href="css/bootstrap.css">
        <title>Nearests.com - Login</title>
        
    </head>
    <body>
        <div class="container">
            <div class="row">
            <a href="#Foo" class="btn btn-default" data-toggle="collapse">Toggle Foo</a>
            <button href="#Bar" class="btn btn-default" data-toggle="collapse">Toggle Bar</button>
            <div id="Foo" class="collapse">
                This div (Foo) is hidden by default
            </div>
            <div id="Bar" class="collapse in">
                This div (Bar) is shown by default and can toggle
            </div>
        </div>
</div>
        <script type="text/javascript" src="js/jquery.min.js"></script>
        <script type="text/javascript" src="js/bootstrap.js"></script>
    </body>
</html>

Visit my website Taxi Website Designerscom

Get Device Current Position without Button Click - Geolocation HTML5

This is strictly for BEGINNERS & pros can refer it too.

Get User / Device Current Position Lattitude & Longitude without clicking button using HTML5 GEOLOCATION

// GET LATITUDE AND LONGITUDE using HTML5 GEOLOCATION without button click

<input type="text" name="latlng" id="latlng">
        <script>
              if(!navigator.geolocation) {
                status.textContent = 'Geolocation is not supported by your browser';
              } else {
                navigator.geolocation.getCurrentPosition(success, error);
              }

              function success(position) {
                const latitude  = position.coords.latitude;
                const longitude = position.coords.longitude;

                var ltlng = position.coords.latitude + ',' + position.coords.longitude;
                return document.getElementById('latlng').value = ltlng;
              }

              function error() {
                status.textContent = 'Unable to retrieve your location';
              }
            </script>

Saturday, April 25, 2020

How to Store an Array in LocalStorage - [SOLVED]

localStorage only supports strings. Use JSON.stringify() and JSON.parse().

place array inside onDeviceReady and asign the json array to localStorage

onDeviceReady: function() {
        this.receivedEvent('deviceready');
        var xarr = { comp_name : 'my company name', phone: '408-543-9351', email: 'info@mycompwebsite.com',logo: 'img/mycomp-logo.png' }
        localStorage.setItem("arr", JSON.stringify(xarr));
    },

On Page parse values stored in localStorage array into another json array for implimentation

    // create div / span elements with respective IDs to display values
    
    var zarr = JSON.parse(localStorage.getItem("arr"));

        document.getElementById('xlogo').src = zarr.logo;
        document.getElementById('xflt').src = zarr.fleet;
        document.getElementById('xphone').innerHTML = zarr.phone;
        document.getElementById('xcomp').innerHTML = zarr.comp_name;

Monday, April 20, 2020

Warning: getimagesize(): Filename cannot be empty -- SOLVED

If you are experiencing this issue while trying to FIND SIZE OF IMAGE for RESIZING and you are getting this error means --- FAULTY CAMERA APP

I have both Samsung M30 & LG Q7+ ---- both IMAGE CREATION APPS are FAULTY
and i believe other phones too has these issues of IMAGE FILE CREATION issue

What a shame Samsung / LG --- am not big fan of Chinese Phone

How to Upload Images again???

Convert your Photos to JPG using photoshop and Upload again. IT WORKS!!!!

Sorry We Have no other ways to convert & upload thru PHP

---- OR ----
DISABLE "GEO LOCATION" feature in your camera -- IT WORKS

Sunday, April 19, 2020

Extract Geocoding Latitude Longitude from Image / Photo using PHP with Google MAP API [SOLVED]

Extract Latittude and Longitude from an photo shot using GPS Enabled device either Smartphone or Digital Camera using PHP & show the location on Google MAP with Marker.

I tried using EXIF.JS & jQuery but failed. PHP is simple and works great.

<!DOCTYPE html>
<html>
<head>
  <title></title>
</head>
<body>

<?php 
function gps2Num($coordPart){
    $parts = explode('/', $coordPart);
    if(count($parts) <= 0)
    return 0;
    if(count($parts) == 1)
    return $parts[0];
    return floatval($parts[0]) / floatval($parts[1]);
}

function get_image_location($image = ''){
    $exif = exif_read_data($image, 0, true);
    if($exif && isset($exif['GPS'])){
        $GPSLatitudeRef = $exif['GPS']['GPSLatitudeRef'];
        $GPSLatitude    = $exif['GPS']['GPSLatitude'];
        $GPSLongitudeRef= $exif['GPS']['GPSLongitudeRef'];
        $GPSLongitude   = $exif['GPS']['GPSLongitude'];
        
        $lat_degrees = count($GPSLatitude) > 0 ? gps2Num($GPSLatitude[0]) : 0;
        $lat_minutes = count($GPSLatitude) > 1 ? gps2Num($GPSLatitude[1]) : 0;
        $lat_seconds = count($GPSLatitude) > 2 ? gps2Num($GPSLatitude[2]) : 0;
        
        $lon_degrees = count($GPSLongitude) > 0 ? gps2Num($GPSLongitude[0]) : 0;
        $lon_minutes = count($GPSLongitude) > 1 ? gps2Num($GPSLongitude[1]) : 0;
        $lon_seconds = count($GPSLongitude) > 2 ? gps2Num($GPSLongitude[2]) : 0;
        
        $lat_direction = ($GPSLatitudeRef == 'W' or $GPSLatitudeRef == 'S') ? -1 : 1;
        $lon_direction = ($GPSLongitudeRef == 'W' or $GPSLongitudeRef == 'S') ? -1 : 1;
        
        $latitude = $lat_direction * ($lat_degrees + ($lat_minutes / 60) + ($lat_seconds / (60*60)));
        $longitude = $lon_direction * ($lon_degrees + ($lon_minutes / 60) + ($lon_seconds / (60*60)));

        return array('latitude'=>$latitude, 'longitude'=>$longitude);
    }else{
        return false;
    }
}


$imgURL = 'prop_img/20200419_105335.jpg';
$imgLocation = get_image_location($imgURL);

$imgLat = $imgLocation["latitude"];
$imgLng = $imgLocation["longitude"];

echo  'Latittude : ' . $imgLat;
echo '<br>longitude : ' . $imgLng . '<br><br>';

?>

<img src="<?php echo $imgURL; ?>" style="width: 150px;"><br><br>

<div id="map"></div>
<style type="text/css">
  #map { width: 500px; height: 500px; }
</style>



 <script>

      function initMap() {
        var myLatLng = {lat: <?php echo $imgLat; ?>, lng: <?php echo $imgLng; ?>};

        var map = new google.maps.Map(document.getElementById('map'), {
          zoom: 18,
          center: myLatLng
        });

        var marker = new google.maps.Marker({
          position: myLatLng,
          map: map,
          title: 'Hello World!'
        });
      }
    </script>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script src="https://maps.googleapis.com/maps/api/js?key=<?php echo $gmkey; ?>&callback=initMap" async defer></script>

</body>
</html>

Wednesday, April 1, 2020

Find Date of Next Sunday in PHP

This is best & beautiful PHP syntax and it surprised me today when i needed this function:

<?php echo date('Y-m-d',strtotime('next sunday')); ?>
<bR><br>

MySQL & PHP References

Search This Blog