/** * Function to handle update for display field * * @param string $disp current display field * @param string $display_field display field * @param string $db current database * @param string $table current table * @param array $cfgRelation configuration relation * * @return string */ function PMA_handleUpdateForDisplayField($disp, $display_field, $db, $table, $cfgRelation) { $html_output = ''; $upd_query = PMA_getQueryForDisplayUpdate($disp, $display_field, $db, $table, $cfgRelation); if ($upd_query) { PMA_queryAsControlUser($upd_query); $html_output = PMA_Util::getMessage(__('Display column was successfully updated.'), '', 'success'); } return $html_output; }
/** * Function to handle update for display field * * @param string $disp field name * @param string $display_field display field * @param string $db current database * @param string $table current table * @param array $cfgRelation configuration relation * * @return void */ function PMA_handleUpdateForDisplayField($disp, $display_field, $db, $table, $cfgRelation) { $upd_query = PMA_getQueryForDisplayUpdate($disp, $display_field, $db, $table, $cfgRelation); if ($upd_query) { PMA_queryAsControlUser($upd_query); } }
/** * Tests for PMA_getQueryForDisplayUpdate() method. * * @return void * @test */ public function testPMAGetQueryForDisplayUpdate() { $disp = true; $display_field = ''; $db = "pma_db"; $table = "pma_table"; $cfgRelation = array('displaywork' => true, 'relwork' => true, 'displaywork' => true, 'table_info' => 'table_info'); $GLOBALS['cfgRelation']['db'] = 'global_db'; //case 1: $disp == true && $display_field == '' $query = PMA_getQueryForDisplayUpdate($disp, $display_field, $db, $table, $cfgRelation); $query_expect = "DELETE FROM `global_db`.`table_info` " . "WHERE db_name = 'pma_db' AND table_name = 'pma_table'"; $this->assertEquals($query_expect, $query); //case 2: $disp == true && $display_field == 'display_field' $display_field == 'display_field'; $query = PMA_getQueryForDisplayUpdate($disp, $display_field, $db, $table, $cfgRelation); $query_expect = "DELETE FROM `global_db`.`table_info` " . "WHERE db_name = 'pma_db' AND table_name = 'pma_table'"; $this->assertEquals($query_expect, $query); //case 3: $disp == false && $display_field == 'display_field' $disp = false; $display_field = 'display_field'; $query = PMA_getQueryForDisplayUpdate($disp, $display_field, $db, $table, $cfgRelation); $query_expect = "INSERT INTO `global_db`.`table_info`" . "(db_name, table_name, display_field)" . " VALUES('pma_db','pma_table','display_field')"; $this->assertEquals($query_expect, $query); //case 4: $disp == false && $display_field == '' $disp = false; $display_field = ''; $query = PMA_getQueryForDisplayUpdate($disp, $display_field, $db, $table, $cfgRelation); $query_expect = ''; $this->assertEquals($query_expect, $query); }