How to enable span insert in SQL

biboylng2 · November 27, 2015, 9:01am

guys Help me how to insert in SQL using < span >

this is my js.

<script  type ="text/javascript">
function CalculateAge(){
var curYear = new Date().getUTCFullYear();
var age = curYear - document.getElementById('txtYear').value;
document.getElementById('Age').innerHTML=age;
}
function SelectLeader(){
var selectedLeader = document.getElementById('blckOption').value;
if (selectedLeader == "Blk 13")
   {
    var bleader = "Marilyn Garcia";
   }
else if(selectedLeader == "Blk 14")
   {
    var bleader = "Beth Perez";
    }
else if(selectedLeader == "Blk 15")
   {
    var bleader = "WillyBoy Dizon";
    }
else
  {
     var bleader = "n/a"; 
  }
document.getElementById('LeaderTest').innerHTML=bleader;
}
</script>

my form. auto compute AGE

Birthdate:  <select id="txtMonth" class="form-control" name="month"  required  >
										<option value="0">Select Month</option>
						<option value="January">January</option>
						<option value="Febuary">Febuary</option>
						<option value="March">March</option>
						<option value="April">April</option>
						<option value="May">May</option>
						<option value="June">June</option>
						<option value="July">July</option>
						<option value="August">August</option>
						<option value="September">September</option>
						<option value="October">October</option>
						<option value="November">November</option>
						<option value="December">December</option>
						
						
						
						</select>
						&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" class="form-control" placeholder="Day" name="day" id="txtday" />
&nbsp;&nbsp;&nbsp;&nbsp;
						 <select id="txtYear" class="form-control" name="year" onblur="CalculateAge();"/>
						<option value="0">Select Year</option>
						<option value="1979">1979</option>
						<option value="1980">1980</option>
						<option value="1981">1981</option>
						<option value="1982">1982</option>
						<option value="1983">1983</option>
						<option value="1984">1984</option>
						<option value="1985">1985</option>
						<option value="1986">1986</option>
						<option value="1987">1987</option>
						<option value="1988">1988</option>
						<option value="1989">1989</option>
						<option value="1990">1990</option>
						<option value="1991">1991</option>
						<option value="1992">1992</option>
						<option value="1993">1993</option>
						<option value="1994">1994</option>
						<option value="1995">1995</option>
						<option value="1996">1996</option>
						<option value="1997">1997</option>
						<option value="1998">1998</option>
						<option value="1999">1999</option>
						<option value="2000">2000</option>
						<option value="2001">2001</option>
						<option value="2002">2002</option>
						<option value="2003">2003</option>
						<option value="2004">2004</option>
						<option value="2005">2005</option>
						<option value="2006">2006</option>
						<option value="2007">2007</option>
						<option value="2008">2008</option>
						<option value="2009">2009</option>
						<option value="2010">2010</option>
						<option value="2011">2011</option>
						<option value="2012">2012</option>
						<option value="2013">2013</option>
						<option value="2014">2014</option>
						<option value="2015">2015</option>
						
						</select>
						&nbsp;&nbsp;&nbsp;&nbsp;
						Age : <span id="Age" class="form-text"></span></p>

and this is my process to insert in sql

Birthdate:  <select id="txtMonth" class="form-control" name="month"  required  >
										<option value="0">Select Month</option>
						<option value="January">January</option>
						<option value="Febuary">Febuary</option>
						<option value="March">March</option>
						<option value="April">April</option>
						<option value="May">May</option>
						<option value="June">June</option>
						<option value="July">July</option>
						<option value="August">August</option>
						<option value="September">September</option>
						<option value="October">October</option>
						<option value="November">November</option>
						<option value="December">December</option>
						
						
						
						</select>
						&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" class="form-control" placeholder="Day" name="day" id="txtday" />
&nbsp;&nbsp;&nbsp;&nbsp;
						 <select id="txtYear" class="form-control" name="year" onblur="CalculateAge();"/>
						<option value="0">Select Year</option>
						<option value="1979">1979</option>
						<option value="1980">1980</option>
						<option value="1981">1981</option>
						<option value="1982">1982</option>
						<option value="1983">1983</option>
						<option value="1984">1984</option>
						<option value="1985">1985</option>
						<option value="1986">1986</option>
						<option value="1987">1987</option>
						<option value="1988">1988</option>
						<option value="1989">1989</option>
						<option value="1990">1990</option>
						<option value="1991">1991</option>
						<option value="1992">1992</option>
						<option value="1993">1993</option>
						<option value="1994">1994</option>
						<option value="1995">1995</option>
						<option value="1996">1996</option>
						<option value="1997">1997</option>
						<option value="1998">1998</option>
						<option value="1999">1999</option>
						<option value="2000">2000</option>
						<option value="2001">2001</option>
						<option value="2002">2002</option>
						<option value="2003">2003</option>
						<option value="2004">2004</option>
						<option value="2005">2005</option>
						<option value="2006">2006</option>
						<option value="2007">2007</option>
						<option value="2008">2008</option>
						<option value="2009">2009</option>
						<option value="2010">2010</option>
						<option value="2011">2011</option>
						<option value="2012">2012</option>
						<option value="2013">2013</option>
						<option value="2014">2014</option>
						<option value="2015">2015</option>
						
						</select>
						&nbsp;&nbsp;&nbsp;&nbsp;
						Age : <span id="Age" class="form-text"></span></p>

Dormilich · November 27, 2015, 9:10am

you don’t insert using <span>. that’s an HTML element not related to server-side processing (which database insertion is).

the database insertion is done by PHP using the data it received from the input source(s).

biboylng2 · November 27, 2015, 2:14pm

Ok thanks for information but How can i get this value in bleader insert to SQL :

Dormilich · November 27, 2015, 2:34pm

you could use a hidden input element (inside the form!)

biboylng2 · November 28, 2015, 1:19am

input type=“hidden” name=“bleader” is not work

Dormilich · November 30, 2015, 10:57am

… is not an HTML element, does not have a value and if you neither put it into the form nor changed the server code appropriately, it doesn’t do anything.

system · February 29, 2016, 6:10pm

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.