Send data to mysql database using AJAX post request

Question

I want to send user typed string via AJAX POST request and add to database:

Új gyártó: <input type="text" id="new_mfg" size="20">
<button id="add_mfg">Hozzáadás</button>
<script>
    $("#add_mfg").click(function(e){
        e.preventDefault()
        var new_mfg = $('#new_mfg').val();
        //$(this).text(new_mfg);                    
        request = new XMLHttpRequest();
        request.open("POST","/phps/add_mfg.php",true);
        xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
        request.send('$new_mfg');
    });
</script>

Here is the add_mfg.php script:

require_once('login.php');

$new_mfg = $_POST['new_mfg'];
$new_mfg = stripslashes($new_mfg);

$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if(!$db_server) die("Unable to connect to MYSQL:" . mysql_error());

mysql_select_db($db_database)
    or die("Unable to select database:" . mysql_error());
$query = "INSERT INTO mfg(ID, mfg_name) VALUES(NULL, '$new_mfg')";
$result = mysql_query($query);

mysql_close($db_server);

The code doesn't work and I don't know what the problem is.

why don´t you use JQuery ajax method? api.jquery.com/jQuery.ajax — Dimo
– Dimo, Commented Aug 26, 2013 at 11:13
Is the request sending to add_mfg.php.Do you have any error in the console? — 웃웃웃웃웃
– 웃웃웃웃웃, Commented Aug 26, 2013 at 11:13
As a matter of fact, you cannot send data to mysql databse using AJAX post request. You can send it to PHP script only — Your Common Sense
– Your Common Sense, Commented Aug 26, 2013 at 11:23
Nope, I dont have any error log. I'll try to change to jquery ajax method, but does it matter for this case? — Zsoca
– Zsoca, Commented Aug 26, 2013 at 12:14

Dipesh Parmar · Accepted Answer · 2013-08-26 11:13:27Z

3

You need to wrap your click event handler into $(document).ready(function(){ });

$(document).ready(function(){  
$("#add_mfg").click(function(e){

});
});

answered Aug 26, 2013 at 11:13

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

pethel Over a year ago

or the shortcut $(function(){});

Dipesh Parmar Over a year ago

@user874774 Yes...But i think OP is newbie so its easier for him to google it.

Dipesh Parmar Over a year ago

even you need to replace new XMLHttpRequest(); request with $.ajax({});

Zsoca Over a year ago

I think there is no problem with the jquery event. My first tough was the same, but I tried to print out the readed new_mfg variable:

Lkopo · Accepted Answer · 2013-08-26 11:18:15Z

0

Use this short version:

$(function() {
  $("#add_mfg").click(function(e){
      // ...
  });
});

answered Aug 26, 2013 at 11:18

Lkopo

4,8538 gold badges37 silver badges60 bronze badges

Collectives™ on Stack Overflow

Send data to mysql database using AJAX post request

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related