Example #1
0
 public function __construct()
 {
     $mysqli = mysqli_connect(DB_HOST, DB_USER, DB_PASS);
     //, DB_NAME
     if (mysqli_connect_errno($mysqli)) {
         echo "Не удалось подключиться к MySQL: " . mysqli_connect_error();
     }
     $queryCreateDB = "CREATE DATABASE IF NOT EXISTS " . DB_NAME;
     $res = mysqli_query($mysqli, $queryCreateDB);
     $mysqli->select_db(DB_NAME);
     $queryCreateTable = "CREATE TABLE IF NOT EXISTS `image` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Идентификатор', \n\t\t\t`image` blob NOT NULL COMMENT 'Картинка', `password` varchar(255) DEFAULT NULL COMMENT 'Пароль',  \n\t\t\tPRIMARY KEY (id)) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET utf8 COLLATE utf8_general_ci;";
     $res = mysqli_query($mysqli, $queryCreateTable);
     self::$mysqliPublic = $mysqli;
 }