fields.php File Reference

Access an applicant's record in the database. More...

Go to the source code of this file.

Functions
	fields_init ($link, $lang)
	initialize the $fields[] array
	input_control ($field, $name, $value)
	delivers HTML code of an input control for $field
Variables
	$fields
	describes how to access record fields in the database

---

Detailed Description

Access an applicant's record in the database.

Definition in file fields.php.

---

Function Documentation

fields_init	(	$	link,
		$	lang
	)

initialize the $fields[] array

This function must be called before $fields[] can be accessed.

Parameters:

$link

an open handle to the MySQL database

Returns:

nothing

Definition at line 392 of file fields.php.

References $field_labels, $fields, $lang, $link, $q, $text_multi, $v, and db_query_mysql().

                                   {
        global $field_labels, $fields, $text_multi;

        $q  = "select usertype_names.usertype_id, usertype_names.name " 
            . "from usertype_names where "
            . "usertype_names.type = 'u' and usertype_names.lang='@lang@'";

        $result = db_query_mysql($link, $q, array("@lang@" => $lang));

        foreach ($result as $row) 
                $fields["usertype"]["choices"][$row["usertype_id"]] = 
                        $row["name"];

        foreach ($fields as $k => $v) {
                if (!isset($v['pica_query']))
                        $fields[$k]['pica_query'] = $v['query'];

                if (!isset($v['view_query']))
                        $fields[$k]['view_query'] = $v['query'];
        }

        ## assign field labels

        foreach ($field_labels[$lang] as $k => $v) {
                $fields[$k]['label'] = $v;
        }

        $fields['sex']['choices'] = array();

        $fields['sex']['choices']['m'] = $text_multi[$lang]['sex_m'];
        $fields['sex']['choices']['w'] = $text_multi[$lang]['sex_w'];
}

Here is the call graph for this function:

input_control	(	$	field,
		$	name,
		$	value
	)

delivers HTML code of an input control for $field

This function delivers HTML code suitable for embedding into HTML forms for editing database records.

Parameters:

	$link	an open handle to the MySQL database
	$field	an index into the $fields[] array
	$name	name of the input control
	$value	initial value of the input control

Returns:

HTML code

Definition at line 437 of file fields.php.

References $f, $fields, $months, $v, nbsp, and print.

Referenced by print_table().

                                              {
        global $fields;
        
        if (isset($fields[$field])) {
                $f = $fields[$field];

        if ($f["type"] == "text") {

                print '<input type="text" name="' . $name . '" ';
                print 'value="' . htmlentities($value) . '" ';
                print 'size="' . $f["size"] . '" ';
                print 'maxlength="' . $f["size"] . '" >';

        } else if ($f["type"] == "choice") {
                
                print '<select name="' . $name . '">';
                foreach ($f["choices"] as $k => $v) {
                        print '<option value="' . htmlentities($k) . '"';
                        if ($k == $value) 
                                print ' selected="yes" ';
                        print '>';
                        print htmlentities($v);
                        print '</option>';
                }
                print '</select>';
        } else if ($f["type"] == "date") {
                global $months;

                list($year, $month, $day) = split('-', $value,3); 

                print '<input type="text" name="' . $name . '_day" ';
                print 'size="2" maxlength="2" value="' . $day . '"> &nbsp;';

                print '<select name="' . $name . '_month">';
                foreach ($months as $k => $v) {
                        print '<option value="' . htmlentities($k) . '"';
                        if ($k == $month) 
                                print ' selected="yes" ';
                        print '>';
                        print htmlentities($v);
                        print '</option>';
                }
                print '</select>';

                print '&nbsp; <input type="text" name="' . $name . '_year" ';
                print 'size="4" maxlength="4" value="' . $year . '">';
                
        }

        }
        
}

Here is the caller graph for this function:

---

Variable Documentation

$fields

describes how to access record fields in the database

The $fields[] array contains information about how to query and change the value of record fields in the database.

Each element is an array representing a field in a database record. The sub-array consists of the following fields:

label

a human-readable description of the field's meaning

type

'text', 'choice', or 'date'

size

maximum length of input field (for "text" only)

choices

an array that contains the valid choices for the select list

valid

user's input is considered valid if it matches this regexp

query

sql query for retrieving the value of the field

update

sql query for modifying the value of the field

pica_query

sql query for retrieving the value of the field in the context of creating a PICA export record

view_query

sql query for displaying the value of the field

pica_field

corresponding field number in the PICA export record

Definition at line 47 of file fields.php.

Referenced by check_for_doubles(), export_to_pica(), fields_init(), input_control(), and print_table().

---