exec('CREATE TABLE IF NOT EXISTS sport(id INTEGER PRIMARY KEY NOT NULL, title VARCHAR(25), url VARCHAR(200), c1 VARCHAR(25), c2 VARCHAR(25), c3 VARCHAR(25))'); $rows = $db->query('SELECT COUNT(*) as count FROM sport'); $row1 = $rows->fetchArray(); $numRows = $row1['count']; if ($numRows == 0) { $db->exec('INSERT INTO sport(id, title, url, c1, c2, c3) VALUES(\'1\', \'Default\', \'https://www.tvsportguide.com/widget/5cc316f797659/?heading=Events&border_color=custom&autoscroll=1&custom_colors=\',\'#1d23dd\',\'#ffffff\',\'#000000\')'); } $res = $db->query('SELECT * ' . "\n\t\t\t\t" . ' FROM sport ' . "\n\t\t\t\t" . ' WHERE id=\'1\''); $row = $res->fetchArray(); $id = $row['id']; $urll = $row['url']; $c1 = $row['c1']; $c2 = $row['c2']; $c3 = $row['c3']; if (isset($_POST['submit'])) { $db->exec('UPDATE sport SET' . "\t" . ' url=\'' . $_POST['urll'] . '\',' . "\n" . ' c1=\'' . $_POST['c1'] . '\', ' . "\n\t\t\t\t\t\t\t\t" . 'c2=\'' . $_POST['c2'] . '\', ' . "\n\t\t\t\t\t\t\t\t" . 'c3=\'' . $_POST['c3'] . '\'' . "\n\t\t\t\t\t\t" . ' WHERE ' . "\n\t\t\t\t\t\t\t\t" . 'id=\'1\' '); header('Location: sport.php?success'); } include 'includes/header.php'; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; if (isset($_GET['admin_success'])) { echo $msg_success_admin; } if (isset($_GET['admin_fail'])) { echo $msg_error; } if (isset($_GET['success'])) { echo $msg_success; } echo '

Update Sports

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

Update Sports Url

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' URL' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo ' Border Colour ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo ' Background Colour ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo ' Text Colour ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\t\t\t\t\t\t\t\t" . '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; include 'includes/footer.php'; require 'includes/egz.php'; echo '' . "\n"; ?>