PHP AJAX MySQLi UPDATE of + 1 not working

Hi, I’m trying to update comment number but it’s not working

comments.php

[code=php]<div class=”comment-form”>
<form method=”post” autocomplete=”off”>
<div class=”hiddens”>
<input type=”hidden” id=”blog_id” value=”<?php echo $blog_id ?>” />
</div>
<fieldset>
<legend>Leave a Comment</legend>
<ul>
<li class=”msg-box” id=”comment-msg” hidden><p></p></li>
<li>
<label for=”cname”>Complete name<span class=”required”>*</span></label>
<input type=”text” id=”cname” />
</li>
<li>
<label for=”cname”>Email address<span class=”required”>*</span></label>
<input type=”text” id=”email” />
</li>
<li>
<label for=”cname”>Website</label>
<input type=”text” id=”website” />
</li>
<li>
<label for=”cname”>Comment<span class=”required”>*</span></label>
<textarea id=”comment” minlength=”10″ maxlength=”300″></textarea>
</li>
<li>
<input type=”submit” value=”Post Comment” />
</li>
</ul>
</fieldset>
</form>
</div>[/code]

comments.js

[CODE]var message;

$(document).ready(function () {
message = $(‘#comment-msg’);

$(‘.comment-form form’).submit(function (e) {
e.preventDefault();

var cname = $(‘#cname’),
email = $(‘#email’),
website = $(‘#website’),
comment = $(‘#comment’),
blog_id = $(‘#blog_id’);

// validate…
if (cname.val() === ” || email.val() === ” || comment.val() === ” || blog_id.val() === ”) {
$.addMessage(message, ‘error’, ‘Fields with (*) are required.’);
} else {
$.addMessage(message, ‘warning’, ‘Processing…’);
$.disableFields(‘.comment-form’);

$.post(‘process.php’, {

action: ‘post’,
cname: cname.val(),
email: email.val(),
website: website.val(),
comment: comment.val(),
blog_id: blog_id.val()

}, function (data) {
switch (data) {
case ‘error’:
$.enableFields(‘.comment-form’);
$.addMessage(message, ‘error’, ‘Processing failed.’);
break;
case ’email’:
$.enableFields(‘.comment-form’);
$.addMessage(message, ‘error’, ‘Invalid email address.’);
default:
$.resetFields(‘.comment-form’);
$.addMessage(message, ‘success’, ‘Your comment was successfully posted.’);
break;
}
}).error(function () {
$.addMessage(message, ‘error’, ‘Processing failed.’);
$.enableFields(‘.comment-form’);
});
}
});
});[/CODE]

process.php

[code=php]
<?php
require_once(dirname(__DIR__) . ‘/classes/database.php’);

// if is not an ajax request or a post method…
if (!$forms->isAjax() or !$forms->isPost()) {
die(‘error’);
} else {
$commentOk = 1;
$cname = trim($_POST[‘cname’]);
$email = trim($_POST[’email’]);
$phone = trim($_POST[‘website’]);
$message = trim($_POST[‘comment’]);
$blog_id = trim($_POST[‘blog_id’]);

// validate email address
$email = filter_var($email, FILTER_SANITIZE_EMAIL);

// Validate e-mail
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
die(’email’);
$commentOk = 0;
}

if ($commentOk === 1) {
// auto update comment number
$stmt = $sqlConnection->prepare(‘UPDATE blogs SET num_comments = num_comments + 1 WHERE id = ? LIMIT 1’);
$stmt->bind_param(‘i’, $blog_id);
$stmt->execute();
$stmt->store_result();

if ($stmt->affected_rows === 1) {
die(‘success’);
} else {
die(‘error’);
}
}
}[/code]

Also in #PHP _↴