[first_name] VARCHAR(40), [last_name] VARCHAR(40), [email] VARCHAR(250));"); // Create table messages $file_db->exec("CREATE TABLE [course] ( [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [start] DATETIME NOT NULL, [end] DATETIME NOT NULL, [teacher_id] CHAR NOT NULL CONSTRAINT [FK_course_teacher] REFERENCES [teacher]([id]));"); // Create table messages $file_db->exec("CREATE TABLE [person] ( [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [first_name] VARCHAR(40) NOT NULL, [last_name] VARCHAR(40) NOT NULL, [email] VARCHAR(250) NOT NULL, [identity] created NOT NULL);"); // Create table messages $file_db->exec("CREATE TABLE [student] ( [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [person_id] INTEGER NOT NULL CONSTRAINT [FK_student_person] REFERENCES [person]([id]), [course_id] INTEGER NOT NULL CONSTRAINT [FK_student_course] REFERENCES [course]([id]), [created] DATETIME NOT NULL, [aborted] DATETIME);"); */ $cdbyuml = new \Dlid\DbYuml\CDbYuml($file_db, ['scale' => 230, 'style' => 'scruffy', 'cachepath' => 'dlid14.mh', 'cachetime' => '15 minutes']); $cdbyuml->outputText(); // Uncommen to see debug information # ->outputImage(true);
<?php require '../autoloader.php'; $dbh = new PDO('mysql:host=localhost;dbname=ames;', 'root', '3UfRAwak', array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'')); $cdbyuml = new \Dlid\DbYuml\CDbYuml($dbh, ['cachepath' => 'mysql_example', 'cachetime' => '15 minutes']); $cdbyuml->outputText(true)->outputImage();