How do I add a recipe database

  • Resolved cbo

    (@cbo)


    17 years, 1 month ago

    I think I added this to the wrong forum (wordpress mu) so I am reposting it here:

    Hi, I’m new to WordPress, and MySQL, and PHP, and all of this! I want to set up a recipe database on my blog. One that visitors can search and get results for, and have the search results (each individual recipe) be like a blog post – that they can comment on, also rate, and also be able to add their own recipes (with my approval). I’d also like to have each recipe have tags, for a cloud tag, so that they could click on a tag and list the recipes for a certain category.

    My question is, how do I go about this? Are there plugins available? Should I use a separate database, or add on to the existing one? Is it a whole separate programming issue? How would I tap into adding the comments, etc? Should each recipe be a “static” post (maybe for the search engines’ sake)? If so, could the recipe “section” be kept separate from the “regular” posts?

    Sorry, I am really new to this. Any help, or even suggestion on how to do this would be greatly appreciated!

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

  • I don’t know how to approach answering this, because I don’t know if you’ve already rejected the most obvious solution, which is to create a Recipe category.

    Basically, with a Recipe category (and sub-categories for the type of recipe, like “pasta”, “soups” etc..) you can post your recipes exactly like blog posts, and have them searchable with the regular search system.

    There are lots of ways you can then display the posts within that category, simply based on the fact that they’re in that category. You can (easly) choose to display posts from that category alphabetically as opposed to by date, etc etc.

    If you want to keep the main page of your site for News posts, or whatever other topics, you can choose to exclude posts made into the Recipe category from displaying on the main page. WP has a lot of this functionality built-in, it just requires a little fiddling with your chosen template.

    The way to start learning is to open your template files individually (try opening sidebar.php for instance) and finding the names of the active functions (like say, wp_list_categories). Simply google what you find there, and you’ll get the relevant link to the wordpress codex which explains how the function works, and what you can do to change the way it outputs its information.

    A little fiddling like this will teach you a lot in a short space of time and open your eyes to a wealth of flexibility.

    The only thing you’ll need to add to make this work the way you want is a post rating plugin. I’m sure I’ve seen at least two in passing, maybe even one with english instructions ??

    Quote:
    each individual recipe be like a blog post

    Then do exactly that: make posts for every recipe of yours. Commenting is automatically on; serach engines find them, visitors can use WP’s search…
    What kind of plugin do you need for it? Just make the posts and that’s it. Unless you are MySQL guru you can NOT add any other “database” to a WordPress installation. The MySQL database is on what your WP installation is running.

    Thread Starter cbo

    (@cbo)

    Ok, seems like a simple answer to something I thought was going to be complicated. Thank you both.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How do I add a recipe database’ is closed to new replies.