<?php 
include ('includes/header.php');
$table_name = "extlink";
$page_name = 'extanal_link';

$data = ['link' => 'https://ug17.github.io/play/Flappy-Bird/'];

$db->insertIfEmpty($table_name, $data);

//table call
$rowU = $db->select($table_name, '*', '', '');

if(isset($_POST['submit'])){
	unset($_POST['submit']);
	$updateData = $_POST;
	$db->update($table_name, $updateData, 'id = :id',[':id' => 1]);
	echo "<script>window.location.href='". $page."?status=1'</script>";
}

?>

<div class="col-md-6 mx-auto ctmain-table">
    <div class="card-body">
        <div class="card text-white ctcard">
            <div class="card-header card-header-warning">
                <center>
                    <h2><i class="icon icon-bullhorn"></i> External link</h2>
                </center>
            </div>
            
            <div class="card-body">
                <form method="post">
                    <div class="form-group ctinput">
                        <label class="form-label">Add External link</label>
                        <input class="form-control" name="link" value="<?=$rowU[0]['link'] ?>" type="text"/>
                    </div>
                    <div class="form-group ctinputform-group">
                        <center>
                            <button class="btn btn-info" name="submit" type="submit">
                                <i class="icon icon-check"></i> Submit
                            </button>
                        </center>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

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