PHP Tutorial: Put MySQL ENUM values into drop down select box
If you have an ENUM field in your table schema then you don’t want to go through the hassle of re-writing out all of the different ENUM values when you do an online form...
Tagged: Programming Languages
PHP Tutorial: Looping Through & Displaying A MySQL Result Set
Recently I’ve seen a lot of people using while loops to retrieve a single record. You only need to loop through your result set when you expect to get more than one row of...
PHP Tutorial: Connecting to a MySQL Database
You would think this is really obvious but I see a TON of posts on devnetwork.net (great php/mysql forum by the way) where people put their login and password for their database on every...
Cheat Sheet: ASP & PHP Cross Reference
I found this cool site that has examples cross-referencing PHP and ASP so you can see the difference (or use it if you’re switching from one language to the other). They also have a...
PHP Tutorial: Format Dates Taking Country Into Consideration
<? /************** * Purpose: Format dates with country in consideration * Precondition: 2 letter country code the individual is from * Postcondition: date is reformatted for that country * Note: all available country abbreviations...
PHP Tutorial: Learning PHP (Part 3)
In Part 2 I covered else-if statements and more complicated if statements. One of the other concepts that’s essential to learning any kind of programming is loops. There are three different types of loops...
PHP Tutorial: Learning PHP (Part 1)
When the Internet exploded in the .com age people were just starting to realize the potential of online programming languages. PHP, or Hypertext Preprocessing, is one of my favorite programming languages. One of the...
Pits of Doom Lesson 8: Monsters & Field of View
In the last lesson we added a huge amount of functionality to our little game. Now we can join the game if we don’t already have an account, login and access only our account...
SQL Tutorial: Easily Update Rows Based on Complex Joins
There are a lot of times I’d like to update hundreds of rows in a database based on a complex set of conditions. In doing a traditional update SQL statement there is no way...
Ten Reasons Not To Use ASP!
10. I have to write my own isNull function? 9. No double equals = retarded language 8. You can’t response.write across multiple lines unless you _ & fix them. Can’t concatenate across multiple lines...
