Expand|Select|Wrap|Line Numbers
- <!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>Example of Bootstrap 3 Supported Form Controls</title>
- <script type="text/javascript" src="js/script.js"></script>
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
- <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
- <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet"/>
- <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.1/css/select2.min.css" rel="stylesheet"/>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.1/js/select2.min.js"></script>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
- <style type="text/css">
- h1{
- margin: 30px 0;
- padding: 0 200px 15px 0;
- border-bottom: 1px solid #E5E5E5;
- }
- .bs-example{
- margin: 20px;
- }
- </style>
- </head>
- <body>
- <div class="bs-example">
- <form class="form-horizontal" role="form" method="post" action="dynform.php">
- <div class="form-group">
- <label class="control-label col-xs-3" for="firstName">Enter Field Name:</label>
- <div class="col-xs-9">
- <input id="new-state" type="text" placeholder="Field Name " class="form-control"/>
- <br>
- <button type="button" id="btn-add-state" class="btn-primary">ADD</button>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-xs-3" for="lastName">Select Field Name:</label>
- <div class="col-xs-9">
- <select id="state" type="text" class="form-control" name="column" required="" >
- <option value="">select</option>
- <option value="col1">col1</option>
- <option value="col2">col2</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-xs-3" for="inputEmail">Enter Field type:</label>
- <div class="col-xs-9">
- <select id="type1" class="form-control" type="text" name="type" required="">
- <option value="">select</option>
- <option value="INT">INT</option>
- <option value="BOOLEAN">BOOLEAN</option>
- <option value="DATE">DATE</option>
- <option value="BLOB">BLOB</option>
- <option value="CHAR">CHAR</option>
- <option value="VARCHAR">VARCHAR</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-xs-3" for="phoneNumber">How Do You Pass Values:</label>
- <div class="col-xs-9">
- <select id="type2" class="form-control" type="text" required="" onselect="select();">
- <option >select</option>
- <option id="chkYes">Custom Values</option>
- <option id="chkNo"> Static Values</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <div class="col-xs-6">
- <span>
- <div id="dPassport" style="display: none">
- <label class="control-label col-xs-3" >Static Values:</label>
- <div class="col-xs-9">
- <select id="value" class="form-control" type="text" name="value1" required="" align="left">
- <option value="">select</option>
- <option value="state">State</option>
- <option value="District">District</option>
- <option value="Gender">Gender</option>
- <option value="B-group">B-group</option>
- </select>
- </div>
- </div>
- <div id="dvPassport" style="display: none">
- <label class="control-label col-xs-3" >Custom Values:</label>
- <div class="col-xs-9">
- <input id="value" type="text" placeholder=" Enter Value " style="width:100%" name="value2" required="" class="form-control"/>
- </div>
- </div>
- <span>
- </div>
- </div>
- <br>
- <div class="form-group">
- <div class="col-xs-offset-3 col-xs-9">
- <input type="submit" value="SUBMIT" class="btn btn-success" name="submit" />
- <input id="remove" type="button" value="Done" onClick="addRow('dataTable')">
- </div>
- </div>
- </form>
- </div>
- <script type="text/javascript">
- $(document).ready(function () {
- function select() {
- if ($('#type2').find(":selected").attr('id') == 'chkYes') {
- $("#dvPassport").show();
- $("#dPassport").hide();
- } else {
- $("#dPassport").show();
- $("#dvPassport").hide();
- }
- }
- //this makes the select change call the function select():
- // anytime the user change the selection the function select() is called and works as expected
- $('#type2').on('change', function () {
- select();
- });
- $("#state").select2({
- tags: true
- });
- $("#btn-add-state").on("click", function () {
- var newStateVal = $("#new-state").val();
- // Set the value, creating a new option if necessary
- if ($("#state").find("option[value='" + newStateVal + "']").length) {
- $("#state").val(newStateVal).trigger("change");
- } else {
- // Create the DOM option that is pre-selected by default
- var newState = new Option(newStateVal, newStateVal, true, true);
- // Append it to the select
- $("#state").append(newState).trigger('change');
- }
- });
- $("#type").select2({
- tags: true
- });
- });//end jQuery
- </script>
- </body>
- </html>
- <?php
- $link = mysqli_connect("localhost","root","") or die("failed to connect to server !!");
- mysqli_select_db($link,"idcard");
- if(isset($_REQUEST['submit']))
- {
- $errorMessage = "";
- $column=$_POST['column'];
- $type=$_POST['type'];
- $value= $_POST['value1'] or $_POST['value2'];
- // Validation will be added here
- if ($errorMessage != "" ) {
- echo "<p class='message'>" .$errorMessage. "</p>" ;
- }
- else{
- //Inserting record in table using INSERT query
- $ins="INSERT INTO `idcard`.`combo1`
- (`column`, `type`, `value`) VALUES ('$column', '$type',
- '$value')";
- $test=mysqli_query($link,$ins) or die(mysqli_error($link));
- if($test)
- echo "<script type='text/javascript'>alert('submitted successfully!')</script>";
- else
- echo "<script type='text/javascript'>alert('failed!')</script>";
- }
- echo "<script type='text/javascript'>window.location.href='zzz.php'</script>";
- exit();
- }
- $sql = "SELECT * FROM combo1 group by id ";
- $result = mysqli_query($link, $sql);
- if ($result && mysqli_num_rows($result) > 0) {
- # code...
- // while($row = $result->fetch_assoc()) {
- echo "<table class='table-hover table borderless table-condensed ';style='background-color: red'>";
- echo "<thead>";
- echo "<tr align=center>";
- echo "<th >Column</th>";
- echo "<th >Type</th>";
- echo "<th >Value</th>";
- echo "<th >Action</th>";
- echo "</tr>";
- echo"</thead>";
- while($row = mysqli_fetch_array($result)){
- $id=$row['id'];
- echo "<tbody>";
- echo "<tr >";
- echo "<td >" . $row['column'] . "</td>";
- echo "<td >" . $row['type'] . "</td>";
- echo "<td >" . $row['value'] . "</td>";
- echo "<td><a href='edit.php?id=" . $row['id'] ."' class='btn btn-success'>Edit</a>
- <a href='delete.php?id= $id' data-toggle='modal' class='btn btn-danger' >Delete </a>
- </td>";
- echo "</tr>";
- echo "</tbody>";
- }
- echo "</table>";
- }
- mysqli_free_result($result);
- ?>