PMA\libraries\plugins\export\ExportOdt::getTriggers PHP Method

getTriggers() protected method

Outputs triggers
protected getTriggers ( string $db, string $table, array $aliases = [] ) : boolean
$db string database name
$table string table name
$aliases array Aliases of db/table/columns
return boolean true
    protected function getTriggers($db, $table, $aliases = array())
    {
        $db_alias = $db;
        $table_alias = $table;
        $this->initAlias($aliases, $db_alias, $table_alias);
        $GLOBALS['odt_buffer'] .= '<table:table' . ' table:name="' . htmlspecialchars($table_alias) . '_triggers">' . '<table:table-column' . ' table:number-columns-repeated="4"/>' . '<table:table-row>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Name') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Time') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Event') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Definition') . '</text:p>' . '</table:table-cell>' . '</table:table-row>';
        $triggers = $GLOBALS['dbi']->getTriggers($db, $table);
        foreach ($triggers as $trigger) {
            $GLOBALS['odt_buffer'] .= '<table:table-row>';
            $GLOBALS['odt_buffer'] .= '<table:table-cell office:value-type="string">' . '<text:p>' . htmlspecialchars($trigger['name']) . '</text:p>' . '</table:table-cell>';
            $GLOBALS['odt_buffer'] .= '<table:table-cell office:value-type="string">' . '<text:p>' . htmlspecialchars($trigger['action_timing']) . '</text:p>' . '</table:table-cell>';
            $GLOBALS['odt_buffer'] .= '<table:table-cell office:value-type="string">' . '<text:p>' . htmlspecialchars($trigger['event_manipulation']) . '</text:p>' . '</table:table-cell>';
            $GLOBALS['odt_buffer'] .= '<table:table-cell office:value-type="string">' . '<text:p>' . htmlspecialchars($trigger['definition']) . '</text:p>' . '</table:table-cell>';
            $GLOBALS['odt_buffer'] .= '</table:table-row>';
        }
        $GLOBALS['odt_buffer'] .= '</table:table>';
        return true;
    }