
Explore full product details below
ACE.
Category: Reagents
₹0.00
Features | <?php\r\nsession_start();\r\ninclude \'db.php\'; // Include your database connection\r\n\r\n// Security: Session timeout after 3 minutes (180 seconds) of inactivity\r\n$timeoutDuration = 180;\r\nif (isset($_SESSION[\'LAST_ACTIVITY\']) && (time() - $_SESSION[\'LAST_ACTIVITY\']) > $timeoutDuration) {\r\n session_unset();\r\n session_destroy();\r\n // Redirect to login with a timeout message\r\n header(\'Location: login.php?timeout=1\');\r\n exit();\r\n}\r\n// Update the timestamp of the last activity\r\n$_SESSION[\'LAST_ACTIVITY\'] = time();\r\n\r\n// Security: Check if admin is logged in\r\nif (!isset($_SESSION[\'admin_logged_in\']) || $_SESSION[\'admin_logged_in\'] !== true) {\r\n header(\'Location: login.php\');\r\n exit();\r\n}\r\n\r\n// Logout logic\r\nif (isset($_GET[\'action\']) && $_GET[\'action\'] == \'logout\') {\r\n session_unset();\r\n session_destroy();\r\n header(\'Location: login.php\');\r\n exit();\r\n}\r\n\r\n// Initialize a message variable\r\n$message = \"\";\r\n\r\n// Check if the form was submitted\r\nif ($_SERVER[\'REQUEST_METHOD\'] == \'POST\') {\r\n // Sanitize and get form data\r\n $product_id = mysqli_real_escape_string($conn, $_POST[\'product_id\']);\r\n $features = mysqli_real_escape_string($conn, $_POST[\'features\']);\r\n $usage = mysqli_real_escape_string($conn, $_POST[\'usage\']);\r\n $packaging = mysqli_real_escape_string($conn, $_POST[\'packaging\']);\r\n $shelf_life = mysqli_real_escape_string($conn, $_POST[\'shelf_life\']);\r\n\r\n // SQL query to UPDATE data into the correct table named \'products\'\r\n // \'usage\' is a keyword, so it is escaped using backticks (`)\r\n $sql = \"UPDATE products SET features = ?, `usage` = ?, packaging = ?, shelf_life = ? WHERE id = ?\";\r\n \r\n // Prepare the statement for security (prevents SQL injection)\r\n $stmt = mysqli_prepare($conn, $sql);\r\n \r\n // Check if the statement was prepared successfully\r\n if ($stmt) {\r\n // Bind the parameters to the statement\r\n mysqli_stmt_bind_param($stmt, \"ssssi\", $features, $usage, $packaging, $shelf_life, $product_id);\r\n\r\n // Execute the statement and check for success\r\n if (mysqli_stmt_execute($stmt)) {\r\n $message = \"<div style=\'background-color: #d4edda; color: #155724; padding: 15px; border: 1px solid #c3e6cb; border-radius: 8px; margin-bottom: 20px; text-align: center;\'>Details added successfully!</div>\";\r\n } else {\r\n $message = \"<div style=\'background-color: #f8d7da; color: #721c24; padding: 15px; border: 1px solid #f5c6cb; border-radius: 8px; margin-bottom: 20px; text-align: center;\'>Error adding details: \" . mysqli_error($conn) . \"</div>\";\r\n }\r\n // Close the statement\r\n mysqli_stmt_close($stmt);\r\n } else {\r\n $message = \"<div style=\'background-color: #f8d7da; color: #721c24; padding: 15px; border: 1px solid #f5c6cb; border-radius: 8px; margin-bottom: 20px; text-align: center;\'>Failed to prepare database query.</div>\";\r\n }\r\n}\r\n\r\n// Fetch all products from the database to populate the dropdown\r\n$sql = \"SELECT id, name FROM products ORDER BY name ASC\";\r\n$result = mysqli_query($conn, $sql);\r\n\r\n?>\r\n<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\" />\r\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\"/>\r\n <title>Add Product Details - SMD MEDICARE</title>\r\n <link rel=\"stylesheet\" href=\"css/style.css\" />\r\n <link href=\"https://fonts.googleapis.com/css2?family=Poppins:wght@400;600&display=swap\" rel=\"stylesheet\">\r\n <style>\r\n * { box-sizing: border-box; }\r\n\r\n body {\r\n font-family: \'Poppins\', sans-serif;\r\n background-color: #f4f8fb;\r\n margin: 0;\r\n padding: 0;\r\n display: flex;\r\n flex-direction: column;\r\n min-height: 100vh;\r\n }\r\n\r\n .navbar {\r\n background-color: #fff;\r\n padding: 15px 30px;\r\n display: flex;\r\n align-items: center;\r\n justify-content: space-between;\r\n box-shadow: 0 2px 6px rgba(0,0,0,0.1);\r\n }\r\n\r\n .navbar img { height: 50px; }\r\n\r\n .navbar ul {\r\n list-style: none;\r\n display: flex;\r\n gap: 25px;\r\n margin: 0;\r\n padding: 0;\r\n }\r\n\r\n .navbar ul li a {\r\n color: #00bcd4;\r\n text-decoration: none;\r\n font-weight: 600;\r\n transition: all 0.3s ease;\r\n }\r\n \r\n .navbar ul li .logout-btn {\r\n background-color: #ff5722;\r\n color: white;\r\n padding: 8px 15px;\r\n border-radius: 8px;\r\n text-decoration: none;\r\n font-weight: 600;\r\n }\r\n \r\n .navbar ul li .logout-btn:hover {\r\n background-color: #e64a19;\r\n color: white;\r\n border-bottom: none;\r\n }\r\n\r\n .navbar ul li a:hover,\r\n .navbar ul li a.active {\r\n color: #0097a7;\r\n border-bottom: 2px solid #0097a7;\r\n }\r\n\r\n .hero-section {\r\n background: linear-gradient(to right, #00c9a7, #00b5ef);\r\n color: white;\r\n padding: 60px 20px;\r\n text-align: center;\r\n }\r\n\r\n .main-content {\r\n flex-grow: 1;\r\n padding: 40px 20px;\r\n width: 90%;\r\n max-width: 800px;\r\n margin: 20px auto;\r\n background-color: #fff;\r\n border-radius: 12px;\r\n box-shadow: 0 5px 15px rgba(0, 0, 0, 0.1);\r\n }\r\n\r\n .main-content h1 {\r\n color: #333;\r\n margin-bottom: 20px;\r\n text-align: center;\r\n }\r\n \r\n .form-group {\r\n margin-bottom: 20px;\r\n }\r\n\r\n .form-group label {\r\n display: block;\r\n margin-bottom: 8px;\r\n font-weight: 600;\r\n color: #555;\r\n }\r\n\r\n .form-group select,\r\n .form-group input[type=\"text\"],\r\n .form-group textarea {\r\n width: 100%;\r\n padding: 12px;\r\n border: 1px solid #ddd;\r\n border-radius: 8px;\r\n font-size: 16px;\r\n transition: border-color 0.3s ease;\r\n }\r\n\r\n .form-group select:focus,\r\n .form-group input[type=\"text\"]:focus,\r\n .form-group textarea:focus {\r\n border-color: #00bcd4;\r\n outline: none;\r\n }\r\n \r\n .form-group textarea {\r\n min-height: 120px;\r\n resize: vertical;\r\n }\r\n\r\n .btn-submit {\r\n width: 100%;\r\n padding: 15px;\r\n background-color: #00bcd4;\r\n color: white;\r\n border: none;\r\n border-radius: 8px;\r\n font-weight: 600;\r\n font-size: 18px;\r\n cursor: pointer;\r\n transition: background-color 0.3s ease;\r\n }\r\n\r\n .btn-submit:hover {\r\n background-color: #0097a7;\r\n }\r\n \r\n footer {\r\n text-align: center;\r\n padding: 20px;\r\n background-color: #00bcd4;\r\n color: white;\r\n margin-top: auto;\r\n font-size: 1em;\r\n }\r\n </style>\r\n</head>\r\n<body>\r\n\r\n<!-- Navbar -->\r\n<header class=\"navbar\">\r\n <div class=\"logo\">\r\n <a href=\"index.php\">\r\n <img src=\"images/SMD MEDICARE.jpeg\" alt=\"SMD MEDICARE Logo\" />\r\n </a>\r\n </div>\r\n <nav>\r\n <ul>\r\n <li><a href=\"index.php\">Home</a></li>\r\n <li><a href=\"products.php\">Products</a></li>\r\n <li><a href=\"admin.php\" class=\"active\">Admin</a></li>\r\n <li><a href=\"contact.php\">Contact</a></li>\r\n <li><a href=\"?action=logout\" class=\"logout-btn\">Logout</a></li>\r\n </ul>\r\n </nav>\r\n</header>\r\n\r\n<!-- Hero Section -->\r\n<section class=\"hero-section\">\r\n <h1>Add Product Additional Details</h1>\r\n <p>Select a product and add its additional details below.</p>\r\n</section>\r\n\r\n<!-- Main Content Section -->\r\n<section class=\"main-content\">\r\n <?php echo $message; // Display success or error message here ?>\r\n <form action=\"admin2.php\" method=\"POST\">\r\n \r\n <div class=\"form-group\">\r\n <label for=\"product_id\">Select Product:</label>\r\n <select id=\"product_id\" name=\"product_id\" required>\r\n <option value=\"\">-- Select Product --</option> <!-- Select Product -->\r\n <?php\r\n if ($result && mysqli_num_rows($result) > 0) {\r\n while ($row = mysqli_fetch_assoc($result)) {\r\n echo \'<option value=\"\' . htmlspecialchars($row[\'id\']) . \'\">\' . htmlspecialchars($row[\'name\']) . \'</option>\';\r\n }\r\n } else {\r\n echo \'<option value=\"\">No products found</option>\';\r\n }\r\n ?>\r\n </select>\r\n </div>\r\n\r\n <div class=\"form-group\">\r\n <label for=\"features\">Features:</label>\r\n <textarea id=\"features\" name=\"features\" required></textarea>\r\n </div>\r\n\r\n <div class=\"form-group\">\r\n <label for=\"usage\">Usage:</label>\r\n <textarea id=\"usage\" name=\"usage\" required></textarea>\r\n </div>\r\n\r\n <div class=\"form-group\">\r\n <label for=\"packaging\">Packaging:</label>\r\n <input type=\"text\" id=\"packaging\" name=\"packaging\" required>\r\n </div>\r\n\r\n <div class=\"form-group\">\r\n <label for=\"shelf_life\">Shelf Life:</label>\r\n <input type=\"text\" id=\"shelf_life\" name=\"shelf_life\" required>\r\n </div>\r\n \r\n <button type=\"submit\" class=\"btn-submit\">Add Details</button>\r\n\r\n </form>\r\n</section>\r\n\r\n\r\n<!-- Footer -->\r\n<footer>\r\n <div style=\"display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 20px; max-width: 1200px; margin: auto;\">\r\n <div>\r\n <h4>About Us</h4>\r\n <p>SMD MEDICARE – Specializing in raw materials (monoclonal antibodies & antigens), rapid test kits, positive human serum, ELISA kits, biochemistry reagents & medical equipment — trusted partners in diagnostics for 10+ years.</p>\r\n </div>\r\n <div>\r\n <h4>Quick Links</h4>\r\n <p><a href=\"index.php\">Home</a></p>\r\n <p><a href=\"products.php\">Products</a></p>\r\n <p><a href=\"contact.php\">Contact</a></p>\r\n </div>\r\n <div>\r\n <h4>Contact Info</h4>\r\n <p><strong>Hours:</strong> Monday–Saturday, 9:00 AM – 6:00 PM</p>\r\n <p><strong>Address:</strong> Shakumbari Vihar, Phase 2, Ganeshpur, Roorkee, Haridwar – 247667</p>\r\n <p><strong>Phone:</strong> <a href=\"tel:+919555422455\">+91 95554 22455</a></p>\r\n <p><strong>Email:</strong> <a href=\"mailto:rahul@smdmedicare.com\">rahul@smdmedicare.com</a></p>\r\n </div>\r\n </div>\r\n <div style=\"text-align: center; padding-top: 20px; font-weight: bold;\">\r\n © <?= date(\"Y\") ?> SMD MEDICARE | All Rights Reserved\r\n </div>\r\n</footer>\r\n\r\n</body>\r\n</html>\r\n |
---|---|
Usage | hospital use |
Packaging | 1 pcs per box |
Shelf Life | N/A |