JasonWoof Got questions, comments, patches, etc.? Contact Jason Woofenden
db_connect.php can now be in code/
[wfpl.git] / metaform / template.php
1 <?php
2
3 # This form requires wfpl. If you didn't recieve wfpl along with this file,
4 # see: http://jasonwoof.org/wfpl
5
6 # This form was auto-generated. If you would like to alter the parameters and
7 # generate a new one try this URL:
8 #
9 # ~metaform_url~
10
11 # This code can send form results by e-mail and/or save them to a database. See
12 # the next two comments to enable either or both.
13
14 # To send results by e-mail, all you have to do is set your e-mail address here:
15 $GLOBALS['~form_name~_form_recipient'] = "fixme@example.com";
16 <!--~upload_settings start~-->
17 # Set this to the path to your uploads directory. It can be relative to the
18 # location of this script. IT MUST END WITH A SLASH
19 $GLOBALS['upload_directory'] = 'uploads/';
20 <!--~end~-->
21 # To save results to a database, you'll need to create the ~form_name~ table
22 # (the file ~form_name~.sql should help with this), and create a file called
23 # 'db_connect.php' which calls db_connect() see:
24 # code/wfpl/examples/db_connect.php
25
26 if(!file_exists('code/wfpl/template.php')) { die('This form requires <a href="http://jasonwoof.org/wfpl">wfpl</a>.'); }
27 require_once('code/wfpl/template.php');
28 require_once('code/wfpl/format.php');
29 require_once('code/wfpl/messages.php');
30 require_once('code/wfpl/email.php');
31 require_once('code/wfpl/db.php');<!--~image_include start~-->
32 require_once('code/wfpl/upload.php');<!--~end~-->
33
34 function ~form_name~_get_fields() {
35         $fields = array();
36         <!--~formats start~-->
37         $~name~ = format_~format~($_REQUEST['~name~']);<!--~end~--><!--~image_upload start~-->
38         $~name~ = save_uploaded_image('~name~', $GLOBALS['upload_directory']);<!--~end~-->
39         <!--~tem_sets start~-->
40         tem_set('~name~', $~name~);<!--~end~-->
41
42         return array(~php_fields~);
43 }
44
45 function ~form_name~() {
46         $edit_id = format_int($_REQUEST['~form_name~_edit_id']);
47         unset($_REQUEST['~form_name~_edit_id']);
48         if($edit_id) {
49                 # add hidden field for database id of row we're editing
50                 tem_set('~form_name~_edit_id', $edit_id);
51                 tem_sub('editing');
52                 tem_sub('edit_msg');
53         }
54
55         $delete_id = format_int($_REQUEST['~form_name~_delete_id']);
56         unset($_REQUEST['~form_name~_delete_id']);
57         if($delete_id) {
58                 db_delete('~form_name~', 'where id=%i', $delete_id);
59                 message('Entry deleted.');
60
61                 # FIXME: what to do after delete?
62                 return;
63         }
64
65         if(!$edit_id && !$delet_id) {
66                 tem_sub('new_msg');
67         }
68
69         if(isset($_REQUEST['~always_field~'])) {
70                 list(~php_fields~) = ~form_name~_get_fields();
71
72                 if("you're happy with the POSTed values") {
73                         # to enable saving to a database, create a file called 'db_connect.php'
74                         # see: code/wfpl/examples/db_connect.php
75                         if(file_exists('db_connect.php') || file_exists('code/db_connect.php')) {
76                                 if(file_exists('db_connect.php') {
77                                         require_once('db_connect.php');
78                                 } else {
79                                         require_once('code/db_connect.php');
80                                 }
81                                 if($edit_id) {<!--~image_db start~-->
82                                         # uploading nothing means leaving it as is.
83                                         if(!$~name~ && $delete_~name~ != 'Yes') {
84                                                 $~name~ = db_get_value('~form_name~', '~name~', 'where id=%i', $edit_id);
85                                         }
86                                         <!--~end~-->
87                                         db_update('~form_name~', '~db_fields~', ~php_fields~, 'where id=%i', $edit_id);
88                                         message('Entry updated.');
89                                 } else {
90                                         db_insert('~form_name~', '~db_fields~', ~php_fields~);
91                                         message('Entry saved.');
92                                 }
93                         }
94                         if($GLOBALS['~form_name~_form_recipient'] != "fixme@example.com") {
95                                 $to = $GLOBALS['~form_name~_form_recipient'];
96                                 if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) {
97                                         $from = $_REQUEST['email'];
98                                         if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
99                                                 $from = "$_REQUEST[name] <$from>";
100                                         }
101                                 } else {
102                                         $from = $to;
103                                 }
104                                 $subject = '~form_name~ form submitted';
105                                 $message = tem_run('~form_name~.email.txt');
106                                 $cc = '';
107                                 $bcc = '';
108                                 if(email($from, $to, $subject, $message, $cc, $bcc)) {
109                                         tem_set('error_message', 'Due to an internal error, your message could not be sent. Please try again later.');
110                                         tem_sub('error');
111                                         $error = true;
112                                 }
113                         }
114                         if($error !== true) {
115                                 tem_load('~form_name~.html');
116                                 tem_sub('thankyou');
117                                 tem_output();
118                                 exit();
119                         }
120                 }
121                 # otherwise, we display the form again. ~form_name~_get_fields() has
122                 # already put the posted values back into the template engine, so they will
123                 # show up in the form fields. You should add some message asking people to
124                 # fix their entry in whatever way you require.
125         } elseif($edit_id) {
126                 # we've recieved an edit id, but no data. So we grab the values to be edited from the database
127                 list(~php_fields~) = db_get_row('~form_name~', '~db_fields~', 'where id=%i', $edit_id);
128                 ~tem_sets.tab~
129         } else {
130                 # form not submitted, you can set default values like so:
131                 #tem_set('~always_field~', 'Yes');
132         }<!--~upload_max start~-->
133
134         tem_set('upload_max_filesize', upload_max_filesize());<!--~end~-->
135
136         tem_sub('form');
137 }
138
139 ?>