WordPress.org

Ready to get started?Download WordPress

Forums

Can I do this in WordPress? (22 posts)

  1. jslavin
    Member
    Posted 1 year ago #

    I want to make an interactive online scholarship database that students can use to find scholarships that suit them. I want to categorize the scholarships in terms of numerous different criteria, including the amount of the scholarship, the application requirement, required test scores, career/major specifications, gender, race, etc. Can a database interface be designed that would allow students to search the scholarships by these criteria? For example, could there be an entry form (or account logins) that would have the student enter his/her pertinent information and then yield a search result of appropriate scholarships based on that criteria?

    If so, how is this done in WordPress?

  2. michael.mariart
    Member
    Posted 1 year ago #

    It's possible and there's a coupel of different ways to it.

    You can set up a plugin that will add the database tables, manage the editing for the scholarships and create the search forms.

    You can also set up scholarships as a new content type and use that to store the details.

  3. mindctrl
    Member
    Posted 1 year ago #

    You could make custom taxonomies and use the plugin called Query Multiple Taxonomies to do your searches.
    http://scribu.net/wordpress/query-multiple-taxonomies

    You can display the taxonomies using the plugin called Taxonomy Terms List.
    http://wordpress.org/extend/plugins/taxonomy-terms-list/

  4. jslavin
    Member
    Posted 1 year ago #

    Michael,

    Which plugin are you referring to?

    Mindctrl,

    What are taxonomies?

    Thanks,

    Jeff

  5. michael.mariart
    Member
    Posted 1 year ago #

    I'm not referring to any plugin that I know of. What I am meaning is that for something that's this specialised there's a very good chance that you'll have to either write it yourself or get someone else to write it for you.

  6. jslavin
    Member
    Posted 1 year ago #

    Can this be done in Access?

  7. michael.mariart
    Member
    Posted 1 year ago #

    Probably, but it won't be online. I haven't tried anything like that with Access before, but I left that behind a whole lot of years ago now.

  8. jslavin
    Member
    Posted 1 year ago #

    You can't do it offline in Access then upload it online?

  9. michael.mariart
    Member
    Posted 1 year ago #

    yes you can, but then people will be downloading the Access databse, not using it like a webiste. Access doesn't work that way.

  10. jslavin
    Member
    Posted 1 year ago #

    If people download the Access database, can it be automatically updated?

  11. michael.mariart
    Member
    Posted 1 year ago #

    No. Like I said, Access doesn't work like a website.

    Unless you can do a search for a plugin that suits your needs and find something that will work for you, you will need to either program something for yourself, or pay/convince someone else to do it for you. It can be done, but it's the same as pretyt much every other system out there - it needs you to know at least something about how to do it before you start/

  12. jslavin
    Member
    Posted 1 year ago #

    If this is done in WordPress and I export it does the database have to be imported into a WordPress website?

    Are there any other resources you can refer me to to help me build my database?

  13. michael.mariart
    Member
    Posted 1 year ago #

    Here's two to get you started:

    Writing a Plugin

    Creating Tables with Plugins

    Just a warning here... Don't expect this to be as "easy" as Access is. Access is made to be an easy-to-use database that most people can make do something small. The programming behing WordPress, plugins and the database are a lot more involved then setting up a basic add/update form in Access.

  14. jslavin
    Member
    Posted 1 year ago #

    Oh okay. And you recommend I attempt to make this in WordPress?

  15. michael.mariart
    Member
    Posted 1 year ago #

    I recommend that you make this in whatever suits you and can do the job. If you can learn to do it in WordPress then great. If you know some other way that can do it that you know already then use that unless you want to learn something different.

  16. jslavin
    Member
    Posted 1 year ago #

    I'm trying to learn something different. What are your thoughts on MySQL/phpMyAdmin for my purposes?

  17. michael.mariart
    Member
    Posted 1 year ago #

    phpMyAdmin is only a management tool for a MySQL database. It won't let you do any sort of set searching. To do anything like that users need to know how to write SQL queries themselves, so it's really not something that you could ever use for a public-facing project like this.

  18. jslavin
    Member
    Posted 1 year ago #

    Lastly, what are your thoughts on Joomla/SobiPro for my purposes?

    Thanks.

  19. michael.mariart
    Member
    Posted 1 year ago #

    I've never used SobiPro, and I've onyl ever glanced over Joomla coding, so I can't say what they would be like. it dpeneds on if it will do what you want it to or if you'll need to do some modifications. Joomla is a fair bit more technical then WordPress so it can be harder to modify.

  20. jslavin
    Member
    Posted 1 year ago #

    Oh okay. Do you know the answer to my question of if you create the database I mentioned in WordPress, can you export it and import it into a non WordPress website?

  21. michael.mariart
    Member
    Posted 1 year ago #

    You can. It all depends on how the other database is set up. If you know what you are doing it's not that hard to create an import and/or export script that will do that for you.

    My best advice for now would be... Go and try a few things. Asking questions on here (or anywhere else) all day is going to give you a few ansers, but so far everything is so high-level it's hard to give yo a definiativ eansewr because the answer to pretty much everything you're asking is "probably". That's not a bad thing and I don't want you to get discouraged, but I've always found that it's better to actually try a few things to see what I can and can't work with and then ask questions when I get stuck so that I can figure out just what I need to do to move on to the next level.

  22. jslavin
    Member
    Posted 1 year ago #

    I think it makes the most sense to play around with WordPress plugins to see what I can do?

Topic Closed

This topic has been closed to new replies.

About this Topic