PHP Advanced for the World Wide Web: Visual QuickPro Guide-->SQL
The CREATE and some of the INSERT SQL commands from the book are available here to be downloaded. Although these scripts are written and organized as they are in the book, they do include any updates and changes as warranted by errors which were found after publication. Thus, if you are having problems with a particular SQL command, download the most current version here or check the errata section. If you find a problem with one of the files here, please contact me with the details.
To create the SQL files, I started by retyping all of the CREATE statements (and some ALTERs) as they appear in the book. These are organized by chapter. Then I also included phpMyAdmin dumps of the databases used in the book (accounting, movies_db, test). These include some sample INSERTs. Note that you will probably have to modify these files before using them in your databases.
These scripts have been formatted with line breaks that will work on most systems running most text editors. If you have difficulty opening a script, try:
- adjusting the way your text editor treats text files
- using a different text editor, if possible
- posting a message to the online forum, asking for help
- contacting me and I will try to assist
SQL Commands |
|
| Formats and Size | Date Modified |
| sql.zip (2 k) sql.sit (2 k) sql.tgz (1 k) |
Wednesday November 07, 2007 |
Newsletter #16 Sent
Newsletter #16 just went out today after a long delay. It's a bigger one but there's lots of good stuff in there. You can read it online at http://www.dmcinsights.com/newsletter.php if you're not subscribed to receive it via email.(October 23, 2008)
Ruby: Visual QuickStart Guide Complete!
I'm very happy to announce that I've completed my Ruby: Visual QuickStart Guide. The book should be available in about three weeks or so (around early November 2008). The book turned out well, I think, and it should hopefully be a nice addition to the relatively small catalog of Ruby books that are available. In particular, I think that the Ruby on Rails chapter is really nice. I was able to develop a real-world example that demonstrates many aspects of the Rails framework. It also covers Rails 2.1, which has some significant changes from the 1.x version of Rails. More news about this book to come in future newsletters and on this site!(October 7, 2008)
Newsletter #15 Released
Newsletter #15 went out in early August but I've been remiss in posting this update about it. It's relatively short, with most of the discussion on the business side of creating your own business. You can read it online at http://dmcinsights.com/newsletter.php. The next newsletter should go out in a few days.(September 2, 2008)
