sprocker

So ashamed…..syntax error – been studying code since I was 13 🙁 there is just no excuse!!!

You have had 5* off me many years ago!

Cheers

It seems to have something to do with the “breadcrumbs” I have created at the top of the page – when these are removed it works fine!

Are you able to advise what is causing this?

Thanks

http referrer is just storing https://www.google.co.uk/ so is not showing what page the form was submitted on.

I really don’t want to create and then have to manage 30 forms+ to ensure there is one form per page – so no, I don’t feel using a rule is the solution.

I have had to disable the email from your plugin and just use the ones from Contact Form 7 as they are able to give me the page the form was submitted on using [_post_title] in the message body.

I urge you to look at including [_post_title] in your variables….knowing what page inspired the client to contact you us a very important part of optimising your website.

Thanks

Seems to have started recording the parameters again now….thanks anyway

function upicrm_hook($lead_id) {
$UpiCRMLeads = new UpiCRMLeads();
$UpiCRMUIBuilder = new UpiCRMUIBuilder();
$UpiCRMFieldsMapping = new UpiCRMFieldsMapping();
$getLeads = $UpiCRMLeads->get_by_id($lead_id); //get lead data
$listOption = $UpiCRMUIBuilder->get_list_option(); //get UI options & existing fields
$getNamesMap = $UpiCRMFieldsMapping->get_all_by($getLeads->source_id, $getLeads->source_type); //get lead fields mapping

$sql_field = “”;
$sql_value = “”;
foreach ($listOption as $key => $list_option) {
foreach ($list_option as $key2 => $field_name) {
$value = $UpiCRMUIBuilder->lead_routing($getLeads, $key, $key2, $getNamesMap, true);
$sql_field.= “{$field_name},”;
$sql_value.= “‘{$value}’,”;
}
}
$sql_field = rtrim($sql_field, “,”);
$sql_value = rtrim($sql_value, “,”);

foreach ($listOption as $key => $list_option) {
foreach ($list_option as $key2 => $field_name) {
$value = $UpiCRMUIBuilder->lead_routing($getLeads, $key, $key2, $getNamesMap, true);
$arr[$field_name] = $value;
}
}

// $query = “INSERT INTO TableName ({$sql_field}) VALUES ({$sql_value})”;
// mysql_query($query);

$FNAME = $_POST[‘FirstName’];
$LNAME = $_POST[‘Surname’];
$EMAIL = $_POST[‘your-email’];
$TELNO = $_POST[‘Phone’];
$notes = $_POST[‘your-message’];
$Source = “24”;

$EnqDate = date(‘Y-m-d H:i:s’);
$ContactDate = $_POST[‘date-377’];
$BTTC = $ContactDate . ” at ” . $_POST[‘ContactTime’];

$con=mysqli_connect(“localhost”,”dbname”,”password”,”dbdetails”);
// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}

mysqli_query($con,”INSERT INTO dbname.Customers (ID, EnqDate, EnqTime, FNAME, MiddleNames, LNAME, ReportWriter, Adviser, DOB, TELNO, MobileTel, OtherTel, ADD1, ADD2, ADD3, ADD4, ADD5, PCODE, EMAIL) VALUES (NULL, ‘$EnqDate’, NULL, ‘$FNAME’, ‘$MiddleNames’, ‘$LNAME’, NULL, NULL, ‘$DOB’, ‘$TELNO’, ‘$MobileTel’, NULL, ‘$ADD1’, ‘$ADD2’, ‘$ADD3’, ‘$ADD4’, ‘$ADD5’, ‘$PCODE’, ‘$EMAIL’);”);

mysqli_close($con);

}

add_action( ‘upicrm_after_new_lead’, ‘upicrm_hook’ );

That is great…..but I already have a table with set columns already set up and this can not be changed.

I have the code for $query = “INSERT INTO TableName ({$sql_field})

I need to be able to get the each field from the submitted form as a separate variable so I can use it in the correct place in my insert code.

Foe example, my form has FirstName, Surname, your-email, Phone, your-message, and I want to track the source – I need to set
$FNAME =
$LNAME =
$EMAIL =
$TELNO =
$notes =
$utmSource =

I can then use this in my insert string and I am done!