Untitled

<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Panel</title>

        <!-- Bootstrap core CSS -->
        <link href="http://orders.code3.x10host.com/css/bootstrap.css" rel="stylesheet" type="text/css">

        <!-- jQuery and table sorter -->
        <script type="text/javascript" src="../assets/js/jquery-3.1.0.min.js"></script>
        <script type="text/javascript" src="../assets/js/stupidtable.js"></script>

        <script type="text/javascript">
        $(document).ready(function()
            {
                $("#mainPanel").stupidtable();
            }
        );
        </script>
    </head>
<body class="login-body" style="background: none;">
    <div class="container">
        <div class="panel panel-default">
        <?php
        include_once("../functions/functions.php");
        ?>
    <div class="panel-body">
<form action="" method="post">
    <table class="table" style="width: 25%;">
       <tr>
          <td align="center">Name:</td>
          <td align="center"><input type="text" name="name"></td>
       </tr>
       <tr>
          <td align="center">Notes:</td>
          <td align="center"><input type="text" name="notes"></td>
       </tr>
    </table>
       <table class="table" style="width: 25%;">
       <tr>
          <td colspan="11" align="center">Vehicles</td>
       </tr>
       <tr>
          <td align="center" style="width: 90%;"></td>
          <td align="center" style="width: 10%;">Amount</td>
       </tr>
       <tr>
          <td align="center">CVPI</td>
          <td align="center"><select name="car[]">
              <option value=""></option>
          <option value="1 CVPI">1</option>
          <option value="2 CVPIs">2</option>
          <option value="3 CVPIs">3</option>
          <option value="4 CVPIs">4</option>
          <option value="5 CVPIs">5</option>
          <option value="6 CVPIs">6</option>
          <option value="7 CVPIs">7</option>
          <option value="8 CVPIs">8</option>
          <option value="9 CVPIs">9</option>
          <option value="10 CVPIs">10</option>
      </select></td>
       </tr>
       <tr>
          <td align="center">Slicktop CVPI</td>
          <td align="center"><select name="car[]">
              <option value=""></option>
          <option value="1 NL CVPI">1</option>
          <option value="2 NL CVPIs">2</option>
          <option value="3 NL CVPIs">3</option>
          <option value="4 NL CVPIs">4</option>
          <option value="5 NL CVPIs">5</option>
          <option value="6 NL CVPIs">6</option>
          <option value="7 NL CVPIs">7</option>
          <option value="8 NL CVPIs">8</option>
          <option value="9 NL CVPIs">9</option>
          <option value="10 NL CVPIs">10</option>
      </select></td>
       </tr>
       </table>
       <table class="table" style="width: 25%;">
       <tr>
          <td colspan="11" align="center">Items</td>
       </tr>
    </table>
       </tr>
          <td colspan="2" align="center"><input type="submit" value="submit" name="sub"></td>
       </tr>
    </form>
    <?php
    if(isset($_POST['sub']))
    {
    $servername = "localhost";
    $username = "code3x10_forms";
    $password = "formsforcode3";
    $dbname = "code3x10_orders";

    $con = new mysqli($servername, $username, $password, $dbname);
    if ($con->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    foreach ($_POST['car'] as $select)
    {
    $chk .= $select.", ";
    }
        $in_ch=mysqli_query($con,"INSERT INTO test (faction, name, items, filled, notes) VALUES (
            'SD',
            '".$_POST['name']."',
            '$chk ',
            'No',
            '".$_POST['notes']."'
            )");
        if($in_ch>=1)
           {
              echo '<div class="alert alert-success">Successfully submitted order, redirecting...</div><meta http-equiv="refresh" content="1;url=http://code3.x10host.com/">';
           }
        else
           {
              echo '<div class="alert alert-warning">Failed to submit order, redirecting...</div><meta http-equiv="refresh" content="1;url=http://code3.x10host.com/">';
           }
        }
    $con->close();
    ?>