MachForm Community Forums Topic: mysql Search

MachForm Community Forums Topic: mysql Search https://www.machform.com/forums/ MachForm Community Forums Topic: mysql Search en Mon, 01 Jun 2026 19:43:10 +0000 redityo on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3081 Wed, 24 Sep 2008 11:40:08 +0000 redityo 3081@https://www.machform.com/forums/ You can try this code, For date element you don't have to mention child number like "element_1_1" in there, but you can use "element_1" only <pre><code>if ($key == 'element_1' && $form_id == '1') { $_SESSION['date_time'] = $value; }</code></pre> If you do not want to save the data to database, you can comment the code between line 1015 ~ 1020 in "includes/post-functions.php" file <pre><code>/* if(empty($form_review)){ $query = "INSERT INTO <code>ap_form_{$form_id}</code> ($field_list) VALUES ($field_values);"; }else{ //insert to temporary table, if form review is enabled $query = "INSERT INTO <code>ap_form_{$form_id}_review</code> ($field_list) VALUES ($field_values);"; } */</code></pre> bhogsett on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3077 Wed, 24 Sep 2008 09:55:47 +0000 bhogsett 3077@https://www.machform.com/forums/ OK, I now have my album, artist and track search working, but date is not working. Here is what I have added to post-functions.php // Get the data to my search script if ($key == 'element_1_1' && $form_id == '1') { $_SESSION['month'] = $value; } if ($key == 'element_1_2' && $form_id == '1') { $_SESSION['day'] = $value; } if ($key == 'element_1_3' && $form_id == '1') { $_SESSION['year'] = $value; } if ($key == 'element_1' && $form_id == '2') { $_SESSION['artist'] = $value; } if ($key == 'element_1' && $form_id == '3') { $_SESSION['album'] = $value; } if ($key == 'element_1' && $form_id == '4') { The information for the date search form is apparently not being inserted into the $_SESSION variable while the other search forms all insert the data. The date is three elements and I suspect that is the problem. Any suggestions? Is the element for date an array that needs walked? Thanks. Bill bhogsett on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3066 Tue, 23 Sep 2008 19:14:04 +0000 bhogsett 3066@https://www.machform.com/forums/ Thanks that works fine. I didn't realize I needed: if ($key == 'element_1' && $form_id == '1') { $_SESSION['artist'] = $value; } Any suggestion how to generalize the insertion into the SESSION array? I will have maybe 4 forms each with one element (likely to be album, artist, track, date). I can do a series of ifs or switches, but is there a more elegant way? Final question for now. I don't need or particular want the form data to be inserted into my database. I thought I saw once directions as to which lines to comment out to avoid the insertion, but I can't find it now. Thanks again! Bill redityo on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3065 Tue, 23 Sep 2008 16:04:34 +0000 redityo 3065@https://www.machform.com/forums/ Hi .. I think it's better to use SESSION instead of POST variable and I think you've done the correct way. In this case I assume you want to parse "element_1" on form 1 to search.php, so you need to do the following steps. 1. Edit "includes/post-functions.php" on line 943 <pre><code>if ($key == 'element_1' && $form_id == '1') { $_SESSION['artist'] = $value; }</code></pre> 2. in your search.php file add this code to get session variable <pre><code><?php session_start(); ?> <html> <head> <title>My Variables PHP Script</title> </head> <body> The artist is: <? echo $_SESSION['artist'] ?> </body> </html></code></pre> bhogsett on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3060 Tue, 23 Sep 2008 10:45:18 +0000 bhogsett 3060@https://www.machform.com/forums/ I still need some help. After reading many of the forum messages, it appears I intend to use the forms differently than they were intended. While I have a working mysql database on the server (bhogsett.com in music) I do not need to use the Machform form to insert data into the database. I bought Machforms for the look of the form and the ease of creating the forms. What I want to do is get the data from the form into my own php search script that will search my database and display the results in my page. I found a post here that suggested inserting: //retrieve the data from element WFH added if ($key == 'element_1' && $form_id == '1') { $_SESSION['Artist'] = $value; } to line 948 of the post_functions include file. I added the 'Artist'. My redirect test page (variable.php) is: <html> <head> <title>My Variables PHP Script</title> </head> <body> The artist is: <? echo $_SESSION['element_1'] ?> </body> </html> I do not think I understand how to pass the $_SESSION to the redirect page. At the end of the day, I will settle for just adding an action=variables.php and give up all of the Machform validation and database entry. But maybe there is a better solution. Thanks. Bill bhogsett on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3051 Mon, 22 Sep 2008 17:26:24 +0000 bhogsett 3051@https://www.machform.com/forums/ Yes, I want to pass the POST values to search.php so that search.php can construct the mysql query and then display the results. Bill yuniar on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3050 Mon, 22 Sep 2008 12:28:57 +0000 yuniar 3050@https://www.machform.com/forums/ Hi Bill, So you would like your form to redirect to search.php after form submission and pass some search query parameters? If so, what are the parameters needed by search.php ? bhogsett on "mysql Search" https://www.machform.com/forums/topic/mysql-search#post-3041 Sun, 21 Sep 2008 18:20:36 +0000 bhogsett 3041@https://www.machform.com/forums/ I have just purchased and installed MachForm. Installation was as fast and easy as advertised. I want to use the form to launch a search.php script rather than insert information into the database. Do I have to manually change the form code? I looked in the data directory and the files subdirectory, but the files are not appearing. Help please. Bill Hogsett