My Blog
contains PHP, Web and business/entrepreneurial related content. Please join in the conversation!
Tag Archives: SQL
Use MySQL Gui tools to securely connect to remote database
This particular example is going to be based on a connection from Windows XP using Putty, MySQL GUI tools and Dreamhost. Quick summary of issue: I want to use MySQL Query Browser to access my database on my dreamhost account. … Continue reading
Write Security Triggers Against SQL Injection
An interesting idea that a colleague told me about was a ‘security trigger’ in any application that has a SQL type storage engine. The trick is to make sure that your admin account is not ID #1 and that your … Continue reading
ODBC for UDB and PHP – How I increased performance by 400%
In our current setup at (“the triangle”), we have to use odbc connections to access our db2-udb database – and I don’t like it. But we have to stick with it – and thats the way life is. The main … Continue reading
PHP developer's shortcut for optimizing mysql
PHP developers, raise your hand if you run an explain on each MySQL statement you write and use in your apps! Anyone? Ok… 1… 2… thats it? Yah, I tend to forget that too, but luckily PHP allows us to … Continue reading
Real world stories of a prepared statement
A couple months ago, I was out in Rochester MN at IBM for a multi-day meeting about communication between the iSeries(system-i, i5, as400, whatever its called now a days) and PHP/Apache. One of the things we talked about was our … Continue reading
Random user generation – optimized
I came across this blog posting about optimizing order by rand() and decided to make my queries better. Here is my real life example on how to optimize this query: