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>

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;

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

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>

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>

Date as Header Row in PHP MySQL [solved]

After long bang bang and stackflow here is what i found to :
Date as Row Header
Daily Report Table in Using MySQL & PHP

How You will love it

<?php include('config.php'); $result = mysqli_query($con, 'select * from sform where date_format(csdate,"%Y") != "1969" order by csdate ASC'); $dateSection = ""; echo '<table width="100%">'; while($row = mysqli_fetch_assoc($result)) { $dateHeader = date("d-M, Y", strtotime($row['csdate'])); if ( $dateHeader != $dateSection ) { $dateSection = $dateHeader; echo '<tr><td colspan="5" style="background:#000;color:#fff; text-align:center; padding:8px; font-weight:bold;">' . $dateHeader .'</td></tr>'; } echo '<tr>'; echo '<td>#' . $row["rno"] . '</td>'; echo '<td>' . $row["cname"] . '</td>'; echo '<td>' . date('d-M, Y @ h:i A', strtotime($row["csdate"])) . '</td>'; echo '<td>' . $row["cphone"] . '</td>'; echo '<td>' . $row["caddr"] . '</td>'; echo '<td>' . $row["csnop"] . '</td>'; echo '</tr>'; } ?>

How to Install Laravel on Mac OSX

If you're facing this issue with macOS Catalina, I recommend these steps:

[PS: do not waste your time installing apt-get or yum ]

-- Just Install Homebrew (if you haven't already done so): head over to brew.sh or simply run this command: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

-- Run brew install php@7.3


Update your $PATH variable to include the newly installed version of php:
>>> echo 'export PATH="/usr/local/opt/php@7.3/bin:$PATH"' >> ~/.zshrc
-- Also --
>>>>>> echo 'export PATH="/usr/local/opt/php@7.3/sbin:$PATH"' >> ~/.zshrc

-- Reload your shell preferences script $ source ~/.zshrc or source ~/.bashrc

Finally, install laravel: composer global require laravel/installer

CSS Clip-PathMaker - live code

If you are looking for CSS CLIP-PATH example code for polygon, hexagon, triangle or square or custom shape for your webiste - just check here for instant size & point co-ordinates --- Clip-Path Maker

Dot Leaders in Receipt Design CSS HTML

Dot leaders btw Description and Rate in HTML CSS

CSS Code
<style type="text/css"> ul li { width: 100%; } ul.leaders { max-width: 40em; padding: 0; overflow-x: hidden; list-style: none} ul.leaders li:before { float: left; width: 0; white-space: nowrap; content: ". . . . . . . . . . . . . . . . . . . . " ". . . . . . . . . . . . . . . . . . . . " ". . . . . . . . . . . . . . . . . . . . " ". . . . . . . . . . . . . . . . . . . . "} ul.leaders span:first-child { padding-right: 0.33em; background: white} ul.leaders span + span { float: right; padding-left: 0.33em; background: white} </style>

HTML Cide
<ul class="leaders"> <li> <span>Base Fare</span> <span>$25.00</span> </li> <li> <span>Addl. PAX</span> <span>$20.00</span> </li> <li> <span>Child Seat</span> <span>$10.00</span> </li> <li> <span>Booster Seat</span> <span>$10.00</span> </li> <li> <span>Total Fare</span> <span>$65.00</span> </li> <li> <span>Discount (15%)</span> <span>$9.75</span> </li> <li> <span>Total Payable<br>(After Discount)</span> <span>$55.25</span> </li> </ul>

Taxi Website Designers.com

MYSQL - Group by date and Sum by Everyday

If want to calculate sum of everyday here is simple ways to do it

Sum of Everyday Descending Order in MySQL

select date(csdate) as xdate, sum(ifare) as total from rform group by date(csdate) order by date(csdate) DESC

Sum of A Day in Mysql

select csdate, ifare from rform where date(csdate) = "2015-09-21"

Removing white space non-numeric characters parenthesis spaces hyphens of Phone Number formatting in MySQL Query Statement

This is God of All Small Things.

You have phone number with too many formattting like
(444) 444-4444
(555)555-5555
800-123-4567
877 987-4563

and you want to QUERY it in MySQL like "4085439351" --- you will have to write a trigger and use it as function in your MYSQL QUERY STATEMENT

STEP#1 -- WRITE A QUERY

// phone10() is your function name DELIMITER $$ USE [database]$$ // USE A DATABASE WHERE YOU WANT TO SAVE YOUR TRIGGER DROP FUNCTION IF EXISTS `phone10`$$ CREATE DEFINER=`root`@`localhost` FUNCTION `phone10`(str VARCHAR(1000)) RETURNS VARCHAR(1000) CHARSET latin1 DETERMINISTIC BEGIN DECLARE counter INT DEFAULT 0; DECLARE strLength INT DEFAULT 0; DECLARE strChar VARCHAR(1000) DEFAULT '' ; DECLARE retVal VARCHAR(1000) DEFAULT ''; SET strLength = LENGTH(str); WHILE strLength > 0 DO SET counter = counter+1; SET strChar = SUBSTRING(str,counter,1); IF strChar REGEXP('[0-9]+') = 1 THEN SET retVal = CONCAT(retVal,strChar); END IF; SET strLength = strLength -1; SET strChar = NULL; END WHILE; RETURN retVal; END $$ DELIMITER ;

MYSQL QUERY STATEMENT

SELECT person FROM usermst WHERE phone10(phone_number) = '123456789' select phone10(phone_number) from usermst

SIMPLE - ISN'T IT???

Video Background Header Plain CSS - SOLVED

This is Plain CSS Video Background Header optimized for Desktop & Mobile Phone working great. Enjoy!!!

<!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, height=device-height, initial-scale=1.0, minimum-scale=1.0"> <style type="text/css"> *{ margin: 0; paddding: 0; } .wrapper{ width: 100%; height: 80vh; overflow: hidden; } .wrapper .wrapper__video{ object-fit: cover; width: 100%; height: 100%; } #xoverlay { text-align: center; margin: 20px 40px; position: absolute; z-index: 214; } #logo1 { width: 90%; } </style> </head> <body> <header> <div class="wrapper"> <div id="xoverlay"> <img src="images/our-logo.png" id="logo1"> </div> <video autoplay loop muted class="wrapper__video"> <source src="images/bg-video.mp4"> </video> </div> </header> </body> </html>

Dropdown of 50 States of United States

Here is Dropdown of 50 States of United States for you

<select name="states"> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connecticut</option> <option value="DE">Delaware</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Kentucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">NewHampshire</option> <option value="NJ">NewJersey</option> <option value="NM">NewMexico</option> <option value="NY">NewYork</option> <option value="NC">NorthCarolina</option> <option value="ND">NorthDakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">RhodeIsland</option> <option value="SC">SouthCarolina</option> <option value="SD">SouthDakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">WestVirginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select>

how to install ADB on MACBOOK or Mac OS - SOLVED

It is very simple. follow the steps

• 1. INSTALL HOMEBREW (if not installed) -- ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
• INSTALL ADB --- brew cask install android-platform-tools
• TEST --- adb devices

htaccess REWRITE URL with multiple Query String

.htaccess REWRITE URL with multiple Query String

RewriteEngine On Options -Multiviews Options +FollowSymLinks #LoadModule rewrite_module modules/mod_rewrite.so #AddModule mod_rewrite.c #RewriteBase / #local pages RewriteRule ^US/([A-Za-z0-9-]+)/([A-Za-z0-9-]+)/?$ city.php?st=$1&cty=$2 [NC,L]

Visit my website : Taxi Website Designers.com