Elehhjhjjkjkfpf6df56fd65ffff

korsygfhrfggfhfgfffgffg6655665dtggggggzangaiide Elehhjhjjkjkfpf6df56fd65ffff

<?php
include 'header.php';
include 'config.php';
?>
<?php 
$con_qry  = "SELECT * from vis";
$res = mysqli_query($connect,$con_qry);
if(mysqli_num_rows($res) > 0 )
{
	$cons_data = mysqli_fetch_assoc($res);
}

?>
<div class="content-wrapper">
    <div class="page-title">
        <div>
            <p><i class="fa fa-eye"></i> Vision</p>
        </div>
    </div>
    <div class="card">
	
		   <?php
        if(isset($_POST['submit'])) {
			
            $descp = mysqli_real_escape_string($connect,$_POST['descp']);
			
            $target_dir = "images/about/";
            $target_file = $target_dir . strtolower(basename($_FILES["image"]["name"]));
            $allowed = array("image/jpeg", "image/gif", "image/png");
            if (!in_array($target_file, $allowed)) {
                $error_message = 'Only jpg, gif, and png files are allowed.';
                if (isset($_FILES['image']['errors']) == 1) {
                    echo "Sorry, your file was not uploaded.";
                } else {
                    if (!move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {

$co_qery = "UPDATE vis set descp = '$descp' WHERE id = 1";
                        $co_res = mysqli_query($connect,$co_qery);
                    if($co_res)
                    {
                        ?>
                        <script> alert('Updated Successfully');
                            window.location.replace("vis.php");
                        </script>
                    <?php
                    }

else {
                    ?>
                        <script> alert('Not Updated');
                            window.location.replace("vis.php");
                        </script>
                    <?php
                    }
                    }
                    else {
                    $co_qerys = "UPDATE vis set descp = '$descp', image = '$target_file' WHERE id = 1";
                    $co_ress = mysqli_query($connect,$co_qerys);
                    if($co_ress)
                    {
                    ?>
                        <script> alert('Updated Successfully');
                            window.location.replace("vis.php");

</script>
                    <?php
                    }

else {
                    ?>
                        <script> alert('Not Updated');
                            window.location.replace("vis.php");
                        </script>
                        <?php
                    }
                    }
                }
            }
        }
        ?>
	
	
	 <form method="post" action="" enctype="multipart/form-data">
	 <h2 style="color:red;text-align: center;">Vision</h2>
            <div class="row">
			
		
              
               <div class="col-md-4">
                    <label>Image</label>
                    <input type="file" name="image" accept="image/jpg, image/jpeg, image/png,image/gif" id="imageUpload" onchange="return fileValidation(this)">
                </div>
            </div>
			
			<br>
			
            <div class="row">
                <div class="col-md-12">
                    <label>Description</label>
                    <textarea name="descp" rows="8" id="descp" class="form-control"><?php echo $cons_data['descp'];?></textarea>
                </div>
            </div>
            <br> 
			
			
			
            <div class="row">
                <div class="col-md-12">
                    <img src="<?php echo $cons_data['image'];?>" height="300" width="300">
                </div>
            </div>
            <br>
            <div class="row">
                <div class="col-md-4">
                    <input type="submit" name="submit" class="btn btn-success" value="Update">
                </div>
            </div>
        </form>

</div>
	</div>

</script>
<script>
    function fileValidation(file){
        var fileInput = file.value;
        var allowedExtensions = /(\.jpg|\.jpeg|\.png|\.gif)$/i;
        if(!allowedExtensions.exec(fileInput)){
            alert('Please upload file having extensions .jpeg/.jpg/.png/.gif only.');
            file.value = '';
            file.focus();
            return false;
        }else{
            return true;
        }
    }

</script>