Question

I ve created an email class that will add users to a mysql database. then I ve created two methods, the first is private static so I can access it within the second method which is public static, when run this class displays a blank page? What could be the cause of the blank page?

class Email {
private static function DATABASE() {
    $dbh = new PDO("mysql:host=localhost;dbname=emails",  bjw123nasd4441 ,  hj12j2kJKj11s );
    return $dbh;
}
public static function addemail($email) {
    $sqldata = array( email  => $email);
        $stat = Email::DATABASE();
    $stat->prepare("INSERT INTO tasklist (email) VALUES (:email)");
    $stat->execute($sqldata);
    }
}

Email::addemail( foo@bar.com );

I get this error with PHP Display Errors..

Call to undefined method PDO::execute()

Answer 1

您试图直接打电话pdo->execute(),赢得笔工作。尝试:

$stat = self::DATABASE();
$query = $stat->prepare("INSERT INTO tasklist (email) VALUES (:email)");
$query->execute($sqldata);

and you should also just use one pdo instance:

class Email {

    private static $dbh = null;

    private static function DATABASE() {
        if(is_null(self::$dbh))
            self::$dbh = new PDO("mysql:host=localhost;dbname=emails",  bjw123nasd4441 ,  hj12j2kJKj11s );
        return self::$dbh;
    }

    //...

}

Answer 2

我认为,你在这条线上遇到过“FATAL”错误:

$stat = Task::DATABASE();

不存在任务? 页: 1 电子邮件:DATABASE();。

我假定你也没有显示你的错误,你可以试图把以下错误放在你的文字上:

error_reporting(E_ALL);
ini_set( display_errors , true);

This should fix your white screen with an clear error.

Sidenote(s)

You instantiate a new database connection on each email you want to add.
I believe an class Email shouldn t be in charge of your database connection.

友情链接