PHP, AJAX, MYSQLI, Not inserting a row

Question

I am trying to insert a row to the DB via ajax request, but the row is not inserting to the DB

 //Simple form
<div class="form_style">
<form action="#" method="POST">
<textarea name="content_txt" id="contentText" cols="45" rows="5" 
placeholder="Enter some text"></textarea>
<button id="FormSubmit">Add record</button>
</form>
</div>

And the response.php

if(isset($_POST["content_txt"])){
 //MYSQL CLASS
include('includes/mysql.inc.php');
file_get_contents('php://input');
 //Accessing the POST variables
$contentToSave = $_POST["content_txt"]; 
 //Inserting the row    
$insert_row = "INSERT INTO comments (comment) VALUES 
('".$contentToSave."')";
$r = mysqli_query($dbc, $insert_row);    
 }
else
{
//This block is executing right the moment, seems like $_POST datas not 
POSTING
header('HTTP/1.1 500 Error occurred, Could not process request!');
exit();
} //seems like maybe the jquery include file is not proper? but i checked it connecting not locally to the jquery library

But the row is not inserting to the DB

Debug your script in each stage and find the actual problem.. — Murad Hasan, Jun 29 '17 at 09:01
column name should not enclosed by single quotes . "INSERT INTO comments ('comment') VALUES ('".$contentToSave."')" — JYoThI, Jun 29 '17 at 09:02
As you said your page refreshing . so that first of your ajax call not working . — JYoThI, Jun 29 '17 at 09:05
@JYoThI it's working, headers from the response.php set HTTP/1.1 500 error — Andrew, Jun 29 '17 at 09:07
data should be send properly like this data:{content_txt:$("#contentText").val()}, — JYoThI, Jun 29 '17 at 09:07
@JYoThI I set the data send properly, now the page is not refreshing but in response.php i have an empty set of the POST — Andrew, Jun 29 '17 at 09:13
put this code in response.php echo file_get_contents('php://input'); to know value is posting or not . — JYoThI, Jun 29 '17 at 09:16
remove all the line in response.php put this single line echo file_get_contents('php://input'); and tell me the output @Andrew — JYoThI, Jun 29 '17 at 09:37
@JYoThI seems like found the solution, because of my htaccess rewriting the .php, in my ajax code i done the following url: "../response.php" to url: "../response", now there is no error, but no row inserted again — Andrew, Jun 29 '17 at 10:11
@JYoThI i solved my problem lol))) the problem was that in my html template i had two
tags therefore the other browsers was not functioning — Andrew, Jul 31 '17 at 07:47

score 0 · Answer 1 · answered Jun 29 '17 at 09:03

0

In your insert statement, remove the single quotes around the comment. What you need is back ticks to properly escape if you are trying to access a MySQL reserved keyword

answered Jun 29 '17 at 09:03

Rotimi

4,783
4
18
27

not worked at all, headers sent HTTP/1.1 500 error – Andrew Jun 29 '17 at 09:05

score 0 · Answer 2 · answered Jun 29 '17 at 09:03

0

Your problem is that you have quoted the column name. Use

$insert_row = "INSERT INTO comments (comment) VALUES 
('".$contentToSave."')";

answered Jun 29 '17 at 09:03

Starx

77,474
47
185
261

not worked at all, headers sent HTTP/1.1 500 error – Andrew Jun 29 '17 at 09:05
@Andrew, you need to give me some error responses. Regarding the query itself in my answer is not the problem. – Starx Jun 29 '17 at 09:09
While inserting the page refreshes, however it not has to refresh the page – Andrew Jun 29 '17 at 09:10
@Andrew, that's a different question, let's focus on "not inserting row" in this question. If you have another problem you ask another question, that's how it works in Stackoverflow. – Starx Jun 29 '17 at 09:12

PHP, AJAX, MYSQLI, Not inserting a row

2 Answers2