MachForm Community Forums Topic: Retrieve Data

MachForm Community Forums Topic: Retrieve Data https://www.machform.com/forums/ MachForm Community Forums Topic: Retrieve Data en Sat, 07 Nov 2026 08:05:38 +0000 yuniar on "Retrieve Data" https://www.machform.com/forums/topic/retrieve-data#post-12312 Thu, 14 Jul 2011 18:50:03 +0000 yuniar 12312@https://www.machform.com/forums/ That's odd. Can you send me your PHP file please? I'll check it. You can send it via email: customer.service [at] appnitro.com brucenow on "Retrieve Data" https://www.machform.com/forums/topic/retrieve-data#post-12307 Wed, 13 Jul 2011 23:06:19 +0000 brucenow 12307@https://www.machform.com/forums/ Thanks for your reply. I copied it into a Wordpress page. (I'm using the "exec-php" plugin) I got this message: Parse error: syntax error, unexpected ‘=’ in /home1/neighbr0/public_html/punkobama/wp-content/plugins/exec-php/includes/runtime.php(42) : eval()’d code on line 5 I tried it with a simple .php page that I uploaded to the site and got the same message: Parse error: syntax error, unexpected '=' in /home1/neighbr0/public_html/punkobama/machform-1.php on line 5 So what's with that? I much appreciate any help. Bruce yuniar on "Retrieve Data" https://www.machform.com/forums/topic/retrieve-data#post-12302 Wed, 13 Jul 2011 15:34:53 +0000 yuniar 12302@https://www.machform.com/forums/ The field names within the table should be something like "element_1" ... "element_2"... etc. You can check into the table directly to see it (you will need to use phpMyAdmin or any other mysql console to see it). Also, it seems you are missing some code there. It should be something like this: <pre><code><?php mysql_connect("localhost", "database_name", "password") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); $result = mysql_query("SELECT * FROM form_1"); $row = mysql_fetch_array($result); echo $row['element_1']; echo $row['element_2']; echo $row['element_3']; ?></code></pre> brucenow on "Retrieve Data" https://www.machform.com/forums/topic/retrieve-data#post-12300 Wed, 13 Jul 2011 09:50:35 +0000 brucenow 12300@https://www.machform.com/forums/ I've created my first form. Now I want to retrieve data from the database. I'm guessing the name of the table is form_1, and I have no idea what the field names are. It wasn't clear to me from the form creation what their name would be. But I would like to be able to retrieve specific field values from a record. Just to see if I could get anything from the database I tried this code: (substituting my database name and user name) '<?php>' 'mysql_connect("localhost", "database_name", "password") or die(mysql_error());' 'mysql_select_db("test") or die(mysql_error());' '$result = mysql_query("SELECT * FROM form_1");' 'echo $result;' '?>' but got a blank page. Bruce