input tag data insertion to Database using Ajax and php

Question

hi I was trying to insert input tag value into MySQL using Ajax since most of the operation is going in js I tried with reference to this. now don't know what is going on, it's not doing anything I checked console its shows nothing here...I tried this code in multiple projects and there it was working. any help or alternative way would be appreciated. Thanks here are my codes files.
test.php

<!DOCTYPE html>
<html>
<head>
<script src="./jquery-3.5.0.min.js"></script>
</head>
<body>
<input type="text" name="name" id="name" placeholder="enter name">
<script type="text/javascript">
    $(document).ready(function(){
    $("#name").on('keypress',function(e){
        if(e.which == 13){
            var strr = $("#name").val();
            console.log(strr);
            $.ajax({
                type: 'POST',
                url: 'testinsert.php',
                data: $('#name').val(),
                dataType: 'json',
                success: function( response){
                console.log( 'the feedback from your result.php: ' + response);
                }
            });
        }
    });
 });
</script>
</body>
</html>

testinsert.php

<?php 
if(isset($_REQUEST))
{
mysql_connect("localhost","root","");
mysql_select_db("usr");
error_reporting(E_ALL && ~E_NOTICE);

$email=$_POST['name'];
$sql="INSERT INTO at_user(user) VALUES ('$email')";
$result=mysql_query($sql);
if($result){
echo "You have been successfully subscribed.";
}
}
?>

here is output of console enter image description here

Please use entire form tag instead of just only take input , after taking form provide `id` attribute to form after edit your question — Jatin Kaklotar, Apr 21 '20 at 05:23
Take a look at your browser's DevTools Network tab to see what data gets sent to your script. Does `$_POST['name']` exist? Where do you set `name`? — brombeer, Apr 21 '20 at 05:30
@kerbholz I check error 500 to my script but i got param `$_POST['name']` — imtiyaz khan, Apr 21 '20 at 08:48
"_but i got param $_POST['name']_" I bet you don't: `data: $('#name').val()` says you're sending a _string_ with the value of the field `#name`, no 'name' key here. Take a look at @JatinKaklotar s answer — brombeer, Apr 21 '20 at 08:56
@kerbholz I am receiving proper value of my text `input` tag — imtiyaz khan, Apr 21 '20 at 09:03
[Why shouldn't I use mysql_* functions in PHP?](https://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php?noredirect=1&lq=1) — brombeer, Apr 21 '20 at 09:04

score 2 · Accepted Answer · answered Apr 21 '20 at 05:30

2

Replace below line from ajax script

from

  data: $('#name').val(),

to

  data: {name : $('#name').val()},

answered Apr 21 '20 at 05:30

Jatin Kaklotar

445
5
17

input tag data insertion to Database using Ajax and php

1 Answers1