Default to FETCH_OBJ fetch mode on the DB connection.
darkmorford -
afcdf97a9f6a
Not Reviewed
Show More
Add another comment
TODOs: 0 unresolved 0 Resolved
COMMENTS: 0 General 0 Inline
@@ -40,6 +40,7 $dbParams = array(
40 'charset' => 'utf8mb4'
40 'charset' => 'utf8mb4'
41 );
41 );
42 $dbConnection = \Doctrine\DBAL\DriverManager::getConnection($dbParams, $dbConfig);
42 $dbConnection = \Doctrine\DBAL\DriverManager::getConnection($dbParams, $dbConfig);
43 $dbConnection->setFetchMode(PDO::FETCH_OBJ);
43
44
44 $mtdb = new MysqlStore();
45 $mtdb = new MysqlStore();
45 $mtdb->connect( DB_SERVER, DB_WRITE_USER, DB_WRITE_PASS, DB_NAME );
46 $mtdb->connect( DB_SERVER, DB_WRITE_USER, DB_WRITE_PASS, DB_NAME );
@@ -65,7 +66,7 function sanitize_username( $username ) {
65
66
66 // Attempt to login with a username and password. If from cookies, set already_hashed = true.
67 // Attempt to login with a username and password. If from cookies, set already_hashed = true.
67 function mt_login($username, $password, $already_hashed = false) {
68 function mt_login($username, $password, $already_hashed = false) {
68 global $error,$mtdb,$dbConnection;
69 global $error, $dbConnection;
69
70
70 // Fail login if either user or pass is blank
71 // Fail login if either user or pass is blank
71 if ( '' == $username )
72 if ( '' == $username )
@@ -81,7 +82,7 function mt_login($username, $password, $already_hashed = false) {
81 // Get user info from the database
82 // Get user info from the database
82 $sql = 'SELECT * FROM contributor WHERE name LIKE ?';
83 $sql = 'SELECT * FROM contributor WHERE name LIKE ?';
83 $stmt = $dbConnection->executeQuery($sql, array($username));
84 $stmt = $dbConnection->executeQuery($sql, array($username));
84 $login = $stmt->fetch(PDO::FETCH_OBJ);
85 $login = $stmt->fetch();
85
86
86 if (!$login) {
87 if (!$login) {
87 $error = ('<strong>ERROR</strong>: Invalid username or password.');
88 $error = ('<strong>ERROR</strong>: Invalid username or password.');
Comments 0
You need to be logged in to leave comments. Login now