Access $mysqli class within another class

[TheFilmGod]

// EMAIL
class validateEmail {

    // Grab mysqli class into scope
    global $mysqli;

... validate email
... check if email already exists in database
....

 

How can I access the $mysqli class within the validateEmail class? is there a way of doing this? I don't want to have to connect to the database again.

[the182guy]

I think what you're looking for is called the singleton design pattern.

 

One simple option is to store the mysqli object in a $GLOBALS variable. Then you can easily access the database from anywhere like

 

$GLOBALS['DB']->query();

 

There are more complicated solutions, have a look at this link:

http://www.talkphp.com/advanced-php-programming/1304-how-use-singleton-design-pattern.html

 

Hope this helps

[ignace]

Just pass it to the constructor

 

Edit: why does a validation class need access to the database?

[TheFilmGod]

Just pass it to the constructor

 

Edit: why does a validation class need access to the database?

 

Can you elaborate on how I can pass it to the constructor?

 

The validation class needs access to the database to check if the email address is in the "blacklist" - if the email address has been unsubscribed permanently. I wouldn't want users to contact me through the online contact form and use an email that is "blacklisted" on my website's unsubscribed list, because in principle, I shouldn't be sending them emails EVER... unless they resubscribe of course.

[KevinM1]

Just pass it to the constructor

 

Edit: why does a validation class need access to the database?

 

Can you elaborate on how I can pass it to the constructor?

 

class Email
{
   private $db;

   public function __construct($db)
   {
      $this->db = $db;
   }
}

$mysqli = new mysqli(/* connection string */);
$email = new Email($mysqli);

[ignace]

The validation class needs access to the database to check if the email address is in the "blacklist"

 

Maybe you can take an alternative path as it feels somehow wrong to let a validation class pull records from a database. How about whitelisting? Like below:

 

$subscribed = $usersTable->findBySubscriptionStatus('subscribed');//this line alone should give you the e-mails you need.
if (sizeof($subscribed)) {
    $validEmail = new ValidateEmail();
    if ($validEmail->massValidate($subscribed)) {//all e-mails