PHP code doesn't upload name file into SQL

Question

I have some problems when I upload a picture, it uploads to the directory but in SQL it doesn't put the name, only puts 1 or 0

https://i.sstatic.net/KxSaO.jpg

In SQL, it's all in varchar(255).

   if(isset($_POST["submit"])) {
    $date=date("d/m/Y");

$target_dir = "../img/logo/";

  if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$target_dir.$_FILES['fileToUpload']['name'])){

    $insert=mysqli_query($db, "UPDATE logo SET img = '".basename($_FILES["fileToUpload"]["name"])."' AND  data_insercao = '".$date."'") or die("Error".mysqli_error());
    echo "<script>alert('Success!');</script>";
    echo "<meta http-equiv=\"refresh\" content=\"0;URL='index.php?pg=3'\" /> ";
    echo "<meta http-equiv=\"refresh\" content=\"0;URL='index.php?pg=3'\" /> ";
  }
}

SOLVED

What I did to change

$insert=mysqli_query($db, "UPDATE logo SET img = '".basename($_FILES["fileToUpload"]["name"])."', data_insercao = '".$date."'") or die("Error".mysqli_error());

Just had a comma instead of AND

be sure to that the variable type in DB of column 'img' is VAR_CHAR and not INT — Camilo Go Jr.
– Camilo Go Jr., Commented Mar 7, 2017 at 11:03
Try switching AND for , in your query. You could also build your query first, then echo it for testing purposes, then execute it. — JustBaron
– JustBaron, Commented Mar 7, 2017 at 11:11
@justbaron Thank you! Never thought it would be so easy to do. — Bruno Moutinho
– Bruno Moutinho, Commented Mar 7, 2017 at 11:13
@BrunoMoutinho added answer, feel free to accept and up-vote ;) — JustBaron
– JustBaron, Commented Mar 7, 2017 at 11:17

JustBaron · Accepted Answer · 2017-03-07 11:21:08Z

1

Switch AND for , in your query.

$insert=mysqli_query($db, "UPDATE logo SET img = '".basename($_FILES["fileToUpload"]["name"])."',  data_insercao = '".$date."'") or die("Error".mysqli_error());

Presumably, you are using this table for one image, hence no need for a WHERE clause.

edited Mar 7, 2017 at 11:21

answered Mar 7, 2017 at 11:14

JustBaron

2,3457 gold badges25 silver badges37 bronze badges

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

Comments

Nyc2x · Accepted Answer · 2017-03-07 11:15:23Z

1

Hope this might help:

$insert=mysqli_query($db, "UPDATE logo SET img = '".$_FILES["fileToUpload"]["name"]."', date = '$date'") or die("Error".mysqli_error());

p/s: You might want to put WHERE, just for reminder

answered Mar 7, 2017 at 11:15

Nyc2x

931 silver badge9 bronze badges

Comments

B. Desai · Accepted Answer · 2017-03-07 11:13:35Z

0

To update multiple columns use , instead of AND

 $insert=mysqli_query($db, "UPDATE logo SET img = '".basename($_FILES["fileToUpload"]["name"])."' , data_insercao = '".$date."'") or die("Error".mysqli_error());

answered Mar 7, 2017 at 11:13

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Comments

shashikant pandit · Accepted Answer · 2017-03-07 11:49:48Z

       if(isset($_POST["submit"])) {
        date_default_timezone_set('Asia/Calcutta'); 
    $date= date("Y-m-d H:i:s"); 

    $target_dir = "../img/logo/";

      if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$target_dir.$_FILES['fileToUpload']['name'])){

        $insert=mysqli_query($db, "UPDATE logo SET img = '".$_FILES["fileToUpload"]["name"]."', date = '$date'") or die("Error".mysqli_error());
        echo "<script>alert('Success!');</script>";
        echo "<meta http-equiv=\"refresh\" content=\"0;URL='index.php?pg=3'\" /> ";
        echo "<meta http-equiv=\"refresh\" content=\"0;URL='index.php?pg=3'\" /> ";
      }
    }

use date time with second because sum time file name is same and date also so file will overwrite in image folder.

Collectives™ on Stack Overflow

PHP code doesn't upload name file into SQL

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related