PHP Tutorial: Connecting to a MySQLi Database
So, here’s the low down on how to setup a connection to a MySQL database using MySQLi and PHP. This will also make sure your login information is protected. First, you’ll need a database,...
Tagged: database
PHP Tutorial: Mass search and replace database field contents
So recently I needed to remove a bunch of URLs from my member’s content on my games because of spyware/malware notifications Chrome users were getting. It took me a bit to figure out how...
MSSQL Tutorial: Select All Tables & Fields
select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype=’U’) order by table_name
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?...
