phpLiteAdmin - 添加图像

Question

An application I am presently working on requires an SQLite database. As I will not be the one actually maintaining the database I believe it would be tremendously beneficial to use a tool such phpLiteAdmin. However, I need a way to store an image as a blob in the table (I know there are some pitfalls with storing the actual image data in the database, but for my purposes I believe it is the best approach). Is there any way to do so with a GUI tool such as phpLiteAdmin or not? Could I somehow write a custom function to implement this behavior if it is available by default?

Thanks so much!

Answer 1

As alternative, you could store image's file name in a char type column. For example, there is a column img_filename in your table. Then you can simply show the image in HTML with <img src='...'> tag:

<?php

// your database query here
// ...

print "<img src='".$row['img_filename']."' />"


?>