PHP & MySQL Tutorials
Beginner
- XAMPP: Learn PHP & MySQL Without Online Hosting
- Learning PHP –
Part 1 |
Part 2 |
Part 3 - Get Filename From Domain Path
- Format Dates With Country Consideration
- Connecting to a MySQL Database Using PHP
- SQL Syntax
Intermediate
- Object Oriented Programming
- Loop Through MySQL Result Set
- Put ENUM Values Into Select Box
- Combine Multiple MySQL Rows Into A Single List
- Print All MySQL Tables & Fields Using PHP
- PHP Class File Generator
- Searching and Pagination
Advanced
- Mixing Hex Colors
- Dynamically Color & Overlay Images
- Hangman Game (no database required)
- 2 Player Tic Tac Toe Game (no database required)
- Update Database Results Using Complex Joins
- Create An Email Address In CPanel
Uses AJAX
Uses Angular
- Basic Chat Room (no database or sockets required)
- Advanced Chat Room (no database or sockets required)
Flash AS3 Tutorials
- Easily Add or Remove All Event Listeners
- Embed External .SWF Files
- Difference between a number, int and uint
- Change font styles on textinput and textarea components
- Put tilelist component pictures beside label text
- Remove HTML Tags
- Convert URLs to clickable hyperlinks
- Create 2D or 3D dynamic multi-dimensional arrays
Smartfox Server 2X Tutorials
Pits of Doom
Open Source SIM Game With Tutorials
A while back I was working with some interns and I created this game to teach them PHP and MySQL. We ended up making a little multiplayer online fighting SIM game which I’ve polished up a bit since then. I’m going to share the insights of creating your own PHP/MySQL game by posting the code for this game under the GNU public license. That way you’re free to edit/update and change it as you see fit. We’d appreciate it if you post a link back to our website if you use the code. The available lessons are below with more to come. We’ll also include a .zip file with the final code, images and an installation file once all of the lessons have been posted. Enjoy.
- Lesson 1: Planning & Design Stage
- Lesson 2: Breaking It Down
- Lesson 3: Mixing Things Up
- Lesson 4: And Array We Go
- Lesson 5: Easy Map Editor
- Lesson 6: MySQL Database Class
- Lesson 7: Join, Login & Lost Password
- Lesson 8: Monsters & Field Of View
- Lesson 9: Bring The Fight
- Lesson 10: Member Interaction
APIs & Manuals
in CHM format unless it says otherwise
- Ajax
- Ajax (PDF)
- Allegro API
- C++ Quick Reference (PDF)
- C++ Essentials (PDF)
- C++ part 1
- C++ part 2
- HTML 4 W3C Specs
- HTML 5 W3C Specs (PDF)
- CSS3 W3C Specs (PDF)
- CVS
- Javascript Reference
- Mysql 4
- PHP 4
- PHP 5
- XML
White Papers
Game Industry News, Magazines and Stat PDFs
Informative
- Building Brand Loyalty
- Games & Health
- Optimizing Game Architecture With Threading
- Designing a Framework for a Parallel Game Engine
- Threading and the Making of Ghostbusters
- Multi-Threaded Fluid Simulation
- Rendering Grass with DirectX 10
- Threading Game Aritificial Intelligence
- How To Incorporate Stupidity Into Your AI
Stats & Facts
- Video Games and Families
- Video Games and Social Issues
- Transofrmation of the Video Game Industry
- Scripting Language Rankings 2007
- Game Careers Guide 2008
- Game Careers Guide 2009
- Game Careers Guide 2010
- Game Careers Guide 2011
- ESA Virginia Games Industry 2010
- ESA Sales, Demographic and Usage Data 2008
- ESA Sales, Demographic and Usage Data 2009
- ESA Sales, Demographic and Usage Data 2010
- ESA Sales, Demographic and Usage Data 2011
- ESA Sales, Demographic and Usage Data 2012
- ESA Games and Violence 2008
- ESA Games and Violence 2012
- ESA Violence Overview 2012
- ESA Economics Overview 2012
- ESA Player Data Overview 2012
- ESA Sales Overview 2012
Magazines
- Visual Adrenaline 2009
- Visual Adrenaline 2010
- Visual Adrenaline 2011
- Visual Adrenaline 2012
- World Gaming Executives: Issue 1
- World Gaming Executives: Issue 2
- World Gaming Executives: Issue 3
- World Gaming Executives: Issue 4
- World Gaming Executives: Issue 5
Graphics, Sprites & Isometric Tilesheets
for your 2D games
