Struggling passing database variables into class

Hi

Forgive my inability to work this out myself - still working on it :-(

I am trying to work out how to pass the connection credentials as variables from the doBackup.php

for example: doBackup.php

$host = "localhost";
$db = "database_name";
$username = "SomeUser";
$password = "SomePassword";

$B = new danenMysqlBackup();

And in the class php pass them into the __construct function

... I know it should be easy but for some reason I am struggling...

Many thanks in advance.

Hi Wayne,

Put that information in the last function in the class, getCredentials():

private function getCredentials()
{
// adapt to your environment -- FIXME
$credentials = array();
$credentials['hostname'] = 'localhost';
$credentials['username'] = 'myUsername';
$credentials['password'] = 'myPassword';
$credentials['database'] = 'myDatabase';
return $credentials;
}

Hi

Thanks for such a quick reply...

I foolishly Realised after posting about the function at the bottom.

So where I am now is trying to work out how to get variables from the doBackup file into the getCredentials function so the class can be used for several databases?

I am googling passing variables into a function and all I do is break the script.

Hi

Thanks for such a quick reply...

I foolishly Realised after posting about the function at the bottom.

So where I am now is trying to work out how to get variables from the doBackup file into the getCredentials function so the class can be used for several databases?

I am googling passing variables into a function and all I do is break the script.

Add this to the class:

public function setCredentials($hostname, $username,$password,$database)
{
$this->hostname = $hostname;
$this->username = $username;
$this->password = $password;
$this->database = $database;
}

Then, after this line,
$B = new danenMysqlBackup();

Add:
$B->setCredentials("yourhost", "host", "pw", "db");

<?php
// example to do a full database backup

require_once 'danenMysqlBackup.class.php';


// custom credentials
$customHostname = 'myHost';
$customUsername = 'myUser';
$customPassword = 'myPw';
$customDatabase = 'myDb';


$B = new danenMysqlBackup();

$backupSqlFile = $B->backupStart();

// if custom credentials are needed, pass them here
// this call is optional
$B->setCredentials($customHostname, $customUsername, $customPassword, $customDatabase);


if ( $backupSqlFile )
{
$backupSqlFile = basename($backupSqlFile);
echo "Created: $backupSqlFile";
}
else
{
echo "ERROR: backup failed.";
}

Hi

Works perfectly...

Thank you :-)