index.php File Reference

The Library staff's web frontend (entry page). More...

Go to the source code of this file.

Variables
	$lang = (isset($_GET['lang'])) ? $_GET['lang'] : $lang_default
	$text = $text_multi[$lang]
	$buttons = $buttons_multi[$lang]
	$months = $months_multi[$lang]
	$valid_params
	valid choices for parameters
	$default_params
	initialization values for parameters
	$default_sortkeys = array( 'last_name', 'first_name', 'birthday')
	$sort = $_SESSION['sort']
print	$text ['status']
	print
print	$text ['order']
	print
	print
	$link = mysql_pconnect($dbhost, $dbuser, $dbpass)) or db_error_mysql()
	$table_columns
	$q = "DELETE FROM persons WHERE persons.status='old'"
	$_SESSION ["button"] = ""
	$sortkeys = $_SESSION["sort"]
	$q = "SELECT id FROM persons WHERE status = "
	$q = "'" . $_SESSION["status"] . "' "
	$q = "ORDER BY $sortkeys"
	$res = db_query_mysql($link,$q, array())
print</th >	n
print< th > &	nbsp
</th > print</tr >	n
	$v = (isset($r[1][0])) ? $r[1][0] : ""
</td >	n
print< td >	$id = $row["id"]
print< ahref=\"action.php?&lang=$lang&action=show&id=".$id."\"> print	$text ['details']
print</td >	n
print</tr >	n

---

Detailed Description

The Library staff's web frontend (entry page).

Library staff has access to a web frontend that allows you to:

• list all applicants
• modify or delete applications
• submit the application to PICA, thereby creating a user account
• print a paper form that can be signed by the applicant

This is the entry page (index page) for this web frontend. It extracts all applicants' records from the database and displays them in a list.

Parameters:

	sort	primary key by which the list is sorted
	order	'ascending' or 'descending'
	status	'new' if we should display those records that have not yet been submitted to PICA, 'old' otherwise.
	button	whether the user has pressed a submit button (and which one)

Users may follow a hyperlink that points to action.php and produces a detailed view for that record.

Definition in file admin/index.php.

---

Variable Documentation

$valid_params

Initial value:

 array(
        "sort" => "/^(last_name|first_name|birthday|sex|entry_date)$/",
        "order"=> "/^(up|down)$/",
        "status" => "/^(new|old)$/",
        "button" => "/^(" . $buttons['delete_all'] . "|" .  $buttons['ok'] . "|" .
                            $buttons['cancel'] . "|)$/",
        "action"=> "/^(delete_all|)$/",
        "lang" => "/^(de|en)$/"
)

valid choices for parameters

This associative array is used as first parameter for the param_ok() function, and is used for validating user input that is delivered to the script via GET or POST request.

Definition at line 57 of file admin/index.php.

---