mysql_query($query) or $_SESSION['firephp']->error(mysql_error());
$query = "select media_items.id from media_items where media_items.id = LAST_INSERT_ID()";
$query_result = mysql_query($query) or $_SESSION['firephp']->error(mysql_error());
$result_array = mysql2array($query_result);
$media_id = $result_array[0]['id'];
//genre query
$genre_query = "";
if (is_array($_POST['media_item_genre_input'])) {
foreach ($_POST['media_item_genre_input'] as $genre_id) {
$genre_query = "insert into media_genre (genre_id,media_item_id)\n\t \t\t\tvalues('{$genre_id}',LAST_INSERT_ID())\n\t \t\t\t";
mysql_query($genre_query) or $_SESSION['firephp']->error(mysql_error());
}
}
}
$html .= "\n \t\t<div data-role='header'>\n \t\t\t<form style='float:right; margin-top: 5px;' method='POST' action='add_media_item.php'><input id='edit_media_item_button' type='submit' data-icon='gear' data-iconpos='right' name='Edit' value='Edit' title='edit'></input><input type='hidden' name='edit' value='true' title='edit'></input><input type='hidden' name='media_item_id' value='{$media_id}' /></form>\n \t\t\t<a href='index.php' data-icon='home'>Home</a>\n \t\t\t<h3>View Item</h3>\n \t\t</div>\n \t";
$html .= mediaItemHtml($media_id);
} else {
//DISPLAY FORM
$html .= "\n \t<div data-role='header' data-position='fixed'>\n\t \t<a href='index.php' data-rel='back' data-icon='delete'>Cancel</a>\n\t \t<h1>Add Media</h1>\n\t \t<a data-icon='check' data-theme='a'>Save</a>\n \t</div>\n \t";
$media_item_array = array();
$edit_media_item_hidden_input = "";
if ($_POST['edit'] && $_POST['media_item_id']) {
$_POST['media_item_id'] = addslashes($_POST['media_item_id']);
$_SESSION['firephp']->warn('edit item');
$query = "select * from media_items\n\t\tleft outer join storage_slots on media_items.storage_slot_id = storage_slots.storage_slot_id \n\t\tleft outer join storage_locations on storage_slots.storage_location_id = storage_locations.storage_location_id\n\t\tleft outer join media_types on media_types.media_type_id = media_items.media_type_id\n\t\tleft outer join mediums on mediums.medium_id = media_items.medium_id\n\t where media_items.id = '{$_POST['media_item_id']}'\n\t ";
$result = mysql_query($query) or $_SESSION['firephp']->error(mysql_error());
$media_item_array = mysql2array($result);
$media_item_array = $media_item_array[0];
$_SESSION['firephp']->log($media_item_array, 'media_item_array');
$query = "select * from genres left join media_genre on media_genre.genre_id = genres.genre_id\n\t \twhere media_genre.media_item_id = '{$_POST['media_item_id']}'";
$result = mysql_query($query) or $_SESSION['firephp']->error(mysql_error());
<?php
$html = "\r\n<!DOCTYPE html> \r\n<html>\r\n<head>\r\n";
include_once 'includes/header.php';
if (preg_match('%#.*ui-page=(\\d+)%', $_SERVER['REQUEST_URI'], $matches)) {
$_SESSION['firephp']->log($matches, 'matches');
}
$html .= "\r\n </head>\r\n <body>\r\n \t<div data-role='page'>\r\n\t \t\t<div data-role='header'>\r\n\t \t\t\t<form style='float:right; margin-top: 5px;' method='POST' action='add_media_item.php'><input id='edit_media_item_button' type='submit' data-icon='gear' data-iconpos='right' name='Edit' value='Edit' title='edit'></input><input type='hidden' name='edit' value='true' title='edit'></input><input type='hidden' name='media_item_id' value='{$_GET['item']}' /></form>\r\n\t \t\t\t<a href='index.php' data-rel='back' data-icon='arrow-l'>Back</a>\r\n\t \t\t\t<h3>View Item</h3>\r\n\t \t\t</div>\r\n\t";
$_SESSION['firephp']->log($_GET, 'get');
$html .= mediaItemHtml($_GET['item']);
$html .= "\r\n \t</div>\r\n </body>\r\n </html>\r\n ";
echo $html;
