how to create table in database dynamically using doctrine

Question

Unable to create tables dynamically using doctrine,I got queries for insert,update but i am not able to create table in database,I tried to find but it is showing table created using command line,I want to create using php script and dynamically

HERE IS MY CODE

<?php
//bootstrap.php
// I am able to fetch ,insert ,delete records from existing tables and      wanted to 
//know if there is any way i can create table using php script 
// i am aware that we can create table using CMD but willing to create using     only php scripts i.e Dynamically


use Doctrine\ORM\Tools\Setup;
use Doctrine\ORM\EntityManager;
use Doctrine\DBAL\DriverManager;
use Doctrine\DBAL\Connection;
use Doctrine\ORM\Mapping\Driver\AnnotationDriver;
use Doctrine\Common\Annotations\AnnotationReader;
use Doctrine\Common\Annotations\AnnotationRegistry;

require_once __DIR__ . '/vendor/autoload.php';
require_once __DIR__ . '/entities/Users.php';

$paths            = array(__DIR__ . '/entities');
$isDevMode        = false;
$connectionParams = array(
'driver'   => 'pdo_mysql',
'user'     => 'root',
'host'     =>  'localhost',
'password' => '',
'dbname'   => 'doctrine',
);

$config = Setup::createConfiguration($isDevMode);
$driver = new AnnotationDriver(new AnnotationReader(), $paths);

// registering noop annotation autoloader - allow all annotations by default
AnnotationRegistry::registerLoader('class_exists');
$config->setMetadataDriverImpl($driver);

$em = EntityManager::create($connectionParams, $config);

$query = $em->createQuery('SELECT u.email, u.password FROM users u');
$users = $query->getResult(); // array of CmsUser username and name values
echo $users[0]['email'];

And where is your code so we can help you?

Milad Faridnia
– Milad Faridnia

2015-12-01 08:43:14 +00:00
Commented Dec 1, 2015 at 8:43 — Milad Faridnia
– Milad Faridnia, Commented Dec 1, 2015 at 8:43

Community · Accepted Answer · 2017-05-23 10:29:36Z

4

The following two answers helped me solve a comparable problem:

Code:

$metadata = $entityManager->getClassMetadata($entityClass)

$schemaTool = new \Doctrine\ORM\Tools\SchemaTool($entityManager);
// you can drop the table like this if necessary
$schemaTool->dropSchema(array($metadata));
$schemaTool->createSchema(array($metadata));

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Mar 9, 2016 at 14:49

dave

1,4941 gold badge12 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to create table in database dynamically using doctrine

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related