From 53094de20d007b5a121f8a7cf814eabd8ee75b90 Mon Sep 17 00:00:00 2001 From: Jason Woofenden Date: Thu, 1 Mar 2007 04:46:28 -0500 Subject: [PATCH] updated metaform for new db.php and messages.php --- metaform.php | 3 ++- metaform/template.html | 4 ++-- metaform/template.php | 28 +++++++++++++++------------- 3 files changed, 19 insertions(+), 16 deletions(-) diff --git a/metaform.php b/metaform.php index 03d8b28..ce6a37f 100644 --- a/metaform.php +++ b/metaform.php @@ -30,7 +30,8 @@ $GLOBALS['types'] = array( # 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)'), diff --git a/metaform/template.html b/metaform/template.html index ed5b202..07cf014 100644 --- a/metaform/template.html +++ b/metaform/template.html @@ -12,11 +12,11 @@ div.error { border: 2px solid red; padding: 13px; margin: 20px; background: #ffd -

~form_name~ entry form

+

Add a new entryEdit entry "~~name.html~~"

~error_message.html~

-
+ diff --git a/metaform/template.php b/metaform/template.php index 258581c..adf4803 100644 --- a/metaform/template.php +++ b/metaform/template.php @@ -26,6 +26,7 @@ $GLOBALS['upload_directory'] = 'uploads/'; 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/messages.php'); require_once('code/wfpl/email.php'); require_once('code/wfpl/db.php'); require_once('code/wfpl/upload.php'); @@ -43,20 +44,28 @@ function ~form_name~_get_fields() { 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(); @@ -68,14 +77,14 @@ function ~form_name~() { 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") { @@ -111,7 +120,7 @@ function ~form_name~() { # 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: @@ -123,11 +132,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(); -} - ?> -- 1.7.10.4
~caption.html~: ~caption.html~: ~caption.html~: ~caption.html~: ~caption.html~: