1#@!#!123s

: / home / u935876328 / domains / ggcp.org.in / public_html / admin /
Filename : contactUsPage.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"];

			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\" WHERE id=\"$id\"");
	
			} else {
				mysqli_query($db, "INSERT INTO footer (phone,email,about) VALUES (\"$phone\",\"$email\",\"-\")");
			}

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

		$contactUsFile = "upload/contact/";
		$arr_aboutPageBannerSql = [];
	$aboutPageBannerSql = mysqli_query($db, "SELECT * FROM contact_page_banner order by id DESC LIMIT 1");
	$arr_aboutPageBannerSql = $aboutPageBannerSql->fetch_all(MYSQLI_ASSOC);

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

		$filename = $_FILES["uploadfile"]["name"];
		$tempname = $_FILES["uploadfile"]["tmp_name"];
		$ext = pathinfo($filename, PATHINFO_EXTENSION);
		$newfilename = date('dmYHis') . "." . $ext;
		$folder = $contactUsFile . $newfilename;

		$title = $_POST["title"];

		if (!empty($arr_aboutPageBannerSql)){ 
			// Get field information for all fields
			$hbid = "0";

				$hbid = $arr_aboutPageBannerSql[0]['id'];
				if($filename == null){
					$newfilename = 	$arr_aboutPageBannerSql[0]['filename'];
				}
			

			$result = mysqli_query($db, "UPDATE contact_page_banner SET title=\"$title\", filename=\"$newfilename\" WHERE id=\"$hbid\"");

		} else {
			mysqli_query($db, "INSERT INTO contact_page_banner (title,filename,youtube_id) VALUES (\"$title\",\"$newfilename\",\"-\")");
		}

		// Now let's move the uploaded image into the folder: image 
		if (move_uploaded_file($tempname, $folder)) {
			$msg = "Image uploaded successfully";
		} else {
			$msg = "Failed to upload image";
		}

		$aboutPageBannerSql = mysqli_query($db, "SELECT * FROM contact_page_banner order by id DESC LIMIT 1");
		$arr_aboutPageBannerSql = $aboutPageBannerSql->fetch_all(MYSQLI_ASSOC);
	}

	?>

	<!DOCTYPE html>
	<html>

	<body>
		<!-- End Navbar -->
		<div class="content">
			<div class="container-fluid">
				<h2>Contact Us 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">Banner & Banner Youtube video</h4>
								<p class="card-category">Add Or Update Banner & Banner Youtube video !!!</p>
							</div>
							<div class="card-body">
								<div class="row">

									<div class="col-md-5 col-sm-12 col-xs-12">
										<form method="POST" action="" enctype="multipart/form-data">
											<div class="row">
											<div class="col-md-12 col-sm-12 col-xs-12">
													<div class="form-group">
														<label class="bmd-label-floating">Title</label>
														<?php
														if (!empty($arr_aboutPageBannerSql)){ 
																	$title = $arr_aboutPageBannerSql[0]['title'];
														?>
																<input type="text" name="title" class="form-control" value="<?php echo $title ?>" required>
															<?php
															
																} else {
															?>
															<input type="text" name="title" class="form-control" required>
														<?php
														}
														?>
													</div>
												</div>
												<div class="col-md-12 col-sm-12 col-xs-12">
														<label class="bmd-label-floating">Banner Image</label><br>
														<input type="file" name="uploadfile" value="" />
												</div>
											
												<div class="col-md-12 col-sm-12 col-xs-12">
													<button type="submit" name="upload" 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" style="text-align: center;">
										<?php
										if (!empty($arr_aboutPageBannerSql)){ 
											$filename = "";
												$filename = $arr_aboutPageBannerSql[0]['filename'];
										?>
											<img src="<?php echo $contactUsFile.$filename ?>" height="150px">
										<?php
										}
										?>
									</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: #71774b;">
								<h4 class="card-title">Contact Information</h4>
								<p class="card-category">Update Contact Information !!!</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">
													<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');
		?>