# type input format sql
'name' => array('textbox', 'oneline', 'varchar(200)'),
'textbox' => array('textbox', 'oneline', 'varchar(200)'),
- 'int' => array('textbox', 'int', 'varchar(100)'),
+ 'int' => array('textbox', 'int', 'int'),
+ 'bigint' => array('textbox', 'int', 'varchar(100)'), # up to 100 digits, stored as a string
'email' => array('textbox', 'email', 'varchar(100)'),
'phone' => array('textbox', 'phone', 'varchar(32)'),
'money' => array('textbox', 'money', 'varchar(32)'),
<body>
<!--~~form start~~--><!--~form start~-->
- <h2>~form_name~ entry form</h2>
+ <h2><!--~~new_msg start~~-->Add a new entry<!--~~end~~--><!--~~edit_msg start~~-->Edit entry "~~name.html~~"<!--~~end~~--></h2>
<!--~error start~--><div class="error"><h3>~error_message.html~</h3></div><!--~end~-->
- <form action="~form_name~.php~enctype_attr~" method="post"><!--~~editing start~~--><input type="hidden" name="~form_name~_edit_id" value="~~~form_name~_edit_id.attr~~" /><!--~~end~~--><!--~uploads start~--><input type="hidden" name="MAX_FILE_SIZE" value="~~upload_max_filesize~~" /><!--~end~-->
+ <form action="~form_name~.html~enctype_attr~" method="post"><!--~~editing start~~--><input type="hidden" name="~form_name~_edit_id" value="~~~form_name~_edit_id.attr~~" /><!--~~end~~--><!--~uploads start~--><input type="hidden" name="MAX_FILE_SIZE" value="~~upload_max_filesize~~" /><!--~end~-->
<table cellspacing="0" cellpadding="4" border="0" summary=""><!--~row start~-->
<tr><!--~image start~--><td class="caption">~caption.html~: </td><td><input type="file" name="~name~" /></td><!--~end~--><!--~textbox start~--><td class="caption">~caption.html~: </td><td><input type="text" name="~name~" value="~~~name~.attr~~" /></td><!--~end~--><!--~password start~--><td class="caption">~caption.html~: </td><td><input type="password" name="~name~" value="~~~name~.attr~~" /></td><!--~end~--><!--~textarea start~--><td class="caption">~caption.html~: </td><td><textarea name="~name~">~~~name~.html~~</textarea></td><!--~end~--><!--~checkbox start~--><td class="caption">~caption.html~: </td><td><input type="checkbox" name="~name~~~~name~.checked~~" /></td><!--~end~--><!--~submit start~--><td class="submit_row" colspan="2"><input type="submit" name="~name~" value="~caption.attr~" /></td><!--~end~--></tr><!--~end~-->
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/messages.php');
require_once('code/wfpl/email.php');
require_once('code/wfpl/db.php');<!--~image_include start~-->
require_once('code/wfpl/upload.php');<!--~end~-->
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($edit_id) {<!--~image_db start~-->
# 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);
}
<!--~end~-->
- 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") {
# 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);
+ 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:
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();
-}
-
?>
Got questions, comments, patches, etc.? Contact Jason Woofenden