We help IT Professionals succeed at work.
Get Started

data is not inserting into database properly from two form fields(both having same name )into single column

shruti A
shruti A asked
on
147 Views
Last Modified: 2017-06-10
<html>
<head>
	<meta charset="utf-8">
		<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> 
</head>
	<body>
	<form class="form-horizontal"  role="form" method="post" action="">
		<input id="new-state" type="text" placeholder="Field Name " class="form-control" />
		 <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="vvv" class="form-control" type="text"  name="value"  align="left">
                <option >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="ggg" type="text" placeholder=" Enter Value " name="value" style="width:100%" />
            </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"  onclick="msg()" />
                <input type="reset" class="btn btn-default" value="Reset">
  </form>
	</body>
	<script>
	var x,y;
function msg(){
//var v=document.getElementsByName("value2");
//x=document.getElementById("ggg").value;
if(document.getElementById("ggg").value!=""){
 //alert("Your name is:"+v[0].value);
 //alert("Your name is:"+x);
value=document.getElementById("ggg").value;
alert("Your name is:"+value);
}
else
{
 value=document.getElementById("vvv").value;
alert("You are selected:"+value);
}
}
</script>
	<script type="text/javascript">


			//x="ok";

	$(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
		});
//x=document.getElementById('value2').value;


	});//end jQuery
	</script>
	

	
</html>
<?php
$link = mysqli_connect("localhost","root","")  or die("failed to connect to server !!");
mysqli_select_db($link,"idcard");
if(isset($_REQUEST['submit']))
{
$errorMessage = "";

$value=$_POST['value'];

 
// Validation will be added here
 
if ($errorMessage != "" ) {
echo "<p class='message'>" .$errorMessage. "</p>" ;
}
if( isset($_POST['value'])) {
//Inserting record in table using INSERT query
$ins="INSERT INTO `idcard`.`select`
( `value`) VALUES ('$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='ex.php'</script>";
exit();
}

Open in new window

Comment
Watch Question
Claudiu MihutWeb Programmer
Commented:
This problem has been solved!
Unlock 4 Answers and 10 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE