Mark’s Site

Pensieve for coding and golf :-)

Archives for the ‘2.2. PHP and MySQL’ Category

SQL Injection

By admin • Apr 17th, 2008 • Category: 2.2.1. Hacking Techniques

Due to the rising number of sites I have seen that fail against even
the most basic SQL injection attacks, I want to talk about SQL
injection, the ways in which it can occur and the consequences. After
reading this, you should know whether your applications are, or are
not, secure against this type of attack. This article is the first in a
series, with future articles showing you coding methods to protect
against these attacks.



Brute Force Attacks

By admin • Apr 15th, 2008 • Category: 2.2.1. Hacking Techniques

One of the most common and simple attacks to applications are often the Brute Force Attack, where username and password combinations are tried until access is gained. How do we prevent against such attacks? The answers are simple and important to implement in your applications from the very beginning.



Prepared Statements

By admin • Apr 11th, 2008 • Category: 2.2. PHP and MySQL

Want to know the most secure way of passing data to SQL from your code? Enter prepared statements (available with MySQL 5+, MSSQL and others)



SQL Joins

By admin • Apr 11th, 2008 • Category: 2.2. PHP and MySQL

All systems I work on these days involve relational databases, which are databases that conform to the relational model of managing data. This article will discuss the one of the most commonly used functions of relational databases, joins, explaining the different types of joins and what they all actually mean for you, the programmer.