MAINHACK

Viewing / Editing File: setup-sms.php

<?php 
date_default_timezone_set("Africa/Accra");
 include("../functions.php");
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {

$s_code = $_SESSION['s_code_Xw2119904'];
if (isset($_GET['schoolCode']) || !empty($_GET['schoolCode'])) {
   $schoolCode = test_input($_GET['schoolCode']);
}

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

$senderID = test_input($_POST['senderID']);
    $username = test_input($_POST['username']);
    $password = test_input($_POST['password']);
    $schoolcode = test_input($_POST['schoolcode']);

// Check if the record exists
    $checkQuery = "SELECT * FROM sms_api WHERE senderID = '$senderID' and schoolCode = '$schoolcode'";
    $result = mysqli_query($new, $checkQuery);

if (mysqli_num_rows($result) > 0) {
        // Update existing record
        $query = "UPDATE sms_api SET senderID='$senderID', username='$username', password='$password' WHERE senderID='$senderID' AND schoolCode = '$schoolcode'";
    } else {
        // Insert new record
        $query = "INSERT INTO sms_api (schoolCode,senderID, username, password) VALUES ('$schoolcode','$senderID', '$username', '$password')";
    }

$execute = mysqli_query($new, $query);

if ($execute) {
    
    echo "<script>
    document.addEventListener('DOMContentLoaded', function() {
        Swal.fire({
            title: 'Success!',
            text: 'Record inserted/updated successfully.',
            icon: 'success',
            confirmButtonText: 'OK'
        });
    });
    </script>";

} else {
        echo "Error: " . mysqli_error($new);
    }
}

}

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>SMS SETUP  </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
<meta content="Themesbrand" name="author" />

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">
<div class="page-content">
<div class="container-fluid">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">BULK SMS SETUP</h4>

<h4 class="card-title mt-3">Message Properties</h4>
<hr>
<?php 
$my = mysqli_query($new,"SELECT * FROM sms_api WHERE schoolCode = '$s_code'");
$rows_services = mysqli_fetch_array($my);
?>

<form method="post">
<div class="mb-3">
<label for="senderID" class="form-label">Sender ID:</label>
<input type="text" class="form-control" id="senderID" name="senderID" value="<?php echo $rows_services['senderID'];?>">
</div>

<div class="mb-3">
<label for="api_key" class="form-label">Username:</label>
<input type="text" class="form-control" id="api_key" name="username"  value="<?php echo $rows_services['username'];?>">
</div>

<input type="hidden" name="schoolcode" value="<?php echo $s_code;?>">
<div class="mb-3">
<label for="api_key" class="form-label">Account password</label>
<input type="text" class="form-control" id="api_key" name="password"  value="<?php echo $rows_services['password'];?>">
</div>

<button type="submit" name="submitSMS" class="btn btn-success w-100">SUBMIT</button>
</form>
</div>
</div>

<div class="col-md-6">
<div class="card p-4 shadow h-100">
<h4 class="card-title">How to Setup SMS</h4>
<hr>
<ul>
<li>We utilize a service called <a href="https://deywuro.com/login" target="_blank">https://deywuro.com</a> for sending text messages.</li>
<li>Visit the following link to sign up for a standard account on <a href="https://deywuro.com" target="_blank">https://deywuro.com</a>.</li>
<li>Once you've signed up successfully, log in to your account.</li>
</ul>

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

</div>

<?php include("includes/footer.php");?>
</div>

</div>

fetch(`load_customer_data.php?s_code=<?php echo $s_code; ?>`)
        .then(response => response.json())
        .then(data => {
            tableBody.innerHTML = ""; // Clear placeholder

if (!data.success || data.records.length === 0) {
                tableBody.innerHTML = '<tr><td colspan="4">No records found</td></tr>';
                return;
            }

data.records.forEach((record, index) => {
                const tr = document.createElement("tr");
                tr.innerHTML = `
                    <td>${index + 1}</td>
                    <td>${escapeHtml(record.mobile_num)}</td>
                    <td>${escapeHtml(record.classname)}</td>
                    <td>
                        <input type="checkbox" name="numbers[]" value="${escapeHtml(record.mobile_num)}">
                    </td>
                `;
                tableBody.appendChild(tr);
            });
        })
        .catch(error => {
            console.error("Error:", error);
            tableBody.innerHTML = '<tr><td colspan="4">Error loading data</td></tr>';
        });
});

// Toggle Select All checkboxes
function toggleSelectAll(checkbox) {
    const checkboxes = document.querySelectorAll('input[name="numbers[]"]');
    checkboxes.forEach(cb => cb.checked = checkbox.checked);
}

// Escape HTML for safety
function escapeHtml(unsafe) {
    if (!unsafe) return "";
    return unsafe.toString()
        .replace(/&/g, "&amp;")
        .replace(/</g, "&lt;")
        .replace(/>/g, "&gt;")
        .replace(/"/g, "&quot;")
        .replace(/'/g, "&#039;");
}
</script>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: setup-sms.php

Server Info

System Features

User Info