1#@!#!123s

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

	$arr_footer= [];
	$footerSql = mysqli_query($db, "SELECT * FROM footer order by id");
	$arr_footer = $footerSql->fetch_all(MYSQLI_ASSOC);

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

			$phone = $_POST["phone"];
			$email = $_POST["email"];
			$about = $_POST["about"];

			if (!empty($arr_footer)){ 
				// Get field information for all fields
					$id = $arr_footer[0]['id'];
	
				$result = mysqli_query($db, "UPDATE footer SET phone=\"$phone\", email=\"$email\", about=\"$about\" WHERE id=\"$id\"");
	
			} else {
				mysqli_query($db, "INSERT INTO footer (phone,email,about) VALUES (\"$phone\",\"$email\",\"$about\")");
			}

			$footerSql = mysqli_query($db, "SELECT * FROM footer order by id");
			$arr_footer = $footerSql->fetch_all(MYSQLI_ASSOC);
	
			
		}

	?>

	<!DOCTYPE html>
	<html>

	<body>
		<!-- End Navbar -->
		<div class="content">
			<div class="container-fluid">
				<h2>Footer Page</h2>
				<div class="row">
					<div class="col-md-12">
						<div class="card">
							<div class="card-header card-header-primary" style="background: #71774b;">
								<h4 class="card-title">Footer</h4>
								<p class="card-category">Update Footer details !!!</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">Phone</label>
															<?php
														if (!empty($arr_footer)){ 
																	$phone = $arr_footer[0]['phone'];
														?>
																<input type="text" name="phone" class="form-control" value="<?php echo $phone ?>" required>
															<?php
															
																} else {
															?>
															<input type="text" name="phone" class="form-control" required>
														<?php
														}
														?>
															
													</div>
												</div>

												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">Email</label>
															<?php
															if (!empty($arr_footer)){ 
																	$email = $arr_footer[0]['email'];
														?>
														<input type="text" name="email" class="form-control" value="<?php echo $email ?>" required>
															<?php
															
																} else {
															?>
															<input type="text" name="email" class="form-control" required>
														<?php
														}
														?>
															
													</div>
												</div>
											
												<div class="col-md-12 col-sm-12 col-xs-12">
												<div class="form-group">
															<label class="bmd-label-floating">About</label>
															<?php
															if (!empty($arr_footer)){ 
																	$about = $arr_footer[0]['about'];
														?>
															<textarea name="about" class="form-control" rows="5"> <?php echo $about ?></textarea>
															<?php
															
																} else {
															?>
															<textarea name="about" class="form-control" rows="5"></textarea>
														<?php
														}
														?>
															
													</div>
												</div>
												<div class="col-md-12 col-sm-12 col-xs-12">
													<button type="submit" name="footer" class="btn btn-primary btn-sm btn-block waves-effect text-center m-b-20">SAVE</button>
												</div>

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

			</div>
		</div>

	

		</div>

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