Upload image and save form data into a Mysql db using php

Question

I am writing a code where I can upload an image in a folder and save data form into a Mysql db. At the moment just Saving data form in a db table is working but I can't upload the image in a folder. This is the code:

    <?php

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

$file_name = $_FILES['image']['name'];
$file_type = $_FILES['image']['type'];      
$file_size = $_FILES['image']['size'];
$file_tmp_name  = $_FILES['image']['tmp_name'];

if($file_name){
            move_uploaded_file($file_tmp_name,"images/$file_name");

            }
}
?>
<?php
  include 'guestconfig/config.php';

if (isset($_POST['upload_img']) && $_POST['upload_img']=="invia")
{
        $image = $file_name;
        $title = addslashes($_POST['title']);
        $price = addslashes($_POST['price']);



  $sql = "INSERT INTO testone
(image,title,price) VALUES ('$image', '$title','$price')";
  if($result = mysql_query($sql) or die (mysql_error()))
  {
    echo "Inserimento avvenuto con successo.<br>
    Vai alla <a href=\"index.php\">Home Amministrazione</a>";
  }
}else{
  ?>
  <table border="1">
  <tr>
  <td>
  <img src="xxx.jpg" alt="xxx" />
  <img src="xxx.jpg" alt="xxx" />
  </td>

  </tr>
  <tr>
  <td>

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

<label>upload image </label><br>
<input type="file" name="image"><br>
<br><br>

title:
<input name="title" type="text"><br><br>

price:
<input name="price" type="text"><br><br>

<input name="upload_img" type="submit" value="invia">
</form>
</td>

</tr>
</table>
  <?php
}
?>
<br>

I hope you can help me. Thanks! :)

EDIT: Ok, now I can upload my image but I can't save the image name (before I could). How can I do it, please? Thanks! :)

EDIT2: Ok, now it's perfect... Thanks to everybody! :)

use this image upload code stackoverflow.com/questions/37320872/… — Devsi Odedra
– Devsi Odedra, Commented Jul 5, 2016 at 9:34
use enctype="multipart/form-data" instead of ctype="multipart/form-data" — Devsi Odedra
– Devsi Odedra, Commented Jul 5, 2016 at 9:36

halfer · Accepted Answer · 2019-08-22 21:03:33Z

1

First replace ctype="multipart/form-data" with enctype="multipart/form-data"

   if(!empty($file_name)){
                  if(move_uploaded_file($file_tmp_name,"images/".$file_name))
echo "image uploaded";
else  echo "image not uploaded";


                }

edited Aug 22, 2019 at 21:03

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jul 5, 2016 at 9:40

Passionate Coder

7,3042 gold badges24 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marci Over a year ago

Ok, I correct it :) but now why the image name is not saved in my db? Thanks again

Passionate Coder Over a year ago

@Marci why you have used addslashes function??

Vivek Singh · Accepted Answer · 2016-07-05 09:36:44Z

1

form tag must be like this

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

and in php you can do something like this

if(!empty($file_name)){
              move_uploaded_file($file_tmp_name,"images/".$file_name);
            }

answered Jul 5, 2016 at 9:36

Vivek Singh

2,4451 gold badge16 silver badges29 bronze badges

Comments

Anand Jain · Accepted Answer · 2016-07-05 09:42:21Z

1

You have error in form tag

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

answered Jul 5, 2016 at 9:42

Anand Jain

8192 gold badges12 silver badges32 bronze badges

Collectives™ on Stack Overflow

Upload image and save form data into a Mysql db using php

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related