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", ""); }