The id and value I'm trying to pass is lessonnum6 to AJAX url updatesaved.php. Do I need to specify something below in AJAX for a hidden field type?
The php code
<?echo '<input type="hidden" id="lessonnum6" value='.$a3['lessonid'].'>';?>
echo "<button type=\"submit\" id=\"updatestar6"\" class=\"star0\">";
AJAX Call
$("#updatestar6").click(function(){
var lessonnum6=$("#lessonnum6").val();
var static6=$("#static6").val();
$.ajax({
url:'/updatesaved.php',
method:'POST',
data:{
lessonnum6:lessonnum6,
static6:static6
},
success:function(response){
if ($('#updatestar6').hasClass('star0')) {
$('#updatestar6').removeClass('star0').addClass('star');
}
alert(response);
}
});
});
Below is updatesaved.php. I cannot echo or read the post value for lessonnum6 and as a result the query field idlesson below is showing a 0 in db table.
updatesaved.php - db
<? if (!empty($_POST["lessonnum6"])) {
$p=$_POST["lessonnum6"];
} elseif (!empty($_POST["lessonnum7"])) {
$p.=$_POST["lessonnum7"];
} elseif (!empty($_POST["lessonnum8"])) {
$p.=$_POST["lessonnum8"];
} elseif (!empty($_POST["lessonnum9"])) {
$p.=$_POST["lessonnum9"];
} elseif (!empty($_POST["lessonnum10"])) {
$p.=$_POST["lessonnum10"];
} elseif (!empty($_POST["lessonnum11"])) {
$p.=$_POST["lessonnum11"];
}
$sql = "INSERT into steam_lessons_shared SET idlesson = '".$p."', memberid = '".$_SESSION['memberid']."', stage = 0";
//mysqli_query($con,$sql);
if($con->query($sql)===TRUE){
echo "DATA updated";
}?>