Upload data to database with JSON

Question

How can I upload data to database with AJAX, JSON and PHP? Here is the code.

AJAX

    function saveToTheDB(ratedIndex) {
        $.ajax({
            url: 'fetch.php',
            method: 'POST',
            cache: 'false',
            dataType: 'json',
            data: {
                ratedIndex: ratedIndex
            },
            success: function(data) {
                console.log(data);
            },
            error: function(error) {
                console.log(error);
            }
        });
    }

PHP

if($_SERVER['REQUEST_METHOD'] == 'POST')
{
    require_once 'includes\dbh.inc.php';
    $rate = $_POST['ratedIndex'];
    if(isset($_GET['userid'])){
    if($db->query(" INSERT INTO `recipes_ratings` (`recipe_rating_id`, `recipe_id`, `user_id`, `rating`)
    VALUES (null, 3 , 8, '".$rate."')
    "))   
    }
    echo json_encode($rate);
}

What have I done wrong? Can some one help me to solve this problem? Thank you very much!

EDIT

ERROR I get back a full object

If you present more specific error details would be good. – G.Spirov Apr 19 '20 at 15:00 — G.Spirov, Apr 19 '20 at 15:00

G.Spirov · Accepted Answer · 2020-04-19T16:13:45.813

0

As the response points you have syntax error, here I refactored your code in order to work.

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    require_once 'includes\dbh.inc.php';
    $rate = $_POST['ratedIndex'];

    if (isset($_GET['userid'])) {
        if($db->query("INSERT INTO `recipes_ratings` (`recipe_rating_id`, `recipe_id`, `user_id`, `rating`) VALUES (null, 3 , 8, '".$rate."')")) {
            // implementation if query is successful
        } 
    }

    echo json_encode($rate);
}

JFYI: Avoid directly placing the input variables into the query, you should use Prepared Statements.

edited Apr 19 '20 at 16:13

answered Apr 19 '20 at 15:13

G.Spirov

198
9

I tried. Same... – xMrViktorx Apr 19 '20 at 15:45
i've edited my answer, check it now. – G.Spirov Apr 19 '20 at 16:14
Thanks! It work (uploads to the database), but again, I get an object in console because I add a new line: $recipeid = $_GET['recipe_id']; – xMrViktorx Apr 19 '20 at 17:39

Upload data to database with JSON

1 Answers1