<?php 
$page='page-contact';
$page1='page';

include('inc/sidebar.php') ;

$get_page= "select * from page_contact";
$query=mysqli_query($con,$get_page);
$contact_data=mysqli_fetch_array($query); 


if(isset($_REQUEST['datafrmSubmit'])){
    if($_REQUEST['datafrmSubmit'] == 'Update'){
    	   	$sql_insert = "UPDATE `page_contact` SET `title` = '".str_replace("'", "\'", $_REQUEST['title'])."',`sub_title` = '".str_replace("'", "\'", $_REQUEST['sub_title'])."', `phone` = '".$_REQUEST['phone']."',`email` = '".$_REQUEST['email']."',`address` = '".str_replace("'", "\'", $_REQUEST['address'])."',`hours` = '".str_replace("'", "\'", $_REQUEST['hours'])."', `map` = '".str_replace("'", "\'", $_REQUEST['map'])."', `phone2` = '".$_REQUEST['phone2']."',`email2` = '".$_REQUEST['email2']."'";
    		$query_insert = mysqli_query($con, $sql_insert);
    		if($query_insert){
                echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
                        <div class="toast-body success">
                            <i class="fa fa-warning"></i>Content Updated.<i class="fa fa-close"id="close"></i>
                        </div>
                    </div>';
                echo "<script type='text/javascript'>window.location=\"page-contact.php\";</script>"; 
    		}   
    }
}   
?>


<!-- navbar-wrapper start -->
  <div class="body-wrapper">
    <div class="bodywrapper__inner">
        <div class="row align-items-center mb-30 justify-content-between">
            <div class="col-lg-4 col-sm-6">
                <h6 class="page-title">Contact Us</h6>
            </div>
            <div class="col-lg-8 col-sm-6 text-sm-right mt-sm-0 mt-3 right-part">
                <div class="d-flex flex-wrap justify-content-end flex-gap-8">
                    <a type="button"href="page.php" class="btn btn--primary"style="height: 38px;"><i class="fa fa-plus"></i>Go Back</a>
                </div>
            </div>
        </div>
    <div class="row">
    <div class="col-md-12 mb-30">
        <div class="card">
            <div class="card-body">
                <form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
                    <input type="hidden" name="_token" value="F3hYZRLH4v3C9Ru6ljqKNSmfRwKJx6eXLvbIf74y" /> <input type="hidden" name="type" value="element" />
                    <div class="form-row">
                        <div class="col-md-12">
                            <div class="form-group">
                                <label>Title</label>
                                <input type="text" class="form-control" placeholder="Title" name="title" id="title" value="<?php if(isset($contact_data)){echo $contact_data['title']; } ?>"  />
                            </div>
                        </div>
                        <div class="col-md-12">
                            <div class="form-group">
                                <label>Sub Title</label>
                                <input type="text" class="form-control" placeholder="Sub Title" name="sub_title" id="sub_title" value="<?php if(isset($contact_data)){echo $contact_data['sub_title']; } ?>"  />
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Phone</label>
                                <input type="number" class="form-control" placeholder="Phone" name="phone" id="phone" value="<?php if(isset($contact_data)){echo $contact_data['phone']; } ?>"  />
                            </div>
                        </div>
                         <div class="col-md-6">
                            <div class="form-group">
                                <label>Second Phone</label>
                                <input type="number" class="form-control" placeholder="Second Phone" name="phone2" id="phone2" value="<?php if(isset($contact_data)){echo $contact_data['phone2']; } ?>"  />
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Email</label>
                                <input type="email" class="form-control" placeholder="Email" name="email" id="email" value="<?php if(isset($contact_data)){echo $contact_data['email']; } ?>"  />
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Second Email</label>
                                <input type="email" class="form-control" placeholder="Second Email" name="email2" id="email2" value="<?php if(isset($contact_data)){echo $contact_data['email2']; } ?>"  />
                            </div>
                        </div>
                        <div class="col-md-12">
                            <div class="form-group">
                                <label>Address</label>
                                <input type="text" class="form-control" placeholder="Address" name="address" id="address" value="<?php if(isset($contact_data)){echo $contact_data['address']; } ?>"  />
                            </div>
                        </div>
                        <div class="col-md-12">
                            <div class="form-group">
                                <label>Working Hours</label>
                                <textarea name="hours" class="summernote"><?php if(isset($contact_data)){ echo $contact_data['hours'];} ?></textarea>
                            </div>
                        </div>
                        <div class="col-md-12">
                            <div class="form-group">
                                <label>Map</label>
                                <textarea name="map" class=" "><?php if(isset($contact_data)){ echo $contact_data['map'];} ?></textarea>
                            </div>
                        </div>
                    </div>
                    <div class="form-group">
                        <button type="submit" name="datafrmSubmit" id="datafrmSubmit"value="Update"class="btn btn--primary btn-block btn-lg">Update</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

    
    </div>
    <!-- bodywrapper__inner end -->
</div>
<!-- body-wrapper end -->

    </div>
 
 <!-- body-wrapper end -->
    </div>
<?php include('inc/footer.php') ?>