<?php 
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$db = new SQLite3('./api/.ltq_db.db');

$res = $db->query("SELECT * 
				  FROM notifications 
				  WHERE id='".$_GET['update']."'");
$row=$res->fetchArray();

if(isset($_POST['submit'])){
$db->exec("UPDATE notifications SET  title='".$_POST['title']."', 
								description='".$_POST['description']."',
								backdrop='".$_POST['backdrop']."',
								reference='".$_POST['reference']."' 
						  WHERE 
							  id='".$_POST['id']."'");
$db->close();
header("Location: notifications.php");
}
include ('header.php');
?>

         <div class="container" style="padding:10px;">
            <div class="col-md-10 px-4">
              <div class="card bg-dark text-white">
                <div class="card-header card-header-warning">
                  <h4 class="card-title">Update Notification</h4>
                </div>
                <div class="card-body">
                  <form  method="post">
                      <div>
                        <div class="form-group">
                          <label class="bmd-label-floating">Title</label>
						   <input type="hidden" name="id" value="<?=$row['id'] ?>">
                          <input type="text" class="form-control" name="title" value="<?=$row['title'] ?>">
                        </div>
                      </div>
                      <div>
                        <div class="form-group">
                          <label class="bmd-label-floating">Description</label>
                          <input type="text" class="form-control" name="description" value="<?=$row['description'] ?>">
                        </div>
                      </div>
                      <div>
                        <div class="form-group">
                          <label class="bmd-label-floating">Notification Banner</label>
                          <input type="text" class="form-control" name="backdrop" value="<?=$row['backdrop'] ?>">
                        </div>
                      </div>
                      <div>
                        <div class="form-group">
                          <label class="bmd-label-floating">Reference Url</label>
                          <input type="text" class="form-control" name="reference" value="<?=$row['reference'] ?>">
                        </div>
                      </div>
					<br><button type="submit" name="submit" class="btn btn-warning pull-right">Submit</button>
				</form>
				</div>
              </div>
            </div>
          </div>
    <br><br><br>
<?php include ('footer.php');?>
</body>

</html>