Resources for Web Development Students @ Robin’s Blog

For students who are working with PHP/MySQL in Dreamweaver I have a tutorial forimporting SQL tables into f2o using phpMyAdmin that you may find helpful.

We have encountered some issues trying to import SQL files (text files with the SQL statements) into f2o with phpMyAdmin. I have added notes on how to correct this issue to the tutorial and you can find the import notes here. Even if you don’t have problems “importing” the SQL files, you may find this tutorial helpful if you are beginning tutorial 9 of the Dreamweaver book.

The WAMPServer Installation tutorial also has a BRIEF introduction to working with phpMyAdmin.

Here are a couple more tutorials/resources on working with phpMyAdmin/MySQL:

1. phpMyAdmin Tutorial
2. Learning SQL Using phpMyAdmin – there are a lot of PHP/MySQL resources on this site.
3. Margie also found the book Mastering phpMyAdmin for Effective MySQL Management on Amazon. I have not read it, but it looks like a good one. My only hesitation is that the phpMyAdmin interface changes, so it could become outdated. But then again, once you learn the basics you should be able to work with an updated version without too many issues. I went ahead and ordered the book so we would have a class copy.

On another note: Dan at f2o contacted me to let me know that your accounts have been approved. Start uploading! I have instructions for uploading with WS_FTP and Dreamweaver.