Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
ChronoForms 3.1 for Joomla! site Cookbook

You're reading from   ChronoForms 3.1 for Joomla! site Cookbook 80 recipes for building attractive and interactive Joomla! forms

Arrow left icon
Product type Paperback
Published in Aug 2010
Publisher Packt
ISBN-13 9781849510622
Length 376 pages
Edition 1st Edition
Languages
Tools
Concepts
Arrow right icon
Author (1):
Arrow left icon
Bob Janes Bob Janes
Author Profile Icon Bob Janes
Bob Janes
Arrow right icon
View More author details
Toc

Table of Contents (17) Chapters Close

ChronoForms 3.1 for Joomla! Site Cookbook
Credits
About the Author
About the Reviewer
1. Preface
1. Creating a Simple Form FREE CHAPTER 2. E-mailing Form Results 3. Styling your Form 4. Saving Form Data in the Database 5. Form Validation and Security 6. Showing your Form in your Site 7. Adding Features to your Form 8. Uploading Files from your Forms 9. Writing Form HTML 10. Creating Common Forms 11. Using Form Plug-ins 12. Adding Advanced Features

Using PHP to create "select" dropdowns


One frequent request is to create a select drop-down from a set of records in a database table. The example here lists all the published articles in section 1.

Getting ready

You'll need to know the MySQL query to extract the records you need from the database table. This requires some Joomla! knowledge and some MySQL know-how.

Joomla! keeps its articles in the jos_content database table and the two-table columns that we want are the article title and the article id. A quick check in the database tells us that the columns are appropriately called title and id. We can also see that the section id column is called sectionid (with no spaces); the column that tells us if the article is published or not is called state and takes the values 1 for published and 0 for not published.

How to do it . . .

We are going to use some PHP to look up the information about the articles in the database table and then output the results it finds as a series of options for our...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image