In the pasted code is my "Category" menu code. (1) Fix: When i update a category name and successfully adit it, it doesnt disappear from the form. After succesful edit/updtae that category name must disappear from the form (2) Fix: the time that is being show in both "Date Created" and Date Updated is wrong. Date Created: time when i create that category Date Updtaed time when i updtae that category and when im not yet updtaing thatctegory it should show "Never". What is happening right now is that when im updating a category, the time in "Date Crated " is the same in time in Date Updtaed. It must be when im updating, the time in Date Created must not chnage the time i created that, and the only will change is the time in Date Updtaed. Here is the code: prefix . 'categories'; $inventory_history_table_name = 'inventory_history'; $message = ''; // For success/error messages $message_type = ''; // 'success' or 'error' $editing_category = null; // Initialize editing category variable function log_category_action($action_type, $category_name, $description) { global $wpdb; $history_table_name = 'inventory_history'; // Change according to your table name $username = isset($_SESSION['username']) ? $_SESSION['username'] : ''; // Get current user $result = $wpdb->insert( $history_table_name, array( 'username' => $username, 'action_type' => $action_type, 'item_type' => 'category', 'item_name' => $category_name, 'description' => $description, 'timestamp' => current_time('mysql') // Current time ), array('%s', '%s', '%s', '%s', '%s', '%s') ); return $result !== false; // Return true if inserted successfully } // --- Handle Add/Edit Category Form Submission --- if (isset($_POST['save_category']) && isset($_POST['_wpnonce_category_form']) && wp_verify_nonce($_POST['_wpnonce_category_form'], 'save_category_action')) { $category_name = isset($_POST['category_name']) ? sanitize_text_field($_POST['category_name']) : ''; $edit_category_id = isset($_POST['edit_category_id']) ? absint($_POST['edit_category_id']) : 0; if (!empty($category_name)) { // Check if category already exists (excluding current edited category) $existing_check = $wpdb->prepare( "SELECT id FROM $table_name WHERE LOWER(name) = LOWER(%s) AND id != %d", $category_name, $edit_category_id ); $existing_category = $wpdb->get_var($existing_check); if ($existing_category) { $message = 'Error: Category "' . esc_html($category_name) . '" already exists.'; $message_type = 'error'; } else { if ($edit_category_id) { // Fetch the original name before updating $original_category_name = $wpdb->get_var($wpdb->prepare( "SELECT name FROM $table_name WHERE id = %d", $edit_category_id )); // UPDATE existing category $updated = $wpdb->update( $table_name, [ 'name' => $category_name, 'updated_at' => current_time('mysql') // Add current timestamp ], ['id' => $edit_category_id], ['%s', '%s'], ['%d'] ); if ($updated !== false) { $message = 'Category updated successfully!'; $message_type = 'success'; $editing_category = null; // Reset editing state $_POST['category_name'] = ''; // Log the action with the original category name in description log_category_action('update', $original_category_name, "Category '{$original_category_name}' updated to '{$category_name}'."); } else { $message = 'Error updating category. ' . $wpdb->last_error; $message_type = 'error'; } } else { // INSERT new category $inserted = $wpdb->insert( $table_name, ['name' => $category_name, 'created_at' => current_time('mysql')], ['%s', '%s'] ); if ($inserted) { $message = 'Category added successfully!'; $message_type = 'success'; log_category_action('add', $category_name, "Category '{$category_name}' was added."); } else { $message = 'Error adding category. ' . $wpdb->last_error; $message_type = 'error'; } } } } else { $message = 'Category name cannot be empty.'; $message_type = 'error'; } } // --- Handle Edit Category Action (Prepare form) --- if (isset($_GET['action']) && $_GET['action'] === 'edit_category' && isset($_GET['id']) && isset($_GET['_wpnonce']) && wp_verify_nonce($_GET['_wpnonce'], 'edit_category_' . absint($_GET['id']))) { $category_id_to_edit = absint($_GET['id']); if ($category_id_to_edit) { $editing_category = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $category_id_to_edit), ARRAY_A ); if (!$editing_category) { $message = 'Category not found for editing.'; $message_type = 'error'; } } } // --- Handle Cancel Edit Action --- if (isset($_GET['action']) && $_GET['action'] === 'cancel_edit') { $editing_category = null; wp_redirect(remove_query_arg(array('action', 'id', '_wpnonce'))); exit; } // --- Handle Delete Category Action --- if (isset($_GET['action']) && $_GET['action'] === 'delete_category' && isset($_GET['id']) && isset($_GET['_wpnonce']) && wp_verify_nonce($_GET['_wpnonce'], 'delete_category_' . absint($_GET['id']))) { $category_id_to_delete = absint($_GET['id']); if ($category_id_to_delete) { // First get the category details before deleting $category_to_delete = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $category_id_to_delete), ARRAY_A ); if ($category_to_delete) { // Log the action before deleting log_category_action('delete', $category_to_delete['name'], "Category '{$category_to_delete['name']}' was deleted."); $deleted = $wpdb->delete( $table_name, ['id' => $category_id_to_delete], ['%d'] ); if ($deleted) { $message = 'Category deleted successfully!'; $message_type = 'success'; wp_redirect(remove_query_arg(array('action', 'id', '_wpnonce'))); exit; } else { $message = 'Error deleting category.'; $message_type = 'error'; } } else { $message = 'Category not found.'; $message_type = 'error'; } } } // --- Fetch Categories --- $categories = []; if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $table_name)) == $table_name) { $categories = $wpdb->get_results("SELECT * FROM {$table_name} ORDER BY name ASC", ARRAY_A); } else { $message = "Error: Categories table '{$table_name}' not found."; $message_type = 'error'; } $search_term = ''; if (isset($_POST['search_term'])) { $search_term = sanitize_text_field($_POST['search_term']); $categories = $wpdb->get_results( $wpdb->prepare("SELECT * FROM {$table_name} WHERE name LIKE %s ORDER BY name ASC", '%' . $wpdb->esc_like($search_term) . '%'), ARRAY_A ); } ?> Categories Management

Categories Management

Existing Categories

No categories found.

ID	Name	Date Created	Date Updated	Actions
				Edit Delete