I have been out of programming for a few years now, but I used to use foxpro and then Oracle and I would have used these to do the type of program I wanted but I want it to run on a server, foxpro is out of date and Oracle is far too expensive for what I want to do. I have tried Joomla but got nowhere and someone suggested Drupal, so this is roughly what I am trying to do.
I have a database with tables for say cars.
I have a table with car makers, another table with fuel types. (I am using tables because I want to be able to add lots of records to these tables.)
I have a table I want to put a new record on screen with fields for make and fuel and other blank fields, I want to select inputs from dropdown options and put them into the "blank" fields, validate and save the records.
My question is this, can I do what I am asking with drupal or should I be looking elsewhere.
Thanks
Clive
Comments
Sure you can do it. But you
Sure you can do it. But you should be thinking at the Drupal level of abstraction rather than the db level. For example type of car could be a taxonomy term. You can use select list for taxonomy terms with Drupal core and make it hierarchical with http://drupal.org/project/hierarchical_select. You could build db queries for collecting and displaying data with Views. it
A car can be a node of custom content type "car". Or it can be an entity (which is in effect amore flexible replacement for the node system). If it is a node you use the core node API if you prefer to custom code than to use existing Drupal software for your specific needs. If is an entity you use entity API.
You can do almost anything in Drupal, and a huge amount without any coding. That does not mean it is the best tool but once you have a spent a few days studying Drupal and a few more days studying major contributed modules like Views and Entity API you will see this is all bread and butter.
Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors