X-Git-Url: https://jasonwoof.com/gitweb/?a=blobdiff_plain;f=metaform%2Ftemplate.php;h=fc1263b8f85bd279f7b2d2e5ebf013f67e330773;hb=21c47e88810e97fe5b727c9c2689f64533bf6452;hp=af98d9623bf9530d399ce4d94f434011edcc0608;hpb=a4e42e7c89f4c256ff2512902fb539a2279785ce;p=wfpl.git diff --git a/metaform/template.php b/metaform/template.php index af98d96..fc1263b 100644 --- a/metaform/template.php +++ b/metaform/template.php @@ -1,32 +1,37 @@ # To send results by e-mail, all you have to do is set your e-mail address here: $GLOBALS['~form_name~_form_recipient'] = "fixme@example.com"; - + +# To save results to a database, you'll need to create the ~form_name~ table +# (the file ~form_name~.sql should help with this), and create a file called +# 'db_connect.php' or 'code/db_connect.php' which calls db_connect() see: +# code/wfpl/examples/db_connect.php + # Set this to the path to your uploads directory. It can be relative to the # location of this script. IT MUST END WITH A SLASH $GLOBALS['upload_directory'] = 'uploads/'; -# To save results to a database, you'll need to create the ~form_name~ table -# (the file ~form_name~.sql should help with this), and create a file called -# 'db_connect.php' which calls db_connect() see: -# code/wfpl/examples/db_connect.php if(!file_exists('code/wfpl/template.php')) { die('This form requires wfpl.'); } require_once('code/wfpl/template.php'); require_once('code/wfpl/format.php'); -require_once('code/wfpl/email.php'); -require_once('code/wfpl/db.php'); +require_once('code/wfpl/messages.php'); +require_once('code/wfpl/email.php'); +require_once('code/wfpl/db.php'); require_once('code/wfpl/upload.php'); -function ~form_name~_get_fields() { - $fields = array(); - +function ~form_name~_get_fields() { $~name~ = format_~format~($_REQUEST['~name~']); $~name~ = save_uploaded_image('~name~', $GLOBALS['upload_directory']); @@ -35,43 +40,49 @@ function ~form_name~_get_fields() { return array(~php_fields~); } -function ~form_name~() { +function ~form_name~() { $edit_id = format_int($_REQUEST['~form_name~_edit_id']); + unset($_REQUEST['~form_name~_edit_id']); if($edit_id) { # add hidden field for database id of row we're editing tem_set('~form_name~_edit_id', $edit_id); tem_sub('editing'); + tem_sub('edit_msg'); } $delete_id = format_int($_REQUEST['~form_name~_delete_id']); + unset($_REQUEST['~form_name~_delete_id']); if($delete_id) { - db_delete('~form_name~', 'id = %"', $delete_id); + db_delete('~form_name~', 'where id=%i', $delete_id); + message('Entry deleted.'); # FIXME: what to do after delete? return; } + if(!$edit_id && !$delet_id) { + tem_sub('new_msg'); + } + if(isset($_REQUEST['~always_field~'])) { list(~php_fields~) = ~form_name~_get_fields(); - if("you're happy with the POSTed values") { - # to enable saving to a database, create a file called 'db_connect.php' - # see: code/wfpl/examples/db_connect.php - if(file_exists('db_connect.php')) { - require_once('db_connect.php'); + if("you're happy with the POSTed values") { + if(file_exists($db_connector = 'db_connect.php') || file_exists($db_connector = 'code/db_connect.php')) { + require_once($db_connector); if($edit_id) { # uploading nothing means leaving it as is. if(!$~name~ && $delete_~name~ != 'Yes') { - $~name~ = db_get_value('~form_name~', '~name~', 'id = %"', $edit_id); + $~name~ = db_get_value('~form_name~', '~name~', 'where id=%i', $edit_id); } - db_update('~form_name~', '~db_fields~', ~php_fields~, 'id = %"', $edit_id); - tem_set('did', 'updated'); + db_update('~form_name~', '~db_fields~', ~php_fields~, 'where id=%i', $edit_id); + message('Entry updated.'); } else { db_insert('~form_name~', '~db_fields~', ~php_fields~); - tem_set('did', 'saved'); + message('Entry saved.'); } - } + } if($GLOBALS['~form_name~_form_recipient'] != "fixme@example.com") { $to = $GLOBALS['~form_name~_form_recipient']; if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) { @@ -91,7 +102,7 @@ function ~form_name~() { tem_sub('error'); $error = true; } - } + } if($error !== true) { tem_load('~form_name~.html'); tem_sub('thankyou'); @@ -102,13 +113,13 @@ function ~form_name~() { # otherwise, we display the form again. ~form_name~_get_fields() has # already put the posted values back into the template engine, so they will # show up in the form fields. You should add some message asking people to - # fix their entry in whatever way you require. + # fix their entry in whatever way you require. } elseif($edit_id) { # we've recieved an edit id, but no data. So we grab the values to be edited from the database - list(~php_fields~) = db_get_row('~form_name~', '~db_fields~', 'id = %"', $edit_id); - ~tem_sets.tab~ + list(~php_fields~) = db_get_row('~form_name~', '~db_fields~', 'where id=%i', $edit_id); + ~tem_sets.tab~ } else { - # form not submitted, you can set default values like so + # form not submitted, you can set default values like so: #tem_set('~always_field~', 'Yes'); } @@ -117,11 +128,4 @@ function ~form_name~() { tem_sub('form'); } -# emulate run.php if it's not being used -if(!function_exists('run_php')) { - tem_load('~form_name~.html'); - ~form_name~(); - tem_output(); -} - ?>