1#@!#!123s

: / home / u935876328 / domains / ggcp.org.in / public_html / admin /
Filename : eventManagement.php
back
	<?php
	include('config.php');
	include('header.php');

	$msg = "";
	$homeFile = "upload/home/";

	if(isset($_POST['eventDelete'])){
		$id = $_POST['id'];
		$sql = "DELETE FROM event_tbl WHERE id='$id'";
		$result = $db->query($sql);
	}

	if (isset($_POST['event'])) {

		$name = $_POST["name"];
		$desc = $_POST["desc"];
		$date = $_POST["date"];

		mysqli_query($db, "INSERT INTO event_tbl (event_name,event_desc,event_date) VALUES (\"$name\",\"$desc\",\"$date\")");
	}

	if (isset($_POST['eventEdit'])) {

		$id = $_POST["id"];
		$name = $_POST["name"];
		$desc = $_POST["desc"];
		$date = $_POST["date"];

		mysqli_query($db, "UPDATE event_tbl set event_name = \"$name\" , event_desc = \"$desc\", event_date =  \"$date\" where id = \"$id\"");
	}

	if(isset($_POST['eventUpcomingDelete'])){
		$id = $_POST['id'];
		$sql = "DELETE FROM event_upcoming_tbl WHERE id='$id'";
		$result = $db->query($sql);
	}

	if (isset($_POST['eventUpcoming'])) {
		$name = $_POST["name"];
		$time = $_POST["time"];
		$date = $_POST["date"];
		$address = $_POST["address"];

		mysqli_query($db, "INSERT INTO event_upcoming_tbl (event_name,event_date,event_time,event_address) VALUES (\"$name\",\"$date\",\"$time\",\"$address\")");
	}

	if (isset($_POST['eventUpcomingEdit'])) {

		$id = $_POST["id"];
		$name = $_POST["name"];
		$time = $_POST["time"];
		$date = $_POST["date"];
		$address = $_POST["address"];

		mysqli_query($db, "UPDATE event_upcoming_tbl set event_name = \"$name\" , event_time = \"$time\", event_date =  \"$date\", event_address =  \"$address\" where id = \"$id\"");
	}

	?>

	<!DOCTYPE html>
	<html>

	<body>
		<!-- End Navbar -->
		<div class="content">
			<div class="container-fluid">
			<h2>Event Management</h2>

				
			<div class="row">
					<div class="col-md-12">
						<div class="card">
							<div class="card-header card-header-primary" style="background: #0A5788;">
								<h4 class="card-title">Upcoming Event Management</h4>
								<p class="card-category">Add Or Update Upcoming Event !!!</p>
							</div>
							<div class="card-body">
								<div class="row">
									<div class="col-md-5 col-sm-12 col-xs-12">
										<form method="POST" action="">
											<div class="row">
												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Name</label>
															<input type="text" name="name" class="form-control" required>
													</div>
												</div>

												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Date</label>
															<input type="text" name="date" class="form-control" required>
													</div>
												</div>

												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Time</label>
															<input type="text" name="time" class="form-control" required>
													</div>
												</div>
											
												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Address</label>
															<input type="text" name="address" class="form-control" required>
													</div>
												</div>
												<div class="col-md-12 col-sm-12 col-xs-12">
													<button type="submit" name="eventUpcoming" class="btn btn-primary btn-sm btn-block waves-effect text-center m-b-20">SAVE</button>
												</div>

											</div>
										</form>
									</div>

									<div class="col-md-7 col-sm-12 col-xs-12">
										<table class="table table-bordered">
											<tr>
												<th>Name</th>
												<th>Date</th>
												<th>Time</th>
												<th>Address</th>
												<th>Action</th>
											</tr>
											<?php
											$eventSql = mysqli_query($db, "SELECT * FROM event_upcoming_tbl order by id DESC");
											$arr_event = $eventSql->fetch_all(MYSQLI_ASSOC);
												if (!empty($arr_event)){ 
												foreach ($arr_event as $column) {	
											?>
											<tr>
												<td><?php echo  $column['event_name'] ?></td>
												<td style="white-space: pre-wrap;"><?php echo  $column['event_date'] ?></td>
												<td style="white-space: pre-wrap;"><?php echo  $column['event_time'] ?></td>
												<td style="white-space: pre-wrap;"><?php echo  $column['event_address'] ?></td>
												<td style="width: 20%;">
												<form method="post" action="">
													<input type="hidden" name="id" value="<?php echo $column['id']; ?>">
													<input name="eventUpcomingDelete" type="submit" value="Delete" class="btn btn-danger btn-sm btn-block waves-effect text-center" />
												</form>
												<form method="post" action="eventUpcomingEdit.php">
													<input type="hidden" name="id" value="<?php echo $column['id']; ?>">
													<input name="eventUpcomingEditPass" type="submit" value="Edit" class="btn btn-primary btn-sm btn-block waves-effect text-center" />
												</form>
												</td>
											<?php
											}}
											?>
										</table>
									</div>

								</div>
							</div>
						</div>
					</div>
				</div>
		
				<div class="row">
					<div class="col-md-12">
						<div class="card">
							<div class="card-header card-header-primary" style="background: #0A5788;">
								<h4 class="card-title">Event Management</h4>
								<p class="card-category">Add Or Update Event !!!</p>
							</div>
							<div class="card-body">
								<div class="row">
									<div class="col-md-5 col-sm-12 col-xs-12">
										<form method="POST" action="">
											<div class="row">
												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Name</label>
															<input type="text" name="name" class="form-control" required>
													</div>
												</div>

												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Date</label>
															<input type="text" name="date" class="form-control" required>
													</div>
												</div>
											
												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Event Description</label>
															<textarea name="desc" class="form-control" rows="5"></textarea>
													</div>
												</div>
												<div class="col-md-12 col-sm-12 col-xs-12">
													<button type="submit" name="event" class="btn btn-primary btn-sm btn-block waves-effect text-center m-b-20">SAVE</button>
												</div>

											</div>
										</form>
									</div>

									<div class="col-md-7 col-sm-12 col-xs-12">
										<table class="table table-bordered">
											<tr>
												<th>Name</th>
												<th>Date</th>
												<th>Description</th>
												<th>Action</th>
											</tr>
											<?php
											$eventSql = mysqli_query($db, "SELECT * FROM event_tbl order by id DESC");
											$arr_event = $eventSql->fetch_all(MYSQLI_ASSOC);
												if (!empty($arr_event)){ 
												foreach ($arr_event as $column) {	
											?>
											<tr>
												<td><?php echo  $column['event_name'] ?></td>
												<td style="white-space: pre-wrap;"><?php echo  $column['event_date'] ?></td>
												<td style="white-space: pre-wrap;"><?php echo  $column['event_desc'] ?></td>
												<td style="width: 20%;">
												<form method="post" action="">
													<input type="hidden" name="id" value="<?php echo $column['id']; ?>">
													<input name="eventDelete" type="submit" value="Delete" class="btn btn-danger btn-sm btn-block waves-effect text-center" />
												</form>
												<form method="post" action="eventEdit.php">
													<input type="hidden" name="id" value="<?php echo $column['id']; ?>">
													<input name="eventEditPass" type="submit" value="Edit" class="btn btn-primary btn-sm btn-block waves-effect text-center" />
												</form>
												<form method="post" action="eventPhotos.php">
													<input type="hidden" name="event_id" value="<?php echo $column['id']; ?>">
													<input name="eventPhotos" type="submit" value="Photos" class="btn btn-sucess btn-sm btn-block waves-effect text-center" />
												</form>
												</td>
											<?php
											}}
											?>
										</table>
									</div>

								</div>
							</div>
						</div>
					</div>
				</div>

			</div>
		</div>

	

		</div>

		<?php
		include('footer.php');
		?>