Server : Apache System : Linux server1.cgrithy.com 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64 User : nobody ( 99) PHP Version : 8.1.23 Disable Function : NONE Directory : /home/dnlcambodia/www/dnl_dashboard/Service/ |
<?php // Check if the ID parameter is set if (isset($_GET['id'])) { $id = $_GET['id']; // Connect to the database include '../PHP/config/db_conn.php'; // Prepare and bind the select statement $stmt = $conn->prepare("SELECT * FROM service WHERE id = ?"); $stmt->bind_param("i", $id); // Execute the statement $stmt->execute(); // Get the result $result = $stmt->get_result(); // Check if a service was found if ($result->num_rows > 0) { $row = $result->fetch_assoc(); $title = $row['title']; // Define the $title variable $content = $row['content']; // Define the $content variable $imagePath = $row['image']; // Define the $imagePath variable // Close statement and connection $stmt->close(); $conn->close(); } else { echo "Service not found"; exit(); } } else { echo "No ID provided"; exit(); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Update Service</title> <!-- Include Quill stylesheet --> <link href="https://cdn.quilljs.com/1.3.6/quill.snow.css" rel="stylesheet"> <style> body { font-family: Arial, sans-serif; margin: 0; padding: 0; background-color: #f4f4f4; } .upload-form { max-width: 600px; margin: 20px auto; padding: 20px; background-color: #fff; border-radius: 5px; box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1); } .title { text-align: center; color: #333; } form { margin-top: 20px; } label { font-weight: bold; } input[type="text"], input[type="file"], input[type="submit"] { width: 100%; padding: 10px; margin-top: 5px; border: 1px solid #ccc; border-radius: 5px; box-sizing: border-box; } #editor { border: 1px solid #ccc; border-radius: 5px; margin-top: 5px; } .img-container { margin-top: 5px; } .img-container img { max-width: 200px; max-height: 200px; border: 1px solid #ccc; border-radius: 5px; margin-top: 5px; } </style> </head> <body> <div class="upload-form"> <h3 class="title">Update Service</h3> <form action="process_update.php" method="POST" enctype="multipart/form-data"> <label for="title">Title:</label><br> <input type="text" id="title" name="title" value="<?php echo $title; ?>" required><br><br> <label for="content">Content:</label><br> <div id="editor" style="height: 300px;"><?php echo $content; ?></div> <input type="hidden" id="content" name="content" value="<?php echo $content; ?>"><br><br> <label for="existing_image">Existing Image:</label><br> <div class="img-container"> <?php $imagePath = $row['image']; if (!empty($imagePath)) { echo '<img src="' . $imagePath . '" alt="Existing Image" style="max-width: 200px; max-height: 200px;"><br>'; } else { echo '<p>No image available for this project.</p>'; } ?> </div> <!-- File Upload for Images --> <label for="file">New Image Upload:</label> <input type="file" id="file" name="file" accept="image/*"><br> <input type="hidden" id="id" name="id" value="<?php echo $id; ?>"> <input type="submit" value="Update"> </form> </div> <!-- Include the Quill library --> <script src="https://cdn.quilljs.com/1.3.6/quill.js"></script> <script> var quill = new Quill('#editor', { theme: 'snow', modules: { toolbar: [ [{ 'header': '1' }, { 'header': '2' }, { 'font': [] }], [{ 'size': [] }], ['bold', 'italic', 'underline', 'strike', 'blockquote'], [{ 'list': 'ordered' }, { 'list': 'bullet' }], ['link', 'image', 'video'], ['clean'] ] } }); // Get the content of the Quill editor and set it to the hidden input field var form = document.querySelector('form'); form.onsubmit = function() { var content = document.querySelector('#editor .ql-editor').innerHTML; document.querySelector('#content').value = content; }; </script> </body> </html>