php操作ssdb

建表

phinx\bin\phinx.bat migrate -e production

建设 phinx.yml文件
paths:
migrations: %%PHINX_CONFIG_DIR%%\database\migrations
seeds: %%PHINX_CONFIG_DIR%%\database\seeds

environments:
default_migration_table: phinxlog
default_database: development
production:
adapter: mysql
host: localhost
name: jitamin2
user: root
pass: ‘‘
port: 3306
charset: utf8

development:
adapter: mysql
host: localhost
name: development_db
user: root
pass: ‘‘
port: 3306
charset: utf8

testing:
adapter: mysql
host: localhost
name: testing_db
user: root
pass: ‘‘
port: 3306
charset: utf8

数据迁移命令如下：
phinx\bin\phinx.bat seed:run -e production

%%PHINX_CONFIG_DIR%%\database\seeds下面的文件示例CreateGroupsTable.php如下：
‘admin‘,
‘password‘ => bcrypt(‘admin‘),
‘email‘ => ‘admin@admin.com‘,
‘role‘ => Role::APP_ADMIN,
],
];

$users = $this->table(‘users‘);
$users->insert($data)
->save();
}
}

---

　　任务占坑