Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="../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">
- <div class="panel-body">
- <form action="" method="post">
- <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="CVPI">
- <option></option>
- <option value="1 CVPI">1</option>
- <option value="2 CVPI's">2</option>
- <option value="3 CVPI's">3</option>
- <option value="4 CVPI's">4</option>
- <option value="5 CVPI's">5</option>
- <option value="6 CVPI's">6</option>
- <option value="7 CVPI's">7</option>
- <option value="8 CVPI's">8</option>
- <option value="9 CVPI's">9</option>
- <option value="10 CVPI's">10</option>
- </select></td>
- </tr>
- <tr>
- <td align="center">Slicktop CVPI</td>
- <td align="center"><select name="NLCVPI">
- <option></option>
- <option value="1 NL CVPI">1</option>
- <option value="2 NL CVPI's">2</option>
- <option value="3 NL CVPI's">3</option>
- <option value="4 NL CVPI's">4</option>
- <option value="5 NL CVPI's">5</option>
- <option value="6 NL CVPI's">6</option>
- <option value="7 NL CVPI's">7</option>
- <option value="8 NL CVPI's">8</option>
- <option value="9 NL CVPI's">9</option>
- <option value="10 NL CVPI's">10</option>
- </select></td>
- </tr>
- <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);
- }
- $in_ch=mysqli_query($con,"INSERT INTO test (notes) VALUES ('".$_POST['CVPI'].", ".$_POST['NLCVPI']."')");
- if($in_ch>=1)
- {
- echo'<script>alert("Inserted Successfully")</script>';
- }
- else
- {
- echo'<script>alert("Failed To Insert")</script>';
- }
- }
- $con->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement