using php & Javascrip to pass form on checkbox

[nade93]

Hi All

 

I am trying to update a database when a checkbox has been checked without using a submit button

 

Please find code below:

 

<form action="<? echo $PHP_SELF ; ?>" method="post" >
       <input type='checkbox' id="css_sized_container" name="checkbox[".$row['onoff']."]" value='<? echo $row['onoff']; ?>' onclick='document.form".$row['onoff'].".submit();' />

        </form>
        
        <? include('../lib/conn.php'); 
	$ifchecked = $_REQUEST['checkbox'];
	mysql_query("UPDATE users_audio SET onoff='' WHERE userid='1'");
	 ?>

 

basically, i want the user to check or uncheck the box, this be passed to the database then the checkbox remembers the answer for that user from the database (i.e. $row['onoff']; )

 

Any help would be amaing as very stuck!

 

[StathisG]

You can add a call to a JavaScript function using onclick="nameOfFunction()" within your checkbox (like you already do in a way). In that function you can make a request using Ajax to another php file and update the database there.

[nade93]

thanks for the reply, however i want to do it all on the same page without using ajax

[StathisG]

If you don't have to use Ajax, you'll have to reload the page and submit the value of the checkbox to it.

[nade93]

how do i do it using ajax then as dont want to reload the page..... sorry just not very good with ajax..... well dont know any!

[nade93]

hey sorry to bump but can any one help me out please?

 

thanks