MySQL Tutorial: Archiving and Loading Archived Table Data
Let’s say you have a really large table and you want to archive the data to a new table so that your main table is smaller again. This is useful with things like chat...
Tagged: MySQL
PHP Tutorial: Looping Through & Displaying A MySQLi 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 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,...
PHP Tutorial: Searching and Pagination
In the work that I’ve done for clients and just in browsing the web I’ve seen a fair amount of strange pagination scripts out there. If you’re looking for a simple pagination solution then...
MySQL Tutorial: A Beginners Guide
So, what is a database? If you think you’ve never used a database before you’re wrong. Are you online right now reading this post?? Guess what, you’re reading information from a database. You can...
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...
PHP Tutorial: 2 Player Tic-Tac-Toe Game (no database required)
In the first part of my games tutorial series we created a PHP Hangman game and then in the second installment we converted Hangman to use AJAX. Now it’s time to follow the same...
MySQL Workbench FIX: Cannot start SSH tunnel manager error — even when using TCP/IP connections
I recently ran into this problem when I updated to the newest version of Tortoise SVN. This error was happening every time I tried to connect to a server, even if I wasn’t using...
Pits of Doom Lesson 10: Member Interaction
In the last lesson we added the ability to fight monsters on our map and added a graphic library to display our maps and updated the map editor so we can easily customize our...
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...
