}
// How many tags should be added
$numberOfTagsToAdd = count($tagsToAdd);
$query = "INSERT INTO whwp_Tag (tag_description) VALUES (:tag)";
$conn->prepQuery($query);
for ($i = 0; $i < $numberOfTagsToAdd; $i++) {
$conn->bind('tag', $tagsToAdd[0]);
$conn->execute();
array_shift($tagsToAdd);
array_push($tagIdsStored, $conn->lastInsertId());
}
$query = "INSERT INTO whwp_AdTag (adtag_advert, adtag_tag) " . "VALUES (:advert_id, :tag_id)";
$conn->prepQuery($query);
$conn->bind('advert_id', $advert_id);
for ($i = 0; $i < $numberOfTags; $i++) {
$tag_id = $tagIdsStored[$i];
$conn->bind('tag_id', $tag_id);
$conn->execute();
}
$conn->endTransaction();
$response_array['message'] = "You can see it " . "<a href='showAdvert.php?advert_id=" . $advert_id . "'>here</a>";
$response_array['success'] = true;
} catch (PDOException $e) {
$conn->cancelTransaction();
array_push($response_array['error_code'], 3);
}
} else {
array_push($response_array['error_code'], 2);
}
}
echo json_encode($response_array);
