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

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

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

Samsung SmartTV WebUI - AngularJS

The 'caph.focus' is an AngularJS module which provides functionality to navigate the focusable elements using the remote controller which is a main input device of TV. It consists of 3 parts: the 'focusable' directives which represent focusable elements, the 'nearestFocusableFinder' which is in charge of searching for the nearest focusable elements, and the 'focusController' which provides the focus related behaviors.

Samsung SmartTV & AngularJS - Check Here

Multiple Links - AJAX load Page in DIV PHP

Check this for simply load dynamic php content into a DIV using AJAX

<html lang="en"> <head> <meta charset="UTF-8"> <title>Include</title> </head> <body> <a href="#link1">Link1</a> <a href="#link2">Link2</a> <a href="#link3">Link3</a> <a href="#link4">Link4</a> <div id="include"></div> <script type="text/javascript" src="http://code.jquery.com/jquery-1.11.0.min.js"></script> <script type="text/javascript"> var includeDiv = $("#include"); $(window).on('hashchange', function() { var href = location.hash.slice(1) +".html"; includeDiv.load('include/' + href); }); </script> </body> </html>

Google Fucked my Website Ranking - ADSENSE SCAM

Google Fucked my website ranking after I installed Google Adsense

Yes, It is True!!!

Mother fuckers - fucked my website ranking very very very badly I was ranked 3rd in my category
they pushed me to 4th page

Took time to back on 1st page after i removed GOOGLE FUCKING ADSENSE.

Dont go and fuck your website ranking unless you are not a DIRECTORY SERVICE

WHY???
COULD BE BECAUSE I HAD A INQUIRY FORM on all pages of my website
SPAMMERS SPAM-ED LIKE HELL
IDIOT FUCKING ALGORITHM OF GOOGLE DID NOT UNDERSTAND SPAM ATTACK
AND I LOST MY RANKING

stripe\stripe-php no version set - solved

This is idiotic by Stripe that NO VERSION SET always gives gitter to developers.

its very simple
Change this to "name": "stripe/stripe-php",

"name": "stripe/stripe-php^5.7",

Just Add the version shown in the error message

Css Flip Image Tutorial

You have a Image & you want to flip it left-to-right or right-to-left

its simple in CSS

.flip { -moz-transform: scaleX(-1); -o-transform: scaleX(-1); -webkit-transform: scaleX(-1); transform: scaleX(-1); filter: FlipH; -ms-filter: "FlipH"; }

Taxi Website Designers.com

Ionic 3 Tutorials

Google Chrome - Stop Page Refreshing / Reload in inactive tabs - Solved

Idiot Drunken Engineers at Google tried something horrible to save some RAM but ended up screwing our browsing experience - INACTIVE TAB PAGE REFRESH When you go back to a TAB after long period (15mins) - WEBPAGE WOULD START RELOADING

That is stupidity anyone can think of.

Here is the solution on how to STOP THIS NUISANCE. check the image

#1 - type chrome://flags #2 - browse to AUTOMATIC TAB DISCARDING #3 - change option to "DISABLED" #4 - Close the brower & reopen

Cheer!!! No more page reloading

Google Fucked My Blogger

Google is a Mother Fucking "Search Engine"

Google has fucked highly ranked this Blog after I put Google Adsense to it.

Now am Removing it.

Anyways, We dont make money, neither should Google.

Navigator Watch Position - Access Geolocation Mobile Browser

Simple Code for Watch Navigator Position & access geo location on mobile browsers code for you.

Remember you need SSL Certificate (HTTPS) to test or implement it.

index.php <!DOCTYPE HTML> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <title>GEO location Experiment</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <meta name="robots" content="index,follow"/> <meta name="description" content=""/> <meta name="keywords" content=""/> <meta name="title" content=""/> <meta name="language" content="en"/> <meta name="author" content="Bharadwaja Bidadi - www.taxiwebsitedesigners.com"/> <meta name="googlebot" content="NOODP"/> <link rel="stylesheet" href="geo.css"/> <script type="text/javascript" src="geo.js"></script> </head> <body> <div class="output" id="output"></div> <div class="geo_controls"> <button id="geo_start_stop"> Start </button> </div> <div class="website_link"> <a href="http://www.taxiwebsitedesigners.com">Back to My Website</a> </div> </body> </html>

CSS Stylesheet : GEO.CSS html{background:#fff;font:100 80% helvetica,arial,verdana,sans-serif;color:#494949;margin:0;padding:1em;}div{float:left;width:100%;}form{float:left;width:auto;}fieldset{float:left;width:auto;padding:0.5em;border-color:#f0f;outline:none;}div#online_status{font-size:0.8em;color:#999;padding:0 0 1em 0;}div.form_row{width:100%;padding:0.25em 0;}div.form_row label,div.form_row textarea{float:left;clear:both;}div#output{padding:0.5em;border:1px solid #999;}div#google_map{margin:2em 0;width:800px;height:600px;}div.website_link{padding:1em 0 0 0;}

Javascript var start_stop_btn,wpid=false,map,z,op,prev_lat,prev_long,min_speed=0,max_speed=0,min_altitude=0,max_altitude=0,distance_travelled=0,min_accuracy=150,date_pos_updated="",info_string="";function format_time_component(time_component) {if(time_component<10) time_component="0"+time_component;else if(time_component.length<2) time_component=time_component+"0";return time_component;} function geo_success(position) {start_stop_btn.innerHTML="Stop";info_string="";var d=new Date();var h=d.getHours();var m=d.getMinutes();var s=d.getSeconds();var current_datetime=format_time_component(h)+":"+format_time_component(m)+":"+format_time_component(s);if(position.coords.accuracy<=min_accuracy) {if(prev_lat!=position.coords.latitude||prev_long!=position.coords.longitude) {if(position.coords.speed>max_speed) max_speed=position.coords.speed;else if(position.coords.speed<min_speed) min_speed=position.coords.speed;if(position.coords.altitude>max_altitude) max_altitude=position.coords.altitude;else if(position.coords.altitude<min_altitude) min_altitude=position.coords.altitude;prev_lat=position.coords.latitude;prev_long=position.coords.longitude;info_string="Current positon: lat="+position.coords.latitude+", long="+position.coords.longitude+" (accuracy "+Math.round(position.coords.accuracy,1)+"m)<br />Speed: min="+(min_speed?min_speed:"Not recorded/0")+"m/s, max="+(max_speed?max_speed:"Not recorded/0")+"m/s<br />Altitude: min="+(min_altitude?min_altitude:"Not recorded/0")+"m, max="+(max_altitude?max_altitude:"Not recorded/0")+"m (accuracy "+Math.round(position.coords.altitudeAccuracy,1)+"m)<br />last reading taken at: "+current_datetime;}} else info_string="Accuracy not sufficient ("+Math.round(position.coords.accuracy,1)+"m vs "+min_accuracy+"m) - last reading taken at: "+current_datetime;if(info_string) op.innerHTML=info_string;} function geo_error(error) {switch(error.code) {case error.TIMEOUT:op.innerHTML="Timeout!";break;};} function get_pos() {if(!!navigator.geolocation) wpid=navigator.geolocation.watchPosition(geo_success,geo_error,{enableHighAccuracy:true,maximumAge:30000,timeout:27000});else op.innerHTML="ERROR: Your Browser doesnt support the Geo Location API";} function init_geo() {op=document.getElementById("output");if(op) {start_stop_btn=document.getElementById("geo_start_stop");if(start_stop_btn) {start_stop_btn.onclick=function() {if(wpid) {start_stop_btn.innerHTML="Start";navigator.geolocation.clearWatch(wpid);wpid=false;} else {start_stop_btn.innerHTML="Aquiring Geo Location...";get_pos();}}} else op.innerHTML="ERROR: Couldn't find the start/stop button";}} window.onload=init_geo;

Google Adwords & Adsense - SCAM

This is about Google Adwords & Adsense all you need to know.

Fun is, this BLOG LOST RANKING on GOOGLE once I applied GOOGLE ADWORDS!!!???

Over the period of time I've been watching Google Advts Spear and things keep evolving & Google comes out with NEW CHEAT METHODS to THUG ADVERTISERS & WEBSITE POSTING / DISPLAYING ADVERTISEMENTS.

Scam - Advertisers

Google Charge Advertisers based on Peak Hours / Off Peak. Just like Uber (rather Uber follows Google Method)

Google hardly keeps tracks of FAKE CLICKS & Competitor Clicks and ZERO REFUND
Google Adwords ~ Charges differential rates to advertisers
I doubt Google JUMPS click METER...

XDSoft DateTimePicker - Previous Dates Only & Future Days

XDSoft Date & Time Picker is my favorite script & have been using for very longtime.

Its a simple Method, check the samples

<script> jQuery.noConflict(); (function( $ ) { $(function() { // ONLY FUTURE DATES $('#fdate').datetimepicker({ timepicker:false, format:'m/d/Y', minDate: "1", }); // ONLY PREVIOUS DATES $('#pdate').datetimepicker({ timepicker:false, format:'m/d/Y', startDate: '<?php date("m/d/Y", strtotime("-3 months")); ?>', maxDate:"1", }); }); })(jQuery); </script>

Pay Now Button Custom HTML Code - Paypal

Fucking Paypal removed term "PAY NOW" from its vocabulary but "BASIC BUY NOW" button

<form action="https://www.paypal.com/cgi-bin/webscr" method="post"> <!-- Identify your business so that you can collect the payments. --> <input type="hidden" name="business" value="yourpaypalemailid@gmail.com"> <!-- Specify a Buy Now button. --> <input type="hidden" name="cmd" value="_xclick"> <!-- Specify details about the item that buyers will purchase. --> <input type="hidden" name="item_name" value="NYC Taxi Service"> <input type="hidden" name="amount" value="25.85"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="custom" value="254121"> <!-- Display the payment button. --> <input type="image" name="submit" border="0" src="https://www.paypalobjects.com/webstatic/en_US/i/btn/png/btn_buynow_107x26.png" alt="Buy Now"> <img alt="" border="0" width="1" height="1" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" > </form>

Simple isnt it???

Our latest Delivery ~ Airport Taxi Service Minneapolis