view_create.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 *
 * @version $Id: view_create.php 11343 2008-06-24 14:11:54Z lem9 $
 */

/**
 *
 */
require_once './libraries/common.inc.php';

/**
 * Runs common work
 */
require './libraries/db_common.inc.php';
$url_params['goto'] = $url_params['back'] = 'view_create.php';

if (isset($_POST['submitoptions'])) {
    /**
     * Creates the view
     */
    $message = '';
    $sep = "\r\n";
    $create_query = 'CREATE' . $sep;
    if (isset($_POST['or_replace'])) {
        $create_query .= ' OR REPLACE' . $sep;
    }
    if (isset($_POST['algorithm'])) {
        $create_query .= ' ALGORITHM = ' . $_POST['algorithm'] . $sep;
    }
    $create_query .= ' VIEW ' . PMA_backquote($_POST['view_name']) . $sep;

    if (!empty($_POST['column_names'])) {
        $create_query .= ' (' . $_POST['column_names'] . ')' . $sep;
    }

    $create_query .= ' AS ' . $_POST['sql_statement'] . $sep;

    if (isset($_POST['cascaded']) || isset($_POST['local']) || isset($_POST['check_option'])) {
        $create_query .= ' WITH ';
    }

    if (isset($_POST['cascaded'])) {
        $create_query .= ' CASCADED ';
    }

    if (isset($_POST['local'])) {
        $create_query .= ' LOCAL ';
    }

    if (isset($_POST['check_option'])) {
        $create_query .= ' CHECK OPTION ';
    }

    $message        .= PMA_DBI_query($create_query) ? $strSuccess : $strError;

    // to display the CREATE VIEW query
    $sql_query = $create_query;

    require './' .  $cfg['DefaultTabDatabase'];
    exit();

} else {
    /**
     * Displays top menu links
     * We use db links because a VIEW is not necessarily on a single table
     */
    $num_tables = 0;
    require_once './libraries/db_links.inc.php';

    $url_params['goto'] = 'view_create.php';
    $url_params['back'] = 'view_create.php';

    /**
     * Displays the page
     *
     * @todo js error when view name is empty (strFormEmpty)
     * @todo (also validate if js is disabled, after form submission?)
     */

?>
<!-- CREATE VIEW options -->
<div id="div_view_options">
<form method="post" action="view_create.php">
<?php echo PMA_generate_common_hidden_inputs($GLOBALS['db']); ?>
<input type="hidden" name="reload" value="1" />
<fieldset>
    <legend>CREATE VIEW</legend>

    <table>
    <tr><td><label for="or_replace">OR REPLACE</label></td>
        <td><input type="checkbox" name="or_replace" id="or_replace"
                value="1" />
        </td>
    </tr>
    <tr>
        <td><label for="algorithm">ALGORITHM</label></td>
        <td><select name="algorithm" id="algorithm">
                <option value="UNDEFINED">UNDEFINED</option>
                <option value="MERGE">MERGE</option>
                <option value="TEMPTABLE">TEMPTABLE</option>
            </select>
        </td>
    </tr>
    <tr><td><?php echo $strViewName; ?></td>
        <td><input type="text" size="20" name="view_name" onfocus="this.select()"
                value="" />
        </td>
    </tr>

    <tr><td><?php echo $strColumnNames; ?></td>
        <td><input type="text" maxlength="100" size="50" name="column_names" onfocus="this.select()"
                value="" />
        </td>
    </tr>

    <tr><td><?php echo 'AS' ?></td>
        <td>
            <textarea name="sql_statement" rows="<?php echo $cfg['TextareaRows']; ?>" cols="<?php echo $cfg['TextareaCols']; ?>" dir="<?php echo $text_dir; ?>" onfocus="this.select();"><?php echo htmlspecialchars($sql_query); ?></textarea> 
        </td>
    </tr>
    <tr><td>WITH</td>
        <td>
            <input type="checkbox" name="cascaded" id="cascaded" value="1" />
            <label for="cascaded">CASCADED</label>
            <input type="checkbox" name="local" id="local" value="1" />
            <label for="local">LOCAL</label>
            <input type="checkbox" name="check_option" id="check_option" value="1" />
            <label for="check_option">CHECK OPTION</label>
        </td>
    </tr>
    </table>
</fieldset>
<fieldset class="tblFooters">
        <input type="submit" name="submitoptions" value="<?php echo $strGo; ?>" />
</fieldset>
</form>
</div>
<?php
/**
 * Displays the footer
 */
require_once './libraries/footer.inc.php';

} // end if
?>