Dados não estão sendo salvos no banco
Olá gostaria da ajuda de vocês para resolver este problema.
Estou passando os dados de um formulário via Ajax de um modal e após eu preencher o formulário e clicar save os dados não aparecem no banco.
Código da pagina com modal:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title>Crud</title>
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<p><br /></p>
<div class="container">
<p></p>
<button class="btn btn-primary" data-toggle="modal" data-target="#addData">Insert Dataaa</button>
<!-- Modal -->
<div class="modal fade" id="addData" tabindex="-1" role="dialog" aria-labelledby="addLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="addLabel">Insert Data</h4>
</div>
<form>
<div class="modal-body">
<div class="form-group">
<label for="nm">Full Name:</label>
<input type="text" class="form-control" id="nm" placeholder="Nama Lengkap">
</div>
<div class="form-group">
<label for="em">email</label>
<input type="email" class="form-control" id="em" placeholder="Surel">
</div>
<div class="form-group">
<label for="hp">Phone Number</label>
<input type="number" class="form-control" id="hp" placeholder="Nomor Telp/HP">
</div>
<div class="form-group">
<label for="al">Adress</label>
<textarea type="password" class="form-control" id="al" placeholder="Alamat"></textarea>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="submit" onclick="saveData()" class="btn btn-primary">Save</button>
</div>
</form>
</div>
</div>
</div>
<p></p>
</div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script type="text/javascript" src="js/jquery.min.js.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script type="text/javascript" src="js/bootstrap.min.js"></script>
<script>
function saveData(){
var name = $('#nm').val();
var email = $('#em').val();
var phone = $('#hp').val();
var adress = $('#al').val();
$.ajax({
type: "POST",
url: "server.php?p=add",
data: "nm="+name+"&em="+email+"&hp="+phone+"&al="+address,
success: function(msg){
alert("Success insert Data");
}
});
}
</script>
</body>
</html>
Código da base de dados:
<?php
$db = new pdo('mysql:host=localhost;dbname=crudss', 'root');
$page= isset($_GET['add']) ? $_GET['add'] : '';
if($page == 'add'){
$name = $_POST['nm'];
$email = $_POST['em'];
$phone = $_POST['hp'];
$address = $_POST['al'];
$stmt = $db->prepare("insert into crud values('', ?, ?, ?, ?)");
$stmt->bindParam(1, $name);
$stmt->bindParam(2, $email);
$stmt->bindParam(3, $phone);
$stmt->bindParam(4, $address);
}else if($page == 'edit'){
}else if($page == 'del'){
}else{
}
var_dump($name);
?>Discussão (13)
Carregando comentários...