<script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery/jquery-1.6.2.min.js"></script>
<script type="text/javascript">
numBets=0;
function chooseBets(f)
{
var c=f['ckbox[]'];
for(var i=0;i<c.length;i++){
if(c[i].checked) { numBets++; }
}
}
</script>
<form> <table cellspacing=5 cellpadding=5 border=1> <tr><td id="cell2_1" style="display:none;"> <input name="ckbox[]" type="checkbox" id="trn2_1" onclick="chooseBets(this.form)">2=1</input> </td><td id="cell3_1" style="display:none;"> <input name="ckbox[]" type="checkbox" id="trn3_1" onclick="chooseBets(this.form)">3=1</input> </td></tr> <tr><td colspan=5><input type="submit" name="btnOrder" id="btnOrder" value="place order"/></td></tr> </table> </form>
<script type="text/javascript">
$("#btnOrder").click( function(){
$.post('save2tdb.php', { total_bets: numBets }, function(data){
if(data == 1){
alert('Data was saved in db!');
} else {
alert('failed to execute save2db.php...');
}
});
});
</script>
save2tdb.php:
<?php
if ($_POST && isset($_POST['value'])) {
.... connecting to db and table..
$num_bets=mysql_real_escape_string($_POST['value']);
$sql = "INSERT INTO orders (order_number,order_date,total_bets) VALUES ('5',2012-08-13','$num_bets')";
.....
}
?>
This post has been edited by g37752: 13 August 2012 - 07:38 PM

New Topic/Question
Reply


MultiQuote



|