public function executeSaveImages(sfWebRequest $request)
{
$data = $request->getPostParameter("stuff");
//Sent from AJAX.
if (!empty($data)) {
$data = json_decode($data);
//Decode from JSON to PHP array
$color = $data->color;
//eg, "red"
$keywords = $data->keywords;
//eg, "unicorns"
$images = $data->images;
// Array of URLs
$keyword = new keywords();
//MySQL INSERT.
$keyword->setKeyword($keywords);
$keyword->save();
//Query executed
$keyword_identifier = $keyword->identifier();
$keyword_id = $keyword_identifier["id"];
//$keyword->identifier()["id"]; not possible :(
foreach ($images as $image_url) {
$image = new images();
//MySQL INSERT
$image->setColor($color);
//All images have the same $color and $keywords.
$image->setUrl($image_url);
$image->save();
//Query executed
$image_identifier = $image->identifier();
$image_id = $image_identifier["id"];
$image_keyword_relationship = new image_keyword_map();
$image_keyword_relationship->setKeywordId($keyword_id);
$image_keyword_relationship->setImageId($image_id);
$image_keyword_relationship->save();
//Query executed
}
}
}
