MySQL & PHP References: 2018

Tuesday, November 20, 2018

Mac OSX adb command not found - SOLVED

Am sure you have not set your PATH to android PLATFORM-TOOLS

No Worries

Try this

brew cask install android-platform-tools

Friday, October 26, 2018

PHP MySQL - Stored procedure with a Query SOLVED

1st Time in almost 19 years i tried this a I was building backend intensive application using PHP & MySQL, where I had to reuse queries in many pages and had to write SQL QUERY repetitively almost everywhere across tables

****** mysqli PROCEDURE *******
DELIMITER //
CREATE PROCEDURE prop_detail(IN pno INT)
 BEGIN
 SELECT * 
 FROM listings, property_tbl
 WHERE listings.pno = pno and listings.pno = property_tbl.pno;
 END //
DELIMITER;

***** PHP MYSQL ***********
<?php include('config.php'); ?>
<?php
 $mtk = mysqli_query($con,'CALL photo_all("184")') or die('photo error : ' . mysqli_error($con));
 while($stk = mysqli_fetch_assoc($mtk)){
  echo '<img src="' . $stk["location"] . '"><br>';
 }
?>

LIFE COULD HAVE BEEN THIS SIMPLE BEFORE had i used it.

SHIT HAPPENS!!!!

Tuesday, October 16, 2018

PHP Lakh and Million Number Format - solved

Its very simple till you learn

Million Format
 echo number_format($ppc["cost"], 0, '', ',');

/// lakhs format

$dollar = 6000000000;
setlocale(LC_MONETARY, 'en_IN');
echo $dollar = money_format('%!i', $dollar);

Saturday, October 6, 2018

How to Remove GoDaddy Tracker Script from Your Web page Footer - SOLVED

How to Remove GoDaddy Tracker Script from Your Web page Footer???

Login into your GoDaddy A/c
Hosting - MANAGE ALL
Below cPanel Button - see 3-Dotted button
Click on - HELP US
and click - OPT OUT

No Thanks Necessary, Ma'am...

Wednesday, September 12, 2018

Parse error: syntax error, unexpected 'use' (T_USE) in phpmailer - SOLVED

Yep!!! shit happens to everyone who use PHPMailer.

//declare USE before session_start()
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

//dont worry it wont give any error
session_start();

Friday, August 31, 2018

Javascript not Adding two values from dropdown and input element - solved

prepend "+" to value
use canary : (+waiting_charge + +ifare)
check the example

<div id="dfare"><input type="text" id="ifare" name="ifare" value="125.86554215"></div>

<select name="wait" id="wait" onchange="getwait()" >
      <option value="0">--- Waiting Time ---</option>
      <option value="30">30 Mins</option>
      <option value="60">1 Hour</option>
      <option value="90">1 Hour 30 Mins</option>
      <option value="120">2 Hour</option>
      <option value="150">2 Hour 30 Mins</option>
      <option value="180">3 Hour</option>
      <option value="210">3 Hour 30 Mins</option>
      <option value="240">4 Hour</option>
      <option value="270">4 Hour 30 Mins</option>
      <option value="300">5 Hour</option>
      <option value="330">5 Hour 30 Mins</option>
      <option value="360">6 Hour</option>
      <option value="390">6 Hour 30 Mins</option>
    </select>

    <script type="text/javascript">
     function getwait(){
      var ifare = document.getElementById('ifare').value;

      var k = document.getElementById('wait');
        var waiting = k.options[k.selectedIndex].value;

        var tfare = (+waiting + +ifare);

      //document.getElementById("dfare").innerHTML += '<Br>Base Fare : $ ' + parseFloat(ifare).toFixed(2) + '<br>';
      
      //document.getElementById("dfare").innerHTML += '<Br>Waiting Charge : $ ' + parseFloat(waiting,2) + '<br>';
      document.getElementById("dfare").innerHTML += '<br>Total Fare : ' +  parseFloat(tfare).toFixed(2) + '<br>';
      document.getElementById("dfare").innerHTML += '<input type="text" name="tfare" id="tfare" value="' + parseFloat(tfare).toFixed(2) + '" />';
     }
    </script>

Tuesday, August 21, 2018

Google Map API - Multiple Waypoint and Distance Calculation - SOLVED

I was wondering for longtime on how "MULTIPLE WAYPOINTS by adding Address New INPUTS" works thanks to GeoZipCode and I added Distance and Time taken to gravel

Criteria
Start Point
End Point
--- add ----
Multiple Waypoints

---- Return ----
Routes on Google Map
Show Total Distance
Show Time take to travel Distance

Here is the complete code for you

<!DOCTYPE html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title></title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <meta name="robots" content="noindex, nofollow"> <meta name="googlebot" content="noindex, nofollow"> <meta name="viewport" content="width=device-width, initial-scale=1"> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js" ></script> <link rel="stylesheet" type="text/css" href="result-light.css"> <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?libraries=geometry,places&ext=.js"></script> <style type="text/css"> html, body, #map_canvas { height: 100%; width: 100%; margin: 0px; padding: 0px } </style>  <script type="text/javascript"> var counter = 1; var limit = 10; var i = 0; var ACoptions = { componentRestrictions: { country: "au" } }; var directionsService; var directionsDisplay; function initialize() { var inputs = document.getElementById('start'); var autocompletes = new google.maps.places.Autocomplete(inputs, ACoptions); var inpute = document.getElementById('end'); var autocompletee = new google.maps.places.Autocomplete(inpute, ACoptions); var waypoints = document.getElementsByName("waypoints[]"); for (var i = 0; i < waypoints.length; i++) { var inputw = waypoints[i]; var autocompletew = new google.maps.places.Autocomplete(inputw, ACoptions); } directionsDisplay = new google.maps.DirectionsRenderer(); directionsService = new google.maps.DirectionsService(); var melbourne = new google.maps.LatLng(-31.953512, 115.857048); var myOptions = { zoom: 12, mapTypeId: google.maps.MapTypeId.ROADMAP, center: melbourne } map = new google.maps.Map(document.getElementById("map_canvas"), myOptions); directionsDisplay.setMap(map); google.maps.event.addDomListener(document.getElementById('getdir'), 'click', function() { calculateAndDisplayRoute(directionsService, directionsDisplay); }); } google.maps.event.addDomListener(window, "load", initialize); function addInput(divName) { if (counter == limit) { alert("You have reached the limit of adding " + counter + " inputs"); } else { var newbr = document.createElement('br'); var newtxt = document.createTextNode("" + (counter + 1)); var newinput = document.createElement("input"); newinput.setAttribute("name", "waypoints[]"); newinput.setAttribute("autocompute", "on"); newinput.setAttribute("type", "text"); // newin = (counter + 1) + "<input type=text name=waypoints[] autocomplete=on>"; document.getElementById(divName).appendChild(newbr); document.getElementById(divName).appendChild(newtxt); document.getElementById(divName).appendChild(newinput); counter++; i++; console.log("cntr=" + counter + " i=" + i + " waypoints[].length=" + document.getElementsByName("waypoints[]")); // var inputw = waypoints[i]; var autocompletew = new google.maps.places.Autocomplete(newinput, ACoptions); } } function calculateAndDisplayRoute(directionsService, directionsDisplay) { var waypts = []; var checkboxArray = document.getElementById('dynamicInput'); var waypointElmts = document.getElementsByName('waypoints[]'); for (var i = 0; i < waypointElmts.length; i++) { if (waypointElmts[i].value.length > 0) { waypts.push({ location: waypointElmts[i].value, stopover: true }); } } directionsService.route({ origin: document.getElementById('start').value, destination: document.getElementById('end').value, waypoints: waypts, optimizeWaypoints: true, travelMode: 'DRIVING' }, function(response, status) { if (status === 'OK') { directionsDisplay.setDirections(response); computeTotalDistance(response); } else { window.alert('Directions request failed due to ' + status); } }); function computeTotalDistance(result) { var totalDist = 0; var totalTime = 0; var myroute = result.routes[0]; for (i = 0; i < myroute.legs.length; i++) { totalDist += myroute.legs[i].distance.value; totalTime += myroute.legs[i].duration.value; } totalDist = totalDist / 1000. document.getElementById("total").innerHTML = "total distance is: " + totalDist + " km<br>total time is: " + (totalTime / 60).toFixed(2) + " minutes"; } } </script> </head> <body> <div id="total"></div> <input id="start" value="Margaret River, AU" /> <input id="end" value="Perth, AU" /> <div id="dynamicInput"> <br>1 <input type="text" name="waypoints[]" autocomplete="on"> </div> <input type="button" value="Another Delivery" onClick="addInput('dynamicInput');"> <input id="getdir" type="button" value="get route" /> <div id="map_canvas"></div> <script> // tell the embed parent frame the height of the content if (window.parent && window.parent.parent){ window.parent.parent.postMessage(["resultsFrame", { height: document.body.getBoundingClientRect().height, slug: "v5sh9o2z" }], "*") } </script> </body> </html>

Friday, June 22, 2018

How to Prevent Web Form SPAM - Solved PHP

Very simple after getting spammed 47000 times in 8 days, i found this solutions.

Dont go with Preg or rpreg etc etc

Just put common keywords in an array & boot the mother fuckers with EXIT(0) when they caught redhanded spamming on your website.

no mother fucker can now, spam on my holy-FORM

$owned_urls = array('blog','http','medicine','10 mg','article','product','porn','bitch','http','25 mg','0.25 mg',' mg','purchase','clinical','diseases','pain','oxy','children','kids');

$string = strtolower('i have a medicine for your to look into');

//$owned_urls = array('website1.com', 'website2.com', 'website3.com');
   /// $string = 'my domain name is website3.com';
    for($i=0; $i < count($owned_urls); $i++)
    {
        if(strpos($string,$owned_urls[$i]) != false){
            echo 'Found';

        } else {
         exit(0);
         echo 'stop it';
        }
    }

Have Fun --- our latest delivery VIP Boston Limo

Friday, April 27, 2018

Htaccess redirect to HTTPS://WWW - solved

If you are looking for HTACCESS script to redirect your SSL Enabled website to redirect to HTTPS and to WWW here is the best one for you

RewriteEngine On
RewriteCond %{HTTPS} off
# First rewrite to HTTPS:
# Don't put www. here. If it is already there it will be included, if not
# the subsequent rule will catch it.
RewriteRule .* https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
# Now, rewrite any request to the wrong domain to use www.
# [NC] is a case-insensitive match
RewriteCond %{HTTP_HOST} !^www\. [NC]
RewriteRule .* https://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

Our latest Delivery
Sunulimo.com
GroundAirLimo.com

Friday, March 9, 2018

Google Ranking Lost due to Google Adwords

Fuck!!! Fuck!!! Fuck!!!

My website was on top 3 & went down after I put Google Adwords.

I was a big fucking mistake.

Right now my website is on 4th page.

Dont Know HOW-To bring it back on 1st page.

Google Screwed my Website Ranking

PHP MySQL - Effective Way to Build Search Query SQL Example

If you are implementing search capabilities on your PHP MySQL website.

Here is best example on HOW-TO

When implementing searching capabilities 1st thing we need to look into is SQL QUERY STATEMENTS and effective way of writing it for best search results

Check Here for Best Example

Saturday, January 13, 2018

Self-Hosted Scripts - Github

This is a list of Free Software network services and web applications which can be hosted locally. Selfhosting is the process of locally hosting and managing applications instead of renting from SaaS providers.

Check All Self-Hosted Scripts

Tuesday, January 2, 2018

Find Image Size in PHP - solved

Its very easy to resize images in PHP based on your requirement - height or width to keep them uniform on pages

<?php

function imgsize($ximg){
list($width, $height, $type, $attr) = getimagesize($ximg);

  echo "Image width " . $width;
  echo "Image height " . $height;
  echo "Image type " . $type;
  echo "Attribute " . $attr;
  echo '<br><Br>';
 
 if($width <= 250){
   echo '<img src="' . $ximg . '" alt="" style="width:250px" />';
 } else if($height >= 100 ) {
  echo '<img src="' . $ximg . '" alt="" style="height:100px" />';
 } else {
  echo '<img src="' . $ximg . '" alt="" style="width:250px" />';
 }
}

  imgsize('../images/hotels/hotels/Adina_logo.png');


?>

Our Latest Website Released

MySQL & PHP References

Search This Blog