How use while loop image from the Directory inserting a record into Database in MYSQL Script

Asked May 30 '17 at 06:08

Active May 30 '17 at 06:08

Viewed 47 times

I am inserting an image from directory into Database:

Here's my attempt and this is working, but it only insert one record at a time:

insert into tbl_image(image) values(LOAD_FILE('E:/EDITED/Studio Session-012.jpg'))

I need to insert all images from edited folder together with each image name.

I am thinking that i need something like a loop to that folder so that i could get all images and insert into database.

Is this possible?

All Suggestions is appreciated.

Thanks in advance.

asked May 30 '17 at 06:08

redzsol

You can follow this link https://stackoverflow.com/questions/2059891/php-get-list-of-all-filenames-contained-within-my-images-directory – Web Artisan May 30 '17 at 06:10
I'd be sorely tempted to use a bit of application level code for this – Strawberry May 30 '17 at 06:12
Thanks for the comments.. @Bikash it is a PHP code. – redzsol May 30 '17 at 06:13
Yes. You can loop for each images and insert into table – Web Artisan May 30 '17 at 06:16
But i need MYSQL SCRIPT. – redzsol May 30 '17 at 06:17

0 Answers0