Severity: Notice
Message: Only variable references should be returned by reference
Filename: core/Common.php
Line Number: 257
<table> <thead> <tr> <th>Title</th> <th>Description</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php while ($row = mysqli_fetch_assoc($result)) { ?> <tr> <td><?php echo $row['title']; ?></td> <td><?php echo $row['description']; ?></td> <td><?php echo $row['status']; ?></td> <td> <a href="edit_work_order.php?id=<?php echo $row['id']; ?>">Edit</a> <a href="delete_work_order.php?id=<?php echo $row['id']; ?>">Delete</a> </td> </tr> <?php } ?> </tbody> </table>
<?php // Connect to the database $conn = mysqli_connect('localhost', 'username', 'password', 'database');
mysqli_close($conn); ?>
// Login user if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $_POST['username']; $password = $_POST['password']; Simple Work Order Management System Nulled Php
// Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }
// Create work order if ($_SERVER["REQUEST_METHOD"] == "POST") { $title = $_POST['title']; $description = $_POST['description'];
CREATE TABLE work_orders ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, description TEXT NOT NULL, status VARCHAR(50) NOT NULL DEFAULT 'pending', assigned_to INT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (assigned_to) REFERENCES users(id) ); ?php echo $row['title']
$query = "INSERT INTO work_orders (title, description) VALUES ('$title', '$description')"; mysqli_query($conn, $query);
// Register user if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $_POST['username']; $password = $_POST['password']; $email = $_POST['email'];
// Delete work order $id = $_GET['id']; $query = "DELETE FROM work_orders WHERE id = '$id'"; mysqli_query($conn, $query); ?php echo $row['description']
<form action="" method="post"> <input type="hidden" name="id" value="<?php echo $row['id']; ?>"> <input type="text" name="title" value="<?php echo $row['title']; ?>"> <textarea name="description"><?php echo $row['description']; ?></textarea> <button type="submit">Update Work Order</button> </form> Create a delete_work_order.php file to handle deleting work orders:
<?php // Connect to the database $conn = mysqli_connect('localhost', 'username', 'password', 'database');
?>
// Get work order details $id = $_GET['id']; $query = "SELECT * FROM work_orders WHERE id = '$id'"; $result = mysqli_query($conn, $query); $row = mysqli_fetch_assoc($result);
if (mysqli_num_rows($result) > 0) { // Start session and redirect to dashboard session_start(); $_SESSION['user_id'] = $result->fetch_assoc()['id']; header('Location: dashboard.php'); exit; } else { echo "Invalid username or password"; } }