<?php 
include ('includes/header.php');
$table_name = 'exsport';
$page_name = 'extra_sports';
$data = ['name' => 'name','link' => 'add link'];
$db->insertIfEmpty($table_name, $data);
$res = $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_name.".php?status=1'</script>";
}

?>

        <div class="col-md-8 mx-auto ctmain-table">
            <div class="card-body">
                <div class="card ctcard">
                    <div class="card-header card-header-warning">
                        <center>
                            <h2><i class="icon icon-bullhorn"></i> Extra Sport link</h2>
                        </center>
                    </div>
                    
                    <div class="card-body">
                            <form method="post">
                                <div class="form-group ctinput">
                                    <label class="form-label " >Name</label>
                                        <input class="form-control"  name="name" value="<?=$res[0]['name'] ?>" type="text"/>
                                </div>
                                <div class="form-group ctinput">
                                    <label class="form-label " >Link</label>
                                        <input class="form-control"  name="link" value="<?=$res[0]['link'] ?>" type="text"/>
                                </div>
                                <div class="form-group ctinput">
                                    <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');?>