Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Manually classifying images in an sql database?

  • 03-12-2013 01:26PM
    #1
    [Deleted User]
    Posts: 18,046 ✭✭✭✭


    I have this idea.. I have a folder full of images. I'd like to show these images locally in a webpage and beside each one, there's drop down menus for what each image contains. These drop downs edit an sql table with the info and filename.

    In the future, I could run queries on this database and show images.

    Any basic code for doing this? Or a good pointer at a tutorial? I saw my friend do it once with php but we've fallen out of touch.


Comments

  • #2
    TonyStark
    Registered Users, Registered Users 2 Posts: 851 ✭✭✭TonyStark


    Deleted User wrote: »
    I have this idea.. I have a folder full of images. I'd like to show these images locally in a webpage and beside each one, there's drop down menus for what each image contains. These drop downs edit an sql table with the info and filename.

    In the future, I could run queries on this database and show images.

    Any basic code for doing this? Or a good pointer at a tutorial? I saw my friend do it once with php but we've fallen out of touch.

    Is this a desktop application? Hosted on a server? Where are


  • #3
    [Deleted User]
    Posts: 18,046 ✭✭✭✭ [Deleted User]


    Initially, all local through Wamp.

    EXAMPLE
    IMAGE

    Drop down 1 Drop down 2 Drop down 3 etc.. Confirm button.
    menu
    options
    from
    sql
    table
    axis

    The idea would be that any drop down options selected would then enter the database with a "yes" for that image.. I guess first I have to do is create an sql table with the image address and then run a php script to bring up the images and the menus?


  • #4
    Procasinator
    Registered Users, Registered Users 2 Posts: 1,311 ✭✭✭Procasinator


    Sounds like you want to tag images.
    Could you use off-the-shelf gallery software?


  • #5
    [Deleted User]
    Posts: 18,046 ✭✭✭✭ [Deleted User]


    I'd love to if the data went into a table I could use on a webserver?


  • #6
    [Deleted User]
    Posts: 18,046 ✭✭✭✭ [Deleted User]


    Jesus, adding "tag" to the google searching makes things a whole lot easier!


  • Advertisement
  • #7
    TonyStark
    Registered Users, Registered Users 2 Posts: 851 ✭✭✭TonyStark


    So what happens when a file is moved from the folder? It's pretty straightforward what you are asking really.

    Basically you want to store meta data about the file. However you know do know you can store a certain amount of meta data within the image file itself? Create a program that points to the folder that points to the pictures and you can add/edit the metadata directly rather than having to intervene with storing references in databases and so forth.


Advertisement