Thanks!

April

I actually figured it out. I had an hidden field on my testdir,php page so I got it all working. My only other question is it still possible to validate the data for required fields on the first page (testdir.php) before it goes to the preview page?

 ########################################################################################
  ##   Form Code
  
  $schema = loadSchema('dir_listings');
  
  // save?
  $errorsAndAlerts = '';
  
 
  
  if (@$_REQUEST['save']) {
   
   
 
    
    if ($errorsAndAlerts) {
    
   if (!@$_REQUEST['title'])             { $errorsAndAlerts .= "You must enter your listing name!<br/>\n"; }
    if (!@$_REQUEST['state'])            { $errorsAndAlerts .= "You must enter your state!<br/>\n"; }
    if (!@$_REQUEST['city'])             { $errorsAndAlerts .= "You must enter your city!<br/>\n"; }
    if (!@$_REQUEST['zipcode'])          { $errorsAndAlerts .= "You must enter your zip!<br/>\n"; }
    if (!@$_REQUEST['address'])          { $errorsAndAlerts .= "You must enter your address!<br/>\n"; }
    if (!@$_REQUEST['summary'])          { $errorsAndAlerts .= "You must choose a description!<br/>\n"; }
   if (!@$_REQUEST['category'])          { $errorsAndAlerts .= "You must select a category!<br/>\n"; }
  }
    
   
 // save!
    if (!$errorsAndAlerts) {
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)
      require_once("../../cmsAdmin/lib/user_functions.php");
      $record = array_slice_keys($_REQUEST, explode(', ', 'category, title, address, city, state, zipcode, summary'));
      
      $record = array_merge($record, array(
        'hidden'           => 1,
       'createdDate'      => mysql_datetime(),
        'createdByUserNum' => intval( @$CURRENT_USER['num'] ),
        'updatedDate'      => mysql_datetime(),
        'updatedByUserNum' => intval( @$CURRENT_USER['num'] ),
        'publishDate'      => mysql_datetime(),
 'date'             => mysql_datetime(),
        'reg_listing'      => 1,
 'url_link'        => 0,
        'neverRemove'      => 1,
      ));
      
    
}
  }
    
  $_REQUEST['preSaveTempId'] = coalesce(@$_REQUEST['preSaveTempId'], uniqid());
  
?>

Could this be causing it?

Can you take a look at my files and see what I am doing wrong? 

Thanks!

Thanks!

Thanks!

April

Is there a way to include an image filename in email template?

'image'        => $_REQUEST['image'],

EX: So the emailed template could show the following:

Image: 177114234-family_003.jpg

I used this and it worked perfectly to output text in my email template.

However, then when I went back to submit my form again, I got the following error where this code is located.

'days'             => implode(', ',$_REQUEST['days']),

Notice: Undefined index: days in C:\inetpub\charlotteparent\directory\forms\form.php on line 293 Warning: implode(): Invalid arguments passed in C:\inetpub\charlotteparent\directory\forms\form.php on line 293

Is it conflicting with the main code we placed to make days of week work or if there an easy to fix?

// setup checkbox days
 if(isset($_REQUEST['days'])) {
    $days_TSV = "\t" . implode("\t", $_REQUEST['days'] ) . "\t";
}
else {
     $days_TSV = "";
}

I one other thing I need help with. With the coding above that we used to output the days of week which is a multiple list with checkbox. It works perfect to record the data in backend of CMS. However, when I put the

<?= @$_REQUEST['days']?>

in my preview file, it just outputs array. It also does the same for the email template (#days#) that is sent to user and admin:

'days'            => $_REQUEST['days'],

Is there a way to make that data display properly in the preview file and email template? I have uploaded my file as well in case you need to look at everything.

Here is my coding for the checkbox:

<div id="days" >
<div class="form-label">Days of Week:</div>
<div class="form-field">

<fieldset>
<?php foreach($days_dirRecords as $record): ?>
<input type="checkbox" value="<?php echo $record['habbit']; ?>" <?php echo checkIfInArray($record['habbit'], @$_REQUEST["days"]) ?> name="days[]" />&nbsp;<?php echo $record['habbit']; ?>
<br />
<?php endforeach; ?>
</fieldset>



</div></div>

Thanks! April

I one other thing I need help with. With the coding above that we used to output the days of week which is a multiple list with checkbox. It works perfect to record the data in backend of CMS. However, when I put the

<?= @$_REQUEST['days']?>

in my preview file, it just outputs array. It also does the same for the email template (#days#) that is sent to user and admin:

'days'            => $_REQUEST['days'],

Is there a way to make that data display properly in the preview file and email template? I have uploaded my file as well in case you need to look at everything.

Here is my coding for the checkbox:

<div id="days" >
<div class="form-label">Days of Week:</div>
<div class="form-field">

<fieldset>
<?php foreach($days_dirRecords as $record): ?>
<input type="checkbox" value="<?php echo $record['habbit']; ?>" <?php echo checkIfInArray($record['habbit'], @$_REQUEST["days"]) ?> name="days[]" />&nbsp;<?php echo $record['habbit']; ?>
<br />
<?php endforeach; ?>
</fieldset>



</div></div>

Thanks! April

Thanks for all your help!

Warning: implode(): Invalid arguments passed in C:\inetpub\charlotteparent\directory\freeform1.php on line 86 

Thanks!

April

One last thing and I promise I will stop bothering you today!

I included the coding Dave provided above with my field names:

$days_TSV = "\t" . implode("\t", $_REQUEST['days'] ) . "\t";

It all works great when I select the category that it associated with. However, when I choose another category that is not associated with that field (days), I get an error undefined index because that fields days is being hidden by my query. 

Here is the error: Notice: Undefined index: days in C:\inetpub\charlotteparent\directory\freeform1.php on line 86 Warning: implode(): Invalid arguments passed in C:\inetpub\charlotteparent\directory\freeform1.php on line 86

Is there any other way to fix that error when I am selecting other categories?

fieldname = name   (value and label)

I was using the get list options so it would not reset the drop down on submit or user error message. 

One other question: Using the add form.php, it has a  action="?preSaveTempId=<?php echo $preSaveTempId ?>" for the action. Is there another way that I can still submit the form and send it to a separate thank-you page?

I have also included my file if you need to look at that. 

Thanks for all your help with this!!!

<select name="category">
<option value = "">-Select-</option>
<?php foreach (getListOptions($tableName, 'category') as $value => $label): ?>
<option value = "<?php echo htmlspecialchars($value);?>" <?php selectedIf($value, @$_REQUEST['category']);?>> <?php echo htmlspecialchars($label);?> </option>
<?php endforeach ?>
</select>

I just noticed something. Need your help. This option works great but it is effecting the drop down in the CMS backend as well as on the form because of the advanced coding. I only want the excluded options to show on the form not in the backend. Can I just include some code on the actual form page to exclude options in the list only for form page and not in backend?

Feel like I am missing some syntax

SELECT fieldname1, fieldname2
FROM `<?php echo $TABLE_PREFIX ?>tableName` WHERE hidden = 0 ORDER BY dragSortOrder

Thank so much, that worked perfectly. Can I include an order by clause  so that the options in the drop down will display in the same drag/sort order that I have them in the category menu vs sorting them by id num?

Thanks!

April