How to Select multiple tables for converting mysql to json?

Question

How to Convert mysql all tables to json(How to Select Multiple tables, not one);

I am trying to select multiple table of my db: then convert it from mysql to json format Please guide me!

  <body>  
       <?php   
       $connect = mysqli_connect("localhost", "root", "", "martlink_db");  
       $sql = "SELECT * FROM users";  
       $result = mysqli_query($connect, $sql);  
       $json_array = array();  
       while($row = mysqli_fetch_assoc($result))  
       {  
            $json_array[] = $row;  
       }  
       echo '<pre>';  
       print_r(json_encode($json_array));  
       echo '</pre>'; 
       //echo json_encode($json_array);  
       ?>  
  </body>

AswathyShaji · Accepted Answer · 2019-02-09 08:57:11Z

1

Check the following query

<?php   
    $connect = mysqli_connect("localhost", "root", "", "martlink_db");  
    $sql ="SELECT * FROM table1 t1,table2 t2 where condition"  
    $stmt = $conn->query($sql);
    $jsonArr = array();
    do 
    {
        $rowset = $stmt->fetchAll(PDO::FETCH_NUM);
        if ($rowset) 
          {
            $jsonArr[] = tojson($rowset, $i);
          }
    }while ($stmt->nextRowset()); 
?>

edited Feb 9, 2019 at 8:57

answered Feb 9, 2019 at 8:37

AswathyShaji

733 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

How to Select multiple tables for converting mysql to json?

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