PHP CImportTools::getDatabaseStructure Examples

Example #1

File: vw_database_explorer.php Project: OpenXtrem/mediboard-test

<?php

/**
 * $Id$
 *  
 * @category ImportTools
 * @package  Mediboard
 * @author   SARL OpenXtrem <*****@*****.**>
 * @license  GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 * @version  $Revision$
 * @link     http://www.mediboard.org
 */
CCanDo::checkAdmin();
$databases = CImportTools::getAllDatabaseInfo();
foreach ($databases as $_dsn => &$_info) {
    $_info = CImportTools::getDatabaseStructure($_dsn, true);
}
$smarty = new CSmartyDP();
$smarty->assign("databases", $databases);
$smarty->display("vw_database_explorer.tpl");

Example #2

File: ajax_select_primary_key.php Project: fbone/mediboard4

<?php

/**
 * $Id: ajax_select_primary_key.php 27769 2015-03-30 08:45:03Z phenxdesign $
 *  
 * @category ImportTools
 * @package  Mediboard
 * @author   SARL OpenXtrem <*****@*****.**>
 * @license  GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 * @version  $Revision: 27769 $
 * @link     http://www.mediboard.org
 */
CCanDo::checkAdmin();
$dsn = CValue::get("dsn");
$table = CValue::get("table");
$column = CValue::get("column");
$db_info = CImportTools::getDatabaseStructure($dsn);
$smarty = new CSmartyDP();
$smarty->assign("dsn", $dsn);
$smarty->assign("table", $table);
$smarty->assign("column", $column);
$smarty->assign("db_info", $db_info);
$smarty->display("inc_select_primary_key.tpl");