Uploaded images not showing in mysql table PHP BLOB

Question

Update: I have uploaded images using PHP BLOB, but they are not showing up in mysql table. Images are being moved to the destination folder but are not showing up in table. and when I fetch the images this code nothing shows up

Code for uploading images

      <?php
        if (isset($_POST['add_p'])) {
            @$pn = $_POST['pname'];
            @$pp = $_POST['pprice'];
            @$pc = $_POST['pcategory'];
            @$date = date('d-m-y H:i:s');
            $img = $_FILES['img']['name'];
            $tmp_img = $_FILES['img']['tmp_name'];
            move_uploaded_file($tmp_img, "uploads/$img");
            $insert = "INSERT INTO products (`p_name`, `p_price`, `img`, `p_category`, `date_added`) VALUES ('$pn', '$pp', '$img', '$pc', '$date')";
            mysqli_query($con, $insert);
      }
    ?>
    <form action="add-product.php" method="POST" class="form">                                 
      Name: <input class="inpt" type="text" name="pname">
      Price: <input class="inpt" type="text" name="pprice">
      Upload Image: <input class="inpt" type="file" name="img">
      Select Category
            <select class="inpt" name="pcategory">
                <option>Men</option>
                <option>Women</option>
                <option>Kids</option>
            </select>
      <input type="submit" name="add_p" value="Add Product">
     </form>

Code for fetching images

     <?php 
        $get = "SELECT * FROM products ORDER BY p_id DESC LIMIT 0,4";
        $query = mysqli_query($con, $get);
        while ($row = mysqli_fetch_array($query)) {
            echo $id = $row['p_id'];
            echo $n = $row['p_name'];
            echo $p = $row['p_price'];
            echo $c = $row['p_category']; 
            echo $i = $row['img'];
        }
     ?>

score 1 · Accepted Answer · edited May 23 '17 at 11:51

1

Add enctype='multipart/form-data' to your form to support file uploads:

<form action="add-product.php" method="POST" class="form" enctype="multipart/form-data">

See this answer for more details on encoding types for HTML forms.

edited May 23 '17 at 11:51

Community

1
1

answered Jul 24 '15 at 10:42

Ben

8,894
7
44
80

Thanks, how dumb of me to miss that little part – Radioactive Jul 24 '15 at 10:45
Glad I could help! If it was the solution, don't forget to mark it as the answer! – Ben Jul 24 '15 at 10:51

Uploaded images not showing in mysql table PHP BLOB

1 Answers1