prepare("UPDATE $table_name SET url = :url WHERE id = 1");
$stmt->bindValue(':url', $intro_url, SQLITE3_TEXT);
$stmt->execute();
}
}
error_reporting(0); // Avoid displaying errors to users in production
include 'includes/header.php';
$table_name = 'intro';
$db = new SQLite3('./api/intro.db'); // Replace with your database configuration
$db->exec("CREATE TABLE IF NOT EXISTS $table_name (id INTEGER PRIMARY KEY, url TEXT)");
$rows = $db->querySingle("SELECT COUNT(*) as count FROM $table_name");
$numRows = intval($rows);
if ($numRows === 0) {
$db->exec("INSERT INTO $table_name (url) VALUES ('')");
}
$intro = $db->querySingle("SELECT url FROM $table_name WHERE id = 1");
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
Submit('sub_new', $db, $table_name);
}
if (!file_exists('intro')) {
mkdir('intro', 0755, true);
}
$url_intro = $intro;
?>
LINK DO VÍDEO SALVO ATUAL: