One of the most important things we do as web developers is test websites. While it’s easy to test static .html pages on your local development machine, it’s not as easy to test dynamic pages without some tweaking first. In this tutorial I will review how to quickly and easily setup a PHP/MySql development environment on your local PC using WAMPSERVER. For this tutorial I … [Read more...] about How to Setup a Local PHP/MySql Test Environment with WAMPSERVER
PHP
Free MySQL GUI tools for Database Development and Maintenance
I've been working with mysql/php for many years, and although there is no substitute for the command line when it comes to certain tasks (like running mysqldump), there are a few MySql GUI programs that I use for almost all of my mysql database development. I've tested many commercial products, but in the end I still wind up using these free GUI tools for MySql … [Read more...] about Free MySQL GUI tools for Database Development and Maintenance
PHP/MySQL: How to Store Queries in a Separate Include File
When implementing a php/mysql database (or any database for that matter), it's sometimes easy to have all of the queries located in one place, as opposed to having them hard-coded into the pages. If the queries are hard-coded in, and the queries are reused on multiple pages (which they often are), it can be a cumbersome task to update all of the queries. Having hard-coded … [Read more...] about PHP/MySQL: How to Store Queries in a Separate Include File
Regular Expression for Single Letter – PHP
I was working on a project where I needed to validate a querystring for a single letter -- uppercase or lowercase. Since there is no php equivalent to the is_numeric() function, (e.g. a hypothetical is_alpha() function) I decided to use regular expressions to get the task done. I could have used ctype_alpha(), but that function wouldn't account for the fact that I needed to … [Read more...] about Regular Expression for Single Letter – PHP