Upload file pdf php mysql

HTML

<form method="post" enctype="multipart/form-data">

    <div class="form-input py-2">

        <div class="form-group">

          <input type="text" class="form-control" name="name"

                 placeholder="Enter your name" required>

        div>                                 

        <div class="form-group">

          <input type="file" name="pdf_file"

                 class="form-control" accept=".pdf"

                 title="Upload PDF"/>

        div>

        <div class="form-group">

          <input type="submit" class="btnRegister"

                 name="submit" value="Submit">

        div>

   div>

form>

Upload PDF files: Now we will see how we can upload PDF files to the database. In the below code, the first block verifies that the ‘submit’ button from the form has been clicked and it verifies that the ‘pdf_file’ field has an attachment using the PHP isset() function.

$_FILES is a two-dimensional associative global array of items that are being uploaded via the HTTP POST method. The move_uploaded_file() function is used to upload the pdf file to the server. We are passing 2 values, the temporary file name and the folder where the file will be stored. The files will be stored in the “GeeksForGeeks/pdf/ ” folder which we created earlier.

PHP

    if (isset($_POST['submit'])) {

        $name = $_POST['name'];

        if (isset($_FILES['pdf_file']['name']))

        {

          $file_name = $_FILES['pdf_file']['name'];

          $file_tmp = $_FILES['pdf_file']['tmp_name'];

          move_uploaded_file($file_tmp,"./pdf/".$file_name);

          $insertquery =

          "INSERT INTO pdf_data(username,filename) VALUES('$name','$file_name')";

          $iquery = mysqli_query($con, $insertquery);

        }

        else

        {

           ?>

        }

    }

?>

Creating HTML Table and displaying records:

We will fetch the records from the database and display them in the HTML table.

displaying records from the database

HTML code snippet: The HTML source code for the above HTML table is as follows.

HTML

<div class="card-body">

    <div class="table-responsive">

        <table>

            <thead>

                <th>IDth>

                <th>UserNameth>

                <th>FileNameth>

            thead>

            <tbody>

                php

                    $selectQuery = "select * from pdf_data";

                    $squery = mysqli_query($con, $selectQuery);

                    while (($result = mysqli_fetch_assoc($squery))) {

                ?>

                <tr>

                  <td>php echo $result['id']; ?>td>

                  <td>php echo $result['username']; ?>td>

                  <td>php echo $result['filename']; ?>td>

                tr>

                php

                    }

                ?>

            tbody>

        table>               

    div>

div>

PHP code:

Approach:

First, we are selecting all the columns from the table pdf_data and then execute the query in $squery.

$selectQuery = "select * from pdf_data"; 
$squery = mysqli_query($con, $selectQuery);

Next, we will use the while loop to fetch all the rows of the table and store the data in $result.

while (($result = mysqli_fetch_assoc($squery)))
{
    ...
}

The fetched data will now be displayed column-wise in the HTML table with the help of where ‘id‘ is the first column of our ‘pdf_data‘ table. Similarly, we can fetch the data for the respective columns from the table.