Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory :  /home/u615232177/public_html/admin5352/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']); 
include("headerstrict.php"); ?>
<title><?php echo $company_name; ?>, Admin, Annoucements</title>
<?php
if (isset($_POST['add_announcement'])) {
	
	$paragraph = mysqli_real_escape_string($con,$_POST['paragraph']);
			
	$db_id=0;
	$stmt = $con -> prepare('INSERT INTO announcements VALUES (?,?)');
	$stmt -> bind_param('is', $db_id,$paragraph);
	$stmt -> execute();
	 
		//create a session to verify it's coming from here
		$_SESSION["action"] = "true";
		$message="Item successfully added.";
		echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
	
}
?>

<!-- ======= Breadcrumbs ======= -->
<section id="breadcrumbs" class="breadcrumbs">
  <div class="container"> </div>
</section>
<!-- End Breadcrumbs -->
<!-- ======= Contact Section ======= -->
<section id="contact" class="contact inner-page">
	<div class="container" data-aos="fade-up">

	<div class="section-title">
		<h2>Annoucements</h2>
		<p>Add announcements to the top bar</p>
	</div>

        <div class="row">

          <div class="col-lg-6 mt-5 mt-lg-0 d-flex align-items-stretch">
      <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="post" class="php-email-form1" enctype='multipart/form-data'>
			<div class='validate'></div>
              
			  <div class="form-row">
          <div class="form-group col-md-12">
						<input type="text" name="paragraph" class="form-control" placeholder="Annoucement" required /> 
          </div>       
        </div>
        <div class="text-center">
					<button type="submit" name='add_announcement'>Save</button>
			  </div>
      </form>
          </div>
		  <div class="col-lg-6 d-flex align-items-stretch">
            
          </div>

        </div><!-- end row -->
		<br/></br>

	<div class="section-title">
		<h2>Uploaded Annoucements</h2>
		<p></p>
	</div>

	<div class='row'>
	<?php
	$stmt = $con -> prepare('SELECT * FROM announcements'); 
	$stmt -> execute(); 
	$stmt -> store_result(); 
	$stmt -> bind_result($id,$top_paragraph); 
	$numrows = $stmt -> num_rows();
	if($numrows > 0){
		while ($stmt -> fetch()) { 
		echo"			
		<div class='col-md-4'>
		<form action='";?><?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?><?php echo"' method='post'class='php-email-form1'enctype='multipart/form-data'>
			
			<div class='form-row'>
				<div class='form-group col-md-12'>
					<textarea name='top_paragraph' class='form-control' placeholder='Annoucement'>$top_paragraph</textarea>
                </div>
            </div>

			<div class='text-center'>
				<button type='submit' name='update$id'>Update</button>
				<button type='submit' name='delete$id'>Delete</button>
			</div>
		
		</form>
		</div>
		
		";
		if (isset($_POST["update$id"])) {

			$top_paragraph = mysqli_real_escape_string($con,$_POST['top_paragraph']);
	
			$stmt = $con -> prepare('UPDATE announcements SET paragraph = ? WHERE id = ?');
			$stmt -> bind_param('si', $top_paragraph,$id);
			$stmt -> execute();
			
			//create a session to verify it's coming from here
			$_SESSION["action"] = "true";
			$message="Update was successfully done.";
			echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
		}
						
		if (isset($_POST["delete$id"])) {
			$stmt = $con -> prepare('DELETE FROM announcements WHERE id = ?');	
			$stmt -> bind_param('i', $id);
			$stmt -> execute();
			
			//create a session to verify it's coming from here
			$_SESSION["action"] = "true";
			$message="Item successfully deleted.";
			echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
		}
		
		}
	}
			
		?>
	</div>

    </div>
</section><!-- End Contact Section -->
<?php include("footer.php"); ?>