无法在phpMyAdmin中添加图像路径

Question

I was just working on my PHP website and I need database for that, so I was trying to insert image path to phpMyAdmin.

But I am unable to add path because I don't know the exact syntax for image path and also when I am trying to insert image path.

I can't see empty column instead of that. I am watching something like binary and choose file, as you can see in image.

Answer 1

Its good to save files / images in folders and just save their name in database.

<input type="file" name="photo">


$tmpFile = $_FILES['file']['tmp_name'];
$newFile = $_FILES['file']['name'];
move_uploaded_file($tmpFile, '/images/'.$newFile);

$query = "update users set photo = '$newFile' where id = '$userId'";

Here I assume that we are going to upload profile photo of users and saving file in images folder. Also, updating file name in database record.