How to save an image to database using SQLite and PHP?

Question

I want to save an image to the database using SQLite. I send the image via <input type='file'> in HTML, get the file in the $_FILES var in PHP, and after this, what I should do?

I created a BLOB field in the database. Currently I'm using SQLite 2.1, because that is the limitation of my homework.

Should I convert an image to binary to store in a database or do something else?

You may want to consider storing the files on the filesystem, and then storing the image name/path in your database. Makes management easier down the road. — Ben Roux
– Ben Roux, Commented Jun 7, 2011 at 18:00
@yes: I would argue for it because it gives me full access to my image store without needed to go into a db and select bytes to save as an image. — Ben Roux
– Ben Roux, Commented Jun 7, 2011 at 18:30
@Ben: actually to get access to your image in your case you need Access to your DB then access your File System. While storing into DB you just need the access to DB — dynamic
– dynamic, Commented Jun 7, 2011 at 18:31

dynamic · Accepted Answer · 2011-06-07 17:58:36Z

2

you can do $image = file_get_contents( $_FILES['file']['tmp_name'] );

And then upload it into your blob column (of course it needs to be escaped before, PDO)

answered Jun 7, 2011 at 17:58

dynamic

48.2k56 gold badges163 silver badges236 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Renato Dinhani Over a year ago

I used an base64_encode to write the data to the database after this.

Collectives™ on Stack Overflow

How to save an image to database using SQLite and PHP?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related