revealability

Back Back Up Advanced Editor

<?php
session_start();
include '../assets/constant/config.php';

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>
<?php include('include/sidebar.php'); ?>

<?php include('include/header.php'); ?>

</div>
                    <h4 class="page-title">Settings</h4>
                </div>
            </div>
            <div class="clearfix"></div>
        </div>
        
        <div class="row">
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-body">

<ul class="nav nav-tabs" role="tablist">
                            <li class="nav-item">
                                <a class="nav-link active" data-toggle="tab" href="#home" role="tab">Logo</a>
                            </li>

<li class="nav-item">
                                <a class="nav-link" data-toggle="tab" href="#settings" role="tab">Email Setting </a>
                            </li>

<li class="nav-item">
                                <a class="nav-link" data-toggle="tab" href="#captcha" role="tab">Captcha Setting </a>
                            </li>
                        </ul>

<div class="tab-content">
                            <div class="tab-pane active p-3" id="home" role="tabpanel">
                                <form name="myform1" class="row" action="app/web_crud.php" method="POST" enctype="multipart/form-data" onsubmit="return validation()" id="validate">
                                    <?php

$stmt1 = $conn->prepare("SELECT * FROM `manage_web` ");
                                    $stmt1->execute();
                                    $record1 = $stmt1->fetchAll();

foreach ($record1 as $key1) { ?>

<div class="form-group col-md-6">
                                            <label class="control-label">Existing Photo</label><br>
                                            <input type="hidden" value="<?php echo $key1['photo1'] ?>" name="old_photo1_img">
                                            <img class="img-fluid" src="../assets/images/<?php echo $key1['photo1'] ?>" style="width:100px;height:auto;"><br>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">New Photo<span class="text-danger">(file size must be less than 500 x 400 pixel)</span></label>
                                            <input class="form-control" type="file" id="photo1" name="photo1" value="<?php echo $key1['photo1'] ?>" accept=".png,.jpeg,.jpg">

</div>

<div class="col-md-12">
                                            <h6 class="p-2 seo-info" style="background-color: lightgrey;">Favicon</h6>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Title<span class="text-danger">*</span></label>
                                            <input class="form-control" type="text" name="title" value="<?php echo $key1['title'] ?>" required /><br><br>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Existing Photo</label><br>
                                            <input type="hidden" value="<?php echo $key1['photos'] ?>" name="old_photos_img">
                                            <img class="img-fluid" src="../assets/images/<?php echo $key1['photos'] ?>" style="width:100px;height:auto;"><br>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">New Photo <span class="text-danger">(file size must be less than 500 x 400 pixel)</span></label>
                                            <input class="form-control" type="file" name="photos" id="photos" value="<?php echo $key1['photos'] ?>" accept=".png,.jpeg,.jpg">
                                        </div>

<div class="col-md-12">
                                            <h6 class="p-2 seo-info" style="background-color: lightgrey;">Google ReCaptcha</h6>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Site-key</label>
                                            <input class="form-control" type="text" name="sitekey" value="<?php echo $key1['sitekey'] ?>" required>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Secret-key</label>
                                            <input class="form-control" type="text" name="secretkey" value="<?php echo $key1['secretkey'] ?>" required>
                                        </div>

<div class="col-md-12">
                                            <h6 class="p-2 seo-info" style="background-color: lightgrey;">Contact Us</h6>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Contact No.</label>
                                            <input class="form-control" type="text" name="contact" value="<?php echo $key1['contact'] ?>" required>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Email</label>
                                            <input class="form-control" type="text" name="email" value="<?php echo $key1['email'] ?>" required>
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">Address</label>
                                            <input class="form-control" type="text" name="address" value="<?php echo $key1['address'] ?>" required>
                                        </div>
                                        
                                 
                                        
                                        <div class="col-md-12">
                                            <h6 class="p-2 seo-info" style="background-color: lightgrey;">Razorpay Keys</h6>
                                        </div>
                                        
                                           <div class="form-group col-md-6">
                                            <label class="control-label">Key Id</label>
                                            <input class="form-control" type="text" name="keyId" value="<?php echo $key1['keyId'] ?>" required>
                                        </div>
                                        
                                          <div class="form-group col-md-6">
                                            <label class="control-label">Key Secret</label>
                                            <input class="form-control" type="text" name="keysecret" value="<?php echo $key1['keysecret'] ?>" required>
                                        </div>

<div class="form-group col-md-12">
                                            <button class="btn btn-primary" type="submit" name="update">Update</button>

</div>
                                    <?php } ?>
                                </form>
                            </div>
                            <script type="text/javascript">
                                var img = document.forms['myform1']['photo1'];
                                var validExt = ["jpeg", "png", "jpg"];

function validation1() {
                                    if (img.value != '') {

var img_ext = img.value.substring(img.value.lastIndexOf('.') + 1);

var result = validExt.includes(img_ext);
                                        if (result == false) {
                                            alert("Sorry, only JPEG & PNG  files are allowed.");
                                            return false;

}

}
                                }
                            </script>

<div class="tab-pane p-3" id="settings" role="tabpanel">
                                <form class="row" action="app/web_crud.php" method="POST">
                                    <?php
                                    $stmt4 = $conn->prepare("SELECT * FROM `emailsetting` ");

$stmt4->execute();

$record4 = $stmt4->fetchAll();

foreach ($record4 as $key4) { ?>

<div class="form-group col-md-6">
                                            <label class="control-label">SMTP Username</label>
                                            <input class="form-control" type="text" name="smtp_username" value="<?php echo $key4['smtp_username'] ?>" />
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">SMTP Password</label>
                                            <input class="form-control" type="password" name="smtp_password" value="<?php echo $key4['smtp_password'] ?>">
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">SMTP Host</label>
                                            <input class="form-control" type="text" name="smtp_server" value="<?php echo $key4['smtp_server'] ?>">
                                        </div>
                                        <label><span class="text-danger">On the SMTPSecure, if you use the Port 465 then it is ssl; if you use the Port 587 then it is tls</span></label>
                                        <div class="form-group col-md-6">
                                            <label class="control-label">SMTP Port</label>
                                            <select class="form-control port" id="port" name="stmp_port">
                                                <option value="465" data-enc="ssl" <?php if ($key4['stmp_port'] == '465') echo 'selected'; ?>>465</option>
                                                <option value="587" data-enc="tls" <?php if ($key4['stmp_port'] == '587') echo 'selected'; ?>>587</option>
                                            </select>
                                            
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">SMTP Encryption</label>

$(".port").change(function() {
                                                    var enc = $('.port').find(":selected").attr('data-enc');
                                                    $('.enc').val(enc);
                                                });

});
                                        </script>

<div class="form-group col-md-6">
                                            <label class="control-label">SMTP Email From</label>
                                            <input class="form-control" type="text" name="email" value="<?php echo $key4['email'] ?>">
                                        </div>

<div class="form-group col-md-6">
                                            <label class="control-label">SMTP Email From</label>
                                            <input class="form-control" type="text" name="email1" value="<?php echo $key4['email1'] ?>">
                                        </div>

<button class="btn btn-primary" type="submit" name="update3">Update</button>

</div>
                                    <?php } ?>
                                </form>
                            </div>

<div class="tab-pane p-3" id="captcha" role="tabpanel">
                                <form class="row" action="app/web_crud.php" method="POST">
                                    <?php
                                    $stmt4 = $conn->prepare("SELECT * FROM `manage_web` ");

$stmt4->execute();

$record4 = $stmt4->fetchAll();

foreach ($record4 as $key4) {
                                    ?>

<div class="form-group col-md-6">
                                            <label class="control-label">Would you like the captcha to be visible?</label>
                                            <div class="form-check">
                                                <input class="form-check-input" type="radio" name="captcha" id="captchaYes" value="0" <?php echo ($key4['captcha'] == '0') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="captchaYes">Yes</label>
                                            </div>
                                            <div class="form-check">
                                                <input class="form-check-input" type="radio" name="captcha" id="captchaNo" value="1" <?php echo ($key4['captcha'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="captchaNo">No</label>
                                            </div>
                                        </div>

<button class="btn btn-primary" type="submit" name="update5">Update</button>

</div>
                                    <?php } ?>
                                </form>
                            </div>

</div>

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

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

<!-- <script>
    function validateImage(input) {
        var file = input.files[0];
        var fileType = file.type;
        var validImageTypes = ["image/jpeg", "image/jpg", "image/png"];

if (!validImageTypes.includes(fileType)) {
            alert("Please select a valid image file (JPEG, JPG, or PNG).");
            input.value = "";
        }
    }

function validation() {
        // Add any additional validation logic here if needed
        return true; // Return true to submit the form
    }
</script> -->

function validation() {
        if (img.value != '') {

var img_ext = img.value.substring(img.value.lastIndexOf('.') + 1);

var result = validExt.includes(img_ext);
            if (result == false) {
                alert("Sorry, only JPEG & PNG  files are allowed.");
                return false;

}

}
    }
</script>

function validation1() {
        if (img.value != '') {

var img_ext = img.value.substring(img.value.lastIndexOf('.') + 1);

var result = validExt.includes(img_ext);
            if (result == false) {
                alert("Sorry, only JPEG & PNG  files are allowed.");
                return false;

}

}
    }
</script>

<?php if (!empty($_SESSION['update'])) { ?>
    <script>
        setTimeout(function() {
            swal({
                title: "Congratulations!",
                text: "Record Updated",
                type: "success",
                confirmButtonText: "Ok"
            }, function() {
                window.location = "web.php";
            }, 1000);
        });
    </script>
    <p><?php $_SESSION['update'] = '';
    } ?></p>

<?php if (!empty($_SESSION['delete'])) { ?>
        <script>
            setTimeout(function() {
                swal({
                    title: "Congratulations!",
                    text: "Record Deleted",
                    type: "success",
                    confirmButtonText: "Ok"
                }, function() {
                    window.location = "web.php";
                }, 1000);
            });
        </script>
        <p><?php $_SESSION['delete'] = '';
        } ?></p>