在mysql中存储图像路径，在文件夹中存储图像

Question

It always echo "image path saved" but nothing gets saved

I've also tested the connection and it connecting normally

I've searched and the only results that I get is using "mysql_connect" which soon will be removed

//I do not get errors in this code

  //submiting form
    if(isset($_POST['submit']))
    {   
     //connecting ot db
     $con = mysqli_connect('localhost', '', '',       '');

            //naming and saving into a folder
            $filetmp = $_FILES["file_img"]["tmp_name"];
            $filename = $_FILES["file_img"]["name"];
            $filetype = $_FILES["file_img"]["type"];
            $filepath = "article_images/".$filename;


            // insert path into db -but nothing gets done
            move_uploaded_file($filetmp,$filepath);
            $query = "INSERT INTO 'Article' ('img_name','img_path','img_type') VALUES ('$filename','$filepath','$filetype')";
            if($query)
            {
                echo "image path saved";
            } else {
                echo "nothing saved";
            }enter code here



        }

?> enter code here

the form works fine but can't see what is wrong

Answer 1

Execute your insert query

So, your code will be like this:

$query = mysqli_query($con, "INSERT INTO 'Article' ('img_name','img_path','img_type') VALUES ('$filename','$filepath','$filetype')");

Note: Hash Image name before inserting it to database.