Hi All, I'm doing a follow-up post from previous help here if possible. Using WordPress/Gravity Forms I'm entering 1 line of data into a MySQL database for each of the 4 functions, the first function runs perfectly but functions 2-4 run on an IF query and the issue I'm seeing is that all three functions will trigger if only one of them meet criteria they are not working independently of each other.
Ideally, it should simply be Fucntion1(beta_pay) triggers every time, and then fucntions2-5 trigger independently only if they meet the criteria on their own and not a one for all scenario.
Any input would be great I've tried various scenarios
Function 1 is beta_pay which runs automatically every time which is correct
add_action("gform_after_submission_123", "beta_pay", 10, 2);
function beta_pay($entry, $form){
$Name = $entry["1"];
$Service = $entry["3"];
$Value = $entry["4"];
$Qty = $entry["11"];
$con=mysqli_connect("");
mysqli_query($con,"INSERT INTO beta_pay (Name,Type,Value,Qty) VALUES ('$Name','$Service','$Value','$Qty')");
}
Function 2 is Mileage which runs on an IF statement and works fine as long as Functions 2-5 meet requirements otherwise it posts data regardless
add_action("gform_after_submission_123", "Mileage", 10, 2);
function Mileage($entry, $form){
$MileageQty = $entry["5"];
if ($MileageQty = 0){
return;
}
$Name = $entry["1"];
$Service = "Fixed-Milage";
$MileageRate = $entry["10"];
$MileageQty = $entry["5"];
$con=mysqli_connect("");
mysqli_query($con,"INSERT INTO beta_pay (Name,Type,Value,Qty) VALUES ('$Name','$Service','$MileageRate','$MileageQty')");
}
Function 3 is Away which runs on an IF statement and works fine as long as Functions 2-5 meet requirements otherwise it posts data regardless
add_action("gform_after_submission_123", "Away", 10, 2);
function Away($entry, $form){
$AwayQty = $entry["20"];
if ($AwayQty = 0){
return;
}
$Name = $entry["1"];
$Service = "Fixed-Away Payment";
$AwayRate = $entry["19"];
$AwayQty = $entry["20"];
$con=mysqli_connect("");
mysqli_query($con,"INSERT INTO beta_pay (Name,Type,Value,Qty) VALUES ('$Name','$Service','$AwayRate','$AwayQty')");
}
Function 4 is CC which runs on an IF statement and works fine as long as Functions 2-5 meet requirements otherwise it posts data regardless
add_action("gform_after_submission_123", "CC", 10, 2);
function CC($entry, $form){
$CCQty = $entry["13"];
if ($CCQty = 0){
return;
}
$Name = $entry["1"];
$Service = "Fixed-Congestion Charge";
$CCRate = $entry["16"];
$CCQty = $entry["13"];
$con=mysqli_connect("");
mysqli_query($con,"INSERT INTO beta_pay (Name,Type,Value,Qty) VALUES ('$Name','$Service','$CCRate','$CCQty')");
}
Function 5 is Toll which runs on an IF statement and works fine as long as Functions 2-5 meet requirements otherwise it posts data regardless
add_action("gform_after_submission_123", "Toll", 10, 2);
function Toll($entry, $form){
$TollQty = $entry["15"];
if ($TollQty = 0){
return;
}
$Name = $entry["1"];
$Service = "Fixed-Toll Crossing";
$TollRate = $entry["17"];
$TollQty = $entry["15"];
$con=mysqli_connect("");
mysqli_query($con,"INSERT INTO beta_pay (Name,Type,Value,Qty) VALUES ('$Name','$Service','$TollRate','$TollQty')");
}
