Subversion Repositories php_library

<?php

/*
   Copyright 2006
   Daily Data, Inc.
   All rights reserved
   Name: $Id: contact_us_lib.php,v 1.7 2006/11/30 03:58:26 rodolico Exp $
   Description:
      Set of library script for contact_us.php

   $Date: 2006/11/30 03:58:26 $
   $Revision: 1.7 $
   Revision History:
      $Log: contact_us_lib.php,v $
      Revision 1.7  2006/11/30 03:58:26  rodolico
      Beginning work on connection to payment center. Still needs a little work


*/

define (VERSION, '1.1');

function verifyForm( $fields ) {
   $fieldCount = 0;
   $valid = true;
   foreach ( $fields as $field => $value ) { // scan each field for required
      $fieldCount += strlen($_POST[$value['varname']]); // ensure at least one field has a value
      if ($value['required'] === true && strlen( $_POST[$value['varname']] ) == 0 ) {
         $valid = false;
      } // if
   } // foreach
   return ($fieldCount > 0 && $valid);
}

function sendMessage( $categories, $fields ) {
   $values = getCategoryInfo(escapeshellcmd($_POST['category']), $categories, $fields );
   $subject = $values[0] or DEFAULT_SUBJECT;
   $to_email = $values[1] or DEFAULT_EMAIL;
   $message = str_repeat('-', 40) . "\n";
   foreach ($fields as $field => $value ) { // look through the outer array, determining sort order
      $message .= $value['title'] . ' -- ';
      if ( $value['type'] == 'textarea' ) { $message .= "\n";}
      $message .= $_POST[$value['varname']] . "\n" . str_repeat("-", 40) . "\n";
   }
   $from = escapeshellcmd($_POST['email']) or DEFAULT_FROM;
   //$message = "To: $to_email\nFrom: $from\nSubject: $subject\n" . $message;
   //print "<pre>$message</pre>\n";
   return mail ( $to_email, $subject, $message, "From: $from" );
}

   function makeSafeSQLValue ( $value, $type='S' ) {
      if(get_magic_quotes_gpc()) {
           $value = stripslashes($value);
       }
      $value = mysql_real_escape_string( $value );
      if (($type == 'S') and strlen($value)  > 0) { // put quotes around strings
         $value = "'" . $value . "'";
      } elseif (strlen($value) == 0) { // and substitue null for empty values otherwise;
         $value = 'null';
      }
      return $value;
   }


   function storeMessage ( $categories, $fields ) {
      mysql_connect("localhost", DB_USERNAME, DB_PASSWORD) or die(mysql_error());
      mysql_select_db(DATABASE) or die(mysql_error());
      $fieldnames = array();
      $formValues = array();
      foreach ($fields as $field => $value ) { // look through the outer array, determining sort order
         $fieldnames[] =  $value['varname'];
         $formValues[] .= makeSafeSQLValue($_POST[$value['varname']]);
      }
      $sql = 'insert into ' . DB_TABLE . ' (' .  implode(',', $fieldnames) . ') values (' . implode(',', $formValues) . ')';
      mysql_query($sql) or die ('MYSQL ERROR #'.mysql_errno().' : <small>' . mysql_error(). "</small><br><VAR>$sql</VAR>");
   } // function storeMessage


function makeForm ($form, $maxDisplayWidth ) {
   $result = '';
   foreach ($form as $field => $value ) { // look through the outer array, determining sort order
      $result .= '<tr><td>' . $value['title'];
      if ($value['required'] == 1) {
         $result .= ' *';
      }
      $result .= '</td><td>';
      if ( $value['type'] == 'textarea' ) {
         $result .= "<textarea name='" . $value['varname'] . "' ";
         $result .= "cols='" . ( $value['columns'] ? $value['columns'] : $maxDisplayWidth ) . "' ";
         $result .= "rows='" . ( $value['rows'] ? $value['rows'] : 10 ) . "' ";
         $result .= "class='" . ( $value['class'] ? $value['class'] : 'text-area' ) . "'";
         $result .= '>' . $_POST[$value['varname']] . '</textarea>';
      } else {
         $result .= "<input type='text' name='";
         $result .= $value['varname'] . "' ";
         if ($value['max length']) {
            $result .= "maxlength='" . $value['max length'] . "' ";
            $result .= "size='" . ($value['size'] ? $value['size'] : min($value['max length'], $maxDisplayWidth) ) . "' ";
         } else {
            $result .= "size='" . ($value['size'] ? $value['size'] :  $maxDisplayWidth ) . "' ";
         }
         $result .= "class='" . ( $value['class'] ? $value['class'] : 'text-field' ) . "'";
         $result .= "value='". $_POST[$value['varname']] . "'>";
      } // else
      $result .= "</td></tr>\n";
   } // foreach
   return $result;
} // makeForm

function getCategoryInfo( $categoryCode, $categories ) {
   return array(
                strlen($categories[$categoryCode]['subject']) ? $categories[$categoryCode]['subject'] : $categories[$categoryCode]['title'],
                $categories[$categoryCode]['email']
               );
} // getCategoryInfo

function getAvailableCategoryList( $categories ) {
   $returnValue = '';
  foreach ($categories as $field => $value ) { // look through the outer array, determining sort order
      $returnValue .= "<option value=$field>" . $value['title'] . '</option>' . "\n";
   }
   return $returnValue;
}

?>