D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u935876328
/
domains
/
ggcp.org.in
/
public_html
/
admin
/
Filename :
contactUsPage.php
back
Copy
<?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'); ?>