can i send an email if i insert a record with php?

[carpetman]

Hi everyone,

My website has grown somewhat since i started using Form Tools and the more i use it the more fantastic ideas i come up with.

A year down the track and i'm happily using the data in ways i never imagined (probably childs play for some of you programmers but i'm a humble carpet cleaner).

So here is my problem - I think the answer is i cant do it this way but maybe someone out there has a suggestion.

I wrote some php code to add a record in mysql . The record is normally added with a 'post' form submission to a database in formtools where it trickers an email, a mobile text message to the client and redirects the webpage to somewhere suitable.

The problem is when adding a record with php i'm not getting the email or text message. I'm guessing its because the record isnt being submitted as a form post but does anyone have any ideas as to how i can get formtools to send the email and text this way?

Thanks
Rob

[carpetman]

ok i downloaded some script but it didnt work grrrr

so i'm going to try and set up a hidden form to see if this works - it will duplicate the existing form on the same page but php will replace the first one with the hidden one when needed. The idea is the user clicks the button without seeing the sensitive data behind it.

I'll keep you posted but if someone else has a better idea i'd be happy to hear it.

[Ben]

Hi Carpetman,

Cool! No problem, here's how you can trigger it manually.

The emails are "normally" triggered in the ft_finalize_submission() function, called when the submission is finally marked as complete & ready to show up in the interface. But in your case, you can just call the email function manually. Here's some example code:

PHP Code:

<?php 

// your insert code here

mysql_query(" ... ");



// get the unique Submission ID that you just inserted 

$submission_id = mysql_insert_id();



// now send whatever emails are associated with this event ("on submission") for this form

$form_id = 1; // you'll need to update this for your own form ID

ft_send_emails("on_submission", $form_id, $submission_id); 

[carpetman]

Hi Carpetman,

Cool! No problem, here's how you can trigger it manually.

The emails are "normally" triggered in the ft_finalize_submission() function, called when the submission is finally marked as complete & ready to show up in the interface. But in your case, you can just call the email function manually. Here's some example code:

PHP Code:

<?php 

// your insert code here

mysql_query(" ... ");



// get the unique Submission ID that you just inserted 

$submission_id = mysql_insert_id();



// now send whatever emails are associated with this event ("on submission") for this form

$form_id = 1; // you'll need to update this for your own form ID

ft_send_emails("on_submission", $form_id, $submission_id); 

[carpetman]

Hi Carpetman,

Cool! No problem, here's how you can trigger it manually.

The emails are "normally" triggered in the ft_finalize_submission() function, called when the submission is finally marked as complete & ready to show up in the interface. But in your case, you can just call the email function manually. Here's some example code:

PHP Code:

<?php 

// your insert code here

mysql_query(" ... ");



// get the unique Submission ID that you just inserted 

$submission_id = mysql_insert_id();



// now send whatever emails are associated with this event ("on submission") for this form

$form_id = 1; // you'll need to update this for your own form ID

ft_send_emails("on_submission", $form_id, $submission_id); 

[carpetman]

ok i got it - it needs the library

include("formtools/global/library.php");

$form_id=1;
$submission_id=1016;
$email_id=1;

ft_process_email_template($form_id, $submission_id, $email_id);

cool - now i can set the form , email and submission variables as needed in my code.

Thanks Ben

[javiervgn]

ok i got it - it needs the library

include("formtools/global/library.php");

$form_id=1;
$submission_id=1016;
$email_id=1;

ft_process_email_template($form_id, $submission_id, $email_id);

cool - now i can set the form , email and submission variables as needed in my code.

Thanks Ben

You all are genius, this is exactly what I needed.

Thanks!!