I have this jquery script
<script>
$("#btn1").click(function(e) {
e.preventDefault();
var name = $("#id1").val();
var last_name = $("#id2").val();
var dataString = 'name='+name+'&last_name='+last_name;
$.ajax({
type:'POST',
data:dataString,
url:'php/insert.php',
success:function(data) {
alert(data);
}
});
});
</script>
and this insert.php script
<?php
$dbconn = pg_connect("host=localhost dbname=kinoseansy user=postgres password=postgrespass")
or die('Could not connect: ' . pg_last_error());
$name = $_POST['name'];
$last_name = $_POST['last_name'];
$result = pg_query($dbconn, "INSERT INTO contacts(address,phone_number,city,others)
VALUES('+1 123 456 7890', 'John', 'Doe','123');");
var_dump($result);
pg_close($dbconn);
?>
but when I try to click button with id=btn1 nothing happens, no errors, no messages in Chrome console and no data inserted in the database. What is wrong here?
edit#1: this is head part of my document:
<!DOCTYPE html>
<html lang="en">
<head>
<title>Car Repair | Locations</title>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" media="screen" href="css/reset.css">
<link rel="stylesheet" type="text/css" media="screen" href="css/style.css">
<link href='http://fonts.googleapis.com/css?family=Open+Sans+Condensed:700,300' rel='stylesheet' type='text/css'>
<script type="text/javascript" src="js/jquery-1.7.min.js"></script>
<script type="text/javascript" src="js/jquery.easing.1.3.js"></script>
<script>
$("#btn1").click(function(e) {
e.preventDefault();
var name = $("#id1").val();
var last_name = $("#id2").val();
var dataString = {'name=':name, 'last_name': last_name};
$.ajax({
type:'POST',
data:dataString,
url:'php/insert.php',
success:function(data) {
alert(data);
}
});
});
</script>
so jquery library is loaded here, I believe.