Escape Input and Output
30 Mar 2010
There is a surprising amount of confusion about XSS and SQL injection among the PHP programmers I've worked with. Here are some common ways to do it right and to do it wrong.
Wake Up! Do You Know Encryption?
26 Mar 2010
I'm surprised by how many developers aren't familiar with encryption. Many say to me that encryption is md5 and sha1.
Applications often need one-way encryption and two-way encryption. There are also public/private key encryption schemes like pgp which are not as commonly used in web applications.
utf8_bin vs. utf8_general_ci
23 Sep 2009
After reading a thread on the phpbuilder forum I now understand the nuances of UTF-8 character coalation on MySQL. NogDog writes:
I Love MySQL
2 Jul 2009
There are several things I love about MySQL compared to SQL Server and Oracle. Hopefully my memory is accurate on the SQL Server and Oracle support. I haven't used Oracle in a few months and SQL Server in two years.