MySQL & PHP References: October 2020

Friday, October 30, 2020

background 100% center css

Very simple apply body or container div

body { 
  background: url(images/bg.jpg) no-repeat center center fixed; 
  -webkit-background-size: cover;
  -moz-background-size: cover;
  -o-background-size: cover;
  background-size: cover;
}

Monday, October 26, 2020

Square Payment Form PHP -- Customer linked to Payment Order

After lot of bang bang. I could find a way to do 3 tasks with Square Payment Form in PHP

Check from Square Customer Director if USER EXISTS based on PHONE number - If yes Get "CUSTOMER ID" and MAKE PAYMENT
If Customer does not exists in Directory -- CREATE A NEW USER -- GO & GET --> find CUSTOMER ID --> & MAKE PAYMENT
Get PAYMENT ID & SAVE IT IN MySQL Database

PS : This is very crud way of scripting (hahaha). Had to find a way to get this project done. I found out simple way by using GOTO statement. Hope it will help you of my 3 weeks of in between projects and delivered.

ENV file -- env (without extension -- plain text file)

# Acceptable values are sandbox, production or custom. 
ENVIRONMENT=sandbox 

# Production credentials
PRODUCTION_ACCESS_TOKEN=EAAAEHVIqnlTrOXTNRrE-OrUb543339iU5B4Ah1mg87659we74jbf448dVk87m
PRODUCTION_APP_ID=sq0idp-ZsOG3433Y9U7QUT53433cV33mA
PRODUCTION_LOCATION_ID=D33BS33SCC343Y6

# Sandbox credentials
SANDBOX_ACCESS_TOKEN=EAAAE33ssbbDcCM33wXvcuOZagCmAaVGlFDmU0STei8393wZCA2RdfWKonGOQhEVkR7N
SANDBOX_APP_ID=sandbox-sq0idb-6KYsus78fsdfseglC55Z_5mLw

Genarate Square Idempotency Key CLASS) - square-functions.php

class UUID {
  public static function v3($namespace, $name) {
    if(!self::is_valid($namespace)) return false;

    // Get hexadecimal components of namespace
    $nhex = str_replace(array('-','{','}'), '', $namespace);

    // Binary Value
    $nstr = '';

    // Convert Namespace UUID to bits
    for($i = 0; $i < strlen($nhex); $i+=2) {
      $nstr .= chr(hexdec($nhex[$i].$nhex[$i+1]));
    }

    // Calculate hash value
    $hash = md5($nstr . $name);

    return sprintf('%08s-%04s-%04x-%04x-%12s',

      // 32 bits for "time_low"
      substr($hash, 0, 8),

      // 16 bits for "time_mid"
      substr($hash, 8, 4),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 3
      (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x3000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

      // 48 bits for "node"
      substr($hash, 20, 12)
    );
  }

  public static function v4() {
    return sprintf('%04x%04x-%04x-%04x-%04x-%04x%04x%04x',

      // 32 bits for "time_low"
      mt_rand(0, 0xffff), mt_rand(0, 0xffff),

      // 16 bits for "time_mid"
      mt_rand(0, 0xffff),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 4
      mt_rand(0, 0x0fff) | 0x4000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      mt_rand(0, 0x3fff) | 0x8000,

      // 48 bits for "node"
      mt_rand(0, 0xffff), mt_rand(0, 0xffff), mt_rand(0, 0xffff)
    );
  }

  public static function v5($namespace, $name) {
    if(!self::is_valid($namespace)) return false;

    // Get hexadecimal components of namespace
    $nhex = str_replace(array('-','{','}'), '', $namespace);

    // Binary Value
    $nstr = '';

    // Convert Namespace UUID to bits
    for($i = 0; $i < strlen($nhex); $i+=2) {
      $nstr .= chr(hexdec($nhex[$i].$nhex[$i+1]));
    }

    // Calculate hash value
    $hash = sha1($nstr . $name);

    return sprintf('%08s-%04s-%04x-%04x-%12s',

      // 32 bits for "time_low"
      substr($hash, 0, 8),

      // 16 bits for "time_mid"
      substr($hash, 8, 4),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 5
      (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x5000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

      // 48 bits for "node"
      substr($hash, 20, 12)
    );
  }

  public static function is_valid($uuid) {
    return preg_match('/^\{?[0-9a-f]{8}\-?[0-9a-f]{4}\-?[0-9a-f]{4}\-?'.
                      '[0-9a-f]{4}\-?[0-9a-f]{12}\}?$/i', $uuid) === 1;
  }


  	/// usage -- 
  	//$v4uuid = UUID::v4();

 	//echo 'generated code : ' . $v4uuid;
}

HTML FORM - paynow.php

<!DOCTYPE html>
<html>
<head>
	<title></title>
<style type="text/css">
	#xtbl { width: 400px; }
	#xtbl  { width: 100%; }
	#xtbl td { padding: 5px; }
	#xtbl [type=text],[type=tel],[type=email] { padding: 5px; font-size: 14px; margin: 6px 0px; width: 100%; }
</style>

<?php
require 'vendor/autoload.php';

use Square\Environment;
$dotenv = Dotenv\Dotenv::create(__DIR__);
$dotenv->load();

$upper_case_environment = strtoupper(getenv('ENVIRONMENT'));

?> 

<script type="text/javascript" src=
    <?php
        echo "\"";
        echo ($_ENV["ENVIRONMENT"] === Environment::PRODUCTION)  ?  "https://js.squareup.com/v2/paymentform"
                                            :  "https://js.squareupsandbox.com/v2/paymentform";
        echo "\"";
    ?>
  ></script>
  <script type="text/javascript">
    window.applicationId =
      <?php
        echo "\"";
        echo getenv($upper_case_environment.'_APP_ID');
        echo "\"";
      ?>;
    window.locationId =
    <?php
      echo "\"";
      echo getenv($upper_case_environment.'_LOCATION_ID');
      echo "\"";
    ?>;
  </script>
<script type="text/javascript" src="js/sq-payment-form.js"></script>
  <link rel="stylesheet" type="text/css" href="css/sq-payment-form.css">

</head>
<body>

<div class="sq-payment-form">



    <div id="sq-ccbox">

  <form id="nonce-form" novalidate action="check-customer.php" method="post" style="padding: 30px; border: #c3c3c3 1px solid; border-radius: 8px;">

      	<center><img src="images/square-logo.png" style="width: 180px; margin-bottom: 25px;"></center>

      	<table id="xtbl">
			<tr>
				<td colspan="2">
					<label>Your Full Name</label>
					<input type="text" name="cname" id="cname" placeholder="name familyname">
				</td>
			</tr>
			<tr id="col2">
				<td>
					<label>Phone #</label>
					<input type="tel" name="cphone" id="cphone" class="cxPhone" maxlength="12">
				</td>
				<td>
					<label>E-Mail @</label>
					<input type="email" name="cemailid" id="cemailid">
				</td>
			</tr>
			<tr id="col2">
				<td>
					<label>Fare</label>
					<input type="text" name="ifare" id="ifare">
				</td>
				<td>
					<label>Note</label>
					<input type="text" name="note" id="note">
				</td>
			</tr>
		</table>
		<h3 style="background: #000; color: #fff; padding: 8px 0px; text-align: center;"><b>Credit Card Details</b></h3>
        <div class="sq-field">
          <label class="sq-label">Card Number</label>
          <div id="sq-card-number"></div>
        </div>
        <div class="sq-field-wrapper">
          <div class="sq-field sq-field--in-wrapper">
            <label class="sq-label">CVV</label>
            <div id="sq-cvv"></div>
          </div>
          <div class="sq-field sq-field--in-wrapper">
            <label class="sq-label">Expiration</label>
            <div id="sq-expiration-date"></div>
          </div>
          <div class="sq-field sq-field--in-wrapper">
            <label class="sq-label">Postal</label>
            <div id="sq-postal-code"></div>
          </div>
        </div>
        <div class="sq-field">

        	
          <button id="sq-creditcard" class="sq-button" onclick="onGetCardNonce(event)">
            Pay Now 
          </button>
        </div>
        <div id="error"></div>
        <input type="hidden" id="card-nonce" name="nonce">
      </form>
    </div>
  </div>
</body>
</1html>

PROCESS PAYMENT Page --- process-payment.php

<?php include('config.php');
			//print_r($_POST); 
			$booknow = $_POST;

			require 'vendor/autoload.php';

			use Dotenv\Dotenv;
			use Square\Models\Money;
			use Square\Models\CreatePaymentRequest;
			use Square\Exceptions\ApiException;
			use Square\SquareClient;
			use Square\Environment;
			use SquareConnect\ApiClient;
			use Square\Models\CreateCustomerRequest;

			$idem = UUID::v4();


			$sname = explode(' ', $_POST["cname"]);
			$sname0 = $sname[0];
			$sname1 = $sname[1];

			$cphone = $_POST["cphone"];
		
			$cemailid = $_POST["cemailid"];
			$ifare = ($_POST["ifare"] * 100);
			$xnote = $_POST["note"];

			//echo '<br><br>fare : ' . $ifare . '<br><br>';


			$dotenv = Dotenv::create(__DIR__);
			$dotenv->load();

			$upper_case_environment = strtoupper(getenv('ENVIRONMENT'));

			$access_token =  getenv($upper_case_environment.'_ACCESS_TOKEN');   

			//print_r($access_token);
			 //echo '<br><br><br>';

			$client = new SquareClient([
			  'accessToken' => $access_token,  
			  'environment' => getenv('ENVIRONMENT')
			]);


			if ($_SERVER['REQUEST_METHOD'] != 'POST') {
			  error_log('Received a non-POST request');
			  echo 'Request not allowed';
			  http_response_code(405);
			  return;
			}

			$nonce = $_POST['nonce'];
			if (is_null($nonce)) {
			  echo 'Invalid card data';
			  http_response_code(422);
			  return;
			}

				goto searchCustomers;

				searchCustomers: ///search customers

				$phone_number = new \Square\Models\CustomerTextFilter();
				$phone_number->setFuzzy($cphone);

				$filter = new \Square\Models\CustomerFilter();
				$filter->setPhoneNumber($phone_number);

				$query = new \Square\Models\CustomerQuery();
				$query->setFilter($filter);

				$body = new \Square\Models\SearchCustomersRequest();
				$body->setQuery($query);

				$api_response = $client->getCustomersApi()->searchCustomers($body);

				if ($api_response->isSuccess()) {

					$rmn = $api_response->getBody();
					$stx = json_decode($rmn,true);

					echo '<br><br>';	
					echo '# of arrays : ' . count($stx);
					if(count($stx) != 0){
						//echo '<br><br>';		
						$cust_id = $stx["customers"][0]["id"];
						//echo "Customer ID : " . $cust_id;
						goto makePayment;
						


					} else {
						//echo 'user do not exists';
						/// new customer - start

						$body1 = new \Square\Models\CreateCustomerRequest();
						$body1->setIdempotencyKey($idem);
						$body1->setGivenName($sname0);
						$body1->setFamilyName($sname1);
						$body1->setEmailAddress($cemailid);
						$body1->setPhoneNumber($cphone);

						$api_response = $client->getCustomersApi()->createCustomer($body1);

						if ($api_response->isSuccess()) {
						    $result = $api_response->getResult();
						    sleep(12);
						     goto searchCustomers;
						} else {
						    $errors = $api_response->getErrors();
						   
						}

						/// new customer - end
					}
				} else {
				   echo '<br><br>sorry not found!<bR><br>';
				}

				goto end;


				makePayment:

				$amount_money = new \Square\Models\Money();
				$amount_money->setAmount($ifare);
				$amount_money->setCurrency('USD');

				$body = new \Square\Models\CreatePaymentRequest(
						'cnon:card-nonce-ok',
						$idem,
					    $amount_money
				);
				$body->setCustomerId($cust_id);
				$body->setNote($xnote);

				$api_response = $client->getPaymentsApi()->createPayment($body);

				if ($api_response->isSuccess()) {
				    $result = $api_response->getResult();
				    $pmt = $api_response->getResult();

				    echo '<br><br>';
				    echo "PAYEMNT SUCCESSUFLL <BR><br><br>";
				   // print_r($srt);
					echo '<br><br>';

					$resp_arr = $api_response->getBody();
					  $resp_dec = json_decode($resp_arr, true);
					  $transid = $resp_dec["payment"]["id"];
					  echo 'payment id : ' . $transid;

				    
				    goto end;

				} else {
				    $errors = $api_response->getErrors();
				    echo 'payment FAILEDDDDDDDDDD';
				}

				goto end;

				end:
?>

Thursday, October 22, 2020

Create a New Customer in Square Payment Gateway

This script helps you to Create a new customer for your references to do business with. Open in API

This script Requires ENV script file (without FILE EXTENSION) at root -- env
Please Change your API CREDENTIALS accordingly

# Acceptable values are sandbox, production or custom. 
ENVIRONMENT=sandbox 

# Production credentials
PRODUCTION_ACCESS_TOKEN=EAAAEHVIqnlTrOXTNRrE-OrUb543339iU5B4Ah1mg87659we74jbf448dVk87m
PRODUCTION_APP_ID=sq0idp-ZsOG3433Y9U7QUT53433cV33mA
PRODUCTION_LOCATION_ID=D33BS33SCC343Y6

# Sandbox credentials
SANDBOX_ACCESS_TOKEN=EAAAE33ssbbDcCM33wXvcuOZagCmAaVGlFDmU0STei8393wZCA2RdfWKonGOQhEVkR7N
SANDBOX_APP_ID=sandbox-sq0idb-6KYsus78fsdfseglC55Z_5mLw

Add New Customer Form Page -- new-customer.php

<!DOCTYPE html>
<html>
<head>
	<title></title>
	<style type="text/css">
		#xform { width: 350px; }
		#xform table { width: 100%; }
		#xform [type=text],[type=email],[type=tel] { width: 100%; padding: 8px; margin: 7px 0px; }
		#xform table td { padding:5px; }
	</style>
</head>
<body>

<form id="xform" action="save-customer.php" method="post">
<table>
	<tr>
		<td colspan="2">
			<label>Name of Passenger</label>
			<input type="text" name="cname" id="cname" placeholder="passenger name">
		</td>
	</tr>
	<tr>
		<td>
			<label>Phone #</label>
			<input type="tel" name="cphone" id="cphone" placeholder="000 000 0000" maxlength="10">
		</td>
		<td>
			<label>E-Mail @</label>
			<input type="email" name="cemailid" id="cemailid" placeholder="youremail@server.com">
		</td>
	</tr>
	<tr>
		<td colspan="2">
			<input type="submit" name="csubmit" id="csubmit" value="  Save Customer  ">
		</td>
	</tr>
</table>

</form>
</body>
</html>

Save New Customer to SQUARE -- new-customer.php


print_r($_POST);
echo '<br><br>';

$sname = explode(' ',$_POST["cname"]);


require 'vendor/autoload.php';

use Dotenv\Dotenv;
use Square\Models\Money;
use Square\Models\CreatePaymentRequest;
use Square\Exceptions\ApiException;
use Square\SquareClient;
use Square\Environment;
use SquareConnect\ApiClient;
use Square\Models\CreateCustomerRequest;

// dotenv is used to read from the '.env' file created for credentials
$dotenv = Dotenv::create(__DIR__);
$dotenv->load();

// Pulled from the .env file and upper cased e.g. SANDBOX, PRODUCTION.
$upper_case_environment = strtoupper(getenv('ENVIRONMENT'));

//echo $upper_case_environment . '<br><br>';

// The access token to use in all Connect API requests.
// Set your environment as *sandbox* if you're just testing things out.
$access_token =  getenv($upper_case_environment.'_ACCESS_TOKEN');   
//$access_token =  getenv('_ACCESS_TOKEN');   

//echo 'access token for you lkjlksdjflkajdsflka  :  ';
print_r($access_token);
 echo '<br><br><br>';

// Initialize the Square client.
$client = new SquareClient([
  'accessToken' => $access_token,  
  'environment' => getenv('ENVIRONMENT')
]);

$body = new \Square\Models\CreateCustomerRequest();
//$body->setIdempotencyKey('9cd6a0bd-e29e-4a73-981f-964da564bb31');
$body->setGivenName($sname[0]);
$body->setFamilyName($sname[1]);
$body->setEmailAddress($_POST["cemailid"]);
$body->setPhoneNumber($_POST["cphone"]);

$api_response = $client->getCustomersApi()->createCustomer($body);

if ($api_response->isSuccess()) {
    $result = $api_response->getResult();
} else {
    $errors = $api_response->getErrors();
}

Sunday, October 18, 2020

SQUARE Paypement API -- is fucking stupid

Tell you what!!! Square SDK and APIs are so fucking stupid, do they even have working script example???

Nowadays we have many frameworks & CMS plugins --- if you keep popping "AUTHENTICATION_ERROR" -- how the fuck in your cunt are we gonna get it right & deliver product solution????

All SQUARE have for you is fucking WALK THROUGH in NODE???

can you host THIS NODE script on SHARED LINUX HOSTING???

who the fuck you think is kidding -- mother fuckers???

POST output -- all error

Array
(
    [amount] => 100
    [nonce] => cnon:CBASEKtzztv5iqjCZCj27lsNBXk
    [nds-pmd] => {"jvqtrgQngn":{"oq":"1536:434:1536:824:1536:824","wfi":"flap-151081","oc":"7801n9nnn1pq5r85","fe":"1536k864 24","qvqgm":"-330","jxe":454178,"syi":"snyfr","si":"si,btt,zc4,jroz","sn":"sn,zcrt,btt,jni","us":"26rp5o5p2o5sq2po","cy":"Jva32","sg":"{\"zgc\":0,\"gf\":snyfr,\"gr\":snyfr}","sp":"{\"gp\":gehr,\"ap\":gehr}","sf":"gehr","jt":"s2nno0055p58o750","sz":"1rqsq5761s4859n9","vce":"apvc,0,5s8oo13q,2,1;fg,0,;zz,73o,313,q8,fd-pii;zzf,3rn,0,n,0 6p8,4nr5 r84,n54,o03,-33q3o,2oor6,-r4p;zzf,3s0,3s0,n,ABC;zzf,3qs,3qs,n,ABC;zzf,3r8,3r8,n,6335 395,6335 395,9rq,n07,3q6r8,3q6r8,624n;zz,2s1,2on,r1,;zzf,sn,3ro,n,r9 19q,196r 1qq5,p37,p5p,-3on8q,1941r,-5r37;zzf,3r5,3r5,n,ABC;zzf,3s3,3s3,n,ABC;zzf,3r3,3r3,n,ABC;zzf,3r4,3r4,n,n48 rr9,n48 rr9,1q0,1o4,-o518,p0n7,128;zzf,3r5,3r5,n,ABC;zz,182,340,qn,;zz,14ps,38s,10n,;gf,0,449p;zp,40q,2sp,13n,fd-perqvgpneq;","ns":""},"jg":"1.j-669810.1.2.VTRvNxGbIOUzs6VspVDdGN,,.TyDuEa47agV1eu5eo7gms8-4JKAg0GwBLowl04JbiFzjAoHhKqdgj2Gt5y1uiv40I4HHdD4kitt4vl38LperLJqhFIgyqmCPHpvhZfww8WZtibCNAdMHEZuxwBgb0ZfgOuFiWcQmZjDNkKgjE7ArwOQ_2joruMq9zwR4KTmWQqwWhMc4QOnJ5luU1bPXIX18LwhNgd7NKdYtXuVPNdDlgr6yKe3ZADzTKvJTddConRc1zKw58lWb6fMPuYmD6FR-"}
)

USUAL FUCKING SUSPECT --- which these fucking square developer section or ZERO CUSTOMER CARE never explains you where the fuck YOU HAVE GONE WRONG -- WHAT ARE THEY MOTHER FUCKERS AT SQUARE ARE ARROGANT ABOUT???.

Exception when calling TransactionApi->charge:object(stdClass)#8 (1) {
  ["errors"]=>
  array(1) {
    [0]=>
    object(stdClass)#7 (3) {
      ["category"]=>
      string(20) "AUTHENTICATION_ERROR"
      ["code"]=>
      string(12) "UNAUTHORIZED"
      ["detail"]=>
      string(491) "The `Authorization` http header of your request was malformed. The header value is expected to be of the format "Bearer TOKEN" (without quotation marks), where TOKEN is to be replaced with your access token (e.g. "Bearer ABC123def456GHI789jkl0"). For more information, see https://developer.squareup.com/docs/build-basics/using-rest-api#__set-the-headers__. If you are seeing this error message while using one of our officially supported SDKs, please report this to developers@squareup.com."
    }
  }
}

MySQL & PHP References

Search This Blog