[Summary view] [Print] [Text view]

   1  <?php
   2       /*
   3       Copyright (C)
   4  
   5       This program is free software; you can redistribute it and/or modify it
   6       under the terms of the GNU General Public License as published by the Free
   7       Software Foundation; either version 2 of the License, or (at your option)
   8       any later version.
   9  
  10       This program is distributed in the hope that it will be useful, but WITHOUT
  11       ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
  12       FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
  13       more details.
  14  
  15       You should have received a copy of the GNU General Public License along
  16       with this program; if not, write to the Free Software Foundation, Inc.,
  17       59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  18       */
  19  ?>
  20  <?php
  21  
  22  include ('inc/header.php');
  23  
  24  mssql_select_db($_SESSION['database']);
  25  
  26  if($_POST['query'] != '')
  27  {
  28      if(!@mssql_query($_POST['query']))
  29          throwSQLError('unable to create view');
  30      else
  31          echo '<meta http-equiv="refresh" content="0;url=database_properties.php">';
  32  }
  33  else
  34      $_POST['query'] = 'CREATE VIEW NewView AS ();';
  35  
  36  ?>
  37          <form name="form1" method="post" action="view_create.php">
  38          <table cellpadding="3" cellspacing="3" style="border: 1px solid">
  39              <tr>
  40                  <td align="center" style="background: #D0DCE0">
  41                      <b>Create View</b>
  42                  </td>
  43              </tr>
  44              <tr>
  45                  <td>
  46                      <textarea rows="10" cols="60" name="query" wrap="off"><?php echo($_POST['query']); ?></textarea><br>
  47                  </td>
  48              </tr>
  49              <tr>
  50                  <td align="center" style="background: #D0DCE0">
  51                      <input type="submit" value="Create">
  52                  </td>
  53              </tr>
  54          </table>
  55          </form>
  56  
  57          <script language="javascript">
  58              document.form1.query.focus();
  59          </script>
  60  <?php include ('inc/footer.php'); ?>