Advertisement
Guest User

Untitled

a guest
Feb 18th, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 3.19 KB | None | 0 0
  1. <?php
  2. session_start();
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="en">
  6.     <head>
  7.         <meta charset="utf-8">
  8.         <meta name="viewport" content="width=device-width, initial-scale=1.0">
  9.         <title>Panel</title>
  10.  
  11.         <!-- Bootstrap core CSS -->
  12.         <link href="../css/bootstrap.css" rel="stylesheet" type="text/css">
  13.  
  14.         <!-- jQuery and table sorter -->
  15.         <script type="text/javascript" src="../assets/js/jquery-3.1.0.min.js"></script>
  16.         <script type="text/javascript" src="../assets/js/stupidtable.js"></script>
  17.  
  18.         <script type="text/javascript">
  19.         $(document).ready(function()
  20.             {
  21.                 $("#mainPanel").stupidtable();
  22.             }
  23.         );
  24.         </script>
  25.     </head>
  26. <body class="login-body" style="background: none;">
  27.     <div class="container">
  28.         <div class="panel panel-default">
  29.     <div class="panel-body">
  30. <form action="" method="post">  
  31.     <table class="table" style="width: 25%;">
  32.        <tr>
  33.           <td colspan="11" align="center">Vehicles</td>
  34.        </tr>
  35.        <tr>  
  36.           <td align="center" style="width: 90%;"></td>  
  37.           <td align="center" style="width: 10%;">Amount</td>  
  38.        </tr>
  39.        <tr>  
  40.           <td align="center">CVPI</td>  
  41.           <td align="center"><select name="CVPI">
  42.               <option></option>
  43.           <option value="1 CVPI">1</option>
  44.           <option value="2 CVPI's">2</option>
  45.           <option value="3 CVPI's">3</option>
  46.           <option value="4 CVPI's">4</option>
  47.           <option value="5 CVPI's">5</option>
  48.           <option value="6 CVPI's">6</option>
  49.           <option value="7 CVPI's">7</option>
  50.           <option value="8 CVPI's">8</option>
  51.           <option value="9 CVPI's">9</option>
  52.           <option value="10 CVPI's">10</option>
  53.       </select></td>
  54.        </tr>
  55.        <tr>  
  56.           <td align="center">Slicktop CVPI</td>  
  57.           <td align="center"><select name="NLCVPI">
  58.               <option></option>
  59.           <option value="1 NL CVPI">1</option>
  60.           <option value="2 NL CVPI's">2</option>
  61.           <option value="3 NL CVPI's">3</option>
  62.           <option value="4 NL CVPI's">4</option>
  63.           <option value="5 NL CVPI's">5</option>
  64.           <option value="6 NL CVPI's">6</option>
  65.           <option value="7 NL CVPI's">7</option>
  66.           <option value="8 NL CVPI's">8</option>
  67.           <option value="9 NL CVPI's">9</option>
  68.           <option value="10 NL CVPI's">10</option>
  69.       </select></td>
  70.        </tr>
  71.        <tr>
  72.           <td colspan="11" align="center">Items</td>
  73.        </tr>
  74.     </table>
  75.        </tr>
  76.           <td colspan="2" align="center"><input type="submit" value="submit" name="sub"></td>  
  77.        </tr>  
  78.     </form>  
  79.     <?php  
  80.    if(isset($_POST['sub']))  
  81.    {  
  82.     $servername = "localhost";
  83.     $username = "code3x10_forms";
  84.     $password = "formsforcode3";
  85.     $dbname = "code3x10_orders";
  86.    
  87.     $con = new mysqli($servername, $username, $password, $dbname);
  88.     if ($con->connect_error) {
  89.         die("Connection failed: " . $conn->connect_error);
  90.     }
  91.         $in_ch=mysqli_query($con,"INSERT INTO test (notes) VALUES ('".$_POST['CVPI'].", ".$_POST['NLCVPI']."')");  
  92.         if($in_ch>=1)  
  93.            {  
  94.               echo'<script>alert("Inserted Successfully")</script>';  
  95.            }  
  96.         else  
  97.            {  
  98.               echo'<script>alert("Failed To Insert")</script>';  
  99.            }  
  100.         }  
  101.     $con->close();
  102.     ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement