/** * Get HTML snippet for privileges that are attached to a specific column * * @param string $columns olumns array * @param array $row first row from result or boolean false * * @return string $html_output */ function PMA_getHtmlForAttachedPrivilegesToTableSpecificColumn($columns, $row) { $html_output = PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'Select_priv', 'SELECT', 'select', __('Allows reading data.'), 'Select'); $html_output .= PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'Insert_priv', 'INSERT', 'insert', __('Allows inserting and replacing data.'), 'Insert'); $html_output .= PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'Update_priv', 'UPDATE', 'update', __('Allows changing data.'), 'Update'); $html_output .= PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'References_priv', 'REFERENCES', 'references', __('Has no effect in this MySQL version.'), 'References'); return $html_output; }
/** * Test for PMA_getHtmlForDisplayColumnPrivileges * * @return void */ public function testPMAGetHtmlForDisplayColumnPrivileges() { $columns = array( 'row1' => 'name1' ); $row = array( 'name_for_select' => 'Y' ); $name_for_select = 'name_for_select'; $priv_for_header = 'priv_for_header'; $name = 'name'; $name_for_dfn = 'name_for_dfn'; $name_for_current = 'name_for_current'; $html = PMA_getHtmlForDisplayColumnPrivileges( $columns, $row, $name_for_select, $priv_for_header, $name, $name_for_dfn, $name_for_current ); //$name $this->assertContains( $name, $html ); //$name_for_dfn $this->assertContains( $name_for_dfn, $html ); //$priv_for_header $this->assertContains( $priv_for_header, $html ); //$name_for_select $this->assertContains( $name_for_select, $html ); //$columns and $row $this->assertContains( htmlspecialchars('row1'), $html ); //$columns and $row $this->assertContains( _pgettext('None privileges', 'None'), $html ); }