By Carus on
ive been trying to find something in the drupal modules that would allow a user to search a particular db table and retrieve the information associated with it. just a simple search, and return the information in the row. ive been messing around with table wizard and views, im not really sure if thats what i should be looking at, then again it is 2:40 am and i need sleep....
if any of you have ideas to point me in the right direction it would be appreciated.
Comments
_
Sounds like on the right track with tw and views-- you'll want to setup a view with an 'exposed filter' to simulate a search.
Drupal is based on a database
Drupal is based on a database and we have the beautiful CCK module, yet we don't have a module which will link those two together and enable us retrieve database rows?
I might be able to figure it out with Views and TW (I hope), but I think it should be simpler to retrieve what we have entered and am surprised that this is not a commonly asked question.
I am about to design a database entry system for a client, they need to retrieve records, edit records and display a table as a report format. I suppose we don't have a module that will do all those right?
Thanks WorldFallz, you are always there to provide solutions. It's great to have people like you and I hope I can do the same in the near future.
_
We do now-- that's exactly what the tablewizard module is for. The other option is use simply use db related api functions and pull and display the data manually.
that's what cck is for. unless you want to actually specify the schema at the db level, and then you can use the tablewizard module to make that data available via views if desired.
I'm not sure I understand your quandary. If you want to set up data storage through the ui you use cck, if you want to work with the db directly then you can and expose that data to drupal via the tablewizard module. what am i missing?
I understand the power of
I understand the power of Drupal, that's why am using it. But sometimes we need to use several modules to accomplish a simple task. I was just saying that we should have a module that will allow us to integrate several requirements into one simple-and-quick way of doing it.
I also have to add that am not very well experienced with Views and sometimes I find it overwhelming working with it. That might be because I do trial-and-error instead of reading the documentation or a book about it. I need to invest more time into learning things, but sometimes we need a quick turnaround.
In summary, there are numerous modules that already do what I am asking for - integrate several module's functions into one. Why not have something DB related as well. Actually we do have one that can be adapted: the nodeadmin module: http://drupal.org/project/nodeadmin
For now, I can live with it, and I understand that working with CCK+Views will give us more power and flexibility than a specific module that does one thing.
I found this module which
I found this module which will do the job for me: http://drupal.org/project/tablemanager
However it's only for Drupal 4.x & 5.x and for Drupal 6.x it's a dev release only: http://drupal.org/node/37339/release
There is some bullying going around with the module's developer so let's see if there will be any updates to it soon...
We should appreciate developer's time and effort and not insult them in any way!
_
tablemanager is not quite what you think-- it mostly facilitates creating displayed html tables, it's not really a schema generator.