Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
MODx Web Development - Second Edition

You're reading from  MODx Web Development - Second Edition

Product type Book
Published in Feb 2011
Publisher Packt
ISBN-13 9781849513487
Pages 288 pages
Edition 1st Edition
Languages
Toc

Table of Contents (19) Chapters close

Credits
About the Author
About the Reviewers
1. www.PacktPub.com
2. Preface
1. What is MODx? 2. Getting Started 3. MODx Basics 4. Templating 5. Authentication and Authorization 6. Content Aggregation 7. Creating Lists 8. Snippets 9. PHx 10. Simple Recipes 11. Creating Snippets 12. SEO, Deployment, and Security 13. Plugins and Modules 14. MODx Revolution

Fortunes


Now that you have learned how to create snippets, let us create a snippet that displays a random fortune from the database. Fortunes are just quotations from famous texts. These are like a "quote of the day". They are called fortunes in the UNIX culture, after the introduction of the command-line program called fortune, many decades ago.

Creating the table

We will create a table that will hold the fortune and the author's name, using phpMyAdmin, to keep it simple. Most snippets that use a custom table will automatically create the table, if it doesn't exist already.

  1. 1. Open phpMyAdmin. The URL for phpMyAdmin will be different depending on your method of installation. If you choose to install Apache and PHP individually, then you will have to install phpMyAdmin first. If you are using XAMPP, as explained in Chapter 2, Getting Started, then the URL is http://localhost/phpmyadmin.

  2. 2. Log in using the username mySQL and the password that you created initially.

  3. 3. Click on the learningMODx...

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 $15.99/month. Cancel anytime}