https://www.machform.com/forums/ MachForm Community Forums Topic: embed 'Success Message' in 'template variable' en Mon, 04 May 2026 05:19:46 +0000 https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9743 Mon, 21 Jun 2010 09:12:28 +0000 redityo 9743@https://www.machform.com/forums/ <p>Sorry, I forget to remove "backtick" character in the code, it automatically changed to "code" tag in here. </p> <p>I've update those code, you can try to change the file again.</p> <p>However, if you still having difficulty with this, you can send me the file to </p> <p>customer.service[at]appnitro.com</p> <p>I will help you there </p> https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9742 Mon, 21 Jun 2010 08:43:50 +0000 sweetrobot 9742@https://www.machform.com/forums/ <p>Okay, gettign somewhere. Now, when the form is submitted, the following error is displayed:</p> <p><code>INSERT INTO ap_form_1 (<code>element_1</code>,<code>element_2</code>,<code>element_4</code>,<code>ip_address</code>,<code>date_created</code>) VALUES ('Tom','tom@tom.com','test message','69.84.101.212','2010-06-20 21:38:38'); Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ap_form_1 (<code>element_1</code>,<code>element_2</code>,<code>element_4</code>,<code>ip_address</code>,`date_c' at line 1</code></p> <p>Also, should there be two '==' in this: <code>if ($form_id == 1)</code>?</p> <p>Any suggestions, or could I send the "post-functions.php" file to you for review? Ive uploaded the file here: <a href="http://www.mediafire.com/file/mc1iqmzzwzw/post-functions.php" rel="nofollow">http://www.mediafire.com/file/mc1iqmzzwzw/post-functions.php</a> </p> https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9741 Mon, 21 Jun 2010 07:50:54 +0000 redityo 9741@https://www.machform.com/forums/ <p>It seems you've put the code in wrong line in "post-functions.php" file. Maybe you're using previous version.<br /> To fix this, try to search this Code :</p> <pre><code>$query = &quot;INSERT INTO ap_form_{$form_id}_review ($field_list) VALUES ($field_values);&quot;;</code></pre> <p>and you'll see the complete code like this </p> <pre><code>if(empty($form_review)){ $query = &quot;INSERT INTO ap_form_{$form_id} ($field_list) VALUES ($field_values);&quot;; }else{ //insert to temporary table, if form review is enabled $query = &quot;INSERT INTO ap_form_{$form_id}_review ($field_list) VALUES ($field_values);&quot;; } do_query($query);</code></pre> <p>then put the code bellow those complete code like this </p> <pre><code>if(empty($form_review)){ $query = &quot;INSERT INTO ap_form_{$form_id} ($field_list) VALUES ($field_values);&quot;; }else{ //insert to temporary table, if form review is enabled $query = &quot;INSERT INTO ap_form_{$form_id}_review ($field_list) VALUES ($field_values);&quot;; } do_query($query); if ($form_id == 1) { $_SESSION[&#39;page_data&#39;] = $table_data; }</code></pre> https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9739 Mon, 21 Jun 2010 05:45:16 +0000 sweetrobot 9739@https://www.machform.com/forums/ <p>My man, I can't get it to work... This is what I have:</p> <p>1. "includes/post-functions.php:</p> <p><code> //for form with review enabled, append .tmp suffix to all uploaded files<br /> //move file and check for invalid file<br /> $destination_file = $input['machform_data_path'].DATA_DIR."/form_{$form_id}/files/{$element_name}-{$record_insert_id}-{$_FILES[$element_name]['name']}.tmp";<br /> if (move_uploaded_file($_FILES[$element_name]['tmp_name'], $destination_file)) {<br /> $filename = mysql_real_escape_string($_FILES[$element_name]['name']);<br /> $query = "update ap_form_{$form_id}_review set $element_name='{$element_name}-{$record_insert_id}-{$filename}' where id='$record_insert_id'";<br /> do_query($query);<br /> if ($form_id == 1) {<br /> $_SESSION['page_data'] = $table_data;<br /> }<br /> }</code></p> <p>and</p> <p>2. includes/view-functions.php:</p> <p><code> //check for specific form css, if any, use it instead<br /> if($form-&gt;has_css){<br /> $css_dir = DATA_DIR."/form_{$form_id}/css/";<br /> }</p> <p> if($embed){<br /> $embed_class = 'class="embed"';<br /> }</p> <p> if ($form_id == 1) {<br /> $form-&gt;success_message = "your submission has been received. a notification has also been sent to " . $_SESSION['form_data']['element_2'] ;<br /> }<br /> $form_markup = &lt;&lt;&lt;EOT</code> </p> https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9730 Sat, 19 Jun 2010 11:18:04 +0000 sweetrobot 9730@https://www.machform.com/forums/ <p>thanks. will try soon. </p> https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9689 Mon, 14 Jun 2010 10:52:52 +0000 redityo 9689@https://www.machform.com/forums/ <p>You can customize some machform files for this. Try to follow these steps :</p> <p>1. Edit "includes/post-functions.php" file and go to line 1051 for this code :</p> <pre><code>do_query($query);</code></pre> <p>then put these code exactly bellow that line </p> <pre><code>if ($form_id == 1) { $_SESSION[&#39;page_data&#39;] = $table_data; }</code></pre> <p>2. Edit "includes/view-functions.php" file and go to line 2229 for this code :</p> <pre><code>$form_markup = &lt;&lt;&lt;EOT</code></pre> <p>and put these code above that line </p> <pre><code>if ($form_id == 1) { $form-&gt;success_message = &quot;thank you for contacting us. a confirmation email has been sent to &quot; . $_SESSION[&#39;page_data&#39;][&#39;element_3&#39;] ; }</code></pre> <p>Don't forget to change the form id with yours </p> https://www.machform.com/forums/topic/embed-success-message-in-template-variable#post-9686 Sun, 13 Jun 2010 18:58:34 +0000 sweetrobot 9686@https://www.machform.com/forums/ <p>i would like the 'success message' to display something like this:</p> <p>"thank you for contacting us. a confirmation email has been sent to {element_3}"</p> <p>where {element_3} prints the address the user had entered.</p> <p>cheers </p>