https://www.machform.com/forums/ MachForm Community Forums Topic: Can data be sent directly through email and not inserted into database? en Mon, 04 May 2026 02:01:34 +0000 https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-6127 Sat, 06 Jun 2009 15:45:04 +0000 susanfw 6127@https://www.machform.com/forums/ <p>Thank you. I'll give it a try. </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-6123 Sat, 06 Jun 2009 13:10:50 +0000 yuniar 6123@https://www.machform.com/forums/ <p>Yes, that is possible.<br /> Let say you have a form with id number = 7</p> <p>Change the above code with this one:</p> <pre><code>if($form_id == 7){ do_query(&quot;truncate table ap_form_{$form_id}&quot;); }</code></pre> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-6112 Fri, 05 Jun 2009 19:39:00 +0000 susanfw 6112@https://www.machform.com/forums/ <p>I would like to use the above hack as well, but have it apply to only one form that would have private emails. The other form results I want to go into the database. Is that possible? </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3228 Mon, 06 Oct 2008 15:38:27 +0000 yuniar 3228@https://www.machform.com/forums/ <p>oops.. sorry, my bad.</p> <p>the above hack seems to work fine for version 1.2 only.<br /> Ok, please disregard the above hack and restore your original post-functions.php file.</p> <p>Then try this, around line 1170 you'll find this code:</p> <pre><code>$process_result[&#39;status&#39;] = true;</code></pre> <p>right below that line, add this code:</p> <pre><code>do_query(&quot;truncate table ap_form_{$form_id}&quot;);</code></pre> <p>that should be working fine.</p> <p>PS. This hack assume you have "form review" disabled. </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3217 Sun, 05 Oct 2008 09:35:35 +0000 franki 3217@https://www.machform.com/forums/ <p>Hmm.. Well I'm not sure if I need to change anything there because the email and everything else works perfectly until I take that piece code away (sorry I didn't indicate this before). After that the email has the issues I described. Do I need to change anything there now?</p> <p>Thanks </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3214 Sun, 05 Oct 2008 08:32:49 +0000 AMurray 3214@https://www.machform.com/forums/ <p>Have you set up the email option correctly e.g. to use an SMTP server (specify the server name and creditentials etc) or the inbuilt "send mail" of PHP?</p> <p>You need to change the option in config.php </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3213 Sun, 05 Oct 2008 06:21:08 +0000 franki 3213@https://www.machform.com/forums/ <p>So I commented out do_query($query); and it does keep the information out of the database, but the email comes in totally blank except for the Powered By Machform which is all that I see there. Also the "Your Users" email doesn't come through at all. I tried using different email addresses and things but not a clue really what the problem is. Any ideas I can try?</p> <p>Thanks. </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3210 Sat, 04 Oct 2008 19:18:49 +0000 franki 3210@https://www.machform.com/forums/ <p>Thanks yuniar! Great product you have here! :) </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3206 Sat, 04 Oct 2008 13:40:23 +0000 yuniar 3206@https://www.machform.com/forums/ <p>Edit your <strong>includes/post-functions.php</strong> file, on line 1008 you'll find these:</p> <pre><code>do_query($query); $record_insert_id = mysql_insert_id();</code></pre> <p>remove the first line above and your submission won't be saved to your database. </p> https://www.machform.com/forums/topic/can-data-be-sent-directly-through-email-and-not-inserted-into-database#post-3203 Sat, 04 Oct 2008 12:17:19 +0000 franki 3203@https://www.machform.com/forums/ <p>I understand a database is necessary to install machform, but is there a way to not store form information and just have it sent in email?</p> <p>Thanks </p>