Welcome Guest, Not a member yet? Register   Sign In
Creating a new database.
#1

(This post was last modified: 10-10-2022, 06:50 PM by davecoventry.)

I've been trying to follow the process for creating a new database, as detailed here: https://codeigniter4.github.io/userguide...se-db-name
PHP Code:
<?php
namespace App\Models;
use 
CodeIgniter\Model;
use 
CodeIgniter\Database\RawSql;

class 
InitiateDatabaseModel extends Model{
public function 
createDrawingTable($id){
    $dbName 'D'.$id;
    $forge = \Config\Database::forge();
    $forge->createDatabase($dbName,TRUE);

    $fields = array(
        'element'=>array(
                'type'=>'INT',
                'unsigned'=>true
            
),
        'eID'=>array(
                'type'=>'INT',
                'unsigned'=>true
            
),
        'txt'=>array(
                'type'=>'VARCHAR',
                'constraint'=>255
            
)
        );
$forge->addField($fields);
$forge->createTable('text'TRUE); 
The Database is not created but the table, with its fields, is added to the default database.
What am I doing wrong?
~ Dave
Reply


Messages In This Thread
Creating a new database. - by davecoventry - 10-10-2022, 12:30 PM
RE: Creating a new database. - by InsiteFX - 10-11-2022, 01:04 AM
RE: Creating a new database. - by davecoventry - 10-11-2022, 02:44 AM
RE: Creating a new database. - by InsiteFX - 10-12-2022, 01:24 AM
RE: Creating a new database. - by davecoventry - 10-12-2022, 06:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB