Can I create gallery in DB?

  • Resolved tnorebel

    (@tnorebel)


    5 years, 11 months ago

    Hello. Congrats for the wornderful gallery. I actually use it in a fiew pages on my site. I am thinking on using it more but I have a question: can I create galleries through database? I have taken a look to the table in mysql and looks quite simple… I need to create more than 100 different galleries. Doing it manually would be a lot of time so I was thinking creating them in the database.

    Thanks for your help!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello tnorebel

    I don’t know if you found the answer
    I already did that because 140 gallery to create, one french and the second in english.
    For that, I create the 2 first in Word Press (One in to french and the 2nd to english). I choose all the parameters.

    After I use Excel for the name of the galleries. It’s more easy with excel to create all the creations.

    It’s a simple request
    insert into TQBDYVrUFinalTiles_gallery (configuration) select replace( configuration, ‘NAME_GALLERIE_FR_1’, ‘NAME_OF_NEW_GALLERY_FR’) from TQBDYVrUFinalTiles_gallery where id = 1;
    As I have 2 kind of galleries, I had a 2nd request :
    insert into TQBDYVrUFinalTiles_gallery (configuration) select replace( configuration, ‘NAME_GALLERIE_EN_2’, ‘NAME_OF_NEW_GALLERY_EN’) from TQBDYVrUFinalTiles_gallery where id = 2;
    With that, all the galleries have the same parameters.

    That’s all
    Frederic

    • This reply was modified 5 years, 7 months ago by fredericsant.
    Thread Starter tnorebel

    (@tnorebel)

    @fredericsant thank you very much for your reply. I finally did not do the gallery in database, but is a good thing to know for the future. Have a good day! ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can I create gallery in DB?’ is closed to new replies.