function __construct() { parent::__construct(); $this->factory = new Student_passwdDomainFactory(); $this->selectStmt = self::$pdo->prepare("SELECT * FROM student_password WHERE open_id=?"); $this->insertStmt = self::$pdo->prepare("INSERT INTO student_password (open_id,student_id,zhxy_psw,jwxt_psw,tsg_psw,aolan_psw) VALUES(?,?,?,?,?,?)"); $this->deleteStmt = self::$pdo->prepare("DELETE FROM student_password WHERE open_id=?"); $this->updateStmt = self::$pdo->prepare("UPDATE student_password set zhxy_psw=?,jwxt_psw=?,tsg_psw=?,aolan_psw=? WHERE open_id=?"); $this->updateAllStmt = self::$pdo->prepare("UPDATE student_password set student_id=?,zhxy_psw=?,jwxt_psw=?,tsg_psw=?,aolan_psw=? WHERE open_id=?"); }
function __construct() { if (!isset(self::$pdo)) { try { // $dsn="mysql:dbname=afwdb;host=localhost;port=3306"; // $user="******"; // $password=""; $dsn = "mysql:dbname=afwdb;host=55bcb9ddc1a3f.sh.cdb.myqcloud.com;port=6055"; $user = "******"; $password = "******"; self::$pdo = new PDO($dsn, $user, $password); self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die; } } }