Tips & Tricks
- October 19, 2009
Use Zend_Form to create SQL table
A quick code snippet that uses a Zend form (in the case below, with subforms) to generate a SQL table create statement. Useful for scaffolding : create your form with Zend Form Elements then the SQL table automatically.
-
<textarea rows="50" cols="80">
-
create table yrbeaute (`id` int(10) NOT NULL AUTO_INCREMENT,<?
-
foreach($this->form as $k=>$subform)
-
{
-
foreach($subform as $k=>$element)
-
{
-
if ($element->getType()=="Zend_Form_Element_Select") $type="varchar(50)";
-
if ($element->getType()=="Zend_Form_Element_Radio") $type="varchar(50)";
-
if ($element->getType()=="Zend_Form_Element_Text") $type="varchar(255)";
-
if ($element->getType()=="Zend_Form_Element_Textarea") $type="text";
-
if ($element->getType()=="Zend_Form_Element_MultiCheckbox") $type="varchar(255)";
-
?>
-
<?=$element->getName() ?> <?=$type?>,
-
<?
-
} else
-
foreach($element as $k=>$elem )
-
{
-
?><?=$elem->getName() ?> varchar(50),
-
<?
-
}
-
-
}}
-
?> step int(5), `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
