PMA\libraries\Table::getReservedColumnNames PHP Method

getReservedColumnNames() public method

Get all column names which are MySQL reserved words
public getReservedColumnNames ( ) : array
return array
    public function getReservedColumnNames()
    {
        $columns = $this->getColumns(false);
        $return = array();
        foreach ($columns as $column) {
            $temp = explode('.', $column);
            $column_name = $temp[2];
            if (Context::isKeyword($column_name, true)) {
                $return[] = $column_name;
            }
        }
        return $return;
    }

Usage Example

Example #1
0
 /**
  * Test for getColumns
  *
  * @return void
  */
 public function testGetColumns()
 {
     $table = 'PMA_BookMark';
     $db = 'PMA';
     $table = new Table($table, $db);
     $return = $table->getColumns();
     $expect = array('`PMA`.`PMA_BookMark`.`column1`', '`PMA`.`PMA_BookMark`.`column3`', '`PMA`.`PMA_BookMark`.`column5`', '`PMA`.`PMA_BookMark`.`ACCESSIBLE`', '`PMA`.`PMA_BookMark`.`ADD`', '`PMA`.`PMA_BookMark`.`ALL`');
     $this->assertEquals($expect, $return);
     $return = $table->getReservedColumnNames();
     $expect = array('ACCESSIBLE', 'ADD', 'ALL');
     $this->assertEquals($expect, $return);
 }