Cannot return id as json object using php

Asked Aug 02 '16 at 10:06

Active Aug 02 '16 at 10:08

Viewed 32 times

I am creating an android application and I am currently creating groups. Everything is fine when I insert the group into the table and echoing "success" as a JSON object.

The problem is, I need to retrieve the auto incremented id from this group. This is what my php looks like.

<?php
    $con = mysqli_connect();

    $gname = $_POST["gname"];
    $statement = mysqli_prepare($con, "INSERT INTO groups (gname) VALUES (?)");
    $id =  mysql_insert_id();
    mysqli_stmt_bind_param($statement, "s", $gname);
    mysqli_stmt_execute($statement);

    $response = array();
    $response["success"] = true; 
    $response["id"] = $id;


    echo json_encode($response);
?>

When I added the lines

$id =  mysql_insert_id();

and

$response["id"] = $id;

the program stopped working. How do I retrieve the Id?

edited Aug 02 '16 at 10:08

RiggsFolly

93,638
21
103
149

asked Aug 02 '16 at 10:06

Gustav Lindfors

1

First of all, mysql vs mysqli? second of all, I always thought you need to execute the query first before asking last insert id.. – Naruto Aug 02 '16 at 10:09
1

You cannot mix `mysqli_` and `mysql_` API's change `mysql_insert_id()` to `mysqli_insert_id($con)` – RiggsFolly Aug 02 '16 at 10:09
Remove the line ` $id = mysql_insert_id();` and replace this line `$response["id"] = $id;` with $response["id"] = mysqli_insert_id();; – Anuranjan Pandey Aug 02 '16 at 10:44
@AnuranjanPandey Thanks it solved my problem!! – Gustav Lindfors Aug 02 '16 at 11:09

Cannot return id as json object using php

0 Answers0