CODEWITHSUNDEEP
phpmysqljson
Thomas Haas
Thomas Haas

Reputation: 33

MySQL Data to JSON Array with inserting a string

This is my Code for now but it only works until the for loop in the mySQLResultsetToJSON().

<?php    
$servername = "127.0.0.1";
$username = "root";
$password = "123456";
$table = "ticketing";
$link = new mysqli($servername, $username, $password, $table);
if ($link->connect_error) {
    die("Connection failed: " . $link->connect_error);
}
    echo "Connected successfully";    

$result = $link->query("SELECT * from Ticket");

print_r($result);
$final_result = mySQLResultsetToJSON($result);
print_r($final_result);    
$link->close();    

function mySQLResultsetToJSON($resultSet)
{
        for($i = 0; sizeof($resultSet); $i++)
        {
            $rows = array();
            while($r = mysqli_fetch_assoc($resultSet[$i])) {
                $rows[] = $r;
            }
            $jsonResult[$i] = json_encode(array('Results' => $rows));
        }    
        print_r($jsonResult);    
        return $jsonResult;
    }    
?>

Thank you!

Thomas

Upvotes: 1

Views: 50

Answers (2)

Deepak Adhikari
Deepak Adhikari

Reputation: 417

echo "mysql data<br />";
$result = $link->query("SELECT * from users");
print_r($result->fetch_object());

echo "<br />";

echo "in json<br />";
$res = ['Results' => $result->fetch_object() ];
echo json_encode($res);
$link->close();

Upvotes: 1

Brijal Savaliya
Brijal Savaliya

Reputation: 1091

User like 

$result = $link->query("SELECT * from Ticket");
$rows = array();
while($r = mysqli_fetch_assoc($result)) {
    $rows[] = $r;
}
print "<pre>";
print_r(json_encode(array('Results' =>$rows)));    
$link->close();

Upvotes: 0

Related Questions