Introduction

Assuming you have Apache, PHP and MySQL installed with the relative modules enabled (php_gd) and configured, proceed with installing Classroombookings following these steps.

If you don't already have a working web server setup, I recommend WampServer.

Details

Set up database

Using phpMyAdmin

Note If using WampServer - click on the WAMP tray icon, then click 'phpMyAdmin'.

1. On the main phpMyAdmin page, click Privileges.
2. Scroll down and click on Add a new user.
3. Fill in the required fields in the Login Information box.
4. Select Create database with same name and grant all privileges from the Database for user box.
5. Click the Go button.

Using HeidiSQL

1. Go to Tools -> Create Database.
2. Enter a name, eg. crbs.
3. Go to Tools -> User-Manager.
4. Fill in the Username and Password field as required.
5. Select your new database (created in step 2) from the list on the right (Allow access to).
6. Optionally click the Create connection account ... box and enter a name for this connection if you want to access the database via HeidiSQL at a later date.

Extract files

First, make a directory for Classroombookings in your web server's document root (eg. c:\wamp\www\classroombookings.)

Then, using a archiving tool such as 7zip, extract the contents of the crbs archive to the new folder.

Modify config files

You will now need to edit several lines in the configuration files, relative to the directory you created previously:

• system/application/config/config.php
• system/application/config/database.php
• .htaccess (optional)

config.php

// Full URL to your installation
$config['base_url'] = 'http://www.example.com/classroombookings/';

// Empty string if using mod_rewrite in .htaccess
$config['index_page'] = 'index.php';

database.php

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'crbs_user';
$db['default']['password'] = 'password';
$db['default']['database'] = 'crbs';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;

~/.htaccess (optional)

If you're going to use Apache mod_rewrite for cleaner URLs, all you need to do is change the URL to reflect where Classroombookings is installed with a leading and trailing forward-slash.

For example, if Classroombookings was installed at http://www.example.com/classroombookings/ then you need to change the RewriteBase to reflect the installation path. If you aren't using a subdirectory, just leave a single forward-slash.

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /classroombookings/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]
</IfModule>

To enable Mod_rewrite on WAMP:

• Click the WAMP tray icon
• Click Apache
• Click Apache modules
• Make sure rewrite is ticked

Apply write permissions

The next step involves applying writeable permissions to several directories in your installation to allow Apache to upload files to them (images, CSV files etc).

On Windows, the directories are usually writeable by the web server by default. If not, you will need to use Windows Explorer to allow the web server to write to these directories (again, relative to the directory you created earlier):

• webroot/images/roomphotos
• webroot/images/schoollogo
• webroot/images/bg
• system/cache
• temp

Run installation script

Using a web browser, navigate to the web server where you installed Classroombookings to, Eg. http://www.example.com/classroombookings/. You will be presented with the installation page.

Fill in the required information and and click on the Install button.