From the monthly archives: February 2007

10 (very) Basic Tips for PHP Web Application Security

By On February 23, 2007 · 1 Comment

Barebones list for the things you should be looking for when developing a web app in PHP. Some of it applies to all web apps, not just PHP.

Use HTML_Safe (or a similar javascript stripping library) to check for and remove javascript when you’re accepting data that will be output to a page. [...]

Continue Reading →

What caused that load spike?

By On February 13, 2007 · 2 Comments

Every now and then, we find that we will have a sudden increase in the number of apache processes, load average will spike up, and then go back down to normal. In rare cases, we will see the same thing happen, and the load avg spike WAY up, all queries appear locked up, and the [...]

Continue Reading →

SHOW CREATE TRIGGER – Nope

By On February 8, 2007 · 4 Comments

As of MySQL 5.0 there is no SHOW CREATE TRIGGER which is pretty annoying. I don’t like using “show triggers like
“, so I figured I’d write a wrapper around mysqldump. For the record, this was a huge pain the ass. I did this on Fedora, GNU sed version 4.1.5. You need to have [...]

Continue Reading →