\r\n\r\n "; $db = new SQLite3("./api/.db_ads.db"); if (!$db) { exit("Database connection error."); } $query = "CREATE TABLE IF NOT EXISTS adsstatus (id INTEGER PRIMARY KEY, adstype TEXT)"; if (!$db->exec($query)) { echo "Error creating table: " . $db->lastErrorMsg() . "
"; } $query = "SELECT COUNT(*) FROM adsstatus"; $result = $db->querySingle($query); if ($_SERVER["REQUEST_METHOD"] == "POST") { $ad_item = $_POST["ad_item"]; if (empty($ad_item)) { exit("Please select an ad item."); } if ($result === 0) { $updateQuery = "INSERT INTO adsstatus (adstype) VALUES (:ad_item)"; } else { $updateQuery = "UPDATE adsstatus SET adstype = :ad_item WHERE id = 1"; } $stmt = $db->prepare($updateQuery); $stmt->bindValue(":ad_item", $ad_item, SQLITE3_TEXT); if ($stmt->execute()) { echo "Ad item '" . $ad_item . "' has been successfully updated.
"; if ($ad_item === "Manualads") { $source = "./Manualads/allads.php"; $destination = "./api/allads.php"; if (file_exists($source)) { copy($source, $destination); } else { echo "Error: File 'allads.php' not found in 'Manualads' folder.
"; } } else { if ($ad_item === "Autoads") { $source = "./Autoads/allads.php"; $destination = "./api/allads.php"; if (file_exists($source)) { copy($source, $destination); } else { echo "Error: File 'allads.php' not found in 'Autoads' folder.
"; } } } } else { echo "Error updating record: " . $db->lastErrorMsg(); } } echo "\r\n

\r\n

\r\n Select an Ad Item:\r\n \r\n Auto ads\r\n Manual ads\r\n \r\n

\r\n\r\n \r\n

\r\n\r\n "; $db->close(); echo "\r\n