<?php
require('../session.php');

if (!isset($conn)) {
    die("Variabel koneksi tidak ditemukan. Cek session.php");
}

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

    $telegram = mysqli_real_escape_string($conn, $_POST['telegram']);
    $facebook = mysqli_real_escape_string($conn, $_POST['facebook']);

    $cek = mysqli_query($conn, "SELECT * FROM tb_group LIMIT 1");

    if (mysqli_num_rows($cek) > 0) {

        $data = mysqli_fetch_assoc($cek);
        $id = $data['id'];

        $update = mysqli_query($conn, "UPDATE tb_group SET 
            telegram_group = '$telegram',
            facebook_group = '$facebook'
            WHERE id = '$id'
        ");

        if (!$update) {
            die(mysqli_error($conn));
        }

    } else {

        $insert = mysqli_query($conn, "INSERT INTO tb_group 
            (telegram_group, facebook_group) 
            VALUES ('$telegram','$facebook')
        ");

        if (!$insert) {
            die(mysqli_error($conn));
        }
    }

    echo "<script>
        alert('Link group berhasil disimpan');
        window.location='../group.php';
    </script>";

}