added (untested) updates to metaform's php template to do editing and deleting from...

diff --git a/metaform.php b/metaform.php
index 2adf13b..347717c 100644 (file)
--- a/metaform.php
+++ b/metaform.php
@@ -201,6 +201,7 @@ function make_php() {
                                $php_fields .= '$' . $name;
                        }
                        $tem->sub('formats');
+                       $tem->sub('tem_sets');
                        if(!$always_field and $input != 'checkbox' and $input != 'radio') {
                                $always_field = $name;
                        }

diff --git a/metaform/template.php b/metaform/template.php
index 2ee09ee..2755101 100644 (file)
--- a/metaform/template.php
+++ b/metaform/template.php
@@ -2,32 +2,65 @@
 
 # This form requires wfpl. See: http://jasonwoof.org/wfpl
 
-# You'll need to set the following to a valid email address:
+# This code can send form results by e-mail and/or save them to a database. See
+# the next two comments to enable either or both.
+
+# 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' which calls db_connect() see:
+# code/wfpl/examples/db_connect.php
+
 if(!file_exists('code/wfpl/template.php')) { die('This form requires <a href="http://jasonwoof.org/wfpl">wfpl</a>.'); }
 require_once('code/wfpl/template.php');
 require_once('code/wfpl/format.php');
 require_once('code/wfpl/email.php');
+require_once('code/wfpl/db.php');
 
 function ~form_name~_get_fields() {
        $fields = array();
        <!--~formats start~-->
-       $~name~ = format_~format~($_REQUEST['~name~']);
-       tem_set('~name~', $~name~);
-       <!--~end~-->
+       $~name~ = format_~format~($_REQUEST['~name~']);<!--~end~-->
+       <!--~tem_sets~-->
+       tem_set('~name~', $~name~);<!--~end~-->
+
        return array(~php_fields~);
 }
 
 function ~form_name~() {
+       $event_id = format_int($_REQUEST['~form_name~_edit_id']);
+       if($edit_id) {
+               # add hidden field for database id of row we're editing
+               tem_set('~form_name~_event_id', $edit_id);
+               tem_sub('editing');
+       }
+
+       $delete_id = format_int($_REQUEST['~form_name~_delete_id']);
+       if($delete_id) {
+               db_delete('~form_name~', 'id = %"', $delete_id);
+
+               # FIXME: what to do after delete?
+               return;
+       }
+
        if(isset($_REQUEST['~always_field~'])) {
                list(~php_fields~) = ~form_name~_get_fields();
 
                if("you're happy with the POSTed values") {
-                       # uncomment the following lines to save the values recieved to the
-                       # database. You can use ~form_name~.sql to create the database table.
-                       #require_once('db_connect.php');
-                       #db_insert('~form_name~', '~db_fields~', ~php_fields~);
+                       # 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($edit_id) {
+                                       db_update('~form_name~', '~db_fields~', ~php_fields~, 'id = %"', $edit_id);
+                                       tem_set('did', 'updated');
+                               } else {
+                                       db_insert('~form_name~', '~db_fields~', ~php_fields~);
+                                       tem_set('did', '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'])) {
@@ -54,6 +87,14 @@ function ~form_name~() {
                # show up in the form fields. You should add some message asking people to
                # 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('events', '~db_fields~', 'id = %"', $event_id);
+               ~tem_sets~
+       } else {
+               # form not submitted, you can set default values like so
+               #tem_set('~always_field~', 'Yes');
+       }
 
        tem_sub('form');
 }