How to change string into JSON format structure using PHP?

Question

I have these code to pull data from two different database.

And I need to eliminate the same row by 'staffid'.

So far I can eliminate the duplicate. But the output is not what I want it to be.

index.php

<?php

    // PART A
    require 'conn.php';
    $query = "SELECT STAFFID FROM TABLE";
    $result = oci_parse($conn, $query);
    oci_execute($result);
    while ($row = oci_fetch_array($result,OCI_NUM)){
        $arr[] = $row[0]; 
    } 


    // PART B
    $url="http://localhost/fetch_data.php";  
    $ch = curl_init(); 
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); 
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); 
    curl_setopt($ch, CURLOPT_URL,$url); 
    $result=curl_exec($ch); 
    curl_close($ch); 


    foreach(json_decode($result) as $result2)
    {
        if(!in_array($result2[0],$arr))
        {
            $total = "".$result2[0].",".$result2[1].",".$result2[2]."<br/>"; 
            echo json_encode($total);
        }       
    }
?>

The output for far for the above code as below

"A001","BILLY","[email protected]"
"A002","JOHN","[email protected]"
"A003","SALLY","[email protected]"

fetch.php

<?php
    include_once('conn.php');

    $arr        = array();
    $query      = "SELECT * FROM TABLE "; 
    $stmt       = sqlsrv_prepare($conn, $query);
    $result     = sqlsrv_execute($stmt);
    $row        = sqlsrv_fetch_array($stmt);

    $array  = array();
    while( $self = sqlsrv_fetch_array( $stmt)) { 

        $array2 = array();
        $array2[]= $self['ID'];  
        $array2[]= $self['NAME'];  
        $array2[]= $self['EMAIL'];  

        $array[] =  $array2;
    }
    echo json_encode($array);
?>

My goal is to change it into JSON as below. I'm missing the bracket and the coma.

[
    ["A001","BILLY","[email protected]"],
    ["A002","JOHN","[email protected]"],
    ["A003","SALLY","[email protected]"]
]

Appreciate if someone can help me to fix this issue. Thanks.

Yes. I want the output to be like [ ["A001","BILLY","[email protected]"], ["A002","JOHN","[email protected]"], ["A003","SALLY","[email protected]"] ] — Rzj Hayabusa
– Rzj Hayabusa, Commented Oct 30, 2019 at 12:26
@PeterM . Yup, I need to echo the output in index.php only. Is it possible ? — Rzj Hayabusa
– Rzj Hayabusa, Commented Oct 30, 2019 at 12:33

Peter M · Accepted Answer · 2019-10-30 12:34:24Z

1

Try changing

foreach(json_decode($result) as $result2)
{
    if(!in_array($result2[0],$arr))
    {
        $total = "".$result2[0].",".$result2[1].",".$result2[2]."<br/>"; 
        echo json_encode($total);
    }       
}

into

foreach(json_decode($result) as $result2)
{
    if(!in_array($result2[0],$arr))
    {
        $total[] = $result2; 
    }       
}
echo json_encode($total);

edited Oct 30, 2019 at 12:34

answered Oct 30, 2019 at 12:22

Peter M

1,0598 silver badges19 bronze badges

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

2 Comments

Rzj Hayabusa Over a year ago

Thanks. But how can I add bracket for each row of data ?

Peter M Over a year ago

@Rozaimi this should do the trick, json_encode does all the magic for your, no need to add the brackets [] on your own. Also don't add <br/> in there, your JSON will be invalid.

Collectives™ on Stack Overflow

How to change string into JSON format structure using PHP?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related