$body->line("Index creation on table : <b>" . $req->get('table') . "</b><br>"); $form = new Form(); $form->setAction('controller.php'); $form->setJs(' onsubmit="return PSA.indexcol();" '); $form->build(); // TODO: check if table name already exists $name = new Input(); $name->setName('idxname'); $name->setSize(50); $name->setMaxlength(128); $name->setId('idxname'); $body->line('Name : ' . $name->dump() . ' ' . $cmd->dump() . '<br>'); for ($i = 0; $i < sizeof($fields); ++$i) { $select = new Select(); $select->setName('col' . $i); $select->setSize(1); $select->add('', '-'); for ($j = 0; $j < sizeof($fields); ++$j) { $select->add($fields[$j], $fields[$j]); } $body->line('index on : ' . $select->dump() . '<br>'); } $submit->build(); $tblname = new Input(); $tblname->setName('tblname'); $tblname->setSize(128); $tblname->setValue($req->get('table')); $tblname->setType('hidden'); $tblname->build(); unset($form); $body->line('</div>');
$th = new Th(); $th->add('name'); $th->add('type'); $th->add('primary'); $th->add('size'); $th->add('null'); $th->add('default'); $th->build(); $colname = new Input(); $colname->setName('colname'); $colname->setSize(25); $colname->setMaxlength(128); $colname->setId('colname'); $coltype = new Select(); $coltype->setName('coltype'); $coltype->setSize(1); $coltype->setId('coltype'); $coltype->add('VARCHAR', 'VARCHAR'); $coltype->add('INTEGER', 'INTEGER'); $coltype->add('FLOAT', 'FLOAT'); $coltype->add('TEXT', 'TEXT'); $coltype->add('DATETIME', 'DATETIME'); $colprime = new Input(); $colprime->setName('colprime'); $colprime->setType('checkbox'); $colprime->setId('colprime'); $colprime->setJs(' onclick="PSA.checkprimary();" '); $colsize = new Input(); $colsize->setName('colsize'); $colsize->setSize(7); $colsize->setMaxlength(7);