MySQL & PHP References

Wednesday, October 30, 2019

HASH Algorithm in MySQL PHP Query - SOLVED

MySQL Query of HASH SHA2 Type of SHA384

select * from users where SHA2(userid,384)="839121c5bbda9f7b630137aa10104cae53085f7a8a030d7b37f8158318ba20d059276c7aa0c455bdba3937582160a0b8"

PHP CONVERSION into HASH SHA2 Type of SHA384

<?php
hash( 'sha256', '789889 );
?>

List of universal HASH types for your references and MD5 is most common used - which can be easily DECODE by hash machines in seconds.

Array
(
    [0] => md2
    [1] => md4
    [2] => md5
    [3] => sha1
    [4] => sha224
    [5] => sha256
    [6] => sha384
    [7] => sha512
    [8] => ripemd128
    [9] => ripemd160
    [10] => ripemd256
    [11] => ripemd320
    [12] => whirlpool
    [13] => tiger128,3
    [14] => tiger160,3
    [15] => tiger192,3
    [16] => tiger128,4
    [17] => tiger160,4
    [18] => tiger192,4
    [19] => snefru
    [20] => snefru256
    [21] => gost
    [22] => gost-crypto
    [23] => adler32
    [24] => crc32
    [25] => crc32b
    [26] => fnv132
    [27] => fnv1a32
    [28] => fnv164
    [29] => fnv1a64
    [30] => joaat
    [31] => haval128,3
    [32] => haval160,3
    [33] => haval192,3
    [34] => haval224,3
    [35] => haval256,3
    [36] => haval128,4
    [37] => haval160,4
    [38] => haval192,4
    [39] => haval224,4
    [40] => haval256,4
    [41] => haval128,5
    [42] => haval160,5
    [43] => haval192,5
    [44] => haval224,5
    [45] => haval256,5

Tuesday, October 29, 2019

Cordova Screen Orientation Portrait - Solved

Cordova Screen Orientation Portrait in INDEX.JS inside "onDeviceReady: function()"

onDeviceReady: function() {
        this.receivedEvent('deviceready');
        screen.orientation.lock('portrait');
    },

Friday, October 25, 2019

UK Credit Card - HTML Dropdown

This html dropdown for you with all creditcard types available in United Kingdom developers

<select tabindex="11" id="CardType" style="margin-left: 10px;">
  <option value="AmEx">American Express</option>
  <option value="CarteBlanche">Carte Blanche</option>
  <option value="DinersClub">Diners Club</option>
  <option value="Discover">Discover</option>
  <option value="EnRoute">enRoute</option>
  <option value="JCB">JCB</option>
  <option value="Maestro">Maestro</option>
  <option value="MasterCard">MasterCard</option>
  <option value="Solo">Solo</option>
  <option value="Switch">Switch</option>
  <option value="Visa">Visa</option>
  <option value="VisaElectron">Visa Electron</option>
  <option value="LaserCard">Laser</option>
</select>

Thursday, October 24, 2019

Paypal PayNow BuyNow Button Script - Solved

Hey check this Paypal "Pay Now" or "Buy Now" button script

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" id="pxform" style="display:none !important;">
   <input type="hidden" name="business" value="merchant_email@domain.com">
   <input type="hidden" name="cmd" value="_xclick">
   <input type="hidden" name="item_name" value="NewPaper Service">
   <input type="hidden" name="amount" value="158.08">
   <input type="hidden" name="currency_code" value="USD">
   <input type="hidden" name="custom" value="refno2571">
   <input type="image" src="https://www.paypal.com/en_US/i/btn/btn_paynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
 </form>

Thats it

100% Body Background Image - Solved

Just check this

body {
    background-image:url("../images/myImage.jpg");
    background-repeat: no-repeat;
    background-size: 100% 100%;
}
html {
    height: 100%
}

Saturday, October 19, 2019

Wait for 5 Seconds and Redirect Page - Javascript or PHP

Piece of Cake. Here is how you can REDIRECT PAGE after waiting for 5 Seconds in PHP or Javascript

Redirect after 5 seconds in Javascript

<script>
window.setTimeout(function(){
   window.location.href = "https://www.google.co.in";
}, 5000);
   </script>

Redirect after 5 seconds in PHP

<php
header("Refresh: 10; url=" . $url . "http://localhost/mylookout/paypal_redirect.php?xno=" . $prno);
?>

Tuesday, October 15, 2019

Cordova MySQL PHP Remote Database functionalities -- SOLVED

After bang bang & kickass searches and tens of pages & trial and error -- here come simplest solution for CORDOVA - MYSQL - PHP REMOTE SERVER DATABASE CONNECTIVITY for you. Hope you dont have to PULL YOUR HAIR & GO BALD (as am already bald & getting married on 12th December 2019)

CORDOVA -- CRUD FORM / RESULT PAGE

<!DOCTYPE html>
<html>
    <head>
    <!--    <meta http-equiv="Content-Security-Policy" content="default-src 'self' data: gap: https://ssl.gstatic.com 'unsafe-eval'; style-src 'self' 'unsafe-inline'; media-src *; img-src 'self' data: content:;">-->
        <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/index.css">
        <title>DFW Taxi App</title>
        <style>
            body { padding:40px; text-align: center;}
        </style>
    </head>
    <body>
        <h1>register now</h1>
        <input type="text" name="cname" id="cname" value="narendra modi" />
        <input type="text" name="cphone" id="cphone" value="9848848450" />
        <input type="text" name="cemailid" id="cemailid" value="namo@htmail.com" />
        <button id="submit_btn">Register Now</button>
        

        <script type="text/javascript" src="cordova.js"></script>
        <script type="text/javascript" src="js/index.js"></script>
        <script type="text/javascript" src="js/jquery.js"></script>

        <script type="text/javascript">
            $(document).ready(function(){
                //updateList();
        
                $("#submit_btn").on("click", function(){
                    var xname = $("#cname").val();
                    var xphone = $("#cphone").val();
                    var xemailid = $("#cemailid").val();
        
                    success: function(data){
                  var obj = JSON.parse(data);
                  //console.log(data);
                  //alert(data);
                  // var scode = data[0];
                  // var uid = data[1];
                  // console.log(uid);
                  // alert(uid);
                  //alert(obj.uid);
                  alert('Your A/c Has Been Successfully Created');
                  //window.localStorage.setItem('xid',obj.uid);
                  window.location.href="index.html";
                }
                });
            });
        </script>
    </body>
</html>

REMOTE CRUD PHP PAGE

// DONT NOT FORGET -- 1st and 2nd line 
header("Access-Control-Allow-Origin: *");
header('Access-Control-Allow-Methods: GET, POST, PATCH, PUT,DELETE, OPTIONS');
// DONT NOT FORGET

session_start(); /// NO WORRIES safe in 3rd line
date_default_timezone_set("America/Mexico_City");

//data base connection
  
  $srv = 'localhost';
  $usr = 'SSDFD787SD7FS';
  $pwd = 'dKJFAUDIS';
  $db = 'usavedmyarse';

 
 $con = mysqli_connect($srv,$usr,$pwd,$db);
 if (!$con)
   {
   die('Could not connect: ' . mysqli_connect_error());
   }


// FUCK MAJIC --- PURE programing
// manipulate the way you want 
// dont just give a shit -- hit it

$booknow = $_POST;
mysql_insert_array('usermst', $booknow,$con); // am using function to save row in mysqli table
echo json_encode($booknow);

I would like to thank Code Sundar and Yogesh Sharma --- thank you nerds.

HOPE YOU WILL ENJOY IT!!! PEACE-V

Friday, July 26, 2019

WILDCARD SSL redirect http to https thru .HTACCESS - SOLVED

Redirect your website and subdomains with .HTACCESS

RewriteEngine On
RewriteCond %{HTTP_HOST} =myhost.com
RewriteCond %{SERVER_PORT} !443
RewriteRule /(.*) https://%{SERVER_NAME}/$1 [R,L]

Thursday, June 6, 2019

CSS Height by percentage - CSS Tricks [SOLVED]

if you have 2 DIV & want it different height in percentage

<!DOCTYPE html>
<html>
<head>
 <title></title>
 <style type="text/css">
  body, html { margin: 0px auto;  }
  #div1 { width:100%; height:70vh; background:#000; }
  #div2 { width: 100%; height: 30vh; background-color: red; }
 </style>
</head>
<body>
<div id="div1">sadfsaf asf asdf as</div>
<div id="div2">safasfasfsd afssa fsaf asdfsaf </div>
</body>
</html>

Sunday, June 2, 2019

Android' webview doesn't show google maps

In MainActivity.java under
webView=findViewById(R.id.webviewid);

Add :
webView.getSettings().setJavaScriptEnabled(true);

Sunday, March 31, 2019

City - Autocomplete JQuery Bootstrap4

City.php

<!DOCTYPE html>
<html>
<head>
    <title>Bootstrap Autocomplete with Dynamic Data Load using PHP Ajax</title>
 <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://code.jquery.com/jquery-2.1.4.min.js"></script>
   
 <style>
 .typeahead { border: 2px solid #FFF;border-radius: 4px;padding: 8px 12px;max-width: 300px;min-width: 290px;background: rgba(66, 52, 52, 0.5);color: #FFF;}
 .tt-menu { width:300px; }
 ul.typeahead{margin:0px;padding:10px 0px;}
 ul.typeahead.dropdown-menu li a {padding: 10px !important; border-bottom:#CCC 1px solid;color:#FFF;}
 ul.typeahead.dropdown-menu li:last-child a { border-bottom:0px !important; }
 .bgcolor {max-width: 550px;min-width: 290px;max-height:340px;background:url("world-contries.jpg") no-repeat center center;padding: 100px 10px 130px;border-radius:4px;text-align:center;margin:10px;}
 .demo-label {font-size:1.5em;color: #686868;font-weight: 500;color:#FFF;}
 .dropdown-menu>.active>a, .dropdown-menu>.active>a:focus, .dropdown-menu>.active>a:hover {
  text-decoration: none;
  background-color: #1f3f41;
  outline: 0;
 }
 </style> 
</head>
<body>
 <div class="bgcolor">
  <form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
  <label class="demo-label">Search City:</label><br/> <input type="text" name="txtCountry" id="txtCountry" class="typeahead"/>
  <input type="submit" name="csubmit" value=" Submit">
 </form>
 <?php if(isset($_POST["csubmit"])){
  print_r($_POST);
 } ?>
 </div>
</body>
<script>
    $(document).ready(function () {
        $('#txtCountry').typeahead({
            source: function (query, result) {
                $.ajax({
                    url: "server.php",
     data: 'query=' + query,            
                    dataType: "json",
                    type: "POST",
                    success: function (data) {
      result($.map(data, function (item) {
       return item;
                        }));
                    }
                });
            }
        });
    });
</script>
</html>

Search.php

<?php  
 $keyword = strval($_POST['query']);
 $search_param = "{$keyword}%";
 $conn =new mysqli('localhost', 'root', '' , 'weddingplanner');

 $sql = $conn->prepare("SELECT * FROM cities WHERE city LIKE ?");
 $sql->bind_param("s",$search_param);   
 $sql->execute();
 $result = $sql->get_result();
 if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
  $countryResult[] = $row["city"] . ' - ' . $row["state"];
  }
  echo json_encode($countryResult);
 }
 $conn->close();
?>

Tuesday, March 19, 2019

Remove PostCSS warning IONIC

Try this

find sass.js file. under /node_modules/@ionic/app-scripts/dist/sass.js
find var postcssOptions and add from: undefined,

Finally should be like this:
var postcssOptions = {
from: undefined,
to: path_1.basename(sassConfig.outFile),
map: autoPrefixerMapOptions
};

Ionic Cordova - spawn EACCES [SOLVED]

While building ionic app I was struck here

JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/HomeError:
spawn EACCES

and solution is simple

This is the command that finally fixed it for MY configuration
sudo chmod 777 “/Applications/Android Studio.app/Contents/gradle/gradle-4.1/bin/gradle”
Note the space in 'Android Studio'

What is the root problem? I don't know. I do know that I recently downloaded the new android studio 3 and then this started being a problem. It probably is something to do with the 'gradle-4.1'.

On a lot of other threads that contain this same issue there is someone strongly advising against just 'chmod'ing random folders, and I see his point, but I tried everything else.

OSX JAVA_HOME openjdk-11.0.2.jdk Error Requirements check failed for JDK 1.8 or greater

1.Remove all the Java related packages (Sun, Oracle, OpenJDK, IcedTea plugins, GIJ):

dpkg-query -W -f='${binary:Package}\n' | grep -E -e '^(ia32-)?(sun|oracle)-java' -e '^openjdk-' -e '^icedtea' -e '^(default|gcj)-j(re|dk)' -e '^gcj-(.*)-j(re|dk)' -e '^java-common' | xargs sudo apt-get -y remove
sudo apt-get -y autoremove

2.Purge config files (careful. This command removed libsgutils2-2 and virtualbox config files too):

dpkg -l | grep ^rc | awk '{print($2)}' | xargs sudo apt-get -y purge

3.Remove Java config and cache directory:

sudo bash -c 'ls -d /home/*/.java' | xargs sudo rm -rf

4.Remove manually installed JVMs:

sudo rm -rf /usr/lib/jvm/*

5.Remove Java entries, if there is still any, from the alternatives:

for g in ControlPanel java java_vm javaws jcontrol jexec keytool mozilla-javaplugin.so orbd pack200 policytool rmid rmiregistry servertool tnameserv unpack200 appletviewer apt extcheck HtmlConverter idlj jar jarsigner javac javadoc javah javap jconsole jdb jhat jinfo jmap jps jrunscript jsadebugd jstack jstat jstatd native2ascii rmic schemagen serialver wsgen wsimport xjc xulrunner-1.9-javaplugin.so;

do sudo update-alternatives --remove-all $g;

done

6.Search for possible remaining Java directories:

sudo updatedb
sudo locate -b '\pack200'

7.Install JAVA-8-SDK

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get install oracle-java8-installer

8.Open

sudo gedit ~/.bashrc
export ANDROID_SDK_ROOT=/yourAndroidStudioPath/Android
export PATH=${PATH}:$ANDROID_SDK_ROOT/tools:$ANDROID_SDK_ROOT/platform-tools
export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export JRE_HOME=/usr/lib/jvm/java-8-oracle/jre

Try to run your ionic app again :) Njoy!

Sunday, February 17, 2019

How to cast Amazon Prime on Google ChromeCast TV [solved]

It is very simple, you dont have to buy an Amazon FireStick to cast it on Google Chromecast or Mira Cast devices.

Log in Amazon Prime or Any Online Video Website
Select Video & Play
On Google Chrome Browser ---> Settings --> Cast --> Select Device from Popup
Thats IT!!!!

PS : ---> Do Not Close Chrome Browser TAB / Shutdown your System
---> If you are on laptop do not close it to sleep mode while movie is on in your TV

This is not just for Google Chrome Cast but any SmartTVs that has Miracast or screen casting features your can always enjoy this tips.