https://www.machform.com/forums/ MachForm Community Forums Topic: get person information from SQL database en Sun, 03 May 2026 23:27:57 +0000 https://www.machform.com/forums/topic/get-person-information-from-sql-database#post-12751 Tue, 11 Oct 2011 22:43:38 +0000 bonda 12751@https://www.machform.com/forums/ <p>If "Show Review Page Before Submitting" is checked in the form properties, the user can choose to get back to the form and modify some entries. In such a case, the form is populated from the $_SESSION data (corresponding scripts are in post-functions.php). Earlier, here also was an explanation how to pre-populate the 'email' field using $GET ['email'] (http://www.appnitro.com/forums/topic/dynamic-content-php?replies=42#post-304). If this is possible, then it should also be possible to pre-populate empty forms by taking any or all data stored in a DB record (selected using one or two entries which are unique in every record). As I see it, such a custom function could be saved in a separate PHP file and just required by a standard MachForm PHP file (not to modify it too much). I mean, all could be done without JavaScripting. Did I miss something? </p> https://www.machform.com/forums/topic/get-person-information-from-sql-database#post-12710 Wed, 05 Oct 2011 00:21:00 +0000 codeoflight 12710@https://www.machform.com/forums/ <p>Yes you can!</p> <p>You have to do it by embedding a javascript segment in any "User Guidelines" field. The javascript has to make an ajax call to get the data and fill in the form fields. Not easy, but the script does save with the form information when you save the form definition. </p> https://www.machform.com/forums/topic/get-person-information-from-sql-database#post-12708 Tue, 04 Oct 2011 20:53:20 +0000 yuniar 12708@https://www.machform.com/forums/ <p>I'm afraid MachForm doesn't have the feature to do so. Sorry. </p> https://www.machform.com/forums/topic/get-person-information-from-sql-database#post-12705 Mon, 03 Oct 2011 19:59:05 +0000 tss 12705@https://www.machform.com/forums/ <p>Hi, if a person has already filled in a form before, is it possible to get his data back when he fill's in his name and birthday for example, from the SQL database so the person does not need to type in all his information again? Thanks </p>