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