https://www.machform.com/forums/ MachForm Community Forums Topic: Add form data to second database en Sun, 03 May 2026 20:41:53 +0000 https://www.machform.com/forums/topic/add-form-data-to-second-database#post-16322 Mon, 29 Oct 2012 18:46:36 +0000 yuniar 16322@https://www.machform.com/forums/ <p>Hi Roy,</p> <p>It is possible to do this, but you will need to know some PHP to be familiar with the modifications. </p> <p>The easiest way to do this is to add privileges to your current machform mysql user to be able accessing the other database.<br /> So that the mysql user is having permission to access your machform database and the other database.</p> <p>Once the privileges being set, you can edit your "includes/post-functions.php" file. Search around line 2393 for this code:</p> <pre><code>if($process_result[&#39;status&#39;] === true){</code></pre> <p>right exactly below that line, you can add the custom code to do the insert into another database. The code would be something like this:</p> <pre><code>mf_do_query(&quot;use myotherdb&quot;,array(),$dbh); $query = &quot;insert into test_table(mytext) values(?)&quot;; $params = array($table_data[&#39;element_1&#39;]); mf_do_query($query,$params,$dbh);</code></pre> <p>in the above sample code, the other database name is "myotherdb" and the table name is "test_table".<br /> All your form data is available through <strong>$table_data</strong> variable, which is an array. </p> https://www.machform.com/forums/topic/add-form-data-to-second-database#post-16321 Mon, 29 Oct 2012 17:08:51 +0000 ROYW1000 16321@https://www.machform.com/forums/ <p>Hi</p> <p>Does anyone know if this is possible?</p> <p>Also has anyone ever attached a HTML Editor to the form?</p> <p>Thanks<br /> Roy </p> https://www.machform.com/forums/topic/add-form-data-to-second-database#post-16290 Thu, 25 Oct 2012 12:28:53 +0000 ROYW1000 16290@https://www.machform.com/forums/ <p>Hi</p> <p>Is it possible when someone completes a form that machform stores it as usual but some of the elements are transferred to a different database with different column names.</p> <p>If this is possible can you supply some code and let me know where to put it.</p> <p>Thanks in advance</p> <p>Roy </p>