function editPage($id)
{
include_once 'login.php';
include_once 'database_conn.php';
include_once 'showEventFunction.php';
$pageHeader = "Event Edit Page";
$sql = "SELECT * FROM te_events WHERE eventID = {$id}";
$rslt = mysqli_query($conn, $sql) or die(mysqli_error($conn));
// error message return if return empty result
$row = mysqli_fetch_row($rslt);
$venues = getFromDb($conn, "SELECT * FROM te_venue");
$categories = getFromDb($conn, "SELECT * FROM te_category");
$output = "<h1>{$pageHeader}</h1>";
$i = 1;
$output .= "<form id=\"editForm\" action=\"handleEditPage.php\" method=\"post\">";
$output .= "<table border=0 >";
$output .= createRowData("Title", createTextField("title", $row[$i++]));
$output .= createRowData("Description", createTextArea("desc", $row[$i++], 5, 40));
$output .= createRowData("Venue Name", createCombobox("venue", $row[$i++], $venues));
$output .= createRowData("Category", createCombobox("category", $row[$i++], $categories));
$output .= createRowData("Start Time", createDate("startTime", $row[$i++]));
$output .= createRowData("End Time", createDate("endTime", $row[$i++]));
$output .= createRowData("Price", createTextField("price", $row[$i++]));
$output .= "<tr><td><input type=\"submit\" name=\"submit\" value=\"Submit\"></td></tr>";
$output .= "<input type=\"hidden\" name=\"e_id\" value=\"{$id}\">";
$output .= "</table></form>";
mysqli_free_result($rslt);
mysqli_close($conn);
return $output;
}
function generateRows($fields, $requirePost = false)
{
$generatedHtml = "";
foreach ($fields as $field => $typeArr) {
$type = $typeArr['type'];
$title = $typeArr['title'];
if (!$requirePost || $requirePost && isset($_POST[$field])) {
$generatedHtml .= createRow($title, createTextField($field, $type));
}
}
return $generatedHtml;
}
function searchPage()
{
include_once 'login.php';
include_once 'database_conn.php';
include_once 'showEventFunction.php';
$pageHeader = "Search Page";
$backURL = "<br/><a href = \"index.php\">Back to Home</a>";
$venues = getFromDb($conn, "SELECT * FROM te_venue");
$categories = getFromDb($conn, "SELECT * FROM te_category");
$output = "<h1>{$pageHeader}</h1>";
$output .= "<form id=\"searchForm\" action=\"handleSearchPage.php\" method=\"post\">";
$output .= "<table border=0 >";
$output .= createRowData("Title", createTextField("title", ""));
$output .= createRowData("Venue Name", createCombobox("venue", "", $venues));
$output .= createRowData("Category", createCombobox("category", "", $categories));
$output .= createRowData("Start Time", createDate("startTime", ""));
$output .= createRowData("End Time", createDate("endTime", ""));
$output .= createRowData("Price", createTextField("price", ""));
$output .= "<tr><td><input type=\"submit\" name=\"submit\" value=\"Search\"></td></tr>";
$output .= "</table></form>";
return $output . $backURL;
}
/**
* function to create an edited form with text fields retrieved
* from the database and check boxes to update a fire
* fighter's information to the database
*
* @return HTML the form to update a fire fighter with all his/her
* current credentials
*/
function createEditForm()
{
return '
<form method="post" action="editFirefighter.php?action=submit&id=' . $_GET[id] . '">
<h2>Edit Firefighter Credentials</h2>
<div class="row" style "text-align:center">' . createTextField("fname", "First Name", 256) . createTextField("lname", "Last name", 256) . createTextField("rank", "Firefighter Rank", 256) . '</div>
<div>
<label class="control-label" >Firefighter Credentials</label>' . createCheckBox("type", "Driver", "Driver") . createCheckBox("type", "EMS", "EMS") . createCheckBox("type", "Exterior", "Exterior") . createCheckBox("type", "Hazardous", "Hazardous") . createCheckBox("type", "Hurst Tools", "Hurst Tools") . createCheckBox("type", "Interior", "Interior") . createCheckBox("type", "Paramedic", "Paramedic") . createCheckBox("type", "Pump", "Pump Operator") . '<button type= "submit" class = "btn btn-success">Submit</button>
</div>';
}
function createFormElements($report_elements)
{
global $bDebug;
if (!is_array($report_elements)) {
return;
}
unset($form_elements);
foreach ($report_elements as $key => $value) {
$elemName = $key;
$elemLabel = $value["label"];
$elemType = $value["type"];
//$arr_params = Array("dbLink"=>get_db_connection(), "bDebug"=>$bDebug );
$arr_params = get_db_connection();
$elemValuesFunction = $value["values_func"];
if ($elemValuesFunction != NULL) {
$elemValues = @call_user_func_array($elemValuesFunction, $arr_params);
//log_err("elemValuesFunction : $elemValuesFunction");
} else {
$elemValues = $value["values"];
}
$elemDefault = $value["default"];
$elemRequired = $value["required"];
switch ($elemType) {
case "date":
$strControl = createDateControl("document._FRM", $elemName, $elemDefault, $elemRequired);
break;
case "select":
$strControl = createSelect($elemName, $elemValues, $elemDefault, $script, $class_style);
break;
case "multiselect":
$strControl = createMultipleSelect($elemName, $elemValues, $elemDefault, $script, $class_style);
break;
case "input":
$strControl = createTextField($elemName, $elemValues, $elemLabel, $class);
break;
case "checkbox":
$strControl = createCheckBox($elemName, $elemValues, $elemLabel, $elemDefault);
break;
default:
$strControl = "cant create control, elem type {$elemType} undefined.";
break;
}
$form_elements[] = array("label" => $elemLabel, "required" => $elemRequired, "control" => $strControl);
}
return $form_elements;
}
function createLoginForm()
{
$formName = htmlspecialchars($_SERVER["PHP_SELF"]);
//$formName
echo "<div id=\"loginForm\"><form method=\"post\" action=\"#\">" . "<div>Username: "******"username", "") . "Password: "******"password", "") . "<input type=\"submit\" name=\"loginBtn\" value=\"Login\"></input></div>\n\t\t</form></div>\n\t\t";
createTextField("username", "");
createTextField("password", "");
}
