} // 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);