File: tests/index.php

Recommend this page to a friend!
  Classes of Elminson De Oleo  >  Table from Insert  >  tests/index.php  >  Download  
File: tests/index.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Table from Insert
Generate create table SQL from an insert query
Author: By
Last change:
Date: 2 years ago
Size: 2,555 bytes
 

Contents

Class file image Download
<?php

namespace Elminson\SqlToTable;

require_once
__DIR__ . '../vendor/autoload.php';

//include("../src/SqlToTable.php");
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <title>From Insert SQL to Create Table</title>

    <!-- Bootstrap -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>
<body>
<h1>From Insert SQL to Create Table</h1>
<div class="container">
    <?php if (!isset($_POST['query'])) { ?>
<form role="form" action="" method="post" enctype="multipart/form-data">
            <H2> OR Paste de sql here</H2>
            <div class="form-group">
                <label for="email">SQL Query</label>
                <textarea class="form-control" id="query" name="query">
      </textarea>
            </div>
            <button type="submit" class="btn btn-default">Submit</button>
        </form>
        <?php
   
}

    if (isset(
$_POST['query'])) {
        if (
$_POST['query'] == "") {
            echo
"Empty value";
            exit();
        }
       
$create = new SqlToTable();
       
?>
<form role="form" action="" method="post" enctype="multipart/form-data">
            <input type="hidden" id="generate" name="generate" value="1">
            <?php echo $create->form($_POST['query']); ?>
<div class="row">

                <div class="col-lg-6">
                    <button type="submit" class="btn btn-default">Create Table</button>
                </div>
            </div>
        </form>
        <?php
   
}
    if (isset(
$_POST['generate'])) {
       
$create = new SqlToTable();
        unset(
$_POST['generate']);

       
?>
<form role="form" action="" method="post" enctype="multipart/form-data">
            <H2>Generated</H2>
            <div class="form-group">
                <label for="email">SQL Query Generated</label>
                <pre>
      <?php echo $create->create($_POST) ?>
</pre>
            </div>
            <button type="submit" class="btn btn-default">Submit</button>
        </form>

        <?php
   
}
   
?>
</div>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>


For more information send a message to info at phpclasses dot org.