How to create table from PDO in yii2?

Question

Hy guys, How to create table in PDO yii2? this code in my controller

$db = new yii\db\Connection([
        'dsn' => 'pgsql:host=localhost;dbname=mydata',
        'username' => 'local',
        'password' => 'bukapeta',
        'charset' => 'utf8',
    ]);


 $commandR = "CREATE TABLE mencoba(nama_tempat TEXT ,tanggal TEXT ,waktu TEXT ,alamat TEXT ,jenis_tempat TEXT ,keterangan TEXT ,foto_lokasi TEXT ,latitude TEXT ,longitude TEXT ,tanggal_buat TEXT ,update_terakhir TEXT ,pembuat TEXT);"
 $command = $db->createCommand($commandR);
 $command->execute();

enter image description here

but this error please help me..

Welcome to stackoverflow! Your problem is right there in the error message: `Class 'Yii\db\Connection' not found`. You should try replacing those backslashes ("\") with forward slashes ("/")... — bassim, Feb 02 '15 at 12:56

score 4 · Accepted Answer · edited May 28 '15 at 05:31

4

add $db->open()

$db = new \yii\db\Connection([
    'dsn' => 'pgsql:host=localhost;dbname=mydata',
    'username' => 'local',
    'password' => 'bukapeta',
    'charset' => 'utf8',
]);
$db->open();

edited May 28 '15 at 05:31

Kinjal Dixit

7,777
2
59
68

answered May 28 '15 at 05:26

Hiren Bhut

1,166
1
13
19

score 1 · Answer 2 · answered Feb 08 '16 at 09:00

1

You can use the method createTable of the queryBuilder. For example :

$queryBuilder = rows = (new \yii\db\Query());
$sql = $queryBuilder->createTable('myTable', [
    'id' => 'pk',
    'myColumn' => 'string',
    'myOtherColumn' => 'number'
]);

answered Feb 08 '16 at 09:00

n1c01a5

88
9

How to create table from PDO in yii2?

2 Answers2