exec("CREATE TABLE IF NOT EXISTS " . $table_name . " (id INTEGER PRIMARY KEY, key TEXT)"); $rows = $db->query("SELECT COUNT(*) as count FROM " . $table_name); $row = $rows->fetchArray(); $numRows = $row["count"]; if ($numRows == 0) { $db->exec("INSERT INTO " . $table_name . "(key) VALUES('')"); } if ($_SERVER["REQUEST_METHOD"] === "POST") { if (isset($_POST["submit"])) { $newKey = $_POST["key"]; // No validation/sanitization here for demonstration purposes // Use prepared statements to prevent SQL injection $stmt = $db->prepare("UPDATE " . $table_name . " SET key = :newKey WHERE id = 1"); $stmt->bindValue(':newKey', $newKey, SQLITE3_TEXT); $stmt->execute(); header("Location: tmdb_api.php"); exit(); } } $res = $db->query("SELECT * FROM " . $table_name . " WHERE id = 1"); $rowU = $res->fetchArray(); ?>

Get Your tMDB API Key

To use this application, you need to have a tMDB API key. Follow these steps to obtain your API key:

  1. Visit the tMDB website at https://www.themoviedb.org/
  2. Sign in or create an account if you don't have one.
  3. To register for an API key, click the API link from within your account settings page.
  4. Please note that the API registration process is not optimized for mobile devices so you should access these pages on a desktop computer and browser
  5. Generate a new API key and copy it.

Paste the copied API key into the field below and click the "Save Settings" button.