<?php
    if (!$local)
        $local = "LOCAL";
?>        
    <table border="0" align="left" cellspacing="2" cellpadding="0">   
        <tr bgcolor="#456789">
            <td class="whitesmall" align="right">CREATE TABLE&nbsp;</td>
            <td align="left" class="whitesmall">
                <input type="text" name="newtable" size="20">&nbsp;with&nbsp;
                <input type="text" name="fields" size="2">&nbsp;fields&nbsp;
                <input type="button" class="button" name="myaction" value="create new table" onClick="promptMyAction(this.value, 1, 'Please enter a name for the new table and the number of fields you would like to have in your table!')"></td>
        </tr>
<?php
    if ($table)
    {
?>
        <tr>
            <td colspan="2">&nbsp;</td>
        </tr>
        <tr bgcolor="#456789">
            <td class="whitesmall" align="right">
                LOAD DATA
                <select name="local" onChange="submit()">
                    <option value="LOCAL"<?php echo ($local == "LOCAL" ? " selected" : ""); ?>>LOCAL
                    <option value="SERVER"<?php echo ($local != "LOCAL" ? " selected" : ""); ?>>FROM SERVER
                </select>
                &nbsp;
            </td>
            <td align="left" class="whitesmall">
                INFILE INTO TABLE <b><?php echo $table; ?></b>&nbsp;<input <?php echo $style3; ?> type="checkbox" name="delete_from_before_upload"><b>Empty before upload?</b></td>
    </tr>
    <?php
        if ($local == "LOCAL") 
        {
    ?>
            <tr bgcolor="#456789">
            <td class="whitesmall" align="right">browse for <b>LOCAL</b> file:&nbsp;</td>
            <td><input type="file" name="csv">&nbsp;</td>
            </tr>
    <?php
        }
        else
        {
    ?>
            <tr bgcolor="#456789">
            <td class="whitesmall" align="right">have file from <b>HOST</b>:&nbsp;</td>
            <td class="whitesmall"><input type="text" name="hostcsv" size="60" value="<?php echo BACKUPDIR; ?>"></td>
            </tr>
    <?php
        }
    ?>
    <tr bgcolor="#456789">
        <td class="whitesmall">&nbsp;</td>
        <td class="whitesmall"><input type="button" class="button" name="myaction" value="upload csv" onClick="promptMyAction(this.value, 1)"></td>
    </tr> 
    <tr>
        <td colspan="2">&nbsp;</td>
    </tr>
    <tr bgcolor="#456789">
        <td class="whitesmall" align="right">SELECT * FROM <b><?php echo $table; ?></b> INTO OUTFILE&nbsp;</td>
        <td align="left" class="whitesmall"><input type="text" name="path" size="60" value="<?php echo BACKUPDIR . $table; ?>.csv">&nbsp;<input type="button" class="button" name="myaction" value="save to csv" onClick="promptMyAction(this.value, 0)"></td>
    </tr>
    <tr>
        <td colspan="2">&nbsp;</td>
    </tr>
    <tr bgcolor="#456789">
        <td colspan="2" class="whitesmall"><b>options</b> for <b>uploading</b> and <b>downloading</b> data</td>
    </tr>
    <tr bgcolor="#456789">
        <td colspan="2" align="center" class="whitesmall">FIELDS TERMINATED BY: <input type="text" name="fieldsterminated" size="1" value=";">&nbsp;OPTIONALLY ENCLOSED BY:<input type="text" name="fields_enclosed_by" size="1" value="&quot;">&nbsp;LINES TERMINATED BY: <input type="text" name="linesterminated" size="2" value="\n"></td>
    </tr>
<?php
    } // if ($table)
?>
</table>