Subversion Repositories phpLibraryV2

      /* the first returned column becomes the value, the second becomes the display element

       * 'query' - An SQL query to run. Should return 2 columns; first is value, second id display

         if $selectedFieldsQuery is begins with 'select', items matching that query will be selected

       * 'selected' - key in 'data' or result of 'query' which will be selected

         if  $selectedFieldsQuery is any other value, it is assumed to be the value of the first column

       * 'nullok' - adds a entry at top with value of -1 and display of three dashes (---)

      */

      function htmlSelect ( $selectedFieldsQuery = '' ) {

         if ( empty( $parameters['data'] ) ) {

         $html = '';

            if ( empty( $paramters['query'] ) )

         $selectedFields = array();

               return '';

         if (strlen( $selectedFieldsQuery )) {

            $save = $this->useAssociativeArray;

            if (  preg_match ( '/^\s*select/i', $selectedFieldsQuery ) ) { // They passed in a query

            $useAssociativeArray = false; // temporarily turn off associative arrays

               if (strlen($selectedFieldsQuery) ) {

            $this->query( $parameters['query'] );

                  $subSet = new DBQuery($selectedFieldsQuery);

            if ( $this->rowsAffected ) { // we returned at least one row

                  $subSet->run();

               foreach ($this->returnData as $rowNumber => $value ) {

                  $selectedFields = $subSet->sqlValuesToKeys();

                  $parameters['data'][$value[0]] = $value[1];

         $save = $this->useAssociativeArray;

         $options = array();

         $useAssociativeArray = false; // temporarily turn off associative arrays

            $options[] = '<option value="-1">---</option>';

         $this->run();

         }

         if ( $this->rowsAffected ) { // we returned at least one row

         foreach ( $parameters['data'] as $key => $value ) {

            foreach ($this->returnData as $rowNumber => $value ) {

            $options[] = sprintf( 

               $html .= '<option value="' . $value[0] . '"';

               '<option value="%s"%s>%s</option>',

               if ( $selectedFields[$value[0]] ) {

               $key == $selectedKey ? ' selected' : '',

                  $html .= ' selected';

               $value

               }

               );

               $html .= '>' . $value[1] . '</option>';

         $return = implode( "\n", $options );

         return $html;

         return $return;

      /* function will take a query and turn it into a series of check boxes. It must contain

       * Create an HTML checkbox block from a query, or array of data passed in

         two columns, with the first becoming the the name of the checkbox

       * if $parameters['data'] is set, no further query is used. $parameters['data']

         and the second becoming the displayed value. an optional third column will be used

       * should contain an array of data. Each row in that array should be another 

         to match if the $checkedValuesQuery is used.

       * array with keys 

         if $checkedValuesQuery is not empty, it will be run to see what boxes need to be

       *    'id' -- 'id' and 'name' of the checkbox

         checked by being compared to the third column of the $sql query.

       *    'name' -- display name of the checkbox

         $htmlBefore will be placed before each check box, and $htmlAfter will be placed after

       *    'checked' -- boolean (or 0/1) saying whether this has a check

       * 

         will have <td> prepended and $htmlAfter will have </td> appended, meaning any passed

       * of $parameters['data'] is not set and $parameters['query'] is set

         values will be INSIDE of the td. NOTE: the <table></table> tags are NOT put in.

       * the query will be run. It MUST contain the column names listed above.

       * 

         the number of elements equal the number of columns.

       * Processing will then continue

         if ($table_columns) {

      function htmlCheckBoxes ( $parameters ) {

            $htmlBefore = '<td>' . $htmlBefore;

         if ( empty( $parameters['template'] ) ) { // they did not send us a template

            $htmlAfter .= '</td>';

            $parameters['template'] = "<input type='checkbox' id='~~id~~' name='~~name~~' ~~checked~~>\n<label for='~~id~~'>~~name~~</label>\n";

         }

         }

         $checkBoxes = queryDatabaseExtended( $sql,0 );

         //print "<pre>" . print_r($parameters, true) . "</pre>"; die;

         if (strlen($checkedValuesQuery) ) {

         if ( empty( $parameters['data'] ) ) {

            $subSet = new DBQuery($selectedFieldsQuery);

            if ( empty( $parameters['query'] ) )

            $subSet->run();

               return '';

         $save = $this->useAssociativeArray;

            $save = $this->useAssociativeArray;

         $useAssociativeArray = false; // temporarily turn off associative arrays

            $useAssociativeArray = false; // temporarily turn off associative arrays

         foreach ($this->returnData as $row => $values) {

            $this->doSQL( $parameters['query'] );

            if ($table_columns && ++$numColumns == $table_columns) {

            if ( $this->rowsAffected ) { // we returned at least one row

               $html .= '</tr><tr>';

               foreach ($this->returnData as $rowNumber => $value ) {

               $numColumns = 0;

                  $parameters['data'][] = $value;

            }

               }

            $html .= '>' . $values[1] . $htmlAfter;

               'name' => $value['name'], 

            //<INPUT type="checkbox" checked name="temp">

               'checked' => $value['checked'] ? 'checked' : ''

         } // foreach

               );

         $html .= '</tr>';

         return implode( '', $html );

         $useAssociativeArray = $save;

       * replaced, for example

         return $html;

         return $template;