Dangers of Adding fields to Database Tables
There are certain dangers if you don't plan carefully before adding fields to your database. Though, it seems obvious but its not as simple as you might think. If you don't plan properly you may miss …
MySQL
MySQL: foreign keys and referential integrity
Recent versions of MySQL have implemented support for foreign keys through the InnoDB table engine. Following is an explaination of how it works. Referential integrity is an important concept in da…
Secure sensitive data in MySQL with few easy steps
Many hackers constantly try to breach your secure data and steal your secure information away. People generally think that they can't secure their data actively but this isn't true. If you're using My…
Setting-Up a Relational Database in MySQL
Relational Database Design is one of the most powerful ways to ensure data integrity and a great way to kick-off any project. Very often the first thing developers do when starting a new project, or…
PHP: Securing Your Input Forms From MySQL Injection Attacks
Every website has ‘em. Forms. Places for users to enter data into your website. Whether it be a search box, a “Contact Us” form, or variables in the website address, at some point in the flow of your …
Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form),…