need the result of mysqli query as a json array from this phpscript

Question

this is my php script

$con = mysqli_connect(HOST,USER,PASS,DB);

if($_SERVER['REQUEST_METHOD']=='GET') 
{

$qry_check="SELECT * FROM `tb_user`";

$stmt = $con->prepare($qry_check);

if ($stmt->execute()){

     echo "Success";

}}

else 
     echo "Fail";

}
?>

when i run this query on my mysqli online server i get result which i have attached below i need this result as a json array when i call this json url, hanks in advance,enter image description here

enter image description here

Possible duplicate of [JSON encode MySQL results](https://stackoverflow.com/questions/383631/json-encode-mysql-results) — Ch4t4r, Aug 18 '17 at 08:54

Vinayak B · Answer 1 · 2017-08-18T10:26:00.217

0

try this

<?php

    $con = mysqli_connect(HOST,USER,PASS,DB);

    if($_SERVER['REQUEST_METHOD']=='GET') 
    {
        $stmt = $con->prepare("SELECT * FROM tb_user");

             if ($stmt->execute()) {
                    $users = array();
                    $user=$stmt->get_result();
                     while($row = $user->fetch_assoc()){
                        $users[]=$row;
                     }

                     $stmt->close();                       

                echo json_encode($users);
            }
}

?>

or use this code. Add your remaining columns in this code for full result

    <?php

    $con = mysqli_connect(HOST,USER,PASS,DB);

    if($_SERVER['REQUEST_METHOD']=='GET') 
    {
        $stmt = $con->prepare("SELECT user_id, category_id FROM tb_user");

             if ($stmt->execute()) {
                    $users = array();
                    $stmt->bind_result($user_id, $category_id);
                      while ($stmt->fetch()) {

                         $user["user_id"] = $user_id;
                        $user["category_id"] = $category_id;
                        $users[] = $user;
                     }

                     $stmt->close();                       

                echo json_encode($users);
            }
}

?>

edited Aug 18 '17 at 10:26

answered Aug 18 '17 at 09:03

Vinayak B

3,922
2
21
49

Fatal error: Using $this when not in object context – ente kottayam Aug 18 '17 at 09:11
i have added two parathesis at end now it shows error like this... Call to a member function execute() on a non-object – ente kottayam Aug 18 '17 at 09:23
try this one please – Vinayak B Aug 18 '17 at 09:31
Fatal error: Call to undefined method mysqli_stmt::get_result() – ente kottayam Aug 18 '17 at 09:34
please do check my database screenshot – ente kottayam Aug 18 '17 at 09:34
you can avoid this problem https://stackoverflow.com/questions/8321096/call-to-undefined-method-mysqli-stmtget-result?answertab=votes#tab-top – Vinayak B Aug 18 '17 at 09:44
use this for reference https://stackoverflow.com/questions/18753262/example-of-how-to-use-bind-result-vs-get-result?answertab=votes#tab-top – Vinayak B Aug 18 '17 at 09:49
if you can help me with code it will be better bcoz i have already read it – ente kottayam Aug 18 '17 at 09:49
am an android developer and i have just minute knowledge in php – ente kottayam Aug 18 '17 at 09:49
added some edits using bind_result . please look into it – Vinayak B Aug 18 '17 at 10:26

B. Desai · Answer 2 · 2017-08-18T10:35:49.990

I already mention in comment that mysqli != PDO. But I thnk you don't get it.

You are initializing connection with mysqli then doing all process with PDO so you don't get result

<?php  

    $servername = HOST;
    $username = USER;
    $password = PASS;
    $dbname = DB;
    $con = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

    if($_SERVER['REQUEST_METHOD']=='GET') 
    {
        $stmt = $con->prepare("SELECT * FROM tb_user");

             if ($stmt->execute()) 
             {
                    $users = array();                        
                     while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                        $users[]=$row;
                     }

                     $stmt->close();                       

                echo json_encode($users);
            }
}

?>

need the result of mysqli query as a json array from this phpscript

2 Answers2