Sunday, November 3, 2019

PHP FIX has been blocked by CORS policy: No 'Access-Control-Allow-Origin' - SOLVED

PHP FIX has been blocked by CORS policy: No 'Access-Control-Allow-Origin'

In the PHP code above, I am telling the browser that site-a.com has permission to make cross-domain requests to my website. The second parameter of PHP’s header function has been set to FALSE so that it is not overwritten by any other Access-Control-Allow-Origin headers that we may add in the future.

Note that you may also come across examples like this on the web:

//Access-Control-Allow-Origin header with wildcard.
Access-Control-Allow-Origin: http://siteA.com
Access-Control-Allow-Methods: GET, POST, PUT
Access-Control-Allow-Headers: Content-Type

<p>In the PHP code above, we have used a wildcard character. The problem with this is that it will allow everybody to make Ajax requests to our website. This is a lazy solution that may introduce security risks.</p>

Friday, November 1, 2019

PHP MySQL multiple rows to JSON

Simple to store PHP MySQL to JSON with multiple rows result

<?php include('config.php'); 
 $mkt = mysqli_query($con,'select * from booking order by csdate DESC');
 //while

 //$mkt = mysqli_query($con, $sql);
$result = array("booknow" => array()); //create an associative array with a property called "dashboard_content", which is an array. (json_encode will convert an associative array to a JSON object)

if (check) {
    $rows = mysqli_fetch_assoc($mkt);
    if (!$rows) {
        echo "No results!";
    } else {
          while ($rows = mysqli_fetch_assoc($mkt)) {
            $pickup = $rows['pickup'];
            $drop = $rows['drop'];
            $csdate = date('m-d-Y @ h:i A', strtotime($rows['csdate']));
            $cmsgs = $rows['cmsgs'];
            $tstamp = $rows['tstamp'];
          //  $rstatus = 

            

            //append the current data to a new entry in the "dashboard_content" array
            $result["booknow"][] = array('pickup' => $cadd, 'drop' => $drop, 'csdate' => $csdate, 'cmsgs' => $cmsgs, 'tstamp' => $tstamp); 
        }
    }

}

    //now, output the whole completed result to one single, coherent, valid JSON array.
    echo json_encode($result); 
?>

Thursday, October 31, 2019

how to create Keystore apk signing in command line cmd

Find KEYSTORE.EXE from your android studio / java installation drive on windows
Set Path to folder for easy access of keystore.exe

keytool -genkey -v -keystore c:\<[your-keystore-file-name]> -keypass bgb123456 -alias <[keystore name]> -keyalg RSA -keysize 2048 -validity 10000

keytool -exportcert -list -v -alias <[keystore name]> -keystore <[your-keystore-file-name]>

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
};

MySQL & PHP References

Search This Blog

Sunday, November 3, 2019