Bridging Etomite and SMF

A few months ago I started a photography forum with another moderator from a previous forum I was on. Part of our goal was to have a library of articles in a static site and link those articles back to a Simple Machines forum for discussion.
For the CMS I decided on Etomite since I’ve [...]

Get list of MySQL databases using PHP

MySQL has a built-in command to get a list of databases that can be accessed by the currently logged in user, and it is very easy to take this list and use it inside a PHP script.
First, let’s look at the command from inside the MySQL monitor ptogram. If you have any experience inside [...]

Get MySQL version using PHP

Many web based applications need to know what version of MySQL they are using. Fortunately MySQL has a built in command that will return the version as part of a query. Just enter the following command at the MySQL prompt and the server will return the version.

If you’re needing to get the version [...]

How to install Menalto Gallery 2

If you’re looking to start an online photo gallery, Menalto Gallery may be a good fit for you. It’s free and open-source so you don’t have to spend any money for it and you can customize it as much as you want with a little PHP skill.
Downloading
The Gallery download page has several packages that [...]

How to create a MySQL database with a shell account

Some hosts give you the ability to login with a shell account through SSH. Even if this option is available, and on many hosts it is not, most of your admin activities will be more difficult since you will be using a command line interface rather than a web control panel like cPanel or [...]