MySQL & PHP References: June 2015

Wednesday, June 24, 2015

Paypal Pending Review IPN - Sandbox or LIVE

Question :

I am using the PayPal IPN feature but I keep getting _POST[payment_status] = Pending when I make a test using the Sandbox. Because of that, I can't test the full purchase to make sure the whole process works properly.

Solution :

If you are using sandbox, open developer.paypal.com->Dashboard->Accounts->facilitator@yourhost.com->Profile->Settings. Set 'Payment review' to 'Off'

Paypal Payment Status Pending -- Paypal

Here is the problem:

User makes payment - ok

User returns to my website succesfully - ok

After a few seconds PayPal calls my website using IPN - ok

My class successfully validate incoming IPN data.

PayPal returns "payment_status: Pending"

I don't know why PayPal IPN calls back with the payment status of "pending"?

Does anyone know what I'm doing wrong?

Solution:

When you're logged into your test business account, manually navigate to:

Check Your Sandbox

You would normally be able to get there by going through your "My Business Setup" but currently it redirects to PayPal live (despite being in the sandbox).

Once you're on that page, change "Block payments sent to me in a currency I do not hold" to "No, accept them and convert them to ..."

Also, don't forget to confirm your business account using the PayPal Sandbox front-end and "Test Email" section of the API.

Media Screen CSS Template

CSS Media Screen Template

@media screen and (max-width: 320px) {
  /* TODO: Modify styles for a phone in portrait */
}
 
@media screen and (max-width: 480px) {
  /* TODO: Modify styles for a phone in landscape */
}
 
@media screen and (max-width: 768px) {
  /* TODO: Modify styles for a tablet in portrait */
}
 
@media screen and (max-width: 1024px) {
  /* TODO: Modify styles for a tablet in landscape */
}

Tuesday, June 23, 2015

Upload Image to Website - Fantastic PHP script

This should do it:

<?php<br /><br />if ($action == "Load")<br /> {<br />  $folder = "home/usr/website/images";<br />  @copy("$filep" , "$folder/$filep_name");<br />  echo "<br><p align=center>File <b><i>$filep_name</i></b> loaded...";<br />  <br />  $result = mysql_connect("mysql_host", "mysql_user", "mysql_password") <br />          or die(""<b>Could not save image name</b><p> Error: " . mysql_error());<br /><br />  @mysql_select_db("mysql_database") or die("Could not select database");<br />  @mysql_query("INSERT into mysql_table (mysql_table_field) VALUES('$filep_name')");<br />  if($result) { echo "<b>Image name saved into database</b><p>"; }<br />   <br /> }<br /><br />?><br /><br /><html><br /><body><br /><head><br /><title>Load</title><br /></head><br /><p><br /><form action=load.php method=post enctype="multipart/form-data"><br /><table border="0" cellspacing="0" align=center cellpadding="3" bordercolor="#cccccc"><br />     <tr><br />                 <td>File:</td><br />                 <td><input type="file" name="filep" size=45></td><br />          </tr><br />     <tr><br />               <td colspan=2><p align=center><br />          <input type=submit name=action value="Load"><br />               </td><br />     </tr><br /></table><br /></form><br /><br /></body><br /></html>

$folder > Should be the absolute path to where you want to store your files. - If on Windows then something like: C:\Folder\Images\directory - If on Linux/Unix just as the one that's declared

$filep_name > Will be the image name you want to store in the DB

I wrote this script a long time ago, so you can notice it's written to make use of the enabled globals, to change it you know what you do, I've seen it in your code... ;)
Hope this works for you...

GoDaddy - TRUTH BEHIND - Search Engine Optimization Visibility Marketing

Seriously Guys...
This is Phony - Godaddy.com - Search Engine Optimization Visibility Marketing Package is a Fraud

Check Image

Search Engine Optimization Visibility Marketing Package is only to push GoDaddy's Website Builder

and Google has already Castrated GoDaddy Website Builder Longtime ago

Poor innocent SEO blind Website Owners falling for this GoDaddy Fraud

This package is also giving Zombieness to Developer and Support Staff as Customers wants it fixed according to GoDaddy's fucking SEO Rules.

Earlier we had that Mother Fucker W3C HTML Validator...

Now this... just dont encourage this trend. Please

Get Smartphone Screen Size in Auto Rotate Mode Javascript - Solved

This one is Classic Example of Getting SmartPhone Screen Size even in AutoRotate Mode using Plain Javascript

Paypal NVP IPN PHP - Source Code Script

Hey Guys...

This is 100% Working Script for Do DirectPayment NVP Sample Code

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
<?php

/** DoDirectPayment NVP example; last modified 08MAY23.
 *
 *  Process a credit card payment. 
*/
$environment = 'sandbox'; // or 'beta-sandbox' or 'live'
/**
 * Send HTTP POST Request
 *
 * @param string The API method name
 * @param string The POST Message fields in &name=value pair format
 * @return array Parsed HTTP Response body
 */
function PPHttpPost($methodName_, $nvpStr_) {
 global $environment;
 // Set up your API credentials, PayPal end point, and API version.
 //$API_UserName = urlencode('my_api_username');
// $API_Password = urlencode('my_api_password');
// $API_Signature = urlencode('my_api_signature');
// $API_Endpoint = "https://api-3t.paypal.com/nvp";
// if("sandbox" === $environment || "beta-sandbox" === $environment) {
//  $API_Endpoint = "https://api-3t.$environment.paypal.com/nvp";
// }

  $API_UserName = urlencode('bgb_76_api1.yahoo.com');
  $API_Password = urlencode('1371664121');
  $API_Signature = urlencode('AsxaPYH9DSLeUz58vNNDVRf7iy5vAwzLgS0EWdVJKBAak20bU8wZr4px');
  
  if("sandbox" === $environment || "beta-sandbox" === $environment) {
   $API_Endpoint = "https://api-3t.$environment.paypal.com/nvp";
   //$API_Endpoint = "https://www.sandbox.paypal.com/cgi-bin/webscr";
  } else {
   $API_Endpoint = "https://api-3t.paypal.com/nvp";
  }

 $version = urlencode('51.0');
 // Set the curl parameters.
 $ch = curl_init();
 curl_setopt($ch, CURLOPT_URL, $API_Endpoint);
 curl_setopt($ch, CURLOPT_VERBOSE, 1);
 // Turn off the server and peer verification (TrustManager Concept).
 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
 curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
 curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
 curl_setopt($ch, CURLOPT_POST, 1);
 // Set the API operation, version, and API signature in the request.
 $nvpreq = "METHOD=$methodName_&VERSION=$version&PWD=$API_Password&USER=$API_UserName&SIGNATURE=$API_Signature$nvpStr_";
 // Set the request as a POST FIELD for curl.
 curl_setopt($ch, CURLOPT_POSTFIELDS, $nvpreq);
 // Get response from the server.
 $httpResponse = curl_exec($ch);
 if(!$httpResponse) {
  exit("$methodName_ failed: ".curl_error($ch).'('.curl_errno($ch).')');
 }
 // Extract the response details.
 $httpResponseAr = explode("&", $httpResponse);
 $httpParsedResponseAr = array();
 foreach ($httpResponseAr as $i => $value) {
  $tmpAr = explode("=", $value);
  if(sizeof($tmpAr) > 1) {
   $httpParsedResponseAr[$tmpAr[0]] = $tmpAr[1];
  }
 }
 if((0 == sizeof($httpParsedResponseAr)) || !array_key_exists('ACK', $httpParsedResponseAr)) {
  exit("Invalid HTTP Response for POST request($nvpreq) to $API_Endpoint.");
 }
 return $httpParsedResponseAr;
}


     
     
     $ipn["cxyear"] = '2019';
     $ipn["cxmonth"] = '11';
     $ipn["ccno"] = '4032031731268909';
     
     $ipn["fname"] = 'Harry';
     $ipn["lname"] = 'Potter';
     $ipn["creditCardType"] = 'visa';
   
     $ipn["cvv2"] = '247';
     //$ipn["noc"] = $ccdat["noc"];
     $ipn["baddr"] = '225 N Jackson Ave';
     $ipn["cscity"] = 'San Jose';
     $ipn["csstate"] = 'CA';
     $ipn["cscountry"] = 'US';
     $ipn["ifare"] = '214.14';
     $ipn["cszip"] = '95116';




// Set request-specific fields.
$paymentType = urlencode('Authorization');    // or 'Sale'
$firstName = urlencode($ipn["fname"]);
$lastName = urlencode($ipn["lname"]);
$creditCardType = urlencode($ipn["creditCardType"]);
$creditCardNumber = urlencode($ipn["ccno"]);
$expDateMonth = $ipn["cxmonth"];
// Month must be padded with leading zero
$padDateMonth = urlencode(str_pad($expDateMonth, 2, '0', STR_PAD_LEFT));
$expDateYear = urlencode($ipn["cxyear"]);
$cvv2Number = urlencode($ipn["cvv2"]);
$address1 = urlencode($ipn["baddr"]);
//$address2 = urlencode('customer_address2');
$city = urlencode($ipn["cscity"]);
$state = urlencode($ipn["csstate"]);
$zip = urlencode($ipn["cszip"]);
$country = urlencode($ipn["cscountry"]);    // US or other valid country code
$amount = urlencode($ipn["ifare"]);
$currencyID = urlencode('USD');       // or other currency ('GBP', 'EUR', 'JPY', 'CAD', 'AUD')
// Add request-specific fields to the request string.
$nvpStr = "&PAYMENTACTION=$paymentType&AMT=$amount&CREDITCARDTYPE=$creditCardType&ACCT=$creditCardNumber"."&EXPDATE=$padDateMonth$expDateYear&CVV2=$cvv2Number&FIRSTNAME=$firstName&LASTNAME=$lastName"."&STREET=$address1&CITY=$city&STATE=$state&ZIP=$zip&COUNTRYCODE=$country&CURRENCYCODE=$currencyID";
// Execute the API operation; see the PPHttpPost function above.
$httpParsedResponseAr = PPHttpPost('DoDirectPayment', $nvpStr);
prx($httpParsedResponseAr);
if("SUCCESS" == strtoupper($httpParsedResponseAr["ACK"]) || "SUCCESSWITHWARNING" == strtoupper($httpParsedResponseAr["ACK"])) {
 exit('Direct Payment Completed Successfully: '.print_r($httpParsedResponseAr, true));
} else  {
 exit('DoDirectPayment failed: ' . print_r($httpParsedResponseAr, true));
}
function prx($arr) {
 echo "<pre>";
 print_r($arr);
 exit;
}


?>

</body>
</html>

Our recent delivery : Dickinson Airport Taxi Service

Monday, June 22, 2015

Google AdSense --- Worlds Biggest Ponzy Scam

Guys Seriously, Adsense is World's Biggest Phoney Ponzy.

You dont want to be wasting time on it, if you want to try your luck.

Its deep shit. Only Google Makes Big Bucks & dont even gives you Middle Finger.

So Stay Away from it...
Its purely a DayLight Scam...

Friday, June 19, 2015

HTML Table TD Cellpadding - Not Working

Try this & it works

<table style="border-collapse: separate; border-spacing: 10px;">

Saturday, June 6, 2015

MYSQLD takes too much memory (400MB) - Solved

This is outrageous when your MySQL takes over 400MB memory.

How to reduce???
Just add:

---> mysql/bin/my.ini  
---> just add

[mysqld]
table_definition_cache = 200

This will do the magic.

Mine is afta 464MB its running at 76MB.

Monday, June 1, 2015

Simple Captcha -- NO NONSENSE

This one is NO NONSENSE - Simple Captcha to secure your web forms from Spam.

I had this on many of my clients websites Simple Captcha
==========================================
Recent Delivery DFW Taxi

PHP MySQL - Generate Daily Sales Reports

Sorry, I couldn't copy this wonderful --- PHP MySQL Script. Take a Look --- Generate Sales Report - MySQL PHP

MySQL & PHP References

Search This Blog