Advertisement
Guest User

Untitled

a guest
Feb 18th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 4.60 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: 50%;">
  32.        <tr>
  33.           <td colspan="11" align="center">Vehicles</td>
  34.        </tr>
  35.        <tr>  
  36.           <td align="center" style="width: 60%;"></td>  
  37.           <td align="center" style="width: 4%;">1</td>  
  38.           <td align="center" style="width: 4%;">2</td>
  39.           <td align="center" style="width: 4%;">3</td>
  40.           <td align="center" style="width: 4%;">4</td>
  41.           <td align="center" style="width: 4%;">5</td>
  42.           <td align="center" style="width: 4%;">6</td>
  43.           <td align="center" style="width: 4%;">7</td>
  44.           <td align="center" style="width: 4%;">8</td>
  45.           <td align="center" style="width: 4%;">9</td>
  46.           <td align="center" style="width: 4%;">10</td>
  47.        </tr>
  48.        <tr>  
  49.           <td align="center">CVPI</td>  
  50.           <fieldset id="item[0]">
  51.           <td align="center"><input type="radio" name="item[0]" value="1 CVPI"></td>
  52.           <td align="center"><input type="radio" name="item[0]" value="2 CVPI's"></td>
  53.           <td align="center"><input type="radio" name="item[0]" value="3 CVPI's"></td>
  54.           <td align="center"><input type="radio" name="item[0]" value="4 CVPI's"></td>
  55.           <td align="center"><input type="radio" name="item[0]" value="5 CVPI's"></td>
  56.           <td align="center"><input type="radio" name="item[0]" value="6 CVPI's"></td>
  57.           <td align="center"><input type="radio" name="item[0]" value="7 CVPI's"></td>
  58.           <td align="center"><input type="radio" name="item[0]" value="8 CVPI's"></td>
  59.           <td align="center"><input type="radio" name="item[0]" value="9 CVPI's"></td>
  60.           <td align="center"><input type="radio" name="item[0]" value="10 CVPI's"></td>
  61.           </fieldset>
  62.        </tr>
  63.        <tr>  
  64.           <td align="center">Slicktop CVPI</td>  
  65.           <fieldset id="item[1]">
  66.           <td align="center"><input type="radio" name="item[1]" value="1 NL CVPI"></td>
  67.           <td align="center"><input type="radio" name="item[1]" value="2 NL CVPI's"></td>
  68.           <td align="center"><input type="radio" name="item[1]" value="3 NL CVPI's"></td>
  69.           <td align="center"><input type="radio" name="item[1]" value="4 NL CVPI's"></td>
  70.           <td align="center"><input type="radio" name="item[1]" value="5 NL CVPI's"></td>
  71.           <td align="center"><input type="radio" name="item[1]" value="6 NL CVPI's"></td>
  72.           <td align="center"><input type="radio" name="item[1]" value="7 NL CVPI's"></td>
  73.           <td align="center"><input type="radio" name="item[1]" value="8 NL CVPI's"></td>
  74.           <td align="center"><input type="radio" name="item[1]" value="9 NL CVPI's"></td>
  75.           <td align="center"><input type="radio" name="item[1]" value="10 NL CVPI's"></td>
  76.           </fieldset>
  77.        </tr>
  78.        <tr>
  79.           <td colspan="11" align="center">Items</td>
  80.        </tr>
  81.     </table>
  82.        </tr>
  83.           <td colspan="2" align="center"><input type="submit" value="submit" name="sub"></td>  
  84.        </tr>  
  85.     </form>  
  86.     <?php  
  87.    if(isset($_POST['sub']))  
  88.    {  
  89.     $servername = "localhost";
  90.     $username = "code3x10_forms";
  91.     $password = "formsforcode3";
  92.     $dbname = "code3x10_orders";
  93.    
  94.     $con = new mysqli($servername, $username, $password, $dbname);
  95.     if ($con->connect_error) {
  96.         die("Connection failed: " . $conn->connect_error);
  97.     }
  98.     $checkbox1=$_POST['item'];  
  99.     $chk="";  
  100.     foreach($checkbox1 as $chk1)  
  101.        {  
  102.           $chk .= $chk1.", ";  
  103.        }  
  104.     $in_ch=mysqli_query($con,"INSERT INTO test (notes) VALUES ('$chk')");  
  105.     if($in_ch==1)  
  106.        {  
  107.           echo'<script>alert("Inserted Successfully")</script>';  
  108.        }  
  109.     else  
  110.        {  
  111.           echo'<script>alert("Failed To Insert")</script>';  
  112.        }  
  113.     }  
  114.     $con->close();
  115.     ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement