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 * FROM sport 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 url=\'' . $_POST['urll'] . '\', c1=\'' . $_POST['c1'] . '\', c2=\'' . $_POST['c2'] . '\', c3=\'' . $_POST['c3'] . '\' WHERE id=\'1\''); $msg_success = 'Update successful'; header('Location: sport.php?success'); } include 'includes/header.php'; ?>

Atualização esportiva

Atualizar URL de esportes