1#@!#!123s

: / home / u384067285 / domains / cauldronsisterss.com / public_html / admin /
Filename : about.php
back
<?php session_start();

    error_reporting(0);

    include 'connection.php';

    if (strlen($_SESSION['bpmsaid'] == 0)) {
        header("Location: logout.php");
    }

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

    $about_quote = htmlentities($_POST['about_quote']);
    $about_quote = addslashes($about_quote);

    $short_description = htmlentities($_POST['short_description']);
    $short_description = addslashes($short_description);

    $short_description1 = htmlentities($_POST['short_description1']);
    $short_description1 = addslashes($short_description1);

    $short_description2 = htmlentities($_POST['short_description2']);
    $short_description2 = addslashes($short_description2);

    /* Add Requests */
    $sql = "INSERT INTO tblabout (about_quote, short_description, short_description1, short_description2) VALUES ('$about_quote', '$short_description', '$short_description1', '$short_description2')";

    if ($conn->query($sql) === TRUE) {
        $msg = "About Added Successfully";
    } else {
        $msg = $conn->error;
    }
}

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

    $about_quote = htmlentities($_POST['about_quote']);
    $about_quote = addslashes($about_quote);

    $short_description = htmlentities($_POST['short_description']);
    $short_description = addslashes($short_description);

    $short_description1 = htmlentities($_POST['short_description1']);
    $short_description1 = addslashes($short_description1);

    $short_description2 = htmlentities($_POST['short_description2']);
    $short_description2 = addslashes($short_description2);

    $sql = "UPDATE tblabout SET about_quote = '$about_quote', short_description = '$short_description', short_description1 = '$short_description1', short_description2 = '$short_description2'";

    if ($conn->query($sql) === TRUE) {
        $msg = "Updated Successfully";
    } else {
        $msg = $conn->error;
    }
}

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

    /* Add Requests */
    $sql = "DELETE FROM tblabout";
    $result = $conn->query($sql);
    if($result){
        $conn->close();  // Close Connection
        header("location: about.php");
        exit;	
    }
    else{
        echo "<script>alert('Error Deleting Records.');</script>";
    }
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Cauldron Sisterss | About</title>
    <!-- plugins:css -->
    <link rel="stylesheet" href="vendors/feather/feather.css">
    <link rel="stylesheet" href="vendors/mdi/css/materialdesignicons.min.css">
    <link rel="stylesheet" href="vendors/ti-icons/css/themify-icons.css">
    <link rel="stylesheet" href="vendors/typicons/typicons.css">
    <link rel="stylesheet" href="vendors/simple-line-icons/css/simple-line-icons.css">
    <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css">
    <!-- endinject -->
    <!-- Plugin css for this page -->
    <link rel="stylesheet" href="vendors/select2/select2.min.css">
    <link rel="stylesheet" href="vendors/select2-bootstrap-theme/select2-bootstrap.min.css">
    <!-- End plugin css for this page -->
    <!-- inject:css -->
    <link rel="stylesheet" href="css/vertical-layout-light/style.css">
    <!-- endinject -->
    <?php include 'favicon.php'; ?>
</head>

<body>
    <div class="container-scroller">
        <!-- partial:../../partials/_navbar.php -->
        <?php include 'header.php'; ?>
        <!-- partial -->

        <div class="container-fluid page-body-wrapper">
            <!-- partial:../../partials/_sidebar.html -->
            <?php include 'sidebar.php'; ?>
            <!-- partial -->

            <div class="main-panel">
                <div class="content-wrapper">
                    <div class="row">
                        <div class="col-md-12 grid-margin stretch-card">
                            <div class="card">
                                <div class="card-body">

                                    <h4 class="card-title">Add about your work (Should Include In  about us page in Website)
                                        <span style = "color:red;">
                                            <?php echo $msg; ?>
                                        </span>
                                    </h4>

                                    <form class="forms-sample" method="post">
                                       
                                        <div class="form-group">
                                            <label for="quote">Add Single Quote</label>
                                            <textarea class="form-control" id="quote" placeholder="Quote" name="about_quote" required></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="descripton">Short Description</label>
                                            <textarea class="form-control" id="descripton" placeholder="Descripton in 100 -150 words" name="short_description" required></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="descripton1">Short Description1</label>
                                            <textarea class="form-control" id="descripton1" placeholder="Descripton 1 in 100 -150 words" name="short_description1" required></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="descripton2">Short Description2</label>
                                            <textarea class="form-control" id="descripton2" placeholder="Descripton 2 in 100 -150 words" name="short_description2" required></textarea>
                                        </div>

                                        <button type="submit" class="btn btn-primary me-2" name="add">Add</button>

                                    </form>

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

                    <!-- Manage Company Contact -->

                    <div class="row">
                        <div class="col-md-12 grid-margin stretch-card">
                            <div class="card">
                                <div class="card-body">

                                    <h4 class="card-title">Update work
                                    </h4>

                                    <form class="forms-sample" method="post">

                                        <?php
                                            $sql = "SELECT * FROM tblabout";
                                            $result = $conn->query($sql);
                                            while ($row = mysqli_fetch_array($result)) {
                                        ?>
                                       
                                        <div class="form-group">
                                            <label for="quote">Add Single Quote</label>
                                            <textarea class="form-control" id="quote" placeholder="Quote" name="about_quote" required><?php echo $row['about_quote']; ?></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="descripton">Short Description</label>
                                            <textarea class="form-control" id="descripton" placeholder="Descripton in 100 -150 words" name="short_description" required><?php echo $row['short_description']; ?></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="descripton1">Short Description1</label>
                                            <textarea class="form-control" id="descripton1" placeholder="Descripton 1 in 100 -150 words" name="short_description1" required><?php echo $row['short_description1']; ?></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="descripton2">Short Description2</label>
                                            <textarea class="form-control" id="descripton2" placeholder="Descripton 2 in 100 -150 words" name="short_description2" required><?php echo $row['short_description2']; ?></textarea>
                                        </div>

                                        <button type="submit" class="btn btn-primary me-2" name="update">Update</button>

                                        <button type="submit" class="btn btn-primary me-2" name="delete">Delete</button>

                                        <?php } ?>

                                    </form>

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

                </div>
                <!-- content-wrapper ends -->

                <!-- partial:../../partials/_footer.html -->
                <?php include 'footer.php'; ?>
                <!-- partial -->

            </div>
            <!-- main-panel ends -->
        </div>
        <!-- page-body-wrapper ends -->
    </div>
    <!-- container-scroller -->
    <!-- plugins:js -->
    <script src="vendors/js/vendor.bundle.base.js"></script>
    <!-- endinject -->
    <!-- Plugin js for this page -->
    <script src="vendors/typeahead.js/typeahead.bundle.min.js"></script>
    <script src="vendors/select2/select2.min.js"></script>
    <script src="vendors/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
    <!-- End plugin js for this page -->
    <!-- inject:js -->
    <script src="js/off-canvas.js"></script>
    <script src="js/hoverable-collapse.js"></script>
    <script src="js/template.js"></script>
    <script src="js/settings.js"></script>
    <script src="js/todolist.js"></script>
    <!-- endinject -->
    <!-- Custom js for this page-->
    <script src="js/file-upload.js"></script>
    <script src="js/typeahead.js"></script>
    <script src="js/select2.js"></script>
    <!-- End custom js for this page-->
</body>

</html>