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...
Tagged: Free Code
Pits Of Doom Lesson 7: Join, Login & Lost Password
In the last lesson we created a database class to make doing queries quick and easy to handle. Then we converted over the current character file and map editor to use the database when...
Pits of Doom Lesson 6: MySQL Database Class
In the last lesson I introduced you to functions, reading & writing to a file, some simple javascript and adding features to the game so we could swap in/out maps and move up/down map...
Pits of Doom Lesson 5: Easy Map Editor
In the last lesson we made some real progress. Now, instead of having a boring page with a click of one button before the game is over, we have a character that can move...
Pits of Doom Lesson 4: And Array We Go
In the last lesson we covered how to create a function, how to use some of php’s built in functions, and how to deal with sessions. Now we’ll take it even a step further....
Pits of Doom Lesson 2: Breaking It Down
One of the best things to do if you’ve never made a game before or you don’t have much programming experience is to break things down into their most basic parts. We’ll start off...
Free Multiplayer PHP/MySQL Game — Pits of Doom
About a month ago I started giving someone PHP/MySQL lessons. In the lessons I made up a little game to teach the guy how to do different things in PHP all the way up...
Pits Of Doom Lesson 1: Planning Stage
Before you start any kind of online game you need to take a minute to sit down and consider some of the following questions: What is my game called? What is my target audience?...
