THIS IS NOT MINE. IT IS FROM ANOTHER FORUM. BUT IT IS VERY USEFUL!
PHP
PHP 101: PHP For the Absolute Beginner
http://devzone.zend.com/node/view/id/627
Server Side Coding : PHP & MySQL Tutorials
http://www.sitepoint.com/subcat/php-tutorials
PHP MySQL Tutorial
http://www.php-mysql-tutorial.com/
PHP Reference Manual
http://php.net/
Learn PHP Free
http://www.learnphpfree.com/
The Melonfire Community
http://www.melonfire.com/community/columns/trog/archives.php?page=2&category=PHP
Free2Code.com PHP tutorials
http://www.free2code.net/tutorials/browse/php-2/index.html
Practical PHP Programming wiki
http://hudzilla.org/phpwiki/index.php?title=Main_Page
W3Schools - PHP Tutorial
http://www.w3schools.com/php/default.asp
Books
Build Your Own Database Driven Website Using PHP & MySQL
http://www.sitepoint.com/books/phpmysql1/
List of books, by Wrox Press. Click on the PHP/MySQL link.
http://www.wrox.com/WileyCDA/Section/id-105077.html[/QUOTE]
MySQL
The MySQL site:
MySQL Developer Zone
Database Normalization:
One of the most important things of database development is understanding the concepts behind Database Normalization. This means setting up the proper structure of your tables and how they will work together to make your data retrieval as seemless as possible while minimizing data resources necessary to perform the output.
An intro to database normalization
Hierarchical Data:
Managing hierarchical data can be tricky, but once you get an understanding of how to approach it, you will find this an important tool in your database development.
Managing hierarchical data
Categories and Subcategories a useful article written on the Adjacency List model.
Joe Celko's Trees and Hierarchies in SQL for Smarties (I've found this to be a pretty involved book.)
GUIs:
Heidi SQL
Navicat
MySQL Administrator
MySQL Query Browser
phpMyAdmin if you are using PHP as well
Database Modelling:
Data Models (note, there are no comments on the designs, just the layouts)
SQL injection attacks:
result from unsanitized user input. The article below details one example of how this could be used to gain access to your data by outside users.
SQL injections
PHP and MySQL
An extensive tutorial I found this tutorial to be pretty extensive and quite helpful.
http://www.apachefriends.org/en/xampp.html (a quick and seemless way to integrate PHP, MySQL, Apache, PERL, PHPMYADMIN on Windows, Solaris, Linux, Mac OS). Note you won't learn how to tune your applications here, but if you are looking to get them set up quickly and jump right in, I personally have found this to be a good set-up on WinXP. Caveat, the discussion boards on the site are in German.
SQL formatters:
These allow you to dump in the code you are using for a query and print it out in a much neater form.
SQLinForm
Instant SQL Formatter[/QUOTE]
More to come!
If you would like to add to this list, please post the site, and a short description!
If you really want to learn PHP, check out the beginning of Deacon's tutorials. Soon to span all of web development, it is step by step to creating some very nice scripts!
PHP
PHP 101: PHP For the Absolute Beginner
http://devzone.zend.com/node/view/id/627
Server Side Coding : PHP & MySQL Tutorials
http://www.sitepoint.com/subcat/php-tutorials
PHP MySQL Tutorial
http://www.php-mysql-tutorial.com/
PHP Reference Manual
http://php.net/
Learn PHP Free
http://www.learnphpfree.com/
The Melonfire Community
http://www.melonfire.com/community/columns/trog/archives.php?page=2&category=PHP
Free2Code.com PHP tutorials
http://www.free2code.net/tutorials/browse/php-2/index.html
Practical PHP Programming wiki
http://hudzilla.org/phpwiki/index.php?title=Main_Page
W3Schools - PHP Tutorial
http://www.w3schools.com/php/default.asp
Books
Build Your Own Database Driven Website Using PHP & MySQL
http://www.sitepoint.com/books/phpmysql1/
List of books, by Wrox Press. Click on the PHP/MySQL link.
http://www.wrox.com/WileyCDA/Section/id-105077.html[/QUOTE]
MySQL
The MySQL site:
MySQL Developer Zone
Database Normalization:
One of the most important things of database development is understanding the concepts behind Database Normalization. This means setting up the proper structure of your tables and how they will work together to make your data retrieval as seemless as possible while minimizing data resources necessary to perform the output.
An intro to database normalization
Hierarchical Data:
Managing hierarchical data can be tricky, but once you get an understanding of how to approach it, you will find this an important tool in your database development.
Managing hierarchical data
Categories and Subcategories a useful article written on the Adjacency List model.
Joe Celko's Trees and Hierarchies in SQL for Smarties (I've found this to be a pretty involved book.)
GUIs:
Heidi SQL
Navicat
MySQL Administrator
MySQL Query Browser
phpMyAdmin if you are using PHP as well
Database Modelling:
Data Models (note, there are no comments on the designs, just the layouts)
SQL injection attacks:
result from unsanitized user input. The article below details one example of how this could be used to gain access to your data by outside users.
SQL injections
PHP and MySQL
An extensive tutorial I found this tutorial to be pretty extensive and quite helpful.
http://www.apachefriends.org/en/xampp.html (a quick and seemless way to integrate PHP, MySQL, Apache, PERL, PHPMYADMIN on Windows, Solaris, Linux, Mac OS). Note you won't learn how to tune your applications here, but if you are looking to get them set up quickly and jump right in, I personally have found this to be a good set-up on WinXP. Caveat, the discussion boards on the site are in German.
SQL formatters:
These allow you to dump in the code you are using for a query and print it out in a much neater form.
SQLinForm
Instant SQL Formatter[/QUOTE]
More to come!
If you would like to add to this list, please post the site, and a short description!
If you really want to learn PHP, check out the beginning of Deacon's tutorials. Soon to span all of web development, it is step by step to creating some very nice scripts!
