[Release] Compose Log Reader - PHP

$host = "127.0.0.1";  //This is the host for your db. Usually 127.0.0.1 or localhost
$user = "root"; //This is your db's username
$pw = "test";  //This is your db's password
$db = "log";  //This is your database

class NewACME_MY_Database extends PDO
	{
		//Declare variables
		private
			$driver,
			$host,
			$database,
			$user,
			$password,
			$port;

		//Setup constructor
		public function __construct()
		{
			//Set all the variables
			$this->driver = 'mysql';
			$this->host = 'localhost';
			$this->database = 'my';
			$this->user = 'userName';
			$this->password = 'Password';
			$this->port = 3307;

			//Setup the DNS
			$dns = $this->driver.':dbname='.$this->database.';host='.$this->host.';port='.$this->port;

			//Setup the PDO
			parent::__construct($dns,$this->user,$this->password);
		}
	}

<?php
	//Include the database file, account
	include_once('classes/database.php');
	include_once('classes/account.php');

	class MainAccount
	{
		//Declare constants
		const
			CURRENT_DATE = 'CUR_DATE';
		//Declare variables
		private
			$id,
			$name,
			$ap,
			$paypal_email,
			$monthly_limit,
			$first_purchase,
			$total_purchased,
			$total_sold,
			$accounts_new,
			$accounts_classic,
			$current_limit;

		//Declare get methods
		function getID()
		{return $this->id;}
		function getName()
		{return $this->name;}
		function getAP()
		{return $this->ap;}
		function getPaypalEmail()
		{return $this->paypal_email;}
		function getMonthlyLimit()
		{return $this->monthly_limit;}
		function getFirstPurchase()
		{return $this->first_purchase;}
		function getTotalPurchased()
		{return $this->total_purchased;}
		function getTotalSold()
		{return $this->total_sold;}
		function getAccountsNew()
		{return $this->accounts_new;}
		function getAccountsClassic()
		{return $this->accounts_classic;}
		function getAccounts($server)
		{
			switch ($server) {
				case 'new':
					return $this->accounts_new;

				case 'classic':
					return $this->accounts_classic;
			}
		}
		function getAccountCount()
		{
			return count($this->accounts_new) + count($this->accounts_classic);
		}
		function getError()
		{return   $this->error;}
		function getTotalPurchasedByDate($date)
		{
			//determine if this is a current month check
			//if($date == )
		}

		//Declare constructor
		function __construct($id)
		{
			//Set the ID
			$this->id = $id;

			//Setup the database
			$database = new SMF_Database();

			//Setup the SQL
			$sql = 'select * from smf_members where id_member = '.$id;

			//Prepare the SQL
			$statement = $database->prepare($sql);

			//Execute the SQL
			$statement->execute();

			//bind the columns
			$statement->bindColumn('real_name',$name);

			//if there was an entry (there should be)
			if($statement->fetch(PDO::FETCH_BOUND))
			{
				//Set the name
				$this->name = $name;
			}

			//Setup the database
			$database = new CP_Database();

			//Setup the SQL
			$sql = 'select * from cp_member_details where id_user = '.$id;

			//prepare the sQL
			$statement = $database->prepare($sql);

			//execute the SQL
			$statement->execute();

			//bind the columns
			$statement->bindColumn('ap',$ap);
			$statement->bindColumn('paypal_email',$paypal_email);
			$statement->bindColumn('monthly_limit',$monthly_limit);
			$statement->bindColumn('first_purchase',$first_purchase);
			$statement->bindColumn('total_purchased',$total_purchased);
			$statement->bindColumn('total_sold',$total_sold);

			//if there was an entry
			if($statement->fetch(PDO::FETCH_BOUND))
			{
				//Set all the values
				$this->ap = $ap;
				$this->paypal_email = $paypal_email;
				$this->monthly_limit = $monthly_limit;
				$this->first_purchase = $first_purchase;
				$this->total_purchased = $total_purchased;
				$this->total_sold = $total_sold;
			}
			else
			{
				//Set all the basic values
				$this->ap = 0;
				$this->paypal_email = 'N/A';
				$this->monthly_limit = 'N/A';
				$this->first_purchase = 'N/A';
				$this->total_purchased = 'N/A';
				$this->total_sold = 'N/A';
			}
			//Setup the SQL statement
			$sql = 'select * from cp_linked_accounts_newacme where id_user = '.$id;

			//prepare the SQL statement
			$statement = $database->prepare($sql);

			//execute the script
			$statement->execute();

			//bind columns
			$statement->bindColumn('id_account',$accountID);

			//whilst there are still rows to fetch
			while($statement->fetch(PDO::FETCH_BOUND))
			{
				//Add new account
				$this->accounts_new[count($this->accounts_new)] = new NewACMEAccount($accountID);
			}

			//Setup the SQL statement
			$sql = 'select * from cp_linked_accounts_classicacme where id_user = '.$id;

			//prepare the SQL statement
			$statement = $database->prepare($sql);

			//execute the script
			$statement->execute();

			//bind columns
			$statement->bindColumn('id_account',$accountID);

			//whilst there are still rows to fetch
			while($statement->fetch(PDO::FETCH_BOUND))
			{
				//Add the new account
				$this->accounts_classic[count($this->accounts_classic)] = new ClassicACMEAccount($accountID);
			}
		}

		function addNewAccount($accountID)
		{
			//Create the account
			$account = new NewACMEAccount($accountID);

			//Add it to the end of the array
			$this->accounts_new[count($this->accounts_new)] = $account;
		}

		function addClassicAccount($accountID)
		{
			//Create the account
			$account = new ClassicACMEAccount($accountID);

			//Add it to the end of the array
			$this->accounts_classic[count($this->accounts_classic)] = $account;
		}

		function removeNewAccount($index)
		{
			//Loop through each account
			for ($i=0; $i < count($this->accounts_new); $i++) 
			{ 
				//if this is the account being removed
				if($i == $index)
				//continue to the next and set the index change
				{$indexChange = -1; continue;}

				//copy over the account
				$accounts[$i+$indexChange]=$this->accounts_new[$i];
			}

			//copy over the accounts
			$this->accounts_new = $accounts;
		}

		function removeClassicAccount($index)
		{
			//Loop through each account
			for ($i=0; $i < count($this->accounts_classic); $i++) 
			{ 
				//if this is the account being removed
				if($i == $index)
				//continue to the next and set the index change
				{$indexChange = -1; continue;}

				//copy over the account
				$accounts[$i+$indexChange]=$this->accounts_classic[$i];
			}

			//copy over the accounts
			$this->accounts_classic = $accounts;
		}

		function newAccountExistsByIndex($index)
		{
			return $index < count($this->accounts_new);
		}

		function classicAccountExistsByIndex($index)
		{
			return $index < count($this->accounts_classic);
		}
	}
?>