March 17, 2011

sqlite pdo write lock problem solved

When using PHP and PDO to access an sqlite dababase, and when you do a "select *" using the $handle->query($sqlcmd), you must use "foreach" to read all the select results before you can issue the next "query" or "exec" call. Otherwise, the database will be locked.

March 4, 2011

Win32 applications GUI vs Console

This web page explains well the difference between a WIN32 GUI app vs. Console app.

March 3, 2011

php header redirect IE issue

In web development, a HTTP POST is often processed on the server ending with a header("Location:page.php") call, so that user can refresh their page without re-posting. This usually works well.

The only issue is IE. After posting or file upload, using the PHP header() call won't work with IE, although it works with Firefox. You will have to use the HTML direct instead.