Mark’s Site

Coding and golf …it’s hard being me :-)

Archives for the ‘2. Advancing in PHP’ Category

To Delete, or not to Delete

By admin • Apr 21st, 2008 • Category: 2.1.2. Security

Do you necessarily assume that ‘delete’ actually means deleting data in your system? Perhaps you should consider simply hiding the data when information is deleted, so in emergencies, data can be recovered without the need for actual database recovery extremes.



Policy Areas & Permissions

By admin • Apr 21st, 2008 • Category: 2.1.2. Security

When you’re allowing content to be managed by various users, whom you may or may not trust, you need some form of control. That control comes from a well thought out security system.



From Diagram to Schema

By admin • Apr 17th, 2008 • Category: 2.1.1. Planning

You’ve got your database diagram at a point where you can see all the relationships among your entities, what now?



Time for an ER Diagram

By admin • Apr 17th, 2008 • Category: 2.1.1. Planning

So you’ve got your ideas vaguely sorted. How do you proceed from here?



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.



Introducing Classes

By admin • Apr 17th, 2008 • Category: 2.1. Useful Techniques

Ever since I started using classes, I’ve enjoyed my programming so much more. In this article, I want to explain why I use classes in my web applications, and more importantly, how I use classes. After reading this article, you should understand why programmers use classes and how you can get started writing classes.



Using Your Classes

By admin • Apr 16th, 2008 • Category: 2.1.3. Classes

You’ve got your classes in place that talk to your database, now what?



From Schema to Classes

By admin • Apr 16th, 2008 • Category: 2.1.3. Classes

You’ve got you database schema all done and are ready to proceed. What do you do now?



Start With Notes

By admin • Apr 16th, 2008 • Category: 2.1.1. Planning

Confused, worried, or excited about building your first CMS? Well this article will help you on your way, safely and, hopefully, intelligently :-)



Introducing Recursion

By admin • Apr 16th, 2008 • Category: 2.1. Useful Techniques

Sooner or later, you will be confronted with a situation where you need to create an unlimited data structure. Think tree structures, or parent/child relationships, or category/subcategory relationships. This article will describe how to store and, more importantly, how to display this data.