| |
[2010-08-31] Prevent MySQL Injection Attacks
What this type of attack entails is a malicious user attempting to insert their own MySQL code into your database without you knowing about it. This is done through forms. Take for example, a log in form, where you type in your username. A typical statement to verify this action would be something like this.
[2010-08-17] The IN Thing
Staying in fashion is often a tough proposition. If you're one of the unfortunate ones that do attempt to keep up, you likely end up with an overpriced and overstocked wardrobe. Some fashions, however, never die, and thus can continue to be used at your discretion. Likewise, your database can become stuffed to the seams, and there may be situations where you want to return a result if it matches not only a single value, but also any from a host of values.
[2010-08-03] Data Integrity with Foreign Keys
In relational database design, we rely on keys in one table to relate to the primary keys of another. The InnoDB engine takes this concept and supplies the Foreign Key constraint to keep our relationships healthy and strong. It's truly a relationship miracle-worker. Eat your heart out, Dr. Phil.
|
|
