@@ -8,32 +8,32 @@ |
||
| 8 | 8 | |
| 9 | 9 | class DatabaseHelper |
| 10 | 10 | { |
| 11 | - public $dbConn; |
|
| 11 | + public $dbConn; |
|
| 12 | 12 | |
| 13 | - /** |
|
| 14 | - * This is a constructor; a default method that will be called automatically during class instantiation. |
|
| 15 | - */ |
|
| 16 | - public function __construct($dbConnect) |
|
| 17 | - { |
|
| 18 | - $this->dbConn = $dbConnect; |
|
| 19 | - } |
|
| 13 | + /** |
|
| 14 | + * This is a constructor; a default method that will be called automatically during class instantiation. |
|
| 15 | + */ |
|
| 16 | + public function __construct($dbConnect) |
|
| 17 | + { |
|
| 18 | + $this->dbConn = $dbConnect; |
|
| 19 | + } |
|
| 20 | 20 | |
| 21 | - /** |
|
| 22 | - * This method creates a particular table. |
|
| 23 | - * |
|
| 24 | - * @param tableName |
|
| 25 | - * $return boolean true or false |
|
| 26 | - */ |
|
| 27 | - public function createTable($tableName, $conn = null) |
|
| 28 | - { |
|
| 29 | - if (is_null($conn)) { |
|
| 30 | - $conn = $this->dbConn; |
|
| 31 | - } |
|
| 21 | + /** |
|
| 22 | + * This method creates a particular table. |
|
| 23 | + * |
|
| 24 | + * @param tableName |
|
| 25 | + * $return boolean true or false |
|
| 26 | + */ |
|
| 27 | + public function createTable($tableName, $conn = null) |
|
| 28 | + { |
|
| 29 | + if (is_null($conn)) { |
|
| 30 | + $conn = $this->dbConn; |
|
| 31 | + } |
|
| 32 | 32 | |
| 33 | - $sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'('; |
|
| 34 | - $sql .= ' id INT( 11 ) AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 100 ), gender VARCHAR( 10 ), alias VARCHAR( 150 ) NOT NULL, class VARCHAR( 150 ), stack VARCHAR( 50 ) )'; |
|
| 33 | + $sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'('; |
|
| 34 | + $sql .= ' id INT( 11 ) AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 100 ), gender VARCHAR( 10 ), alias VARCHAR( 150 ) NOT NULL, class VARCHAR( 150 ), stack VARCHAR( 50 ) )'; |
|
| 35 | 35 | |
| 36 | - return $conn->exec($sql); |
|
| 36 | + return $conn->exec($sql); |
|
| 37 | 37 | |
| 38 | - } |
|
| 38 | + } |
|
| 39 | 39 | } |