i want to display my result in textbox

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bhutan123
    New Member
    • Jun 2014
    • 6
    #1

    i want to display my result in textbox

    Code:
    <?php
		session_start();
		
		require("config/db_config.php");
		$connection=mysql_connect ("$db_host","$db_user","$db_password")
		or die ( " Not able to connect to server ");
		$db_name="calc_db";
		mysql_select_db($db_name,$connection);
	?>
<DOCTYPE html>
<head>
<title></title>
</head>
	
	<script>
	function calculate_Marks()
		{
			var viva_Marks=document.getElementById('VivaMarks').value;
			var Degree_Marks=document.getElementById('DegreeMarks').value;
			var Written_Marks=document.getElementById('WrittenMarks').value;
			
			var viva_percentage =(20/100)*viva_Marks;
			var Degree_percentage=(10/100)*Degree_Marks
			var Written_percentage=(70/100)*Written_Marks;
			
			var Total=(viva_percentage+Degree_percentage+Written_percentage).toFixed(2);
			document.getElementById('Total').innerHTML=Total;
			
			
		}	
	
	</script>
	

	<body>
	<form ACTION="calc.php" method="POST">

	<table align="center" cellspacing="5px" cellpadding="10px">

			<tr>
			<td>Enter Registartion Number:</td>
			<td><input type="number" id="RegNo" name="RegNo" min="11" required  onchange="calculate_Marks()" style="width:150px;" ></td>
			</tr>

			<tr>
			<td>Enter Viva Marks:</td>
			<td><input type="number" id="VivaMarks" name="VivaMarks" required  max="100" min="1" onchange="calculate_Marks()" ></td>
			</tr>

			<tr>
			<td>Enter Degree Marks:</td>
			<td><input type="number" id="DegreeMarks" name="DegreeMarks"  required  max="100" min="1" onchange="calculate_Marks()" ></td>
			</tr>

			<tr>
			<td>Enter Written Marks Marks:</td>
			<td><input type="number" id="WrittenMarks" required name="WrittenMarks" max="100" min="1" onchange="calculate_Marks()"></td>
			</tr>
			
			<tr>
			<td>Your Total Score (%):</td>
			<td>
			<h2 id="Total"  value="" name="Total"></h2>
			</td>
			</tr>
			

			<tr>
			<td></td>
			<td rowspan="2"> <input type="submit" id="submit" name="submit" value="Submit"> <input type="reset" value="Reset" ></td>
			</tr>
		
	</table>


	<?php
	
	if(isset($_POST['submit']))
	{
	mysql_select_db("calc_db",$connection);
		
		$Registartion_No=trim($_POST['RegNo']);
		$Viva=trim($_POST['VivaMarks']);
		$Degree=trim($_POST['DegreeMarks']);
		$Written=trim($_POST['WrittenMarks']);
		$Total=$_POST['Total'];
		
		
		$sql="(INSERT INTO tblscore(Registration_Number, Viva_Marks,Degree_Marks, Written_marks, Total) VALUES ('$Registartion_No', '$Viva','$Degree', '$Written','$Total')";
		$res=mysql_query($sql) or die (mysql_error());
		
		
		
	}
	?>
</form>
</body>
</html>
    i had this code and i want to display total in textbox not in h2 tag and insert into mysql database ...plz help me doing this..i would appreciate for your help...
    Last edited by Dormilich; Jun 5 '14, 04:12 PM.
    Tags: None
    • Dormilich
      Recognized Expert Expert
      • Aug 2008
      • 8694
      #2
      i want to display total in textbox not in h2 tag
      code a textbox and update its value property.

        Comment

        • Bhutan123
          New Member
          • Jun 2014
          • 6
          #3
          Code:
          <DOCTYPE html>
<head>
<title></title>
</head>
	
	<script>

	function calculate_Marks()
		{
			var viva_Marks=document.getElementById('VivaMarks').value;
			var Degree_Marks=document.getElementById('DegreeMarks').value;
			var Written_Marks=document.getElementById('WrittenMarks').value;
			
			var viva_percentage =(20/100)*viva_Marks;
			var Degree_percentage=(10/100)*Degree_Marks
			var Written_percentage=(70/100)*Written_Marks;
			
			var Total=(viva_percentage+Degree_percentage+Written_percentage).toFixed(0);
			document.getElementById('Total').value=Total;
			
			
		}	
	
	</script>
	
	
	

	<body>
	<form ACTION="calc.php" method="POST" name="MarkEntryForm">

	<table align="center" cellspacing="5px" cellpadding="10px">

			<tr>
			<td>Enter Registartion Number:</td>
			<td><input type="number" id="RegNo" name="RegNo" min="11" required  style="width:150px;" ></td>
			</tr>

			<tr>
			<td>Enter Viva Marks(20%):</td>
			<td><input type="number" id="VivaMarks" name="VivaMarks" required  max="100" min="1" ></td>
			</tr>

			<tr>
			<td>Enter Degree Marks(10%):</td>
			<td><input type="number" id="DegreeMarks" name="DegreeMarks"  required  max="100" min="1" ></td>
			</tr>

			<tr>
			<td>Enter Written Marks Marks(70%):</td>
			<td><input type="number" id="WrittenMarks" required name="WrittenMarks" max="100" min="1")"></td>
			</tr>
			
			<tr>
			<td>Your Total Score (%):  <INPUT TYPE="button" NAME="button" Value="=" onClick="calculate_Marks()"></td>
			<td><INPUT TYPE="text" id="Total" NAME="Total" VALUE="">
			
			</td>
			</tr>
			

			<tr>
			<td></td>
			<td rowspan="2"> <input type="submit" id="submit" name="submit" value="Submit"> 
			<input type="reset" value="Reset" ></td>
			</tr>
		
	</table>


	<?php
	
	if(isset($_POST['submit']))
	{
	mysql_select_db("calc_db",$connection);
		
		$Registartion_No=trim($_POST['RegNo']);
		$Viva=trim($_POST['VivaMarks']);
		$Degree=trim($_POST['DegreeMarks']);
		$Written=trim($_POST['WrittenMarks']);
		$Total=trim($_POST['Total']);
		
		
		$sql="INSERT INTO tblscore VALUES ('','$Registartion_No','$Viva','$Degree','$Written', '$Total')";
		$res=mysql_query($sql) or die (mysql_error());
	
		$query = mysql_query("SELECT * FROM tblscore WHERE Registration_Number='$Registartion_No'",($connection));
		if(mysql_num_rows($query) != 1)
			{
				echo "<script>alert('Mark of this Registration number already exists')</script>";
				// redirect back to form and populate with 
				// data that has already been entered by the user
			}

	}
	
	?>
</form>
</body>
</html>

            Comment

            • Dormilich
              Recognized Expert Expert
              • Aug 2008
              • 8694
              #4
              a very important point to consider:

              currently, while JS calculates the total, the user still can modify this value himself and since you have no server-side verification this may lead to wrong data (at best).
              better consider the JS calculation as an aid and re-do the necessary calculations in PHP before you insert them into the DB (there you can also get rid of the floating point arithmetics problem you currently have).
              despite that you’re totally open to SQL Injection on top of using the deprecated mysql_* functions. better use PDO or MySQLi with Prepared Statements.

                Comment

                Previous template Next
                Working...