If checkbox is checked, then post

[Debar]

Hi guys,

Im running into trouble here

I have two fields

A text area field:

<?php echo draw_textarea_field('comments', 'soft', '60', '5'); ?>

A Dropdown box:

<?php 

  $sql='select response_id, response_name, response_text from ' . TABLE_SUPPORT_RESPONSES .' order by response_name';
  $response_query=$db->Execute($sql);
  while (!$response_query->EOF){
    $response_array[]=array('id'=>$response_query->fields['response_text'], 
	                        'text'=>$response_query->fields['response_name']);

	$response_query->MoveNext();

  } //endwhile
  ?>
  <tr>


	<td class="main"><b><?php echo 'Use Custom Response' ?></b></td>
	<td><?php echo draw_pull_down_menu('response', $response_array); ?></td>
  </tr>

Now as you can see they both are submitting data to the same variable, which is this:

$comments = db_prepare_input($_POST['comments']);

Now ive excluded most of the stuff here, if you need more let me know. But I have everything working except the text area field. if I select a canned response from the dropdown box it updates to the db fine. however if I enter data in to the text field. it isnt passed.

So I think what I need here is an if check box is checked, then process data from the dropdownbox, if not check then only process data from the text area field. Can anyone help me out?

Thanks a bunch to the one that can guide me through the steps.

Appreciate it greatly, and love this site.

[olaf]

Your problem sounds like a NULL problem...🙂

Check the attr. of your field in the datbase and convert the empty string in case of an empty value. I use just two single quotes for an empty string.

Of course you can check both entries like this:

if ($P_POST['comments'] != "" || isset($_POST['your_checkbox']) {
// insert into database
} else {
echo "hey do something...";
}

[Debar]

Can you walk me through this one mate.

I can't seem to get it to work. Heres the front side

<tr>
        		<td ><b><?php echo 'Process Order' ?></b></td><?php echo zen_draw_form('status', FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=update_order', 'post', '', true); ?>
      			<td ><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo zen_draw_checkbox_field('notify', '', true); ?> <b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo zen_draw_checkbox_field('notify_comments', '', true); ?></td>
           	  </tr>
			  <tr>
                <td class="main"><b><?php echo ENTRY_STATUS; ?></b></td><td><?php echo zen_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>
              </tr>
			<tr>
        <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
      </tr>




  <tr>
   <td class="main" valign="top"><b><?php echo 'Custom Response:'; ?></b> </td><td ><?php echo zen_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>
  </tr>
  <tr>
  <td colspan="2"><a href="support_responses.php">Create New Custom Response</a></td>
  </tr>




  <?php 

  $sql='select response_id, response_name, response_text from ' . TABLE_SUPPORT_RESPONSES .' order by response_name';
  $response_query=$db->Execute($sql);
  while (!$response_query->EOF){
    $response_array[]=array('id'=>$response_query->fields['response_text'], 
	                        'text'=>$response_query->fields['response_name']);

	$response_query->MoveNext();

  } //endwhile



  ?>

  <tr>


	<td class="main"><b><?php echo 'Use Custome Response' ?></b></td>

	<td><?php echo zen_draw_pull_down_menu('comments', $response_array); ?></td>
  </tr>

  <tr>
    <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
  </tr></form>

and heres php code that I have at the very top of the page.

<?php
  require('includes/application_top.php');

  require(DIR_WS_CLASSES . 'currencies.php');
  $currencies = new currencies();

  $orders_statuses = array();
  $orders_status_array = array();

  $orders_status = $db->Execute("select orders_status_id, orders_status_name
                                 from " . TABLE_ORDERS_STATUS . "
                                 where language_id = '" . (int)$_SESSION['languages_id'] . "'");



  while (!$orders_status->EOF) {
    $orders_statuses[] = array('id' => $orders_status->fields['orders_status_id'],
                               'text' => $orders_status->fields['orders_status_name'] . ' [' . $orders_status->fields['orders_status_id'] . ']');
    $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
    $orders_status->MoveNext();
  }

  $action = (isset($_GET['action']) ? $_GET['action'] : '');

  if (zen_not_null($action)) {
    switch ($action) {
      case 'update_order':
        // demo active test
        if (zen_admin_demo()) {
          $_GET['action']= '';
          $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
          zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
        }
        $oID = zen_db_prepare_input($_GET['oID']);
        $status = zen_db_prepare_input($_POST['status']);
		$comments = zen_db_prepare_input($_POST['comments']);


	$order_updated = false;
    $check_status = $db->Execute("select customers_name, customers_email_address, orders_status, 
                                  date_purchased from " . TABLE_ORDERS . "
                                  where orders_id = '" . (int)$oID . "'");

    if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
      $db->Execute("update " . TABLE_ORDERS . "
                    set orders_status = '" . zen_db_input($status) . "', last_modified = now()
                    where orders_id = '" . (int)$oID . "'");

      $customer_notified = '0';
      if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {
        $notify_comments = '';
        if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && zen_not_null($comments)) {
          $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n";
        }


//send emails
       $message = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" .
      EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
      EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
      EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
      strip_tags($notify_comments) .
      EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status]) . EMAIL_TEXT_STATUS_PLEASE_REPLY;

  $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
  $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
  $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'</a>';
  $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
  $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
  $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
  $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status]));
  $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
  $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');

        $customer_notified = '1';
//send extra emails
            if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
              zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
            }
          }

      $db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
                  (orders_id, orders_status_id, date_added, customer_notified, comments)
                  values ('" . (int)$oID . "',
                  '" . zen_db_input($status) . "',
                  now(),
                  '" . zen_db_input($customer_notified) . "',
                  '" . zen_db_input($comments)  . "')");

      $order_updated = true;
    }

    if ($order_updated == true) {
     if ($status == DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) {
        // adjust download_maxdays based on current date
        $zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

        $update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . (int)$oID . "'";
        $db->Execute($update_downloads_query);
      }
      $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
    } else {
      $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
    }

    zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
    break;
  case 'deleteconfirm':
    // demo active test
    if (zen_admin_demo()) {
      $_GET['action']= '';
      $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')), 'NONSSL'));
    }
    $oID = zen_db_prepare_input($_GET['oID']);

    zen_remove_order($oID, $_POST['restock']);

    zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')), 'NONSSL'));
    break;
}
  }

  if (($action == 'edit') && isset($_GET['oID'])) {
    $oID = zen_db_prepare_input($_GET['oID']);

$orders = $db->Execute("select orders_id from " . TABLE_ORDERS . "
                        where orders_id = '" . (int)$oID . "'");

$order_exists = true;
if ($orders->RecordCount() <= 0) {
  $order_exists = false;
  $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
}
  }

  include(DIR_WS_CLASSES . 'order.php');
?> 

I am definitly having troubles. every which way i try to insert the if statment, i just get a blank screen, dont know how im causing the error.

thanks so much man for taking the time out.

[Debar]

edited.