exec($query)) {
} else {
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)) {
die("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.
";
} else {
echo "Error updating record: " . $db->lastErrorMsg();
}
}
?>
close();
?>