PHP PMA_getQueryForDisplayUpdate Examples

Example #1

File: tbl_relation.lib.php Project: 1290800466/yiyuanduobao

/**
 * 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;
}

Example #2

File: tbl_relation.lib.php Project: pombredanne/ArcherSys

/**
 * 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);
    }
}

Example #3

File: PMA_tbl_relation_test.php Project: FilipeRamosFernandes/phpmyadmin

 /**
  * 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);
 }