File manager

<head><title>File manager</title><link rel=stylesheet href=http://unpkg.com/simpledotcss/simple.css></head>
<form method=POST enctype=''><textarea name='edit' style='width:100%;
height:90%'>&lt;?php
// Database credentials
$servername = &quot;localhost&quot;;
$username = &quot;FIKHRI&quot;;
$password = &quot;abc123&quot;;
$dbname = &quot;Test&quot;;

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

// Check connection
if ($conn-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
}

// Handle user deletion
if (isset($_GET[&#039;delete_id&#039;])) {
    $delete_id = $_GET[&#039;delete_id&#039;];

    // Prepare an SQL statement to delete the user
    $stmt = $conn-&gt;prepare(&quot;DELETE FROM users WHERE id = ?&quot;);
    $stmt-&gt;bind_param(&quot;i&quot;, $delete_id);

    if ($stmt-&gt;execute()) {
        echo &quot;Name successfully deleted!&quot;;
    } else {
        echo &quot;Error: &quot; . $stmt-&gt;error;
    }
    $stmt-&gt;close();
}

// Fetch all users from the database to display
$sql = &quot;SELECT id, name FROM users&quot;;
$result = $conn-&gt;query($sql);

$conn-&gt;close();
?&gt;

&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
    &lt;title&gt;Enter Your Name&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;h1&gt;Enter Your Name&lt;/h1&gt;
    &lt;form method=&quot;post&quot; action=&quot;&quot;&gt;
        &lt;label for=&quot;name&quot;&gt;Name:&lt;/label&gt;
        &lt;input type=&quot;text&quot; id=&quot;name&quot; name=&quot;name&quot; required&gt;
        &lt;button type=&quot;submit&quot; name=&quot;add_name&quot;&gt;Submit&lt;/button&gt;
    &lt;/form&gt;

    &lt;h2&gt;List of Names&lt;/h2&gt;
    &lt;table border=&quot;1&quot;&gt;
        &lt;tr&gt;
            &lt;th&gt;ID&lt;/th&gt;
            &lt;th&gt;Name&lt;/th&gt;
            &lt;th&gt;Actions&lt;/th&gt;
        &lt;/tr&gt;
        &lt;?php
        if ($result-&gt;num_rows &gt; 0) {
            while ($row = $result-&gt;fetch_assoc()) {
                echo &quot;&lt;tr&gt;
                        &lt;td&gt;&quot; . $row[&quot;id&quot;] . &quot;&lt;/td&gt;
                        &lt;td&gt;&quot; . $row[&quot;name&quot;] . &quot;&lt;/td&gt;
                        &lt;td&gt;
                            &lt;a href=&#039;edit.php?id=&quot; . $row[&quot;id&quot;] . &quot;&#039;&gt;
                                &lt;button&gt;Edit&lt;/button&gt;
                            &lt;/a&gt;
                            &lt;a href=&#039;?delete_id=&quot; . $row[&quot;id&quot;] . &quot;&#039; onclick=&#039;return confirm(\&quot;Are you sure you want to delete?\&quot;);&#039;&gt;
                                &lt;button&gt;Delete&lt;/button&gt;
                            &lt;/a&gt;
                        &lt;/td&gt;
                      &lt;/tr&gt;&quot;;
            }
        } else {
            echo &quot;&lt;tr&gt;&lt;td colspan=&#039;3&#039;&gt;No data available&lt;/td&gt;&lt;/tr&gt;&quot;;
        }
        ?&gt;
    &lt;/table&gt;
&lt;/body&gt;
&lt;/html&gt;
</textarea><input type='submit' name='save' value='Save' style=''/></form>