duannei0044 2017-01-07 09:41
浏览 518
已采纳

无法在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.

enter image description here

  • 写回答

1条回答 默认 最新

  • dongyangben6144 2017-01-10 12:28
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?