1. Go to this page and download the library: Download popphp/pop-kettle library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
use Pop\Db\Adapter\AbstractAdapter;
use Pop\Db\Sql\Seeder\AbstractSeeder;
class MyFirstSeeder extends AbstractSeeder
{
public function run(AbstractAdapter $db): void
{
}
}
use Pop\Db\Adapter\AbstractAdapter;
use Pop\Db\Sql\Seeder\AbstractSeeder;
class DatabaseSeeder extends AbstractSeeder
{
public function run(AbstractAdapter $db): void
{
$sql = $db->createSql();
$sql->insert('users')->values([
'username' => 'testuser',
'password' => '12test34',
'email' => '[email protected]'
]);
$db->query($sql);
}
}
use Pop\Db\Sql\Migration\AbstractMigration;
class MyFirstMigration5dd822cdede29 extends AbstractMigration
{
public function up(): void
{
}
public function down(): void
{
}
}
use Pop\Db\Sql\Migration\AbstractMigration;
class MyFirstMigration5dd822cdede29 extends AbstractMigration
{
public function up(): void
{
$schema = $this->db->createSchema();
$schema->create('users')
->int('id', 16)->increment()
->varchar('username', 255)
->varchar('password', 255)
->varchar('email', 255)
->primary('id');
$schema->execute();
}
public function down(): void
{
$schema = $this->db->createSchema();
$schema->drop('users');
$schema->execute();
}
}