chechbox validations

Question

muralibobby2015 17 Posting Pro

14 Years Ago

hello friends ..

i want to do one task. i want some one elp. i am new to php. when ever i check the checkbox amount will add in 'total' textbox.
i am displaying table below.

<form name="form" action="" method="post" >
<table align="center">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my add featured $19.95 (your ad seen before free listings)
</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk1" onclick="check1()"/></td></tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad bold $4.95	
</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk2" /></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad highlighted $4.95
</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk3" /></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add Email $9.95
</td>
<td><input type="text" name="email" /></td>
<td><input type="checkbox" name="chk4" /></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add link to my website $9.95
</td>
<td><input type="text" name="link" /></td>
<td><input type="checkbox" name="chk5" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Add 10 key words $9.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk6" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
or</td>
<td>Add 20 keywords $19.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk7" /></td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add larger description (up to 4,000 charters) $29.95 
</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk8" /></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Add 10 key words $9.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk6" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
or</td>
<td>Add 20 keywords $19.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk7" /></td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td align="right">total &nbsp;&nbsp;&nbsp;<input name="total" type="text" /></td>
</tr>
</table>
</form>

here no.of checkboxs. when ever i check one checkbox that amt willadd to total amount.
plz help me.

php

4 Contributors
17 Replies
162 Views
2 Weeks Discussion Span
Latest Post 14 Years Ago Latest Post by mangel.murti

All 17 Replies

pritaeas 2,194 ¯\_(ツ)_/¯

14 Years Ago

Found this link, and made it into this:
http://expressionengine.com/forums/viewthread/128806/

<html>
  <head>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
    <script type="text/javascript">
      $(document).ready(function() {
        var total = 0;  
     
        function calcTotal() 
        { 
            $("input:checked").each(function() 
            { 
                var value = $(this).attr("value"); 
                total += parseFloat(value);  
            }); 
        } 
    
        calcTotal();     
             
        $("input:checkbox, input:radio").click(function() 
        { 
            total = 0;  
            calcTotal();  
            $("input#total").val(total);
        });
      });
    </script> 
  </head>
  <body>
    <form name="form" action="" method="post" >
      <table align="center">
        <tr>
          <td>Make my add featured $19.95 (your ad seen before free listings)</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="19.95" /></td>
        </tr>
        <tr>
          <td>Make my ad bold $4.95</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="4.95" /></td>
        </tr>
        <tr>
          <td>Make my ad highlighted $4.95</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="4.95" /></td>
        </tr>
        <tr>
          <td>Add Email $9.95</td>
          <td><input type="text" name="email" /></td>
          <td><input type="checkbox" value="9.95" /></td>
        </tr>
        <tr>
          <td>Add link to my website $9.95</td>
          <td><input type="text" name="link" /></td>
          <td><input type="checkbox" value="9.95" /></td>
        </tr>
        <tr>
          <td>Add 10 key words $9.95 <input type="checkbox" value="9.95" /></td>
          <td>or</td>
          <td>Add 20 keywords $19.95 <input type="checkbox" value="19.95" /></td>
        </tr>
        <tr>
          <td><textarea name="text1" rows="6" cols="50"></textarea></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>Add larger description (up to 4,000 charters) $29.95</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="29.95" /></td>
        </tr>
        <tr>
          <td><textarea name="text1" rows="6" cols="50"></textarea></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>Add 10 key words $9.95 <input type="checkbox" value="9.95" /></td>
          <td>or</td>
          <td>Add 20 keywords $19.95 <input type="checkbox" value="19.95" /></td>
        </tr>
        <tr>
          <td><textarea name="text1" rows="6" cols="50"></textarea></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td align="right">total <input id="total" type="text" /></td>
        </tr>
      </table>
    </form>
  </body>
</html>

Edited 14 Years Ago by pritaeas because: removed indent

pritaeas 2,194 ¯\_(ツ)_/¯

14 Years Ago

how to call this function from form

Copy/paste this html into test.html, open it and see what happens when you click a checkbox...

venkat0904 1 Junior Poster

14 Years Ago

you are looking for a radio button not a check box. Only one radio button gets selected from a defined group.
Just define each radio button in a specific group under the same "name" attribute. eg: option1 name="group1" option2 name="group1" option 3 name="group2"
above example lets you choose only 1 out of option 1 and 2 but lets u select option 3 simultaneously

in this we can not group check boxes. so how can we select onlyone from two check boxes in the case of 'OR' case. for example checkbox1 (or)checkbox2. in this case we have to select only one checkbox. if one checkbox checked automatically other will be in uncheck.

Edited 14 Years Ago by venkat0904 because: n/a

venkat0904 1 Junior Poster

14 Years Ago

i think u didnt get me... checkboxes are meant for multiple selection... 1 checkbox is not supposed to be influenced by selection of other but radio buttons are meant to do so... like wen u need to select a gender u use a radio button coz u dont want both male n female to b selected..

k. for suppse we have two checkboxes is there .we have to select one check box from that. so how can?

venkat0904 1 Junior Poster

14 Years Ago

okkk now i see what u r trying to do...
u can do this easily through javascript... see this

function CountChecks() {  // call this function on onClick event of checkboxes
var maxchecked = 2;
var count = 0;
if(document.Form.check1.checked == true) { count++; }
if(document.Form.check2.checked == true) { count++; }
if(document.Form.check3.checked == true) { count++; }
if(document.Form.check4.checked == true) { count++; }
if(document.Form.check5.checked == true) { count++; }
if(document.Form.check6.checked == true) { count++; }
if(document.Form.check7.checked == true) { count++; }
if(count > maxchecked) {	
	alert('only ' + maxchecked + ' may be checked.');
	}
}

Hope this helps...

k.......i know that point. but have you see some examples like this...................."you have to select only 2choices from multiple checkboxes". there is 7 boxes is there but select 2choices only. k. got the point?

Edited 14 Years Ago by venkat0904 because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

muralibobby2015 17 Posting Pro · Answer 1 · 2009-11-06T14:36:57+00:00

muralibobby2015 17 Posting Pro

14 Years Ago

how to call this function from form

muralibobby2015 17 Posting Pro · Answer 2 · 2009-11-06T14:43:04+00:00

thank you so.....much for your help........mr.pritaeas. i have no words to wish. thanks a lot.

muralibobby2015 17 Posting Pro · Answer 3 · 2009-11-06T14:51:23+00:00

in this we can not group check boxes. so how can we select onlyone from two check boxes in the case of 'OR' case. for example checkbox1 (or)checkbox2. in this case we have to select only one checkbox. if one checkbox checked automatically other will be in uncheck.

muralibobby2015 17 Posting Pro · Answer 4 · 2009-11-06T16:22:44+00:00

you are looking for a radio button not a check box. Only one radio button gets selected from a defined group.
Just define each radio button in a specific group under the same "name" attribute. eg: option1 name="group1" option2 name="group1" option 3 name="group2"
above example lets you choose only 1 out of option 1 and 2 but lets u select option 3 simultaneously

k. for suppse we have two checkboxes is there .we have to select one check box from that. so how can?

muralibobby2015 17 Posting Pro · Answer 5 · 2009-11-06T16:48:20+00:00

i think u didnt get me... checkboxes are meant for multiple selection... 1 checkbox is not supposed to be influenced by selection of other but radio buttons are meant to do so... like wen u need to select a gender u use a radio button coz u dont want both male n female to b selected..

k.......i know that point. but have you see some examples like this...................."you have to select only 2choices from multiple checkboxes". there is 7 boxes is there but select 2choices only. k. got the point?

muralibobby2015 17 Posting Pro · Answer 6 · 2009-11-18T12:21:32+00:00

Found this link, and made it into this:
http://expressionengine.com/forums/viewthread/128806/

<html>
  <head>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
    <script type="text/javascript">
      $(document).ready(function() {
        var total = 0;  
     
        function calcTotal() 
        { 
            $("input:checked").each(function() 
            { 
                var value = $(this).attr("value"); 
                total += parseFloat(value);  
            }); 
        } 
    
        calcTotal();     
             
        $("input:checkbox, input:radio").click(function() 
        { 
            total = 0;  
            calcTotal();  
            $("input#total").val(total);
        });
      });
    </script> 
  </head>
  <body>
    <form name="form" action="" method="post" >
      <table align="center">
        <tr>
          <td>Make my add featured $19.95 (your ad seen before free listings)</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="19.95" /></td>
        </tr>
        <tr>
          <td>Make my ad bold $4.95</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="4.95" /></td>
        </tr>
        <tr>
          <td>Make my ad highlighted $4.95</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="4.95" /></td>
        </tr>
        <tr>
          <td>Add Email $9.95</td>
          <td><input type="text" name="email" /></td>
          <td><input type="checkbox" value="9.95" /></td>
        </tr>
        <tr>
          <td>Add link to my website $9.95</td>
          <td><input type="text" name="link" /></td>
          <td><input type="checkbox" value="9.95" /></td>
        </tr>
        <tr>
          <td>Add 10 key words $9.95 <input type="checkbox" value="9.95" /></td>
          <td>or</td>
          <td>Add 20 keywords $19.95 <input type="checkbox" value="19.95" /></td>
        </tr>
        <tr>
          <td><textarea name="text1" rows="6" cols="50"></textarea></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>Add larger description (up to 4,000 charters) $29.95</td>
          <td>&nbsp;</td>
          <td><input type="checkbox" value="29.95" /></td>
        </tr>
        <tr>
          <td><textarea name="text1" rows="6" cols="50"></textarea></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>Add 10 key words $9.95 <input type="checkbox" value="9.95" /></td>
          <td>or</td>
          <td>Add 20 keywords $19.95 <input type="checkbox" value="19.95" /></td>
        </tr>
        <tr>
          <td><textarea name="text1" rows="6" cols="50"></textarea></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td align="right">total <input id="total" type="text" /></td>
        </tr>
      </table>
    </form>
  </body>
</html>

in the above example selected values redirecting to another page with user ids. i am putting each value in session.like this

$_SESSION['fcheckbox']=$_REQUEST['fcheckbox']

and next i have "table" in database. if particular session value
exists that column only update.
i wrote like this

if($_SESSION['fcheckbox']!='')
{
$add_update=mysql_query("UPDATE pro_listings SET featured='Y' where id=$_SESSION['add_id']   ");
}

the problem is there is 10 session values is there. among them 5 session values are null. but i want to update existing session values only ,not null values.
and also there is another solution to write update query to each session value like above. any alternative to write single line.

mangel.murti 5 Helps you in some way · Answer 7 · 2009-11-18T14:18:31+00:00

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Total Problem Solved</title>
<script language="javascript" type="text/javascript">
function ttl()
{
 var  t=0;
  if(document.form.chk1.checked == true) {
			t=t+parseFloat(document.form.chk1.value);
} if(document.form.chk2.checked == true) {
			t=t+parseFloat(document.form.chk2.value);
}if(document.form.chk3.checked == true) {
			t=t+parseFloat(document.form.chk3.value);
}if(document.form.chk4.checked == true) {
			t=t+parseFloat(document.form.chk4.value);
}if(document.form.chk5.checked == true) {
			t=t+parseFloat(document.form.chk5.value);
}if(document.form.chk6.checked == true) {
			t=t+parseFloat(document.form.chk6.value);
}if(document.form.chk7.checked == true) {
			t=t+parseFloat(document.form.chk7.value);
}if(document.form.chk8.checked == true) {
			t=t+parseFloat(document.form.chk8.value);
}
document.form.total.value=t;}
function ch6(){if(document.form.chk6.checked == true) {
document.form.chk7.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch7(){if(document.form.chk7.checked == true) {
document.form.chk6.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch8(){if(document.form.chk8.checked == true) {
document.form.chk6.checked = false ;
document.form.chk7.checked = false;
}ttl();
}
</script>
</head>
<body>
<form name="form" action="" method="post" >
<table align="center">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my add featured $19.95 (your ad seen before free listings)</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk1"  value="19.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad bold $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk2"  value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad highlighted $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk3" value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add Email $9.95</td>
<td><input type="text" name="email" /></td>
<td><input type="checkbox" name="chk4" value="9.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add link to my website $9.95</td>
<td><input type="text" name="link" /></td>
<td><input type="checkbox" name="chk5" value="9.95" onclick="ttl()"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Add 10 key words $9.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk6"  value="9.95" onclick="ch6()"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
or</td>
<td>Add 20 keywords $19.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk7"  value="19.95" onclick="ch7()"/></td>
</tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add larger description (up to 4,000 charters) $29.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk8"   value="29.95" onclick="ch8()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td align="right">total &nbsp;&nbsp;&nbsp;<input name="total" type="text" disabled="disabled" /></td>
</tr>
</table>
</form>
</body>
</html>

muralibobby2015 17 Posting Pro · Answer 8 · 2009-11-18T15:58:06+00:00

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Total Problem Solved</title>
<script language="javascript" type="text/javascript">
function ttl()
{
 var  t=0;
  if(document.form.chk1.checked == true) {
			t=t+parseFloat(document.form.chk1.value);
} if(document.form.chk2.checked == true) {
			t=t+parseFloat(document.form.chk2.value);
}if(document.form.chk3.checked == true) {
			t=t+parseFloat(document.form.chk3.value);
}if(document.form.chk4.checked == true) {
			t=t+parseFloat(document.form.chk4.value);
}if(document.form.chk5.checked == true) {
			t=t+parseFloat(document.form.chk5.value);
}if(document.form.chk6.checked == true) {
			t=t+parseFloat(document.form.chk6.value);
}if(document.form.chk7.checked == true) {
			t=t+parseFloat(document.form.chk7.value);
}if(document.form.chk8.checked == true) {
			t=t+parseFloat(document.form.chk8.value);
}
document.form.total.value=t;}
function ch6(){if(document.form.chk6.checked == true) {
document.form.chk7.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch7(){if(document.form.chk7.checked == true) {
document.form.chk6.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch8(){if(document.form.chk8.checked == true) {
document.form.chk6.checked = false ;
document.form.chk7.checked = false;
}ttl();
}
</script>
</head>
<body>
<form name="form" action="" method="post" >
<table align="center">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my add featured $19.95 (your ad seen before free listings)</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk1"  value="19.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad bold $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk2"  value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad highlighted $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk3" value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add Email $9.95</td>
<td><input type="text" name="email" /></td>
<td><input type="checkbox" name="chk4" value="9.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add link to my website $9.95</td>
<td><input type="text" name="link" /></td>
<td><input type="checkbox" name="chk5" value="9.95" onclick="ttl()"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Add 10 key words $9.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk6"  value="9.95" onclick="ch6()"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
or</td>
<td>Add 20 keywords $19.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk7"  value="19.95" onclick="ch7()"/></td>
</tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add larger description (up to 4,000 charters) $29.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk8"   value="29.95" onclick="ch8()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td align="right">total &nbsp;&nbsp;&nbsp;<input name="total" type="text" disabled="disabled" /></td>
</tr>
</table>
</form>
</body>
</html>

ok. fine .
after this i am redirecting to another page from this page. in there i am creating sessions to each value.

$_SESSION[chk1]=$_REQUEST[chk1];
$_SESSION[chk2]=$_REQUEST[chk2];
$_SESSION[chk3]=$_REQUEST[chk3]

like that assigning sessions to all values.
after that i will update table which is in database.
for suppose i was selected only 2 checkboxes in first page.
that fields only update without passing null values to other column values

mangel.murti 5 Helps you in some way · Answer 9 · 2009-11-19T14:14:59+00:00

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Total Problem Solved</title>
<script language="javascript" type="text/javascript">
function ttl()
{
 var tv="", t=0;
  if(document.form.chk1.checked == true) {
			t=t+parseFloat(document.form.chk1.value);
			tv=tv+'chk1=\''+document.form.chk1.value+'\',';
} if(document.form.chk2.checked == true) {
			t=t+parseFloat(document.form.chk2.value);
			tv=tv+'chk2=\''+document.form.chk2.value+'\',';
}if(document.form.chk3.checked == true) {
			t=t+parseFloat(document.form.chk3.value);
			tv=tv+'chk3=\''+document.form.chk3.value+'\',';
}if(document.form.chk4.checked == true) {
			t=t+parseFloat(document.form.chk4.value);
			tv=tv+'chk4=\''+document.form.chk4.value+'\',';
}if(document.form.chk5.checked == true) {
			t=t+parseFloat(document.form.chk5.value);
			tv=tv+'chk5=\''+document.form.chk5.value+'\',';
}if(document.form.chk6.checked == true) {
			t=t+parseFloat(document.form.chk6.value);
			tv=tv+'chk6=\''+document.form.chk6.value+'\',';
}if(document.form.chk7.checked == true) {
			t=t+parseFloat(document.form.chk7.value);
			tv=tv+'chk7=\''+document.form.chk7.value+'\',';
}if(document.form.chk8.checked == true) {
			t=t+parseFloat(document.form.chk8.value);
			tv=tv+'chk8=\''+document.form.chk8.value+'\',';
}
document.form.total.value=t;
document.form.query.value="update p set "+tv+"total=\'"+t+'\'';
}
function ch6(){if(document.form.chk6.checked == true) {
document.form.chk7.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch7(){if(document.form.chk7.checked == true) {
document.form.chk6.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch8(){if(document.form.chk8.checked == true) {
document.form.chk6.checked = false ;
document.form.chk7.checked = false;
}ttl();
} 
</script>
</head>
<body>
<form name="form" action='redir.php?w=' method="post" >
<table align="center">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><input type="text" name="query" id="query"/></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my add featured $19.95 (your ad seen before free listings)</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk1"  value="19.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad bold $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk2"  value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad highlighted $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk3" value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add Email $9.95</td>
<td><input type="text" name="email" /></td>
<td><input type="checkbox" name="chk4" value="9.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add link to my website $9.95</td>
<td><input type="text" name="link" /></td>
<td><input type="checkbox" name="chk5" value="9.95" onclick="ttl()"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Add 10 key words $9.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk6"  value="9.95" onclick="ch6()"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
or</td>
<td>Add 20 keywords $19.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk7"  value="19.95" onclick="ch7()"/></td>
</tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add larger description (up to 4,000 charters) $29.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk8"   value="29.95" onclick="ch8()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td align="right">total &nbsp;&nbsp;&nbsp;<input name="total" type="text" disabled="disabled" /><input type="submit" value="Done" /></td>
</tr>
</table>
</form>
</body>
</html>

redir.php file

<?php
$q=stripslashes($_POST['query']);
echo "".$q;
include("config.php");
global $conn;
$result=mysql_query($q,$conn) or die("error".mysql_error());
$nm=mysql_affected_rows();
if($nm!=0)
{echo "Inserted";}else{echo "Error";}
?>

muralibobby2015 17 Posting Pro · Answer 10 · 2009-11-19T14:41:20+00:00

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Total Problem Solved</title>
<script language="javascript" type="text/javascript">
function ttl()
{
 var tv="", t=0;
  if(document.form.chk1.checked == true) {
			t=t+parseFloat(document.form.chk1.value);
			tv=tv+'chk1=\''+document.form.chk1.value+'\',';
} if(document.form.chk2.checked == true) {
			t=t+parseFloat(document.form.chk2.value);
			tv=tv+'chk2=\''+document.form.chk2.value+'\',';
}if(document.form.chk3.checked == true) {
			t=t+parseFloat(document.form.chk3.value);
			tv=tv+'chk3=\''+document.form.chk3.value+'\',';
}if(document.form.chk4.checked == true) {
			t=t+parseFloat(document.form.chk4.value);
			tv=tv+'chk4=\''+document.form.chk4.value+'\',';
}if(document.form.chk5.checked == true) {
			t=t+parseFloat(document.form.chk5.value);
			tv=tv+'chk5=\''+document.form.chk5.value+'\',';
}if(document.form.chk6.checked == true) {
			t=t+parseFloat(document.form.chk6.value);
			tv=tv+'chk6=\''+document.form.chk6.value+'\',';
}if(document.form.chk7.checked == true) {
			t=t+parseFloat(document.form.chk7.value);
			tv=tv+'chk7=\''+document.form.chk7.value+'\',';
}if(document.form.chk8.checked == true) {
			t=t+parseFloat(document.form.chk8.value);
			tv=tv+'chk8=\''+document.form.chk8.value+'\',';
}
document.form.total.value=t;
document.form.query.value="update p set "+tv+"total=\'"+t+'\'';
}
function ch6(){if(document.form.chk6.checked == true) {
document.form.chk7.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch7(){if(document.form.chk7.checked == true) {
document.form.chk6.checked = false ;
document.form.chk8.checked = false;
}ttl();
}
function ch8(){if(document.form.chk8.checked == true) {
document.form.chk6.checked = false ;
document.form.chk7.checked = false;
}ttl();
} 
</script>
</head>
<body>
<form name="form" action='redir.php?w=' method="post" >
<table align="center">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><input type="text" name="query" id="query"/></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my add featured $19.95 (your ad seen before free listings)</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk1"  value="19.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad bold $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk2"  value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Make my ad highlighted $4.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk3" value="4.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add Email $9.95</td>
<td><input type="text" name="email" /></td>
<td><input type="checkbox" name="chk4" value="9.95" onclick="ttl()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add link to my website $9.95</td>
<td><input type="text" name="link" /></td>
<td><input type="checkbox" name="chk5" value="9.95" onclick="ttl()"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Add 10 key words $9.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk6"  value="9.95" onclick="ch6()"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
or</td>
<td>Add 20 keywords $19.95&nbsp;&nbsp;&nbsp;<input type="checkbox" name="chk7"  value="19.95" onclick="ch7()"/></td>
</tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
Add larger description (up to 4,000 charters) $29.95</td>
<td>&nbsp;</td>
<td><input type="checkbox" name="chk8"   value="29.95" onclick="ch8()"/></td></tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><textarea name="text1" rows="6" cols="50"></textarea></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td align="right">total &nbsp;&nbsp;&nbsp;<input name="total" type="text" disabled="disabled" /><input type="submit" value="Done" /></td>
</tr>
</table>
</form>
</body>
</html>

redir.php file

<?php
$q=stripslashes($_POST['query']);
echo "".$q;
include("config.php");
global $conn;
$result=mysql_query($q,$conn) or die("error".mysql_error());
$nm=mysql_affected_rows();
if($nm!=0)
{echo "Inserted";}else{echo "Error";}
?>

wonderful!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

muralibobby2015 17 Posting Pro · Answer 11 · 2009-11-19T16:29:46+00:00

document.form.query.value="update p set "+tv+"total=\'"+t+'\'';

but there is no need total.
so i wrote like this .....this is not working.

document.form.query.value="update user_registration set "+tv+'\''+"where";

mangel.murti 5 Helps you in some way · Answer 12 · 2009-11-20T13:23:54+00:00

var i=1;
var strLen = tv.length; 
tv = tv.slice(0,strLen-1); 
document.form.query.value="update p set "+tv+" where id=\'"+i+'\'';

where i is your id

chechbox validations

Recommended Answers Collapse Answers

All 17 Replies

Recommended Answers