示例#1
0
 protected function Remove_Column($column = NULL)
 {
     $query = "ALTER TABLE `" . $column[0] . "` DROP `" . $column[1] . "`";
     $Ar = new NewAr();
     $Ar->Connect();
     $Ar->driver->exec($query);
 }
示例#2
0
<?
$arraux = (isset($arraux))? $arraux: NULL;
$path=INST_PATH;
				$_POST['migrations'][$arraux['Table']] = 'on';
				$_POST['migrations']['up:selected'] = true;
				$this->MigrationsActions();
				$file = Singulars(strtolower($arraux['Table']));
				// Creation of model
				$Obj = new NewAr();
				$Obj->WriteModel($arraux['Table']);
				
				
				// Creation of the list view
				$ClassName = Camelize($arraux['Table']);
				$ClassToUse = Camelize(Singulars($arraux['Table']));
				$directory = INST_PATH."app/templates/$file/";
				if(!is_dir($directory)) mkdir($directory);
				$fp = fopen($directory.'index.phtml', 'w+b');
				$content = '<div style="float:left; width:100%;">'."\n";
				$content .= "\t".'<div align="center">'."\n";
				$content .= "\t\t".'<table width="100%">'."\n";
				$content .= "\t\t\t".'<? foreach($this->data as $row){ ?>'."\n";
				$content .= "\t\t\t<tr>\n";
				$content .= "\t\t\t".'<? foreach($row->getArray() as $col){ ?>'."\n";
				$content .= "\t\t\t\t".'<td><?=$col;?></td>'."\n";
				$content .= "\t\t\t<? } ?>\n";
				$content .= "\t\t\t\t<td><a href=\"<?=INST_URI;?>$file/delete/<?=\$row->id;?>\">delete</a>&nbsp;<a href=\"<?=INST_URI;?>$file/addedit/<?=\$row->id;?>\">Edit</a></td>\n";
				$content .= "\t\t\t</tr>\n";
				$content .= "\t\t\t<? } ?>\n";
				$content .= "\t\t</table>\n";
				$content .= "\t</div>\n";