[easiest way to compare 2 rows from different tables]

Hello,

What would be the easiest way to compare rows from different databases?

I have 2 tables 1 is live and the other is for newly inserted data which needs to be compared against.

firstly the unique_id must match, if not then comparing the rest of the columns is irrelevant.

 

The structure is the same for both tables, something like this:

id

unique_id

val1

val2

val3

 

so i thought i could do something like this

<?php
$q = mysqli_query($conn, "SELECT * FROM live_table LIMIT 10");
while ($r = mysqli_fetch_array($q)) {
    $uniqueId    = $r['unique_id'];
    $val1        = $r['val1'];
    $val2        = $r['val2'];
    $check_query = mysqli_query($conn, "SELECT * FROM unverified_table WHERE unique_id='$uniqueId' AND val1='$val1' AND val2='$val2'");
    
    //from here i would check the num rows and get the result etc...
}

however i have around 20+ columns which would need to be checked to see if they match.

also i would preferable want to be able to print out which columns matched and which didn't depending on what i need.

 

the other idea would be to firstly check for a row with the same unique_id, return it back as an array and then loop through each individual element to check if they match... EG.

<?php
$q = mysqli_query($conn, "SELECT * FROM live_table LIMIT 10");

while ($r = mysqli_fetch_array($q)) {
    
    $uniqueId    = $r['unique_id'];
    $check_query = mysqli_query($conn, "SELECT * FROM unverified_table WHERE unique_id='$uniqueId'");
    while ($r2 = mysqli_fetch_array($check_query)) {
        if ($r[1] != $r2[1]) {
            //etc...
        }
    }
}

is there a better way to do this?

 

thanks

 

sean

[why website is redirecting when using Curl]

Have you looked at the HTML source of the page you're trying to copy? It references stylesheets and images and code. When I run your code from my "website" most of those references will break because the files don't exist, and it happens to break in such a way that most of the page is missing/not visible.

 

Unless you cloned the assorted other files, I would expect the same when you try it. The redirect is completely random.

 

 

Here's another thing to try: running it locally. Start the built-in server

php -S localhost:8000 -t /path/to/where/your/test/file/is

then go to http://localhost:8000/file.php and see what happens.

 

 

to be completely honest i haven't run into this problem before, usually i'm able to use the function to display the website then i use a simple scraping function which scrapes parts out from the source code.

 

I thought curl downloaded the source code after the includes had been created, so didn't realize that include paths made a difference.

 

I will try running the script locally as you suggested.

 

thanks

sean

[why website is redirecting when using Curl]

I know that you didn't show the literal contents of some file because your post is missing the opening <?php. Is there anything else you didn't include?

 

this is exactly the code i'm running:

<?php
//error_reporting(E_ALL);
//ini_set('max_execution_time', 0);

$url = "https://groceries.asda.com/";

$main_page = Acurl($url);

echo $main_page;

function Acurl($url)
{
	//$cookie_file = "cookie.txt";
	
    // Assigning cURL options to an array
    $options = Array(
        CURLOPT_RETURNTRANSFER => TRUE,  // Setting cURL's option to return the webpage data
        CURLOPT_FOLLOWLOCATION => TRUE,  // Setting cURL to follow 'location' HTTP headers
        CURLOPT_AUTOREFERER => TRUE, // Automatically set the referer where following 'location' HTTP headers
        CURLOPT_CONNECTTIMEOUT => 120,   // Setting the amount of time (in seconds) before the request times out
        CURLOPT_TIMEOUT => 120,  // Setting the maximum amount of time for cURL to execute queries
        CURLOPT_MAXREDIRS => 10, // Setting the maximum number of redirections to follow
        CURLOPT_USERAGENT => "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1a2pre) Gecko/2008073000 Shredder/3.0a2pre ThunderBrowse/3.2.1.8",  // Setting the useragent
        CURLOPT_URL => $url, // Setting cURL's URL option with the $url variable passed into the function
		//this is for the cookie.
		CURLOPT_COOKIESESSION => TRUE,
		CURLOPT_COOKIEFILE => $cookie_file,
		CURLOPT_COOKIEJAR => $cookie_file,
    );
	
    $ch = curl_init();  // Initialising cURL
    curl_setopt_array($ch, $options);   // Setting cURL's options using the previously assigned array data in $options
    $data = curl_exec($ch); // Executing the cURL request and assigning the returned data to the $data variable
    curl_close($ch);    // Closing cURL
    return $data;   // Returning the data from the function
}

strange that even with your test it wasn't showing the entire webpage? just parts of the nav bar?

might there be something the website is doing to block a curl connection?

 

<?php

//all your curl stuff here

print_r(curl_getinfo($ch));

Might give some kind of clue.

 

Ok i will give that a try and see what it returns.

[why website is redirecting when using Curl]

Well, when I tried your code I got a page that was empty except for the logo and black background for the navigation bar, so...

Thanks for the response.

That's strange, im running the exact code and its redirecting.

maybe this a something with my servers settings causing the redirect.

[why website is redirecting when using Curl]

Your code is just dumping the HTML out to your browser. If there is any redirect then your browser is doing it, so use your browser's tools to find out why. For example, have it track HTTP requests, find the one that performs the redirect, and see what originated it.

Thanks for your response,

i have just now installed and tried it with httprequester on firefox,

it appears to display the website without any further redirects.

[why website is redirecting when using Curl]

Hello, so im trying to use Curl to connect to a website, but when i try to return the url, i get redirected and it ends up redirecting me back to "myowndomain.com"/back-soon.

is there a way to see why the site is redirecting when using Curl, it doesnt redirect when i connect to the website through a usual web browser..

 

code:

$url = "https://groceries.asda.com/";

$main_page = curlFunction($url);

echo $main_page;

function curlFunction($url)
{
	$cookie_file = "cookie.txt";
	
    // Assigning cURL options to an array
    $options = Array(
        CURLOPT_RETURNTRANSFER => TRUE,  // Setting cURL's option to return the webpage data
        CURLOPT_FOLLOWLOCATION => TRUE,  // Setting cURL to follow 'location' HTTP headers
        CURLOPT_AUTOREFERER => TRUE, // Automatically set the referer where following 'location' HTTP headers
        CURLOPT_CONNECTTIMEOUT => 120,   // Setting the amount of time (in seconds) before the request times out
        CURLOPT_TIMEOUT => 120,  // Setting the maximum amount of time for cURL to execute queries
        CURLOPT_MAXREDIRS => 10, // Setting the maximum number of redirections to follow
        CURLOPT_USERAGENT => "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1a2pre) Gecko/2008073000 Shredder/3.0a2pre ThunderBrowse/3.2.1.8",  // Setting the useragent
        CURLOPT_URL => $url, // Setting cURL's URL option with the $url variable passed into the function
		//this is for the cookie.
		CURLOPT_COOKIESESSION => TRUE,
		CURLOPT_COOKIEFILE => $cookie_file,
		CURLOPT_COOKIEJAR => $cookie_file,
    );
	
    $ch = curl_init();  // Initialising cURL
    curl_setopt_array($ch, $options);   // Setting cURL's options using the previously assigned array data in $options
    $data = curl_exec($ch); // Executing the cURL request and assigning the returned data to the $data variable
    curl_close($ch);    // Closing cURL
    return $data;   // Returning the data from the function
}

Any help would be great.

sean

[sql query where varchar field contains row from another table]

No, there is no sane way to work with the data structure you have.

 

You need to learn the basics of normalization and then fix your tables accordingly. For example, values in relational databases are supposed to be atomic, that is, comma-separated lists are almost always wrong. What you do instead is store each keyword individually. Then you can easily search them without any explode() hacks.

 

Thanks for your answer, I explained the way above as i thought that was the easiest way to explain, but basically the comma delimiter keywords are a set of keywords which could be 50+ long so to create a column for each keyword wouldn't really be feasible either.  

 

Aside from what @Jaques1 said, when you start numbering things something1, something2 etc. you are doing something wrong.

Thanks for your reply, I just used that as an example.

[sql query where varchar field contains row from another table]

Hello,

Im not sure if the title makes sense or not but ill try explain it best i can.

i have 2 tables,

 

the first table which ill call "haystack" contains a varchar field called keywords which contains keywords separated with a comma delimiter eg: "keyword1, keyword5, keyword2, keyword10"

the second table which ill call "needle" has for example 10 rows with a varchar called keyword, this contain only 1 of the keywords for each row eg "keyword5"

 

the aim is to run a search on the haystack table to only return rows where keywords from the needle table match.

 

so i could do this in php by exploding the haystack keywords field and then looping through to compare against the needle keywords, but that would require to select * rows and would make its take a long time, so i was hoping this could be done in sql?

 

thanks

sean

[searching database for multiple words]

Hi, I know this could probably be solved using either php or SQL, so i wasnt sure which board to post this on, but ive always been under the impression its best to solve the issues through SQL if possible as thats the most efficient way.

 

I have a products table which contains

product_name varchar (255)

 

then im allowing users to search for products,

with the current php code:

product_name LIKE '%$searchTerms%' //searchTerm would contain ie: "red apples"

it wont return results when the users type the plural for a word ie apples instead of apple,

or if they type apple red instead of red apple.

 

im wondering the best way to search products?

 

i thought i could explode the searchTerm variable and run the like query for every word

product_name LIKE '%$searchTerm[0]%' OR product_name LIKE '%$searchTerm[1]%'

but then im worried about relevance, if one of the search terms is the word "and" then it might return completely irrelevant results.

 

also how would i go about dealing with the plurals?

 

Any suggestions on the best way to do this?

 

thanks

[using wildcard to scrape between changing div id]

Im currently doing website scraping for the first time, although im getting success, im finding that for when a piece of code is dynamic, then im having to do alot of additional lines when if i could do something like <div id"{wildcard for any value}"> then it would reduce the lines required to collect the data,

here is an example of the html im scraping:

< div id = "productWrapper" >
  < div id = "hih_2126_348" class = "descriptionDetails" data - product - id = "22133545" >
    < div class = "desc" id = "hih_3_266_401" >
      < h1 id = "hih_3_266_4441" >
        < span data - title = "true" id = "hih_1_1466_99" > ProductNameHere </span>
      </h1 >

so every page that i try scraping potentially has a different value id for the div h1 span tags

 

the id value can change in characters/length/symbols etc

 

is there a way to basically scrape between for example < span data - title = "true" id = "{wildcard to allow for any value/text here}" > and </span>

 

the php functions i'm currently using to scrape are below.

 

any help would be awesome

 

thanks.

                // Defining the basic cURL function
                function curl($url) {
                    // Assigning cURL options to an array
                    $options = Array(
                        CURLOPT_RETURNTRANSFER => TRUE,  // Setting cURL's option to return the webpage data
                        CURLOPT_FOLLOWLOCATION => TRUE,  // Setting cURL to follow 'location' HTTP headers
                        CURLOPT_AUTOREFERER => TRUE, // Automatically set the referer where following 'location' HTTP headers
                        CURLOPT_CONNECTTIMEOUT => 120,   // Setting the amount of time (in seconds) before the request times out
                        CURLOPT_TIMEOUT => 120,  // Setting the maximum amount of time for cURL to execute queries
                        CURLOPT_MAXREDIRS => 10, // Setting the maximum number of redirections to follow
                        CURLOPT_USERAGENT => "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1a2pre) Gecko/2008073000 Shredder/3.0a2pre ThunderBrowse/3.2.1.8",  // Setting the useragent
                        CURLOPT_URL => $url, // Setting cURL's URL option with the $url variable passed into the function
                    );
                    $ch = curl_init();  // Initialising cURL
                    curl_setopt_array($ch, $options);   // Setting cURL's options using the previously assigned array data in $options
                    $data = curl_exec($ch); // Executing the cURL request and assigning the returned data to the $data variable
                    curl_close($ch);    // Closing cURL
                    return $data;   // Returning the data from the function
                }

                // Defining the basic scraping function
                function scrape_between($data, $start, $end){
                    $data = stristr($data, $start); // Stripping all data from before $start
                    $data = substr($data, strlen($start));  // Stripping $start
                    $stop = stripos($data, $end);   // Getting the position of the $end of the data to scrape
                    $data = substr($data, 0, $stop);    // Stripping all data from after and including the $end of the data to scrape
                    return $data;   // Returning the scraped data from the function
                }

[possible to print the current value of enum?]

if i have an enum like this:

enum manufacturers { Mazda, Ford, Fiat, Honda };
manufacturers car = manufacturers.Mazda;

is it possible to then print(car) to return its current enum value?

[PayPal IPN getting payment status and other values]

If your server goes down in the 30 seconds between you sending them to paypal and paypal directing them back, well you probably have much bigger problems.  Plus the ipn only sends once too, so it wouldn't make any difference which method you chose, if your server is all the sudden down, the ipn won't work either.

 

I still think you don't understand the difference between the api and ipn.  The api allows you to send them to paypal to enter their payment info and then be sent right back to your site where your php processes the payment and you perform any other db update you want IMMEDIATELY.  Then you redirect your customer to whatever page you want and allow them access to whatever they just paid for.

 

The ipn works like this.  You setup a button with far more details than the api button, they click and go to paypal to enter their payment info.  They stay on paypal until the payment is fully finished.  Paypal shows them a thank you screen and redirects them a few seconds later to the page you setup in the paypal account itself.  Now in the time they are redirected, it is possible that paypal has already sent the ipn info to your page, but it's not a guaranteed to be that fast.  I've seen it take upto a minute.  So even if they are redirected back, the ipn may not have finished yet, so now what do you do, make them wait an unknown amount of time until the ipn finishes and keep refreshing the page and checking if it has.

 

Do you see the difference now?  The api is the better way to go.  The only reason the ipn works good for me if cause I need to verify each transaction as the ipn sends to make sure I have everything on hand for the product the customer requested.  So the customer is informed right away that I need to verify and get things ready for them BEFORE they are allowed to do anything else on the website.

 

The tutorial shows you more than enough to get you going.  There aren't any good ipn tutorials out there that deal with the most recent code from paypal, so you'll be left to figure alot of that out yourself, although I gave you pretty much everything you need already.

thanks for your continued help, i agree that its a very unlikely thing to happen, but it also depends on the user themselves returning back to the success page, so it could go wrong for something as simple as the user losing internet connection before being redirect.. which makes you think this probably happens more often than first thought.

 

I have now done a little research and apparently IPNs requires a HTTP/1.1 200 OK HTTP status response whenever PayPal POST's the IPN data to it, if not it will try again.

 

anyway i shall continue to look into this, so thanks for your help.

[PayPal IPN getting payment status and other values]

In my opinion, you don't need both the api and the ipn, it's one or the other depending on your system.  With the api all of the transaction is taken care of right then, you can update and do whatever you want in the db at that time.  With the ipn, you need to wait for paypal to send the ipn and then update the db.  Also with the ipn way, paypal doesn't redirect back immediately after the transaction, whereas the api redirects back as soon as paypal secures the payment on your behalf so you can finish the payment on your site.

 

The new api is really the better way to go about taking payments on your website, I only used the ipn cause the other older versions of things they had were far to complicated to integrate easily, unlike the new api which is far easier now.

 

how can the api do this all alone though?, if for example my server is down as paypal tries redirecting to the return url then the script will never receive the notification to update the db. i thought it was only by the ipn that you could send notifications after the payment, again the same thing would apply for payment_status changes and refund notifications surely that would all be done via ipn.

[PayPal IPN getting payment status and other values]

I have another question which i related this Api/ipn

 

the way i have it currently is before the person is directed to paypal to make the payment, there is a insertion into my db table which holds all of the current information about the order, then once the person completes the payment and returns to the success url via the api, it updates the table row with transaction number etc.

 

then when the ipn is received it updates the table row based on the transaction id.

 

the issue im thinking could easily occur is, what happens if they go to paypal and make the payment but is unable to return to my success url?

 

im assuming there would need to be failsafes in the ipn itself but without the transaction id, how would the listener script know which row to update?

[PayPal IPN getting payment status and other values]

Here is the basic script that paypal provides for the ipn service.

<?php

 //reading raw POST data from input stream. reading pot data from $_POST may cause serialization issues since POST data may contain arrays
  $raw_post_data = file_get_contents('php://input');
  $raw_post_array = explode('&', $raw_post_data);
  $myPost = array();
  foreach ($raw_post_array as $keyval)
  {
      $keyval = explode ('=', $keyval);
      if (count($keyval) == 2)
         $myPost[$keyval[0]] = urldecode($keyval[1]);
  }
  // read the post from PayPal system and add 'cmd'
  $req = 'cmd=_notify-validate';
  if(function_exists('get_magic_quotes_gpc'))
  {
       $get_magic_quotes_exits = true;
  } 
  foreach ($myPost as $key => $value)
  {        
       if($get_magic_quotes_exits == true && get_magic_quotes_gpc() == 1)
       { 
            $value = urlencode(stripslashes($value)); 
       }
       else
       {
            $value = urlencode($value);
       }
       $req .= "&$key=$value";
  }
 
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://www.paypal.com/cgi-bin/webscr');
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Host: www.paypal.com'));
// In wamp like environment where the root authority certificate doesn't comes in the bundle, you need
// to download 'cacert.pem' from "http://curl.haxx.se/docs/caextract.html" and set the directory path 
// of the certificate as shown below.
// curl_setopt($ch, CURLOPT_CAINFO, dirname(__FILE__) . '/cacert.pem');
$res = curl_exec($ch);
curl_close($ch);
 
// assign posted variables to local variables

//$item_name = htmlentities($_POST['item_name_1']);
//$item_number = (int)$_POST['item_number_1']; 
 
if (strcmp ($res, "VERIFIED") == 0) {
	// check the payment_status is Completed
	// check that txn_id has not been previously processed
	// check that receiver_email is your Primary PayPal email
	// check that payment_amount/payment_currency are correct
	// process payment
}
else if (strcmp ($res, "INVALID") == 0) {
	// log for manual investigation
}

?>

You then go into your paypal account and turn on ipn service and provide the full url path to your ipn processing script.  I can tell you from experience that making sure your script works properly can be tricky since your can't really see the errors it throws when ran cause it's called from paypals side.  I started by making a simple db table to hold the full posted results from paypal so I could see what they send back and how it was named.

foreach($_POST as $k => $v)
{ $value.= $k.' / '.$v.', '; }

$set = $db->prepare("INSERT INTO `test` SET `posted_values` = ?");
$set->execute(array($value));

Then to do my own testing based on the posted info I made another script that puts all the info into a form with text fields so I could repeatedly post the info and test additional query stuff or processing stuff.

<?php
// This list needs to be coppied from the posted text in the table paypal posted to in the other script I showed you.
$test = 'mc_gross / 65.00, protection_eligibility / Eligible, address_status / confirmed, item_number1 / 14, payer_id / KP3ZSMAGVU764, tax / 0.00, address_street / 3415 Delaware Dr., payment_date / 15:22:41 Mar 04 2014 PST, payment_status / Completed, charset / windows-1252, address_zip / 29040, mc_shipping / 0.00, mc_handling / 0.00, first_name / kevin, mc_fee / 2.19, address_country_code / US, address_name / kevin korstange, notify_version / 3.7, custom / 0::standard::c, payer_status / unverified, business / cwpsumter@yahoo.com, address_country / United States, num_cart_items / 1, mc_handling1 / 0.00, address_city / Dalzell, verify_sign / AFcWxV21C7fd0v3bYYYRCpSSRl31AQ50RA-5fQQNKQEAtVOK-KdptSAk, payer_email / kmkorstange1584@gmail.com, mc_shipping1 / 0.00, tax1 / 0.00, txn_id / 8JV23519RC589220L, payment_type / instant, last_name / korstange, address_state / SC, item_name1 / CWP Certification Course  - 3/15/2014, receiver_email / cwpsumter@yahoo.com, payment_fee / 2.19, quantity1 / 1, receiver_id / UK6DJWQC3AXBE, txn_type / cart, mc_gross_1 / 65.00, mc_currency / USD, residence_country / US, transaction_subject / 0::standard::c, payment_gross / 65.00, ipn_track_id / 1d2ea5b3bcfad';

if(isset($_POST['submit']))
{
  print_r($_POST);
}
?>
<div style="width:350px; text-align: right">
<form action="" method="post">

<?php
$item = explode(",", $test);
echo '<input type="submit" name="submit" value="submit"><br>';
foreach($item as $i)
{
	$ex = explode(" / ", $i);
	echo trim($ex[0]).' <input type="text" name="'.trim($ex[0]).'" value="'.$ex[1].'"><br>'."\n";
	//$ex[] = explode(" / ", $i);
}

$op_array = array();


foreach($item as $i)
{
	$ex = explode(" / ", $i);
	//echo $ex[0].' - '.$ex[1].'<br>';
}
echo '';

?>
<input type="submit" name="submit" value="submit">
</form>
</div>

Be aware though, at least cause of how I stored the info and how I explode it, the "address_street /" in the $test usually contains a "," in the value part.  I usually just delete the last half of the address since that's not really the data you need to deal with anyway, otherwise the explode will give you unexpected results and the input names won't match up right.

 

Here is what one of my full ipn scripts looks like.

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'/site_req/core.php');
require_once(ROOT.'site_inc/system_inc/includes.php');

 //reading raw POST data from input stream. reading pot data from $_POST may cause serialization issues since POST data may contain arrays
  $raw_post_data = file_get_contents('php://input');
  $raw_post_array = explode('&', $raw_post_data);
  $myPost = array();
  foreach ($raw_post_array as $keyval)
  {
      $keyval = explode ('=', $keyval);
      if (count($keyval) == 2)
         $myPost[$keyval[0]] = urldecode($keyval[1]);
  }
  // read the post from PayPal system and add 'cmd'
  $req = 'cmd=_notify-validate';
  if(function_exists('get_magic_quotes_gpc'))
  {
       $get_magic_quotes_exits = true;
  } 
  foreach ($myPost as $key => $value)
  {        
       if($get_magic_quotes_exits == true && get_magic_quotes_gpc() == 1)
       { 
            $value = urlencode(stripslashes($value)); 
       }
       else
       {
            $value = urlencode($value);
       }
       $req .= "&$key=$value";
  }
 
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://www.paypal.com/cgi-bin/webscr');
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Host: www.paypal.com'));
// In wamp like environment where the root authority certificate doesn't comes in the bundle, you need
// to download 'cacert.pem' from "http://curl.haxx.se/docs/caextract.html" and set the directory path 
// of the certificate as shown below.
// curl_setopt($ch, CURLOPT_CAINFO, dirname(__FILE__) . '/cacert.pem');
$res = curl_exec($ch);
curl_close($ch);
 
// assign posted variables to local variables

//$item_name = sanitize($_POST['item_name_1']);
//$item_number = (int)$_POST['item_number_1'];

if(isset($_POST['item_name_1'])){ $item_name = sanitize($_POST['item_name_1']); }
elseif(isset($_POST['item_name1'])){ $item_name = sanitize($_POST['item_name1']); }
elseif(isset($_POST['item_name'])){ $item_name = sanitize($_POST['item_name']); }

if(isset($_POST['item_number_1'])){ $item_number = (int)$_POST['item_number_1']; }
elseif(isset($_POST['item_number1'])){ $item_number = (int)$_POST['item_number1']; }
elseif(isset($_POST['item_number'])){ $item_number = (int)$_POST['item_number']; }
else{$item_number = '';}

$payment_status = $_POST['payment_status'];
$payment_amount = (float)$_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = sanitize($_POST['txn_id']);
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$product_id = (int)$_POST['custom'];
 
 
if (strcmp ($res, "VERIFIED") == 0) {
	// check the payment_status is Completed
	// check that txn_id has not been previously processed
	// check that receiver_email is your Primary PayPal email
	// check that payment_amount/payment_currency are correct
	// process payment
	$bad = FALSE;
	
	if($payment_status != 'Completed'){ $bad = TRUE; $what='status';}
	if(checkDepositTxn($txn_id) === TRUE) { $bad = TRUE; $what='txn';}
	if($receiver_email != Settings::get('paypal_email')) { $bad = TRUE; $what='email';}
	//if($payment_amount != '20.00') { $bad = TRUE; $what='amount';}
	if($payment_currency != 'USD') { $bad = TRUE; $what='currency';}
	if(empty($item_number)){ $bad = TRUE; $what = 'other charge'; }

	$db = DB::getInstance();
	
	if($bad === FALSE)
	{
		//Process payment stats
		$now = time();
		$set = $db->prepare("INSERT INTO `".QUOTE_DEPOSITS."` SET `txn_id`= ?, 
																  `q_id`='$item_number', 
																  `part_num`= ?, 
																  `dep_date`='$now', 
																  `product_id`=$product_id,
																  `deposit_amount`=$payment_amount");
		$set->execute(array($txn_id, $item_name));
		
		//$db->query("UPDATE `".QUOTE_RESPONSES."` SET `purchased`=1 WHERE `id`='$item_number'");
	}
	elseif($bad === TRUE && $what != 'other charge')
	{
		$valu='';
		
		foreach($_POST as $k => $v)
		{ $valu.= $k.' / '.$v.', '; }
		
		$valu = sanitize($valu);
		
		$set2 = $db->prepare("INSERT INTO `".QUOTE_DEPOSITS."` SET `why` = ?, `params` = ?");
		$set2->execute(array($what, $valu));
	}
}
else if (strcmp ($res, "INVALID") == 0) {
	// log for manual investigation
}

?>

I have another that my cms uses that is much longer. And no you can't use 2 different ipn scripts, I have this one as a special use for a particular site, whereas my cms script is used in typical cases. Hope that helps get you started.

 

NOTE: the code I posted to test the values sent by paypal was pieced together on this post since the whole script contains other stuff that was specific to my site and would only confuse anyone else using it so I removed those parts.  So that code is untested as it sits on this post, maybe syntax errors if I missed something in the piecing together.

thanks for the code now that all looks a lot easier to understand.

[PayPal IPN getting payment status and other values]

You're confusing the 2 concepts between the tutorial and what IPN is.

 

ok yeah it seems i got confused, because the api code uses a returnURL i was then assuming all the datebase updates are done from their but now i understand that's to complete the payment process and then handle the user immediately.

 

ok ill have to look at an ipn tutorial, any suggestions of a good ipn tutorial?

[PayPal IPN getting payment status and other values]

That code doesn't look like IPN...

 

IPN is where PayPal hits a URL on your server with information about some thing they did (eg, transaction). Do you have something for that?

 

i followed the guide linked above, this means i now have 3 files:

 

gateway.php

        $product  = "myproduct Test";
        $price    = $order['price'];
        $shipping = 0.00;

        $total = $price + $shipping;

        $payer = new Payer();
        $payer->setPaymentMethod('paypal');

        $item = new Item();
        $item->setName($product)
            ->setCurrency('USD')
            ->setQuantity(1)
            ->setPrice($price);

        $itemList = new ItemList();
        $itemList->setItems([$item]);

        $details = new Details();
        $details->setShipping($shipping)
            ->setSubtotal($price);

        $amount = new Amount();
        $amount->setCurrency('USD')
            ->setTotal($total)
            ->setDetails($details);

        $transaction = new Transaction();
        $transaction->setAmount($amount)
            ->setItemList($itemList)
            ->setDescription("description here")
            ->setInvoiceNumber(uniqid());

        $redirectUrls = new RedirectUrls();
        $redirectUrls->setReturnUrl(SITE_URL . '/pay.php?success=true')
            ->setCancelUrl(SITE_URL . '/pay.php?success=false');

        $payment = new Payment();
        $payment->setIntent('sale')
            ->setPayer($payer)
            ->setRedirectUrls($redirectUrls)
            ->setTransactions([$transaction]);

        try {
            $payment->Create($paypal);
        } catch (Exception $e) {
                $data = json_decode($e->getData());
                var_dump($data);
                die();
        }

        $approvalUrl = $payment->getApprovalLink();

the above code does redirect to my page which is what the IPN does?

 

then i have pay.php which the code i have already posted in the earlier thread. but ill show it again.

 

pay.php

<?PHP

use PayPal\Api\Payment;
use PayPal\Api\PaymentExecution;
require 'app/start.php';

if (!isset($_GET['success'], $_GET['paymentId'], $_GET['PayerID'])) {
    die();
    //we will instead redirect the user to confirm something went wrong.
}

if ((bool)$_GET['success'] === false) {
    die(); 
    //we will instead redirect the user to inform something went wrong.
}

$paymentId = $_GET['paymentId'];
$payerId   = $_GET['PayerID'];

$payment = Payment::get($paymentId, $paypal);

$execute = new PaymentExecution();
$execute->setPayerId($payerId);

try {
    $result = $payment->execute($execute, $paypal);
    echo "Payment made. Thanks<br />";
    //echo $result;
} catch (Exception $e) {
    $data = json_decode($e->getData());
    var_dump($data);
    die();
}
?>

then the last page is just a config page which has the include to the api and my keys.

[PayPal IPN getting payment status and other values]

I have not used the new paypal api as of yet, but understand it a little.  The IPN service i don't think is really part of the api.  IPN is a separate thing that paypal does on it's own AFTER a transaction has happened on THEIR site.  I use the IPN for my business so I know how it works not using the api anyway.  I have considered switching to the new api stuff as it seems easier to understand and gives a certainly faster response of the transaction than the classic IPN does.  The IPN can take sometimes a minute to finally process to your server, where as the new api it's pretty much handled by you instantly.

 

Here is a good tutorial on the new api https://youtu.be/BD1dOWIABe0

 

that's actually the tutorial i used to create this script, but from what i can see it has some holes in it. looks like ill be outsourcing this.

 

thanks

[PayPal IPN getting payment status and other values]

hey im currently trying to create a website which works as an item exchange, it allows people to sell goods and my site would be the middleman, basically securing the payment and then notifying the seller they are okay to send the goods. but im a little stuck with the IPN and how to get the values from it.

 

i have currently got this code:

<?PHP

use PayPal\Api\Payment;
use PayPal\Api\PaymentExecution;
require 'app/start.php';

if (!isset($_GET['success'], $_GET['paymentId'], $_GET['PayerID'])) {
    die();
    //we will instead redirect the user to confirm something went wrong.
}

if ((bool)$_GET['success'] === false) {
    die(); 
    //we will instead redirect the user to inform something went wrong.
}

$paymentId = $_GET['paymentId'];
$payerId   = $_GET['PayerID'];

$payment = Payment::get($paymentId, $paypal);

$execute = new PaymentExecution();
$execute->setPayerId($payerId);

try {
    $result = $payment->execute($execute, $paypal);
    echo "Payment made. Thanks<br />";
    echo $result;
} catch (Exception $e) {
    $data = json_decode($e->getData());
    var_dump($data);
    die();
}
?>

this was created using the paypal REST API,

 

i currently returns true if the process was successful that doesnt necessarily mean the payment is completed, as this still happens when the payment is pending.

when i echo $result it returns all of the payers details, but im not sure how to get separate parts,

so for example how do i get the status of the payment? i tried something like $result['state'] but that didnt return anything,

also i would like to extract other variables from the result such as name/address of the payer.

 

also i have another question, in regards to how the ipn works, if the payment is for example pending and then the payment status changes to completed, does paypal then notify my listener script of the change in status?

 

any help would be great!

 

thanks

sean

[convert input="text" value into a number]

i realised that you cant have 2 ids, so i changed them to class however i was wondering if there was a more efficient way of assigning all class' in the array the same value.

 

currently im doing

document.getElementsByClassName('testclass')[0].innerHTML = "result here";
document.getElementsByClassName('testclass')[1].innerHTML = "result here";

surely there must be a better way?

[convert input="text" value into a number]

 

All HTML form data is a string. So you just need to convert it to a number in javascript before doing math.

var test = parseInt(document.getElementById('number').value);  //use parseInt() to convert to an integer. There are others for float, etc.
total = test + 10;

 

thanks for your response thats exactly what i was looking for!

 

i have another problem, i want to display the result in more than 1 place on my page so i created another <span id="testid"></span> but it only shows the result in the first span, should this happen? is there a way to show it in both?

[convert input="text" value into a number]

        <script language="javascript" type="text/javascript">  
            function updatetestid() {
                
                var test = document.getElementById('number').value;
                total = test + 10;
                
                document.getElementById('testid').innerHTML = total; 
            }   
        </script>
        <input type="text" onKeyUp="updatetestid();" name="text" id="number"/>
        <span id="testid">here</span>

currently this will treat #number as a string, but i want to be able to do some maths with the value

 

what am i doing wrong?

 

thanks

[get new num_rows count after filtering mysqli_fetch_array rows via php]

 

Something like this, perhaps, assuming a postcode table ( postcode | latitude | longitude )

// Me and my latitude and longitude
$myId = 123;
$mylat = 54.123456;
$mylong = -2.345678;

// Find users within what distance?
$target = 25;

$sql = "SELECT name
    , latitude
    , longitude
    , ROUND(ATAN2(SQRT(POW(COS(RADIANS($mylat)) * SIN(RADIANS(longitude - $mylong)), 2) 
        + POW(COS(RADIANS(latitude)) * SIN(RADIANS($mylat)) 
        - SIN(RADIANS(latitude)) * COS(RADIANS($mylat)) 
        * COS(RADIANS(longitude - $mylong)), 2)), (SIN(RADIANS(latitude)) 
        * SIN(RADIANS($mylat)) + COS(RADIANS(latitude)) * COS(RADIANS($mylat)) 
        * COS(RADIANS(longitude - $mylong)))) * 6372.795,0) as distance
    FROM user
        INNER JOIN postcode USING (postcode)
    WHERE userid <> $myId    
    HAVING distance <= $target
    ORDER BY distance ";

i added that code to my query and after adjusting tablenames etc and removing the INNER JOIN postcode USING (postcode) it is working quite well.

 

can i ask what the reason for joining postcode? when its not being used in the query?

[get new num_rows count after filtering mysqli_fetch_array rows via php]

Okay so im going to be getting the longitude and latitude of the city+postcode by using this code:

        $address = "Norwich, NR8 6QW"; //persons address as a string.
        $prepAddr = str_replace(' ','+',$address);
        $geocode=file_get_contents('http://maps.google.com/maps/api/geocode/json?address='.$prepAddr.'&sensor=false');
        $output= json_decode($geocode);
        $latitude = $output->results[0]->geometry->location->lat;
        $longitude = $output->results[0]->geometry->location->lng;
      

it seems to be working good, what datatype would be best to store these values in a mysql table?

 

 

Something like this, perhaps, assuming a postcode table ( postcode | latitude | longitude )

// Me and my latitude and longitude
$myId = 123;
$mylat = 54.123456;
$mylong = -2.345678;

// Find users within what distance?
$target = 25;

$sql = "SELECT name
    , latitude
    , longitude
    , ROUND(ATAN2(SQRT(POW(COS(RADIANS($mylat)) * SIN(RADIANS(longitude - $mylong)), 2) 
        + POW(COS(RADIANS(latitude)) * SIN(RADIANS($mylat)) 
        - SIN(RADIANS(latitude)) * COS(RADIANS($mylat)) 
        * COS(RADIANS(longitude - $mylong)), 2)), (SIN(RADIANS(latitude)) 
        * SIN(RADIANS($mylat)) + COS(RADIANS(latitude)) * COS(RADIANS($mylat)) 
        * COS(RADIANS(longitude - $mylong)))) * 6372.795,0) as distance
    FROM user
        INNER JOIN postcode USING (postcode)
    WHERE userid <> $myId    
    HAVING distance <= $target
    ORDER BY distance ";

 

once i have the longitude and latitude set up for each user i can then begin to test the code you have posted to see how it looks.

 

thanks

seany

[get new num_rows count after filtering mysqli_fetch_array rows via php]

im trying to create a search script which allows users to search for eachother based on different criteria, 1 of the criteria is they can find people within x miles of them.

 

so the user already has their postcode/city in the db, the search retrieves other users postcode/city etc.

 

so its calculating the distance from $user['city'].$user['postcode'] to $result['city'].$result['postcode']