3 // vim: expandtab sw=4 ts=4 sts=4:
7 * Get some core libraries
9 require('./libraries/grab_globals.lib.php3');
10 $js_to_run = 'functions.js';
11 require('./header.inc.php3');
15 * Defines the url to return to in case of error in a sql statement
17 $err_url = 'tbl_properties.php3?' . PMA_generate_common_url($db, $table);
21 * Selects the database to work with
23 PMA_mysql_select_db($db);
27 * The form used to define the structure of the table has been submitted
30 $sql_query = $query_cpy = '';
32 // Transforms the radio button field_key into 3 arrays
33 $field_cnt = count($field_name);
34 for ($i = 0; $i < $field_cnt; ++
$i) {
35 if (isset($
{'field_key_' . $i})) {
36 if ($
{'field_key_' . $i} == 'primary_' . $i) {
37 $field_primary[] = $i;
39 if ($
{'field_key_' . $i} == 'index_' . $i) {
42 if ($
{'field_key_' . $i} == 'unique_' . $i) {
47 // Builds the fields creation statements
48 for ($i = 0; $i < $field_cnt; $i++
) {
49 if (empty($field_name[$i])) {
52 if (get_magic_quotes_gpc()) {
53 $field_name[$i] = stripslashes($field_name[$i]);
55 if (PMA_MYSQL_INT_VERSION
< 32306) {
56 PMA_checkReservedWords($field_name[$i], $err_url);
58 $query = PMA_backquote($field_name[$i]) . ' ' . $field_type[$i];
59 if ($field_length[$i] != '') {
60 if (get_magic_quotes_gpc()) {
61 $query .= '(' . stripslashes($field_length[$i]) . ')';
63 $query .= '(' . $field_length[$i] . ')';
66 if ($field_attribute[$i] != '') {
67 $query .= ' ' . $field_attribute[$i];
69 if ($field_default[$i] != '') {
70 if (strtoupper($field_default[$i]) == 'NULL') {
71 $query .= ' DEFAULT NULL';
72 } else if (get_magic_quotes_gpc()) {
73 $query .= ' DEFAULT \'' . PMA_sqlAddslashes(stripslashes($field_default[$i])) . '\'';
75 $query .= ' DEFAULT \'' . PMA_sqlAddslashes($field_default[$i]) . '\'';
78 if ($field_null[$i] != '') {
79 $query .= ' ' . $field_null[$i];
81 if ($field_extra[$i] != '') {
82 $query .= ' ' . $field_extra[$i];
86 $query_cpy .= "\n" . ' ' . $query;
90 $sql_query = ereg_replace(', $', '', $sql_query);
91 $query_cpy = ereg_replace(', $', '', $query_cpy);
93 // Builds the primary keys statements
95 $primary_cnt = (isset($field_primary) ?
count($field_primary) : 0);
96 for ($i = 0; $i < $primary_cnt; $i++
) {
97 $j = $field_primary[$i];
98 if (!empty($field_name[$j])) {
99 if (get_magic_quotes_gpc()) {
100 $field_name[$j] = stripslashes($field_name[$j]);
102 $primary .= PMA_backquote($field_name[$j]) . ', ';
106 $primary = ereg_replace(', $', '', $primary);
107 if (!empty($primary)) {
108 $sql_query .= ', PRIMARY KEY (' . $primary . ')';
109 $query_cpy .= ',' . "\n" . ' PRIMARY KEY (' . $primary . ')';
113 // Builds the indexes statements
115 $index_cnt = (isset($field_index) ?
count($field_index) : 0);
116 for ($i = 0;$i < $index_cnt; $i++
) {
117 $j = $field_index[$i];
118 if (!empty($field_name[$j])) {
119 if (get_magic_quotes_gpc()) {
120 $field_name[$j] = stripslashes($field_name[$j]);
122 $index .= PMA_backquote($field_name[$j]) . ', ';
126 $index = ereg_replace(', $', '', $index);
127 if (!empty($index)) {
128 $sql_query .= ', INDEX (' . $index . ')';
129 $query_cpy .= ',' . "\n" . ' INDEX (' . $index . ')';
133 // Builds the uniques statements
135 $unique_cnt = (isset($field_unique) ?
count($field_unique) : 0);
136 for ($i = 0; $i < $unique_cnt; $i++
) {
137 $j = $field_unique[$i];
138 if (!empty($field_name[$j])) {
139 if (get_magic_quotes_gpc()) {
140 $field_name[$j] = stripslashes($field_name[$j]);
142 $unique .= PMA_backquote($field_name[$j]) . ', ';
146 $unique = ereg_replace(', $', '', $unique);
147 if (!empty($unique)) {
148 $sql_query .= ', UNIQUE (' . $unique . ')';
149 $query_cpy .= ',' . "\n" . ' UNIQUE (' . $unique . ')';
153 // Builds the fulltextes statements
155 $fulltext_cnt = (isset($field_fulltext) ?
count($field_fulltext) : 0);
156 for ($i = 0; $i < $fulltext_cnt; $i++
) {
157 $j = $field_fulltext[$i];
158 if (!empty($field_name[$j])) {
159 if (get_magic_quotes_gpc()) {
160 $field_name[$j] = stripslashes($field_name[$j]);
162 $fulltext .= PMA_backquote($field_name[$j]) . ', ';
165 unset($field_fulltext);
166 $fulltext = ereg_replace(', $', '', $fulltext);
167 if (!empty($fulltext)) {
168 $sql_query .= ', FULLTEXT (' . $fulltext . ')';
169 $query_cpy .= ',' . "\n" . ' FULLTEXT (' . $fulltext . ')';
173 // Builds the 'create table' statement
174 $sql_query = 'CREATE TABLE ' . PMA_backquote($table) . ' (' . $sql_query . ')';
175 $query_cpy = 'CREATE TABLE ' . PMA_backquote($table) . ' (' . $query_cpy . "\n" . ')';
177 // Adds table type and comments (2 May 2001 - Robbat2)
178 if (!empty($tbl_type) && ($tbl_type != 'Default')) {
179 $sql_query .= ' TYPE = ' . $tbl_type;
180 $query_cpy .= ' TYPE = ' . $tbl_type;
182 if (PMA_MYSQL_INT_VERSION
>= 32300 && !empty($comment)) {
183 if (get_magic_quotes_gpc()) {
184 $comment = stripslashes($comment);
186 $sql_query .= ' COMMENT = \'' . PMA_sqlAddslashes($comment) . '\'';
187 $query_cpy .= "\n" . 'COMMENT = \'' . PMA_sqlAddslashes($comment) . '\'';
190 // Executes the query
191 $result = PMA_mysql_query($sql_query) or PMA_mysqlDie('', '', '', $err_url);
192 $sql_query = $query_cpy . ';';
194 $message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenCreated;
195 include('./' . $cfg['DefaultTabTable']);
197 } // end do create table
201 * Displays the form used to define the structure of the table
204 if (isset($num_fields)) {
205 $num_fields = intval($num_fields);
208 if (!isset($table) ||
trim($table) == '') {
209 PMA_mysqlDie($strTableEmpty, '', '', $err_url);
211 // No valid number of fields
212 else if (empty($num_fields) ||
!is_int($num_fields)) {
213 PMA_mysqlDie($strFieldsEmpty, '', '', $err_url);
215 // Table name and number of fields are valid -> show the form
217 if (PMA_MYSQL_INT_VERSION
< 32306) {
218 PMA_checkReservedWords($table, $err_url);
221 $action = 'tbl_create.php3';
222 include('./tbl_properties.inc.php3');
223 // Diplays the footer
225 include('./footer.inc.php3');