PHP PMA_getCentralColumnsListRaw Examples

Example #1

File: db_central_columns.php Project: xtreme-jamil-shamy/phpmyadmin-cf

    $col_type = $_POST['col_type'];
    $collation = $_POST['collation'];
    if (isset($orig_col_name) && $orig_col_name) {
        echo PMA_updateOneColumn($db, $orig_col_name, $col_name, $col_type, $col_attribute, $col_length, $col_isNull, $collation, $col_extra, $col_default);
        exit;
    } else {
        $tmp_msg = PMA_updateOneColumn($db, "", $col_name, $col_type, $col_attribute, $col_length, $col_isNull, $collation, $col_extra, $col_default);
    }
}
if (isset($_POST['populateColumns'])) {
    $selected_tbl = $_POST['selectedTable'];
    echo PMA_getHTMLforColumnDropdown($db, $selected_tbl);
    exit;
}
if (isset($_POST['getColumnList'])) {
    echo PMA_getCentralColumnsListRaw($db, $_POST['cur_table']);
    exit;
}
if (isset($_POST['add_column'])) {
    $selected_col = array();
    $selected_tbl = $_POST['table-select'];
    $selected_col[] = $_POST['column-select'];
    $tmp_msg = PMA_syncUniqueColumns($selected_col, false, $selected_tbl);
}
$response = PMA_Response::getInstance();
$header = $response->getHeader();
$scripts = $header->getScripts();
$scripts->addFile('jquery/jquery.uitablefilter.js');
$scripts->addFile('jquery/jquery.tablesorter.js');
$scripts->addFile('db_central_columns.js');
$cfgCentralColumns = PMA_centralColumnsGetParams();

Example #2

File: PMA_central_columns_test.php Project: nobodypb/phpmyadmin

 /**
  * Test for PMA_getCentralColumnsListRaw with a table name
  *
  * @return void
  */
 public function testPMAGetCentralColumnsListRawWithTable()
 {
     $GLOBALS['dbi']->expects($this->at(3))->method('fetchResult')->with("SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin' AND col_name " . "NOT IN ('id','col1','col2');", null, null, $GLOBALS['controllink'])->will($this->returnValue($this->_columnData));
     $this->assertEquals(json_encode($this->_modifiedColumnData), PMA_getCentralColumnsListRaw('phpmyadmin', 'table1'));
 }

Example #3

File: PMA_central_columns_test.php Project: FilipeRamosFernandes/phpmyadmin

 /**
  * Test for PMA_getCentralColumnsListRaw
  *
  * @return void
  */
 public function testPMAGetCentralColumnsListRaw()
 {
     $this->assertEquals(json_encode(array("id", "col1")), PMA_getCentralColumnsListRaw('phpmyadmin', 'pma_central_columns'));
     $this->assertEquals(json_encode(array("id", "col1")), PMA_getCentralColumnsListRaw('phpmyadmin', ''));
 }