LAMPRAD Files

----------------------------------------------------------------------------------------------------------------
	Steps for Installing LAMPRAD
----------------------------------------------------------------------------------------------------------------


1) Install and configure your LAMP Server (MySQL + PHP are the requirements, so a MAMP or WAMP)
2) Extract the files from the LAMPRAD package (e.g tar -xzvf LAMPRAD_V0.02.tar.gz)
3) Copy all the files to your LAMP Server
4) Connect to MySQL and create a new database (e.g. create database LAMPRAD;)
5) make the database active (e.g use LAMPRAD;)
6) restore the Webfiles table using Create_WebFiles.sql (e.g. \. Create_WebFiles.sql)
7) edit config.php and change the following:
7.1) sqlRHost and sqlWHost if your database and web server are different servers, otherwise leave as localhost
7.2) sqlDB replace YourDB with the database you ceated in step 4
7.3) sqlUser this needs to be set with the username that the web server will use to connect to MySQL
7.4) sqlPass this needs to be set with the password that the web server will use to connect to MySQL
8) copy all the php files to your web server public directory (e.g /var/www)
9) if index.html exists in this directory, rename or remove it.
10) navigate with a browser to your web server

Congratulations you should now have a working LAMPRAD environment.

----------------------------------------------------------------------------------------------------------------
	Additional LAMPRAD Info
----------------------------------------------------------------------------------------------------------------

1) On the home page you should see a link for EditPages, from this page you have a form that lets you create new pages, update existing ones or delete. LAMPRAD provides automatic versioning of your pages. Before you go live with your web site you will want to remove access from this page. If you have multiple environments then this page should be removed from your production site. all pages are sored in the WebFiles table.

2) There is a global php variable $db, to use it inside your functions you will need a line like "global $db;". $db is an array that will provide you access to your database connection. $db['ConnR'] and $db['ConnW'] are PDO database connections already connected to your database, use $db['ConnR'] for selects and $db['ConnW'] for inserts, updates and deletes.

3) Scalability - when a site grows in popularity it needs to be able to scale quickly to cope with the extra load. Most sites need a lot of rework in order to be able to scale well. LAMPRAD is designed to scale quickly out of the box, so any site developed with LAMPRAD will automatically have this scaleability. LAMPRAD provides scalability in a number of ways:
3.1) Adding extra web servers, you do not need to deploy your whole site to a new web server only the 3 php files included in the LAMPRAD package need to be added to a standard out of the box web server.
3.2) The database server can easily be seperated from the web server, only 2 lines need to be updated in the config.php
3.3) if your database server is really busy you can seperate the reading and writing loads, create a read only replica of your database and update sqlRHost in your config.php file to use this replica.

4) http://codemirror.net/ provides syntax highlighting for a number of programming languages, it can be quite easily added into EditPages especially for use in your development environment.