Compilation of Resources

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!

 

I have the following resources to add to your list:

SQL Injection: A video on how to use the Information_Schema table to your advantage:

Code:

http://sidstudios.org/?media:gamegossip

And, there's some other stuff which I recommend you take a look at, but I'm not implying you should add this to your list:
PHP Basics:

Code:

http://sidstudios.org/forum/showthread.php?t=48

I've got some resources on Flash, and they are good tutorials too:

Code:

http://sidstudios.org/forum/forumdisplay.php?f=22

As well as an article on the basics of phishing:

Code:

http://sidstudios.org/forum/showthread.php?t=72

Check it out, and add it if you want. I personally think my article on phishing is pretty good, but it might not fit here.

 

Sythe doesn't support phishing, just remove that portion.

 

It's a post on what phishing is. Here, I'll hotlink the image just for you.

 

It doesn't support hacking either, but to prevent it, you have to know how it's done.

How can you stop SQL injection if you don't even know how to work it?

(I'll add the links you posted)

 

Exactly. Just like in anything else, lets say, boxing, you need to know your opponent's moves to dodge them.

 

Yep, it's being prepared. Like studying for a test...

We don't like hackers, but we like to stop hackers.

 

I'll Pm you more, if you wish to Add. There Books.

 

It would be appreciated if you guys could keep the "chatting" out of this thread, and just post links.

Go straight ahead and post links. They do not need to be approved so as long as they are on topic, and are safe.

 

I highly recommend downloading the PHP Reference Manual to your Desktop. Its available in CHM and PDF format.

 

Ive made a new one. Locked...