AJAX POST to PHP script

Question

I'm trying to POST from my program to a separate PHP file, then grab that data and store it into my SQL database. I've checked my code over and over and can't' find what I'm doing wrong. Any help would be appreciated.

AJAX

$(".btn btn-success last").click(function(){
        $.post("go2.php",
        {
             name: "Donald Duck",
             city: "Duckburg"
        },
        function(data, status){
             alert("Data: " + data + "\nStatus: " + status);
            });
    });

PHP file (go2.php) w/ SQL code

    <?php

include 'connection.php';

$x = $_POST["name"];
$sql = "INSERT INTO users (Username) VALUES ('$x') ";
$query = mysql_query($sql);



?>

Your code has an SQL injection vector and a deprecated API used . — Benjamin Gruenbaum
– Benjamin Gruenbaum, Commented Apr 25, 2015 at 23:55
How come I need to echo something back @adeneo ? I'm checking the SQL database after each execution for any update — Justin E. Samuels
– Justin E. Samuels, Commented Apr 25, 2015 at 23:56
Should provide more detail on what is or isn't working. You haven't specified if the request is being made or not , if any errors are thrown etc. Use browser dev tools/console to inspect request — charlietfl
– charlietfl, Commented Apr 26, 2015 at 0:08

Mohamed-Yousef · Accepted Answer · 2015-04-26 00:24:19Z

1

From your code ..

you need to learn a little bit more about selectors

$(".btn btn-success last") // what is btn-success ID or Class and 

//What is last ID or Class for id use #btn-success for class use .btn-success

before you insert anything to php file check if this file already connected with js or not .. and with the next code you should get alert with 'file already connected'

 $(".btn .btn-success .last").click(function(){
        $.post("go2.php",
        {
             name: "Donald Duck",
             city: "Duckburg"
        },
        function(data){
             alert(data);
            });
    });

and in php

<?php 
echo('file already connected');
?>

Most important thing to know what is a (.last) is that a button or form or anchor

if .last is form

$(".btn .btn-success .last").on('submit',function(e){
   e.preventDefault();
   return false;
});

if .last is button or anchor

$(".btn .btn-success .last").on('click',function(e){
       e.preventDefault();
       return false;
  });

hope it will help

answered Apr 26, 2015 at 0:24

Mohamed-Yousef

24k3 gold badges21 silver badges28 bronze badges

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

3 Comments

Justin E. Samuels Over a year ago

I think it would be more clear if you seen the actual demo I'm working on. It's a SPA, so I really can't echo anything back when making the POST. I understand selectors and what not, it's just not reaching my PHP file and I dont understand why. Since it's SPA, I've been testing a echo by having it write data to a file when it reaches the go2.php file

Justin E. Samuels Over a year ago

check out my demo at justinsamuels.info/structures/Steps/index.html and click all the way to STEP 4. The data being entered, I need it to be POSTED so I can retrieve it and store into a SQL database

Mohamed-Yousef Over a year ago

is the go2.php directory is the same with your index.html?

xNeyte · Accepted Answer · 2015-04-26 00:12:52Z

0

Try the long version of ajax request

$(document).ready( function () { 
        $(".btn btn-success last").click(function(){                        
            $.ajax({ 
               type: "POST",
               url: "go2.php", 
               data: {name:"Donald Duck", city:"Duckburg"},
               success: function(data){
                    document.getElementById('divId').html(data);
               }
            });
        });
    });

For the echo data, you have to echo a message in your go2.php like "Success"

edited Apr 26, 2015 at 0:12

answered Apr 26, 2015 at 0:07

xNeyte

6224 silver badges18 bronze badges

9 Comments

charlietfl Over a year ago

there is no echo in javascript

charlietfl Over a year ago

where does findElementById come from?

xNeyte Over a year ago

changed, going to sleep

Justin E. Samuels Over a year ago

no error being thrown, just my DB is not updating with the info being POSTED

Justin E. Samuels Over a year ago

still no luck with this long version of the AJAX request.

|

Collectives™ on Stack Overflow

AJAX POST to PHP script

AJAX

2 Answers 2

3 Comments

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

AJAX

2 Answers 2

3 Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related