Добавить описание события в админку и базу
Добрый день! На сайте есть календарь событий, в админке редактируется по ссылке event.php: Изображение: https://i.ibb.co/6Y3CW3X/Untitled-1.jpg (https://ibb.co/wy9mz9c) Вот код файла event.php PHP:
Добрый день!
На сайте есть календарь событий, в админке редактируется по ссылке event.php:
Вот код файла event.php
Помогите, пожалуйста, добавить поле header, куда можно добавить описание события с использованием html-кода, а также какие поля нужно добавить в базу данных.
На сайте есть календарь событий, в админке редактируется по ссылке event.php:
Вот код файла event.php
PHP код:
<?php
define('IN_VCARD', true);
define('CURR_FILE','event.php');
include('./lib.inc.php');
// ############################# DB ACTION #############################
if ($action == 'update')
{
$event_dayend = ($event_dayend=='')? $event_day : $event_dayend;
$event_dayend = ($event_dayend < $event_day)? $event_day : $event_dayend;
$event_dayend = (strlen($event_dayend)<2)? '0'.$event_dayend : $event_dayend ;
$event_day = (strlen($event_day)<2)? '0'.$event_day : $event_day ;
$event_month = (strlen($event_month)<2)? '0'.$event_month : $event_month;
$sql = " UPDATE ". TBL_EVENTS ." SET event_day='". addslashes($event_day) ."', event_dayend='". addslashes($event_dayend) ."', event_month='". addslashes($event_month) ."', event_name='". addslashes($event_name) ."', event_active='". addslashes($event_active) ."' WHERE event_id='". addslashes($event_id) ."' ";
$DB_site->query($sql);
result_redirect(CURR_FILE,$action);
}
if ($action == 'delete')
{
message_confirm(ACTION_DELETE,array('event_id'=>$event_id));
}
if ($action == 'delete2' && ($curr_cp_user***91;'superuser'***93;==1 || $curr_cp_user***91;'candeleteevent'***93;==1))
{
$sql = " DELETE FROM ". TBL_EVENTS ." WHERE event_id='$event_id' ";
$DB_site->query($sql);
result_redirect(CURR_FILE,$action);
}
if ($action == 'active')
{
$sql = " UPDATE ". TBL_EVENTS ." SET event_active='1' WHERE event_id='$event_id' ";
$DB_site->query($sql);
result_redirect(CURR_FILE,$action);
}
if ($action == 'deactive')
{
$sql = " UPDATE ". TBL_EVENTS ." SET event_active='0' WHERE event_id='$event_id' ";
$DB_site->query($sql);
result_redirect(CURR_FILE,$action);
}
if ($action == 'insert')
{
// check if is a valide data
if (empty($event_name))
{
message_die(GENERAL_ERROR, $msg***91;'a_event'***93; ." ". $msg***91;'a_error_empty_form_field'***93;);
}
$event_dayend = ($event_dayend=='')? $event_day : $event_dayend;
$event_dayend = ($event_dayend < $event_day)? $event_day : $event_dayend;
$event_dayend = (strlen($event_dayend)<2)? '0'.$event_dayend : $event_dayend;
$event_day = (strlen($event_day)<2)? '0'.$event_day : $event_day;
$event_month = (strlen($event_month)<2)? '0'.$event_month : $event_month;
$sql = " INSERT INTO ". TBL_EVENTS ." ( event_id, event_day, event_dayend, event_month, event_name, event_active ) VALUES (NULL, '". addslashes($event_day) ."', '". addslashes($event_dayend) ."', '". addslashes($event_month) ."', '". addslashes($event_name) ."', '". addslashes($event_active) ."' ) ";
$DB_site->query($sql);
result_redirect(CURR_FILE.'?action=add',$action);
}
include(VCARD_ROOT_PATH.'include/admin_header.inc.php');
// ############################# SCREENS #############################
if ($action == 'edit')
{
$sql = " SELECT * FROM ". TBL_EVENTS ." WHERE event_id='$event_id' ";
$row = $DB_site->query_first($sql);
$options = array();
for ($i=1; $i<32; $i++)
{
$options***91;$i***93; = $i;
}
$HTML_site->form_header(CURR_FILE,'update');
$HTML_site->table_header($msg***91;'a_edit'***93;);
$HTML_site->form_hidden("event_id",$row***91;'event_id'***93;);
$HTML_site->form_input($msg***91;'a_name'***93;,"event_name",$row***91;'event_name'***93;);
$HTML_site->form_select($msg***91;'a_start'***93; ." ". $msg***91;'a_day'***93;,'event_day',$options,$row***91;'event_day'***93;);
$HTML_site->form_select($msg***91;'a_end'***93; ." ". $msg***91;'a_day'***93;,'event_dayend',$options,$row***91;'event_dayend'***93;);
$HTML_site->form_select($msg***91;'a_month'***93;,'event_month',$msg***91;'a_month_names'***93;,$row***91;'event_month'***93;);
$HTML_site->form_yesno($msg***91;'a_active'***93;,'event_active',$row***91;'event_active'***93;);
$HTML_site->form_footer($msg***91;'a_update'***93;);
}
if ($action == 'add')
{
$options = array();
for ($i=1; $i<32; $i++)
{
$options***91;$i***93; = $i;
}
$row = array();
$HTML_site->form_header(CURR_FILE,'insert');
$HTML_site->table_header($msg***91;'a_add'***93;);
$HTML_site->form_hidden("event_id",$row***91;'event_id'***93;);
$HTML_site->form_input($msg***91;'a_name'***93;,"event_name",$row***91;'event_name'***93;);
$HTML_site->form_select($msg***91;'a_start'***93; ." ". $msg***91;'a_day'***93;,'event_day',$options,$row***91;'event_day'***93;);
$HTML_site->form_select($msg***91;'a_end'***93; ." ". $msg***91;'a_day'***93;,'event_dayend',$options,$row***91;'event_dayend'***93;);
$HTML_site->form_select($msg***91;'a_month'***93;,'event_month',$msg***91;'a_month_names'***93;,$row***91;'event_month'***93;);
$HTML_site->form_yesno($msg***91;'a_active'***93;,'event_active',$row***91;'event_active'***93;);
$HTML_site->form_footer($msg***91;'a_add'***93;);
}
if (empty($action))
{
$HTML_site->table_header($msg***91;'a_edit'***93;);
$sql = " SELECT * FROM ". TBL_EVENTS ." ORDER BY event_month,event_day ASC ";
$data_arr = $DB_site->query($sql);
while ($row = $DB_site->fetch_array($data_arr))
{
$row***91;'event_name'***93; = stripslashes(my_htmlspecialchars($row***91;'event_name'***93;));
$_html .= "<tr class='". $HTML_site->get_row_bg() ."'><td>". get_monthname($row***91;'event_month'***93;) ."</td>
<td>". $row***91;'event_day'***93; ." </td>
<td>". $row***91;'event_dayend'***93; ." </td>
<td><b>". $row***91;'event_name'***93; ."</b> ".
"</td><td>".
( ($curr_cp_user***91;'superuser'***93;==1 || $curr_cp_user***91;'caneditevent'***93;==1)?"<a href='". CURR_FILE ."?action=edit&event_id=". $row***91;'event_id'***93; . "&s=$s'>***91;". $msg***91;'a_edit'***93; ."***93;</a> ": '' ).
( ($row***91;'event_active'***93;==1)? "<a href='". CURR_FILE ."?action=deactive&event_id=". $row***91;'event_id'***93; . "&s=$s'>***91;". $msg***91;'a_deactive'***93; ."***93;</a> " : "<a href='". CURR_FILE ."?action=active&event_id=". $row***91;'event_id'***93; . "&s=$s'>***91;". $msg***91;'a_active'***93; ."***93;</a> " ) .
( ($curr_cp_user***91;'superuser'***93;==1 || $curr_cp_user***91;'candeleteevent'***93;==1)? "<a href='". CURR_FILE ."?action=delete&event_id=". $row***91;'event_id'***93; . "&s=$s'>***91;". $msg***91;'a_delete'***93; ."***93;</a> " : '' ).
"</td></tr>\n";
}
$DB_site->free_result($data_arr);
$_html = "<table>" . $_html . "</table>";
$HTML_site->form_row($msg***91;'a_event'***93;,$_html);
$HTML_site->table_footer();
}
include(VCARD_ROOT_PATH.'include/admin_footer.inc.php');
?>