'192.168.0.16', 'database' => 'lasucaai', 'username' => 'lasucaai', 'password' => 'is413#dfslw', ]; $connectionOptions = [ "Database" => $config['database'], "Uid" => $config['username'], "PWD" => $config['password'], "TrustServerCertificate" => true, "Encrypt" => false, ]; $conn = sqlsrv_connect($config['server'], $connectionOptions); if ($conn === false) { die("Connection failed: " . print_r(sqlsrv_errors(), true)); } $message = ''; $messageType = ''; // Handle form submissions if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_POST['action'])) { switch ($_POST['action']) { case 'update': $millId = intval($_POST['mill_id']); $displayName = trim($_POST['display_name']); $sortOrder = intval($_POST['sort_order']); $isActive = isset($_POST['is_active']) ? 1 : 0; $sql = "UPDATE mill_names SET display_name = ?, sort_order = ?, is_active = ? WHERE mill_id = ?"; $result = sqlsrv_query($conn, $sql, [$displayName, $sortOrder, $isActive, $millId]); if ($result) { $message = "Mill name updated successfully!"; $messageType = 'success'; } else { $message = "Error updating: " . print_r(sqlsrv_errors(), true); $messageType = 'error'; } break; case 'add': $millCode = trim($_POST['mill_code']); $displayName = trim($_POST['display_name']); $sortOrder = intval($_POST['sort_order']); $sql = "INSERT INTO mill_names (mill_code, display_name, sort_order) VALUES (?, ?, ?)"; $result = sqlsrv_query($conn, $sql, [$millCode, $displayName, $sortOrder]); if ($result) { $message = "Mill name added successfully!"; $messageType = 'success'; } else { $message = "Error adding: " . print_r(sqlsrv_errors(), true); $messageType = 'error'; } break; case 'delete': $millId = intval($_POST['mill_id']); $sql = "DELETE FROM mill_names WHERE mill_id = ?"; $result = sqlsrv_query($conn, $sql, [$millId]); if ($result) { $message = "Mill name deleted!"; $messageType = 'success'; } else { $message = "Error deleting: " . print_r(sqlsrv_errors(), true); $messageType = 'error'; } break; } } } // Fetch all mill names $sql = "SELECT * FROM mill_names ORDER BY sort_order, mill_code"; $result = sqlsrv_query($conn, $sql); $millNames = []; while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { $millNames[] = $row; } // Layout config $layoutWithoutSidebar = true; $layoutReturnUrl = 'milldata-dashboard.php'; $layoutCloseWindowLabel = 'Back to Dashboard'; $assetBasePath = '../'; include __DIR__ . '/../includes/layout/header.php'; ?>

🏭 Mill Names Admin

Mill Code Display Name Sort Order Status Actions

Add New Mill Name