Scripts
- docbook.phps - create DocBook XML files
- mydump - mysqldump of lds_scriptures tables
- pgdump - pg_dump script
- psql2sqlite - creates SQLite-compatible dump from PostgreSQL database, with garbage pg header data (ignored by sqlite), and non-transactional
PHP class
2005-11-20
I've started work on a revised, simpler PHP class to fetch and display data from the tables. Right now it is nothing more than two simple functions, getVerse() and getVerses(), but eventually I will incorporate things like fulltext searching.
Currently it only supports MySQL and assumes you have a working backend connection already. I'll also be adding a generic database layer for all the possible backends, though some databases (PostgreSQL and SQL Server) will come with native views and functions.
You can download the latest here: class.mdp.txt.
Don't forget to rename the extension to .php.
$ wget http://scriptures.nephi.org/class.mdp.txt -O class.mdp.php