Failed to get data from localhost using php in android

Question

Im new at Android. I'm trying to fetch some data from localhost server. My query is running perfectly on phpMyAdmin But I facing error in api. I have very little knowledge about Php so did not get what the issue is.

Code:

public function saveUserProgress($user_id,$course_id,$topic_id,$quiz_marks){

        $output = $this->con->prepare("INSERT INTO user_progress (user_id, course_id, topic_id,quiz_marks)
        VALUES (?, ?, ?,?)
        ON DUPLICATE KEY UPDATE
            user_id=?, course_id=?, topic_id=?, quiz_marks = quiz_marks + ?");

        $output->bind_param("iiii",$user_id,$course_id,$topic_id,$quiz_marks);

        if($output->execute()){
            return  PROGRESS_SAVED;
        }else{
            return ERROR_OCCUR;
        }
    }

Error:

{"error":true,"message":403}
Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement

@Dharman 4 variables in insert statement is same as 4 variables in On Duplicate Key Update statement — MUHAMMAD AWAIS
– MUHAMMAD AWAIS, Commented Sep 2, 2019 at 18:12
user_id and course_id is set unique as same user not have same course twice @Dharman — MUHAMMAD AWAIS
– MUHAMMAD AWAIS, Commented Sep 2, 2019 at 18:17

Dharman · Accepted Answer · 2019-09-02 18:20:07Z

4

If as you said your unique key is user_id and course_id then you do not need to update them on duplicate key. You only need to update the remaining 2 values. Together with the 4 you wanted to add it makes 6 placeholders, so you need to bind 6 variables.

$output = $this->con->prepare("INSERT INTO user_progress (user_id, course_id, topic_id,quiz_marks)
    VALUES (?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE 
        topic_id=?, quiz_marks = quiz_marks + ?");

$output->bind_param("iiiiii", $user_id, $course_id, $topic_id, $quiz_marks, $topic_id, $quiz_marks);

answered Sep 2, 2019 at 18:20

Dharman♦

34k27 gold badges106 silver badges157 bronze badges

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

Collectives™ on Stack Overflow

Failed to get data from localhost using php in android

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