What happens is I have a variable in javascript called rate, and when I save this variable in the DB I get an error, I do not know why this error is due or how would I save a variable (fix) of javascript in Php? . WITHOUT AJAX.
Here is the code:
<!DOCTYPE html>
<html lang="es">
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
</head>
<body>
<div class="container">
<form name = "form1" class="form-horizontal" method="POST" action="<?php $_SERVER['PHP_SELF'] ?>" autocomplete ="off">
<div class="form-group has-success has-feedback">
<label for="comentario">Comentario :</label>
<input type="text" class="form-control" id="comentario" name = "comentario">
</div>
<label for="comentario">Calificacion :</label>
<div class='starrr' id='rating-student' name = "rating-student"> </div> <br>
<input type="submit" name = "enviar" id="enviar" class="btn btn-success" value="Calificar">
<div class="msg"></div>
</div>
</form>
<hr>
<?php
require 'conexion.php';
if(!empty($_POST)){
$comentario = $mysqli->real_escape_string($_POST['comentario']);
$rating = $mysqli->real_escape_string($_POST['rate']);
$sql = "INSERT INTO comentarios (comentario, rating) VALUES ('$comentario', '$rating')";
$resultado = $mysqli->query($sql);
if($resultado){
echo "Registro insertado";
}else{
echo "No se pudo insertar el registro";
}
}
?>
<script src="js/estrellita.js"></script>
<script>
// rating
var rate;
$('#rating-student').starrr({
change: function(e, value){
rate = value;
if (value) {
$('.your-choice-was').show();
} else {
$('.your-choice-was').hide();
}
}
});
</script>
</body>
</html>