Drupal 7 Module Development Part 7 - Database API displaying data - Daily Dose of Drupal Episode 22

Continued from the last episode of the Daily Dose of Drupal, this episode continues Drupal 7 module development work with the Database API to pull data from the database and display it on a page.

In this episode you will learn:

- How to pull data from the Drupal database using the Drupal 7 db_query function
- How to use db_select and the Database API's dynamic query building to pull data from the database
- How to display data using a theme function to output data as a table
- How to sanitize user entered data for display using the Drupal check_plain and check_markup functions

[nice_soul]

Лучшее обучение Drupal 7 всё понятно хоть я и не знаю английского

[jimmysong]

Excellent video! I learned quickly about the basic skills of module development in drupal 7.

[jeffguroo]

Shane, excellent job on this series. This was exactly what I was looking for to get me started on custom module development. There are surprisingly few tutorial videos out once you get past the graphical interface.

[lovelysingh]

Brilliant man, u just nailed it.. Superb tutorial for beginners....

[PatriceFornalik]

Nice job! that gives me a good idea of the process. Thx a lot.
How about a new part 8 on how to make a common edit/delete table display like drupal do, with check box and action column ?

[Sunnyside--Up]

Thank you.  I like your tutorials.

Would you mind showing the process of 'Modify' the called data, e.g. 'my textfield'?
So far, I haven't found any tutorial (drupal 7) that gives access for changes of data previously submitted.

[Dee-freq]

Hi Shane thanks for this great video it was really helpful. I have been wanting to do something similar with search feature, is there a way to integrate forms in this current tutorial so that we can filter items in the resultset? Thanks.

[popperzr]

i had the same problem, be sure about the { open and close right on the last function!

[codekaratetutorials]

Thanks, I am glad you found it helpful.

[JonathanCardenas_Official]

Hi Shane,
Thanks for this very helpful tutorial...
i have a question regarding printer-friendly link on the custom module... i have already installed the printer-friendly module (DRUPAL 7) and it's showing on every Basic Page that i have...
how to i make it to show also on the custom menu page (like this one in the tutorial) that I have?, , , tnx a bunch :)

[OutboardAdvice]

Hi Shane, great turorials! Could you please give me some quick advice....
I want a text box in a block that the user can enter a part number, the block will then query the sql database and show the price and description of the part.

Is it best to create a custom module, or can I use views to do this?

Thanks :)

[avlisodraude]

Hi Share,
Greats videos.
Regarding this one. How could you modify the code to retrieve records dynamically  based on url, ie, page/ID instead of all records at once?
thanks in advance :-)

[jeffguroo]

try maximizing the video to full screen mode, YouTube is nice enough to increase the resolution after a few seconds.

[codekaratetutorials]

You need to make sure to give authenticated users the correct permission to access that on the permissions page. The access is all controlled in hook_menu by the "access callback" and "access arguments" items but most of the time it comes down to the user needing a specific checkbox on the permissions page. Let me know if that helps.

[margosdesarian]

In this video and the last one - your form and form submissions page is accessible by simply appending the domain with the path  - when i do that i get 404 page not found from drupal - are you missing a step here?

[ZohaibMasood]

Can we add a button next to our database entries to delete this entry? can we do it?

[codekaratetutorials]

You can also change the video quality by clicking the little gear icon. In the future I will provide the code for any module development videos on the CodeKarate site.

[henkyrumbo]

Hi Shane.. Why the menu is just appear for administrators only? It won't appear for authenticated users.

[JonathanCardenas_Official]

oh. found it already in the settings of the print module itself :)

[henkyrumbo]

on 'permissions' option : authenticated user checkbox are ticked under "form example", but the menus did not come up for authenticated user.