<?php

/*CONEXAO COM O BANCO*/
include "Connections/config.php";
/*********************/

ini_set("display_errors", 1);
ini_set("display_startup_errors", 1);
error_reporting(32767);
$res = $db->query("SELECT * \r\n\t\t\t\t  FROM epg \r\n\t\t\t\t  WHERE id='" . $_GET["update"] . "'");
$row = $res->fetch_array();
$id = $row["id"];
$name = $row["name"];
$url = $row["url"];
if (isset($_POST["submit"])) {
    $db->query("UPDATE epg SET name='" . $_POST["name"] . "', " . "\r\n\t\t\t\t\t\t\t\t" . "url='" . $_POST["url"] . "'" . "\r\n\t\t\t\t\t\t" . "  WHERE " . "\r\n\t\t\t\t\t\t\t" . "  id='" . $_POST["id"] . "'");
    
    header("Location: epg.php");
}
include "includes/header.php";
$id = $row["id"];
$name = $row["name"];
$url = $row["url"];
echo "        <div class=\"container-fluid\">\n\n          <!-- Page Heading -->\n          <h1 class=\"h3 mb-1 text-gray-800\"> Update EPG</h1>\n\n              <!-- Custom codes -->\n                <div class=\"card border-left-primary shadow h-100 card shadow mb-4\">\n                <div class=\"card-header py-3\">\n                <h6 class=\"m-0 font-weight-bold text-primary\"><i class=\"fas fa-list\"></i> Edit Details</h6>\n                </div>\n                <div class=\"card-body\">\n                        <form method=\"post\">\n                        <div class=\"form control\">\n                                    <label class=\"control-label \" for=\"name\"><strong>\n                                        Name</strong>\n                                    </label>\n                                    <div class=\"input-group\">\n";
echo "                                        <input type=\"hidden\" name=\"id\" value=\"" . $id . "\">" . "\n";
echo "                                        <input class=\"form-control text-primary\" id=\"description\" name=\"name\"  value=\"" . $name . "\" type=\"text\" required/>" . "\n";
echo "                                    </div></br>\n                                    \n                        <div class=\"form-group \">\n                                    <label class=\"control-label \" for=\"url\">\n                                        <strong>URL</strong> \n                                    </label>\n                                    <div class=\"input-group\">\n";
echo "                                        <input class=\"form-control text-primary\" id=\"description\" name=\"url\" value=\"" . $url . "\" type=\"text\" required/>" . "\n";
echo "                                    </div>\n                                </div>\n                                <div class=\"form-group\">\n                                    <div>\n                                        <button class=\"btn btn-success btn-icon-split\" name=\"submit\" type=\"submit\">\n                        <span class=\"icon text-white-50\"><i class=\"fas fa-check\"></i></span><span class=\"text\">Submit</span>\n                        </button>\n                                    </div>\n\n                                </div>\n                            </form>\n                </div>\n              </div>\n            </div>\n";
include "includes/footer.php";
echo "</body>\n\n</html>";

?>