PHP MySQL Image table

Question

what is the best way to construct an image table in which each user has his own photo album. what I did so far is create a user table with id, username, name etc. fields. I am confused how to construct the image table which will contain all the photos of the users.

any suggestions

as a byte[] if it is possible. Then you just take the file stream and place it in a variable. After that you can use inside the image tag src attribute base 64 encoding. so that way your server script doesnt have to do any processing! This link may help you out! — Callum Linington
– Callum Linington, Commented Apr 19, 2014 at 14:38

Barmar · Accepted Answer · 2014-04-19 14:40:00Z

2

CREATE TABLE user_images (
    id INT AUTO_INCREMENT,
    user_id INT REFERENCES user (id),
    image_name VARCHAR(30) NOT NULL,
    image_data BLOB
);

answered Apr 19, 2014 at 14:40

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

PHP MySQL Image table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related