Create database with search functionality

  • sparty

    (@sparty)


    8 years, 10 months ago

    Hello,

    I want to create a database with names and numeric totals in it. It will be about 300 entries in it and the idea is to be able to search a name and a total comes up in a display.

    The second part is I want this database to be in excel and the client wants to update the database bu just uploading an excel spreadsheet. How would I go about doing this ?

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • dayvee

    (@dayvee)

    8 years, 10 months ago

    There are somethings we need to know about your client’s site for us to help you. To begin with, is their website a wordpress site? If not what language was their site developed in?

    Assuming the site is a wordpress site you could convert the excel files with the data of the names and values like this and then use this wordpress plugin to convert the csv files and save them into your wordpress database which you can search and return values.

    If the site is not a wordpress site then you would have to write a program that has the above functions i just explained which is easy for an intermediate web developer. Let me know if this answers your question.

    • This reply was modified 8 years, 10 months ago by dayvee.
    • This reply was modified 8 years, 10 months ago by dayvee.
    • This reply was modified 8 years, 10 months ago by dayvee.
    Thread Starter sparty

    (@sparty)

    8 years, 10 months ago

    Its a wordpress site, I will go through the links your provided – Thanks

    Thread Starter sparty

    (@sparty)

    8 years, 10 months ago

    Sorry to add, how to add it into my wordpress database and also how would I search and return values from this database ? Sorry for all the questions and thanks a lot, First time in days I seem to get somewhere

    dayvee

    (@dayvee)

    8 years, 9 months ago

    no problem, we are both learning. It depends with who you want the data to be displayed to and where? for instance, does your client want the data to be displayed to their audience (or customers) which would mean that this functionality would be presented in the front end of the website for their customers to use or would this functionality be exclusively for the client, who i assume is the web administrator and hence he wants to privately access the information (names and values from excel document) in the wordpress dashboard of his/her site?

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

The topic ‘Create database with search functionality’ is closed to new replies.