I have a client who wants a website, and having used Drupal many times, I'd like to keep using it, however I'd consider almost ANY CMS that can do something like Petfinder.com.

The client sells horses on their ranch. They'd like something where a website visitor can use combo-boxes (pop-up menus, or whatever your OS calls them) to search through a database of animals by different criteria, like Breed, Gender, Height, Disposition, Training, and so on. In other words, it would be a lot like the "Quick Pet Search" on Petfinder.com (on the left side of their home page. Why not take 10 seconds and try it now, so you know what I'm talking about.)

I can't find ANY CMS, or indeed, and free "e-commerce" package over at opensourcecms.com, that lets me create a database of animals (or products) where I can then search by different criteria.

Obviously, no one buys a $10,000 horse on the web, sight unseen, so there's no shopping card or e-commerce necessary here. Just a searchable, sortable database of products (horses).

So my next way of thinking is to have Drupal run the site, but have the horse database run by something like DaDaBIK (http://www.dadabik.org/), or something else anyone recommends. I'd just set up Drupal Pages with embedded PHP to work with DaDaBIK's database of animals. I guess.

I'd really appreciate anyone's thoughts on this matter.

Thanks,
Warr

Comments

wernst’s picture

No one knows, huh?

-Warr

pluginamp’s picture

Hi Warr,

I just searched for the same kind of information and came up with your post. I have around 1000 records in a MySQL database, and I've got them inserted and searchable in Dadabik, but someone has told me to just use Drupal's database. I'm quite new to this, and I don't understand what to do. Did you learn anything in the last few days?

thanks!
Terri

dgrant’s picture

I don't know if this helps, but you could just use flexinode nodes to store the horses. Then use flexinode's built-in table-view. For the searching, I'm not sure how you'd do it, but I'm sure it's not hard to write some php to do that.