tbl_create.php3

   1 <?php
   2 /* $Id$ */
   3
   4
   5 /**
   6  * Get some core libraries
   7  */
   8 require('./grab_globals.inc.php3');
   9 require('./header.inc.php3');
  10
  11
  12 /**
  13  * Selects the database to work with
  14  */
  15 mysql_select_db($db);
  16
  17
  18 /**
  19  * The form used to define the structure of the table has been submitted
  20  */
  21 if (isset($submit)) {
  22     if (!isset($query)) {
  23         $query = '';
  24     }
  25
  26     // Builds the fields creation statements
  27     for ($i = 0; $i < count($field_name); $i++) {
  28         if (empty($field_name[$i])) {
  29             continue;
  30         }
  31         $query .= backquote($field_name[$i]) . ' ' . $field_type[$i];
  32         if ($field_length[$i] != '') {
  33             if (get_magic_quotes_gpc()) {
  34                 $query .= '(' . stripslashes($field_length[$i]) . ')';
  35             } else {
  36                 $query .= '(' . $field_length[$i] . ')';
  37             }
  38         }
  39         if ($field_attribute[$i] != '') {
  40             $query .= ' ' . $field_attribute[$i];
  41         }
  42         if ($field_default[$i] != '') {
  43             if (strtoupper($field_default[$i]) == 'NULL') {
  44                 $query .= ' DEFAULT NULL';
  45             } else if (get_magic_quotes_gpc()) {
  46                 $query .= ' DEFAULT \'' . sql_addslashes(stripslashes($field_default[$i])) . '\'';
  47             } else {
  48                 $query .= ' DEFAULT \'' . sql_addslashes($field_default[$i]) . '\'';
  49             }
  50         }
  51         if ($field_null[$i] != '') {
  52             $query .= ' ' . $field_null[$i];
  53         }
  54         if ($field_extra[$i] != '') {
  55             $query .= ' ' . $field_extra[$i] . ', ';
  56         } else {
  57             $query .= ', ';
  58         }
  59     } // end for
  60     $query = ereg_replace(', $', '', $query);
  61
  62     // Builds the primary keys statements
  63     if (!isset($primary)) {
  64         $primary = '';
  65     }
  66     if (!isset($field_primary)) {
  67         $field_primary = array();
  68     }
  69     for ($i = 0; $i < count($field_primary); $i++) {
  70         $j = $field_primary[$i];
  71         if (!empty($field_name[$j])) {
  72             $primary .= backquote($field_name[$j]) . ', ';
  73         }
  74     } // end for
  75     $primary = ereg_replace(', $', '', $primary);
  76     if (!empty($primary)) {
  77         $primary = ', PRIMARY KEY (' . $primary . ')';
  78     }
  79
  80     // Builds the indexes statements
  81     if (!isset($index)) {
  82         $index = '';
  83     }
  84     if (!isset($field_index)) {
  85         $field_index = array();
  86     }
  87     for ($i = 0;$i < count($field_index); $i++) {
  88         $j = $field_index[$i];
  89         if (!empty($field_name[$j])) {
  90            $index .= backquote($field_name[$j]) . ', ';
  91         }
  92     } // end for
  93     $index = ereg_replace(', $', '', $index);
  94     if (!empty($index)) {
  95         $index = ', INDEX (' . $index . ')';
  96     }
  97
  98     // Builds the uniques statements
  99     if (!isset($unique)) {
 100         $unique = '';
 101     }
 102     if (!isset($field_unique)) {
 103         $field_unique = array();
 104     }
 105     for ($i = 0; $i < count($field_unique); $i++) {
 106         $j = $field_unique[$i];
 107         if (!empty($field_name[$j])) {
 108            $unique .= backquote($field_name[$j]) . ', ';
 109         }
 110     } // end for
 111     $unique = ereg_replace(', $', '', $unique);
 112     if (!empty($unique)) {
 113         $unique = ', UNIQUE (' . $unique . ')';
 114     }
 115     $query_keys = $primary . $index . $unique;
 116     $query_keys = ereg_replace(', $', '', $query_keys);
 117
 118     // Builds the 'create table' statement
 119     $sql_query = 'CREATE TABLE ' . backquote($table) . ' ('
 120                . $query . ' '
 121                . $query_keys . ')';
 122     // Adds table type (2 May 2001 - Robbat2)
 123     if (!empty($tbl_type) && ($tbl_type != 'Default')) {
 124         $sql_query .= ' TYPE = ' . $tbl_type;
 125     }
 126     if (MYSQL_INT_VERSION >= 32300 && !empty($comment)) {
 127         $sql_query .= ' comment = \'' . sql_addslashes($comment) . '\'';
 128     }
 129
 130     // Executes the query
 131     $result  = mysql_query($sql_query) or mysql_die();
 132     $message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenCreated;
 133     include('./tbl_properties.php3');
 134     exit();
 135 } // end do create table
 136
 137
 138 /**
 139  * Displays the form used to define the structure of the table
 140  */
 141 else {
 142     if (isset($num_fields)) {
 143         $num_fields = intval($num_fields);
 144     }
 145     // No table name
 146     if (!isset($table) || trim($table) == '') {
 147         mysql_die($strTableEmpty);
 148     }
 149     // No valid number of fields
 150     else if (empty($num_fields) || !is_int($num_fields)) {
 151         mysql_die($strFieldsEmpty);
 152     }
 153     // Table name and number of fields are valid -> show the form
 154     else {
 155         $action = 'tbl_create.php3';
 156         include('./tbl_properties.inc.php3');
 157        // Diplays the footer
 158        echo "\n";
 159        include('./footer.inc.php3');
 160    }
 161 }
 162
 163 ?>