无法在phpMyAdmin中添加图像路径
问题描述:
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.
答
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.