Appnitro Software Forums Topic: Multilanguage identical forms data processing and saving

Appnitro Software Forums Topic: Multilanguage identical forms data processing and saving http://www.appnitro.com/forums/ Appnitro Software Forums Topic: Multilanguage identical forms data processing and saving en Wed, 08 Feb 2012 08:05:31 +0000 gillesp on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-6052 Mon, 01 Jun 2009 20:12:47 +0000 gillesp 6052@http://www.appnitro.com/forums/ tbenko, did you found a solution to your problem? I have the same. Thanks mkrakowiak on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5940 Fri, 22 May 2009 03:37:06 +0000 mkrakowiak 5940@http://www.appnitro.com/forums/ OK, here it goes: <pre><code> <?php mysql_connect("HOST", "DB_USER", "PASSWORD") or die('Cannot connect to the database because: ' . mysql_error()); mysql_select_db ("DB_NAME") or die(mysql_error()); // select organizations only - element_3 is checked whether a user signed on as individual or for an organization $query_organizations = "SELECT element_2 FROM ap_form_1 WHERE element_3 = '2' UNION SELECT element_2 FROM ap_form_2 WHERE element_3 = '2' ORDER BY element_2 ASC"; // select names and applicable organizations $query_individuals = "SELECT CONCAT_WS(', ', element_4, element_2) AS name FROM ap_form_1 WHERE element_3 = '1' UNION SELECT CONCAT_WS(', ', element_4, element_2) AS name FROM ap_form_2 WHERE element_3 = '1' ORDER BY name ASC"; $result_organizations = @mysql_query($query_organizations); $num_organizations = mysql_num_rows($result_organizations); // counter $result_individuals = @mysql_query($query_individuals); $num_individuals = mysql_num_rows($result_individuals); // counter echo ''.$num_organizations.' groups and '.$num_individuals.' individuals have signed our petition. ; if ($num_organizations > 0) { // If it ran OK, display the records. echo "$num_organizations organizations have signed our petitions: <ol>"; // Fetch and print all the records. while ($row = mysql_fetch_array($result_organizations)) { echo '<li>' . $row[element_2] . '</li>'; } echo '</ol>'; mysql_free_result ($result_organizations); //Free up the resources. } else { // If it did not run OK. echo 'No organization have signed our petition yet. '; } if ($num_individuals > 0) { // If it ran OK, display the records. echo "$num_individuals individuals have signed our petition: <ol>"; // Fetch and print all the records. while ($row = mysql_fetch_array($result_individuals)) { echo '<li>' . $row[name] . '</li>'; } echo '</ol>'; mysql_free_result ($result_individuals); //Free up the resources. } else { // If it did not run OK. echo 'No one have signed our petition yet. '; } ?></code></pre> yuniar on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5928 Thu, 21 May 2009 16:04:47 +0000 yuniar 5928@http://www.appnitro.com/forums/ feel free to post it here :-) mkrakowiak on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5905 Wed, 20 May 2009 02:17:23 +0000 mkrakowiak 5905@http://www.appnitro.com/forums/ tbenko, if you still need the code, let me know and I can send it to you. I can also post it here if anyone may find it useful. tbenko on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5820 Wed, 13 May 2009 02:12:51 +0000 tbenko 5820@http://www.appnitro.com/forums/ Yes, I was thinking of that as a backup option and last resource... I was hoping that I will get a sollution like a form id replacement at the saving stage of the code... so one of the forms will be saved in the data table of the other form... Seems to me that i will have to search the code, maybe I will have some luck and find the saving spot, where the query is put together... mkrakowiak on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5811 Tue, 12 May 2009 02:32:24 +0000 mkrakowiak 5811@http://www.appnitro.com/forums/ It happens that I need a similar solution and also in both French and English. I think you can create two seperate forms and then pull out data from them by using some PHP and MySQL code to display it on the results page. yuniar on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5784 Sat, 09 May 2009 07:20:09 +0000 yuniar 5784@http://www.appnitro.com/forums/ Sorry, this one won't be possible. Each form has its own table and can't be merged. tbenko on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5779 Fri, 08 May 2009 00:18:56 +0000 tbenko 5779@http://www.appnitro.com/forums/ Instead coludn't we save somehow a form's data as it were an other form's data? Let's say saving the french form data to the english form's records? So this way all the records go to one place. tbenko on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5776 Thu, 07 May 2009 22:42:28 +0000 tbenko 5776@http://www.appnitro.com/forums/ Thanks for your response, however this sollution is not quite enough, because does not cover Form translation. Whenever I create a form, I add labels and explanations, form name and other info to the form. This info will not be translated with the sollution above. Any new suggestions? redityo on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5775 Thu, 07 May 2009 21:54:50 +0000 redityo 5775@http://www.appnitro.com/forums/ Hi, You can still use 1 form in 2 languages with little modification to machform files, so the data will be stored in one table. For example your form language are "English" and "France", to do so try to follow this steps : 1. Rename "includes/language.php" to "includes/language-en.php" and put "language-fr.php" as "French" language file. 2. Create a "language.php" file in "includes" folder and put this code in there : <pre><code><?php /****************************************************************************** MachForm Copyright 2007 Appnitro Software. This code cannot be redistributed without permission from <a href="http://www.appnitro.com/" rel="nofollow">http://www.appnitro.com/</a> More info at: <a href="http://www.appnitro.com/" rel="nofollow">http://www.appnitro.com/</a> ******************************************************************************/ @session_start(); $language_id = 'en'; if (!empty($_GET['lang'])) { $language_id = $_GET['lang']; } switch ($language_id){ case 'fr' : require('language-fr.php');break; default: require('language-en.php');break; } ?></code></pre> 3. Give extra GET variable to your url. For example you call the form with this embed code: <pre><code><iframe height="352" allowTransparency="true" frameborder="0" scrolling="no" style="width:100%;border:none" src="http://www.yourdomain.com/machform/embed.php?id=50" title="Untitled Form"> <a href="http://www.yourdomain.com/machform/view.php?id=50" title="Untitled Form"> Untitled Form </a> </iframe></code></pre> change embed code to be like this, to get "France" language <pre><code><iframe height="352" allowTransparency="true" frameborder="0" scrolling="no" style="width:100%;border:none" src="http://www.yourdomain.com/machform/embed.php?id=50&lang=fr" title="Untitled Form"> <a href="http://www.yourdomain.com/machform/view.php?id=50" title="Untitled Form"> Untitled Form </a> </iframe></code></pre> tbenko on "Multilanguage identical forms data processing and saving" http://www.appnitro.com/forums/topic/multilanguage-identical-forms-data-processing-and-saving#post-5758 Thu, 07 May 2009 04:57:33 +0000 tbenko 5758@http://www.appnitro.com/forums/ I would like to create a form in several languages with the same data fields. Can the data from this forms be saved somehow in just one table, so I do nat have to collect them from x different tables? I'll put an example to be more specific: I have two forms, an english and a hungarian, collecting the same kind of data. The only difference between is the language. But the data collected needs to be processed as a single bunch of records, not two or more separate record tables. Any suggestions? Thanks in advance.