Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/prasanthshunmugam.in/public_html

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: school.php

<?php
// Database credentials
$servername = "localhost"; // or the server hosting your database
$username = "u632480160_school";
$password = "Ariharan@2025";
$dbname = "u632480160_school";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to fetch all data from the school_ideas table
$sql = "SELECT * FROM school_ideas";
$result = $conn->query($sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>School Ideas Display</title>
    
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.3/css/jquery.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/2.3.4/css/buttons.dataTables.min.css">
    
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.3/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.4/js/dataTables.buttons.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.4/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.4/js/buttons.print.min.js"></script>

h1 {
            text-align: center;
            color: #333;
            margin-top: 20px;
        }

table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
        }

table, th, td {
            border: 1px solid #ddd;
        }

th, td {
            padding: 12px;
            text-align: left;
        }

th {
            background-color: #4CAF50;
            color: white;
        }

td {
            background-color: #fff;
        }

.dataTables_wrapper {
            margin: 0 auto;
            max-width: 1000px;
        }

.dataTables_length, .dataTables_filter {
            margin-bottom: 20px;
        }

.btn {
            padding: 10px 20px;
            background-color: #4CAF50;
            color: white;
            border: none;
            cursor: pointer;
            border-radius: 5px;
            margin: 10px 0;
        }

.btn:hover {
            background-color: #45a049;
        }

.signature-box {
            border: 1px solid #000;
            width: 150px;
            height: 30px;
            text-align: center;
            line-height: 30px;
            margin-top: 10px;
        }

.print-signature-box {
            width: 200px;
            height: 40px;
            border: 1px solid #000;
            margin-top: 15px;
            text-align: center;
            line-height: 40px;
        }

@media print {
            .dataTables_wrapper {
                display: none;
            }

.print-signature-box {
                width: 250px;
                height: 50px;
                border: 1px solid #000;
                margin-top: 15px;
                text-align: center;
                line-height: 50px;
                font-size: 16px;
            }
        }
    </style>
</head>
<body>
    <h1>School Ideas Display</h1>

<?php
    if ($result->num_rows > 0) {
        // Display the table with ID for DataTables to target
        echo "<table id='schoolIdeasTable' class='display'>
                <thead>
                    <tr>
                        <th>UDISE Code</th>
                        <th>District</th>
                        <th>School Name</th>
                        <th>Teacher Name</th>
                        <th>Team Name</th>
                        <th>Student Names</th>
                        <th>Title of Idea</th>
                        <th>Sign</th> 
                    </tr>
                </thead>
                <tbody>";

// Fetch and display each row
        while($row = $result->fetch_assoc()) {
            echo "<tr>
                    <td>" . $row['udise_code'] . "</td>
                    <td>" . $row['district'] . "</td>
                    <td>" . $row['school_name'] . "</td>
                    <td>" . $row['teacher_name'] . "</td>
                    <td>" . $row['team_name'] . "</td>
                    <td>" . $row['student_names'] . "</td>
                    <td>" . $row['title_of_idea'] . "</td>
                    <td><div class='signature-box'></div></td> 
                </tr>";
        }
        echo "</tbody>
            </table>";
    } else {
        echo "No data found!";
    }
    ?>

// Remove the "Sign" text and give an empty box
                            $(win.document.body).find('th:nth-child(8), td:nth-child(8)').each(function() {
                                $(this).html('<div class="print-signature-box"></div>');
                            });
                        }
                    }
                ]
            });
        });
    </script>
</body>
</html>

<?php
// Close the connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: school.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation