clintonf

Godaddy are recording the following error now:

[13-Feb-2018 21:13:01 UTC] PHP Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in /home/vijayandclinton/public_html/wp-content/plugins/gift-registry/php/paypal_response.php on line 25

Below is the current code in paypal_response.php: Any thoughts on how to add the second parameter?

function gr_handle_paypal_response() {
global $wpdb;

wp_enqueue_script(‘paypal_response.js’, plugins_url(‘gift-registry/js/paypal_response.js’), array( ‘jquery’ ));
$customId = mysqli_real_escape_string($_GET[‘customId’]);

$q = “update {$wpdb->prefix}registry_order set
status = ‘RECEIVED’
where id = ‘$customId’ and status != ‘COMPLETED'”;
$wpdb->query($q);

I have dug deeper and not that the following is on line of paypal_response.php:25

wp_enqueue_script(‘paypal_response.js’, plugins_url(‘gift-registry/js/paypal_response.js’), array( ‘jquery’ ));
$customId = mysql_real_escape_string($_GET[‘customId’]);

One blog I read suggested changing:
mysql_real_escape_string($_GET[‘customId’]);
to
mysqli_real_escape_string($_GET[‘customId’]);

Which I did and then the PayPal error in ipn was queued however then changed to retrying again….

Any thoughts?