Inventory Management System

Item added successfully!
"; } else { echo "
Error: " . mysqli_error($conn) . "
"; } } if (isset($_POST['delete'])) { $id = (int)$_POST['id']; $sql = "DELETE FROM items WHERE id = $id"; if (mysqli_query($conn, $sql)) { echo "
Item deleted successfully!
"; } } if (isset($_POST['update'])) { $id = (int)$_POST['id']; $name = mysqli_real_escape_string($conn, $_POST['name']); $quantity = (int)$_POST['quantity']; $price = (float)$_POST['price']; $category = mysqli_real_escape_string($conn, $_POST['category']); $sql = "UPDATE items SET name='$name', quantity=$quantity, price=$price, category='$category' WHERE id=$id"; if (mysqli_query($conn, $sql)) { echo "
Item updated successfully!
"; } } } ?>
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
Name Quantity Price Category Actions
" . htmlspecialchars($row['name']) . "" . htmlspecialchars($row['quantity']) . "$" . htmlspecialchars($row['price']) . "" . htmlspecialchars($row['category']) . "
import { useState } from 'react'; import { Plus, Trash2, Edit, Save, X } from 'lucide-react'; export default function InventoryManagement() { const [items, setItems] = useState([ { id: 1, name: 'Laptop', quantity: 10, price: 999.99, category: 'Electronics' }, { id: 2, name: 'Desk Chair', quantity: 15, price: 199.99, category: 'Furniture' }, ]); const [newItem, setNewItem] = useState({ name: '', quantity: '', price: '', category: '' }); const [editingId, setEditingId] = useState(null); const [editItem, setEditItem] = useState({}); const handleAddItem = (e) => { e.preventDefault(); setItems([...items, { ...newItem, id: items.length + 1 }]); setNewItem({ name: '', quantity: '', price: '', category: '' }); }; const handleDeleteItem = (id) => { setItems(items.filter(item => item.id !== id)); }; const startEditing = (item) => { setEditingId(item.id); setEditItem(item); }; const saveEdit = (id) => { setItems(items.map(item => item.id === id ? editItem : item)); setEditingId(null); }; return (

Inventory Management System

{/* Add New Item Form */}

Add New Item

setNewItem({...newItem, name: e.target.value})} className="border rounded-md p-2" required /> setNewItem({...newItem, quantity: e.target.value})} className="border rounded-md p-2" required /> setNewItem({...newItem, price: e.target.value})} className="border rounded-md p-2" required /> setNewItem({...newItem, category: e.target.value})} className="border rounded-md p-2" required />
{/* Inventory Table */}
{items.map(item => ( ))}
Name Quantity Price Category Actions
{editingId === item.id ? ( setEditItem({...editItem, name: e.target.value})} className="border rounded p-1 w-full" /> ) : item.name} {editingId === item.id ? ( setEditItem({...editItem, quantity: e.target.value})} className="border rounded p-1 w-full" /> ) : item.quantity} {editingId === item.id ? ( setEditItem({...editItem, price: e.target.value})} className="border rounded p-1 w-full" /> ) : `$${item.price}`} {editingId === item.id ? ( setEditItem({...editItem, category: e.target.value})} className="border rounded p-1 w-full" /> ) : item.category}
{editingId === item.id ? ( <> ) : ( <> )}
); }