phpmyadmin/libraries/navigation/Nodes/Node_Column.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Functionality for the navigation tree
   5  *
   6  * @package PhpMyAdmin-Navigation
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Represents a columns node in the navigation tree
  14  *
  15  * @package PhpMyAdmin-Navigation
  16  */
  17 class Node_Column extends Node
  18 {
  19     /**
  20      * Initialises the class
  21      *
  22      * @param string $name     An identifier for the new node
  23      * @param int    $type     Type of node, may be one of CONTAINER or OBJECT
  24      * @param bool   $is_group Whether this object has been created
  25      *                         while grouping nodes
  26      *
  27      * @return Node_Column
  28      */
  29     public function __construct($name, $type = Node::OBJECT, $is_group = false)
  30     {
  31         parent::__construct($name, $type, $is_group);
  32         $this->icon  = PMA_Util::getImage('pause.png', '');
  33         $this->links = array(
  34             'text' => 'tbl_structure.php?server=' . $GLOBALS['server']
  35                     . '&amp;db=%3$s&amp;table=%2$s&amp;field=%1$s'
  36                     . '&amp;change_column=1'
  37                     . '&amp;token=' . $GLOBALS['token'],
  38             'icon' => 'tbl_structure.php?server=' . $GLOBALS['server']
  39                     . '&amp;db=%3$s&amp;table=%2$s&amp;field=%1$s'
  40                     . '&amp;change_column=1'
  41                     . '&amp;token=' . $GLOBALS['token']
  42         );
  43     }
  44
  45     /**
  46      * Returns the comment associated with node
  47      * This method should be overridden by specific type of nodes
  48      *
  49      * @return string
  50      */
  51     public function getComment()
  52     {
  53         $db     = PMA_Util::sqlAddSlashes(
  54             $this->realParent()->realParent()->real_name
  55         );
  56         $table  = PMA_Util::sqlAddSlashes(
  57             $this->realParent()->real_name
  58         );
  59         $column = PMA_Util::sqlAddSlashes(
  60             $this->real_name
  61         );
  62         $query  = "SELECT `COLUMN_COMMENT` ";
  63         $query .= "FROM `INFORMATION_SCHEMA`.`COLUMNS` ";
  64         $query .= "WHERE `TABLE_SCHEMA`='$db' ";
  65         $query .= "AND `TABLE_NAME`='$table' ";
  66         $query .= "AND `COLUMN_NAME`='$column' ";
  67         return PMA_DBI_fetch_value($query);
  68     }
  69 }
  70
  71 ?>