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;
}
<input type="checkbox" name="commentsEnabled" id="commentsEnabled" value="1" <?php
echo $thisPilot->commentsEnabled ? 'checked' : '';
?>
/>
</label>
<?php
require_once dirname(__FILE__) . '/FN_editor.php';
if (L_auth::isModerator($userID)) {
$toolbar = 'Leonardo';
$allowUploads = false;
} else {
$toolbar = 'LeonardoSimple';
$allowUploads = false;
}
createTextArea($flight->userServerID, $flight->userID, 'comments', $flight->comments, 'flight_comments', $toolbar, $allowUploads, 700, 200);
?>
</td>
</tr>
<tr>
<td><div align="right" class="styleItalic"><?php
echo _RELEVANT_PAGE;
?>
</div></td>
<td colspan="3">
http://<input name="linkURL" type="text" id="linkURL" size="50" value=""> </td>
</tr>
<?php
for ($i = 0; $i < $CONF_photosPerFlight; $i++) {
echo $area->desc;
?>
"/>
<?php
}
?>
</td>
</tr>
<tr>
<td>Description (in english) </td>
<td>
<?php
if ($areaAction != 'Delete') {
require_once dirname(__FILE__) . '/FN_editor.php';
createTextArea(0, 0, 'descInt', $area->descInt, 'takeoff_description', 'Leonardo', true, 710, 600);
} else {
?>
<input type="text" name="descInt" size="40" value="<?php
echo $area->desc;
?>
"/>
<?php
}
?>
</td>
</tr>
<tr>
<td>Min Latitude </td>
echo $waypt->link;
?>
" size="60" >
<input type="submit" name="Submit2" value="<?php
echo "APPLY CHANGES";
?>
" />
</font></td>
</tr>
<tr>
<td colspan="4" bgcolor="#E7E6CB"><div align="center"><strong><font color="#003366">Description</font></strong></div></td>
</tr>
<tr>
<td colspan="4" valign="top" bgcolor="#CFE2CF">
<?php
createTextArea(0, 0, 'description', $waypt->description, 'takeoff_description', 'Leonardo', true, 710, 400);
?>
</td>
</tr>
<tr>
<td colspan="4"><div align="right"></div>
<div align="center">
<input type="submit" name="Submit" value="<?php
echo "APPLY CHANGES";
?>
">
<input type="hidden" name="editWaypoint" value="1">
</div></td>
</tr>
</table>
