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;