php


<!DOCTYPE html>
<html>
<body>

<form action="index.php" method="post" enctype="multipart/form-data">
    Select File/s
    <input type="file" name="fileToUpload" id="fileToUpload"> <br />
Or Input Files

    <input type="text" value="" name="inputFile" id="inputFile"><br />
    <input type="submit" value="Add File" name="add">

</form>

</body>
</html>

<?php

if(isset($_POST["add"])) {

    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "curl";

    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }


    function displayResult(){
        $servername = "localhost";
        $username = "root";
        $password = "";
        $dbname = "curl";

        $conn = mysqli_connect($servername, $username, $password, $dbname);
        if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        }
            $result = mysqli_query($conn,"SELECT server_filename FROM server_files");

            echo "<table border='1'>
            <tr>
            <th>File Name</th>
            <th>Delete</th>
            </tr>";

            while($row = mysqli_fetch_array($result))
            {
            echo "<tr>";
            echo "<td>" . $row['server_filename'] . "</td>";
            echo "<td> <input type=\"button\" value=\"Remove\" name=\"remove\" id=\"remove\"> </td>";
            echo "</tr>";
            }
            echo "</table>";
            if(isset($_GET["remove"])){
                echo "lol";
            }
            mysqli_close($conn);
    }


    $userInput = $_POST["inputFile"];
    if(!empty($userInput)){
        $getExt = "SELECT exe_id FROM static_exe LIMIT 1";
        $result = mysqli_query($conn, $getExt);
        if (mysqli_num_rows($result) > 0) {
            while($row = mysqli_fetch_assoc($result)) {
                $commonID =  $row["exe_id"];
               // echo $commonID;
            }
        $insertuserinput = "INSERT INTO server_files (server_exename, server_filename)VALUES ('$commonID', '$userInput')";
        if (mysqli_query($conn, $insertuserinput)) {
            //success
        } else {
            echo "Error: " . $insertuserinput . "<br>" . mysqli_error($conn);
        }
        } else {
            echo "0 results";
        }

        mysqli_close($conn);

    displayResult();

    }
    elseif($_FILES["fileToUpload"]["name"]!=''){
        $target_dir = "uploads/";
        $target_file = basename($_FILES["fileToUpload"]["name"]);
        $dispfilename = pathinfo($target_dir . $target_file);
        $server_filename = $dispfilename['filename'];
        $server_exename =  pathinfo($target_file,PATHINFO_EXTENSION);

        //echo $server_exename . "<br />" . $server_filename . "<br />";
        $sql = "INSERT INTO server_files (server_exename, server_filename)VALUES ('$server_exename', '$server_filename')";
        if (mysqli_query($conn, $sql)) {
            //success
        } else {
            echo "Error: " . $sql . "<br>" . mysqli_error($conn);
        }

        $sqldata = "SELECT server_filename FROM server_files";
        $result = mysqli_query($conn, $sqldata);
        if (mysqli_num_rows($result) > 0) {
            // output data of each row
            while($row = mysqli_fetch_assoc($result)) {
                $serverfilename =  $row["server_filename"];
            }
        } else {
            echo "0 results";
        }
        mysqli_close($conn);
          displayResult();

        }


        else{
            echo "Please do something";
        }


}
?>