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/domains/adesmiley.com/public_html/admin41345/

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, FAQs</title>
<?php
if (isset($_POST['add_faqs'])) {
	
	$question = mysqli_real_escape_string($con,$_POST['question']);
	$answer = $_POST['answer'];
	
	$db_id=0;
	$stmt = $con -> prepare('INSERT INTO faqs VALUES (?,?,?)');
	$stmt -> bind_param('iss', $db_id,$question,$answer);
	$stmt -> execute();
 
	//create a session to verify it's coming from here
	$_SESSION["action"] = "true";
	$message="FAQ 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>FAQs</h2>
		<p>Add a question</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="form-row">
                <div class="form-group col-md-12">
					<input type="text" name="question" class="form-control" placeholder="Question" required /> 
                </div>
                <div class="form-group col-md-12">
					<textarea class="form-control" name="answer" rows="5" placeholder='Answer' required></textarea> 
                </div>
              </div>
			  
             
              <div class="text-center">
				<button type="submit" name='add_faqs'>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">
          <p>Uploaded FAQs</p>
        </div>
		<div class='row'>
	<?php
	$stmt = $con -> prepare('SELECT * FROM faqs');
	$stmt -> execute(); 
	$stmt -> store_result(); 
	$stmt -> bind_result($id,$question,$answer); 
	$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'>
					<input type='text' name='question' class='form-control' placeholder='Question' value='$question' required /> 
                </div>
                <div class='form-group col-md-12'>
					<textarea class='form-control' name='answer' rows='5' placeholder='Answer' required>$answer</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"])) {
			$question = mysqli_real_escape_string($con,$_POST['question']);
			$answer = $_POST['answer'];
	
			$stmt = $con -> prepare('UPDATE faqs SET question=?,answer=? WHERE id = ?');
			$stmt -> bind_param('ssi',$question,$answer,$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 faqs WHERE id = ?');	
			$stmt -> bind_param('i', $id);
			$stmt -> execute();
			
			//create a session to verify it's coming from here
			$_SESSION["action"] = "true";
			$message="FAQ 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"); ?>