libraries/display_create_table.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Displays form for creating a table (if user has privileges for that)
   5  *
   6  * for MySQL >= 4.1.0, we should be able to detect if user has a CREATE
   7  * privilege by looking at SHOW GRANTS output;
   8  * for < 4.1.0, it could be more difficult because the logic tries to
   9  * detect the current host and it might be expressed in many ways; also
  10  * on a shared server, the user might be unable to define a controluser
  11  * that has the proper rights to the "mysql" db;
  12  * so we give up and assume that user has the right to create a table
  13  *
  14  * Note: in this case we could even skip the following "foreach" logic
  15  *
  16  * Addendum, 2006-01-19: ok, I give up. We got some reports about servers
  17  * where the hostname field in mysql.user is not the same as the one
  18  * in mysql.db for a user. In this case, SHOW GRANTS does not return
  19  * the db-specific privileges. And probably, those users are on a shared
  20  * server, so can't set up a control user with rights to the "mysql" db.
  21  * We cannot reliably detect the db-specific privileges, so no more
  22  * warnings about the lack of privileges for CREATE TABLE. Tested
  23  * on MySQL 5.0.18.
  24  *
  25  * @package PhpMyAdmin
  26  */
  27 if (! defined('PHPMYADMIN')) {
  28     exit;
  29 }
  30
  31 /**
  32  *
  33  */
  34 require_once './libraries/check_user_privileges.lib.php';
  35
  36 $is_create_table_priv = true;
  37
  38 /**
  39  * Returns the html for create table.
  40  *
  41  * @param string $db database name
  42  *
  43  * @return string
  44  */
  45 function PMA_getHtmlForCreateTable($db)
  46 {
  47     $html  = '<form id="create_table_form_minimal" method="post" '
  48         . 'action="tbl_create.php">';
  49     $html .= '<fieldset>';
  50     $html .= '<legend>';
  51
  52     if (PMA_Util::showIcons('ActionLinksMode')) {
  53         $html .= PMA_Util::getImage('b_newtbl.png');
  54     }
  55     $html .= __('Create table');
  56
  57     $html .= ' </legend>';
  58     $html .= PMA_URL_getHiddenInputs($db);
  59     $html .= '<div class="formelement">';
  60     $html .= __('Name') . ":";
  61     $html .= '  <input type="text" name="table" maxlength="64" '
  62         . 'size="30" required />';
  63     $html .= ' </div>';
  64     $html .= '  <div class="formelement">';
  65     $html .= __('Number of columns') . ":";
  66     $html .= '  <input type="number" min="1" name="num_fields" size="2" />';
  67     $html .= ' </div>';
  68     $html .= '  <div class="clearfloat"></div>';
  69     $html .= '</fieldset>';
  70     $html .= '<fieldset class="tblFooters">';
  71     $html .= '   <input type="submit" value="' . __('Go') . '" />';
  72     $html .= '</fieldset>';
  73     $html .= '</form>';
  74
  75     return $html;
  76 }
  77
  78 if (!defined('TESTSUITE')) {
  79     echo PMA_getHtmlForCreateTable($db);
  80 }
  81 ?>