How to send a request to a file php using jQuery.ajax

Question

I have two buttons: one for create a table in my database and another to delete the table, but when I click on the button "Drop Table" the message shown is: "Error create table: Table 'post' already exists", because it enters the first if on php file. I can not find how to solve this.

Here go my code:

html

<button id="loadButton" type="button" class="btn btn-success" style="margin-top:5px;">Create Table</button>
<button id="deleteButton" type="button" class="btn btn-danger" style="margin-top:5px;">Drop Table</button>

dash.js file

$('#loadButton').click(function() {
    $.ajax({
        url: 'connectdb.php',
        success: function(data){
            alert(data);
        },
        error: function(jqXHR, textStatus, errorThrown){
            alert('Error: ' + textStatus);
        }
    });
});
$('#deleteButton').click(function() {
    $.ajax({
        type: 'POST',
        url: 'connectdb.php',
        data: "drop",
        success: function(data){
            alert(data);
        },
        error: function(jqXHR, textStatus, errorThrown){
            alert('Error: ' + textStatus);
        }
    });
});

connectdb.php file

// Create table
$sql="CREATE TABLE Post( 
    id_post int Primary Key, 
    titulo varchar(100) not null, 
    imagem longblob,
    descricao varchar(1000) not null,
    hashtag varchar(100) not null
)";

// Execute query
if(!isset($_POST["drop"])){
if (mysqli_query($con,$sql)) {
  echo "Table created with success";
} else {
  echo "Error create table: " . mysqli_error($con);
}
}

if (isset($_POST["drop"])) {
    $sql1="DROP TABLE IF EXISTS Post;";
    if (mysqli_query($con,$sql1)) {
        echo "Table deleted";
    } else {
        echo "Error: " . mysqli_error($con);
    }
}

What I'm doing wrong?

You are sending a value, not a key -> data: "drop",. Try data: {drop:'drop'}. Although it is not a great idea to create/drop tables like this. — Sean
– Sean, Commented Aug 4, 2014 at 22:49
thanks it works :)... Why you say that it is not a great idea to create/drop tables like this? In future I will create table manually — seal
– seal, Commented Aug 4, 2014 at 22:59
In order for this to be safe, you will need to make sure your connectdb.php is password protected, or anyone will be able to delete your tables by accessing the url directly. — Sean
– Sean, Commented Aug 4, 2014 at 23:03
Ah ok! you are right, so anyone could make sql injection. I will follow your advice :). Thank you. — seal
– seal, Commented Aug 4, 2014 at 23:19

Stefan Cvetkovic · Accepted Answer · 2014-08-05 00:43:59Z

1

You are don't sending post value. It's should look like this:

$('#deleteButton').click(function() {
    $.ajax({
        type: 'POST',
        url: 'connectdb.php',
        data: { drop: "Drop value that you need"}
        success: function(data){
            alert(data);
        },
        error: function(jqXHR, textStatus, errorThrown){
            alert('Error: ' + textStatus);
        }
    });
});

answered Aug 5, 2014 at 0:43

Stefan Cvetkovic

1442 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

How to send a request to a file php using jQuery.ajax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related