X-Git-Url: https://jasonwoof.com/gitweb/?a=blobdiff_plain;f=metaform%2Ftemplate.php;h=6ed1caa5794092f6922a50b87d7a1d0ceebcd9d0;hb=130669e105c06dbfa3272ae9a2c41d5f11003a80;hp=8cbc9e94e49c0003e11be30772a2ee06b83ab5c3;hpb=10db898ea08d5fb0b9a4b4f20e6ab146e38f947a;p=wfpl.git

diff --git a/metaform/template.php b/metaform/template.php
index 8cbc9e9..6ed1caa 100644
--- a/metaform/template.php
+++ b/metaform/template.php
@@ -2,58 +2,108 @@
 
 # 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'); # fixme
+require_once('code/wfpl/db.php');
 
 function ~form_name~_get_fields() {
-	$GLOBALS['~form_name~_fields'] = array();<!--~formats start~-->
+	$fields = array();
+	<!--~formats start~-->
+	$~name~ = format_~format~($_REQUEST['~name~']);<!--~end~-->
+	<!--~tem_sets start~-->
+	tem_set('~name~', $~name~);<!--~end~-->
 
-	$value = format_~format~($_REQUEST['~name~']);
-	tem_set('~name~', $value);<!--~db_field start~-->
-	$GLOBALS['~form_name~_fields'][] = $value;<!--~end~--><!--~end~-->
+	return array(~php_fields~);
 }
-	
-
-if(isset($_REQUEST['~always_field~'])) {
-	~form_name~_get_fields();
-
-	if("you're happy with the POSTed values") {
-		#db_insert('~form_name~', '~db_fields~', $GLOBALS['~form_name~_fields']); # fixme
-		if($GLOBALS['~form_name~_form_recipient'] != "fixme@example.com") {
-			$to = $GLOBALS['~form_name~_form_recipient'];
-			if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) {
-				$from = $_REQUEST['email'];
-				if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
-					$from = "$_REQUEST[name] <$from>";
+
+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") {
+			# 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'])) {
+					$from = $_REQUEST['email'];
+					if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
+						$from = "$_REQUEST[name] <$from>";
+					}
+				} else {
+					$from = $to;
 				}
-			} else {
-				$from = $to;
+				$subject = '~form_name~ form submitted';
+				$message = tem_run('~form_name~.email.txt');
+				$cc = '';
+				$bcc = '';
+				email($from, $to, $subject, $message, $cc, $bcc);
 			}
-			$subject = '~form_name~ form submitted';
-			$message = tem_run('~form_name~.email.txt');
-			$cc = '';
-			$bcc = '';
-			email($from, $to, $subject, $message, $cc, $bcc);
+			tem_load('~form_name~.html');
+			tem_sub('thankyou');
+			tem_output();
+			exit();
 		}
-		tem_load('~form_name~.html');
-		tem_sub('thankyou');
-		tem_output();
-		exit();
+		# 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.
 	}
-	# 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.
+	} 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.tab~
+	} else {
+		# form not submitted, you can set default values like so
+		#tem_set('~always_field~', 'Yes');
+	}
+
+	tem_sub('form');
 }
 
-tem_load('~form_name~.html');
-tem_sub('form');
-tem_output();
+# emulate run.php if it's not being used
+if(!function_exists('run_php')) {
+	tem_load('~form_name~.html');
+	~form_name~();
+	tem_output();
+}
 
 ?>