PHP - Json Query To A Table?

Dear All,

I would like to create a json a below format

{
    "data": [
        {
            "datetime": "2021-05-12",
            "history": [
                {
				"name": "ABC",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				},
				{
				"name": "DEF",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				}
            ]
        },
		 {
            "datetime": "2021-05-13",
            "history": [
                {
				"name": "ABC",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				},
				{
				"name": "DEF",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				}
            ]
        },
		 {
            "datetime": "2021-05-14",
            "history": [
                {
				"name": "ABC",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				},
				{
				"name": "DEF",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				}
            ]
        }
		
    ]
}

But I need to select database 2 time because information need to group by date

so my PHP like below

 $myArray = array();
   
    $stmt = $conn->prepare("SELECT survay_date FROM tb_feedback WHERE app_ID = ? GROUP BY CAST(survay_date AS DATE) ORDER BY survay_date DESC");
    $stmt->bind_param("s", $data->{'app_id'});
   
    $stmt->execute();
    $res = $stmt->get_result(); 

    if($res->num_rows==0){
      
      header('Content-Type: application/json');
	  $json = array();
	  $myArray['data'] = $json;
       echo json_encode($myArray);die();
    }

    while($row = $res->fetch_array(MYSQLI_ASSOC)) {
        $myArray['data'][] = array_push($row,array("A","B"));
		
		$statement = $conn->prepare("SELECT tb_register.firstname,tb_feedback.feel,tb_feedback.cough,tb_feedback.fever,tb_feedback.headache,tb_feedback.tired,tb_feedback.appetite,tb_feedback.swelling FROM tb_feedback INNER JOIN tb_register ON tb_register.id = tb_feedback.user_id WHERE tb_feedback.app_ID = ? AND tb_feedback.survay_date = ?");
		$statement->bind_param("s", $data->{'app_id'});
		$statement->bind_param("s", $row['survay_date']);
	   
		$statement->execute();
		$result = $statement->get_result(); 
		
		while($infor = $result->fetch_array(MYSQLI_ASSOC)) {
			
			$myArray['data'][] = $infor;
			
		}
		
	}
	
    header('Content-Type: application/json');
    echo json_encode($myArray);

So, How can I create the json format like that?

Hello - I am connecting to MySql and running a query.  If I use a foreach loop, I can iterate over the results and have them print to screen.  However, when I try the below everything is null!

How can I add the results of my MySql query to a php array?

	<?php
$con=mysqli_connect("site", "user", "psasswr=ord", "db");
	if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
	$sql="SELECT * FROM test LIMIT 10";
$result = mysqli_query($con,$sql);
	echo json_encode($result);
	mysqli_free_result($result);
	mysqli_close($con);
?>
	

but what this prints is:

{"current_field":null,"field_count":null,"lengths":null,"num_rows":null,"type":null}

Dear All,

As I would like to create json as below format 

{
    "data": [
        {
            "title": "After getting a COVID-19 Vaccine",
            "content": [
                {
                    "list": "You may have some side effects, which are normal signs that your body is building protection."
                },
                {
                    "list": "Following symptoms can take place, and it usually resolves within 2 to 3 days."
                },
                {
                    "list": "Common Side Effects pain, redness, swelling, warmth, nausea, muscle pain, tiredness, headache"
                }
            ]
        },
        {
            "title": "After getting a COVID-19 Vaccine",
            "content": [
                {
                    "list": "You may have some side effects, which are normal signs that your body is building protection."
                },
                {
                    "list": "Following symptoms can take place, and it usually resolves within 2 to 3 days."
                },
                {
                    "list": "Common Side Effects pain, redness, swelling, warmth, nausea, muscle pain, tiredness, headache"
                }
            ]
        }
    ]
}

The information is from  mysql select command:

SELECT (tb_helpinfo.title_eng) as title,(tb_helpdetail.content_eng) as content FROM tb_helpinfo INNER JOIN tb_helpdetail ON tb_helpinfo.id = tb_helpdetail.helpinfo_id

How could I make json like that from mysql information?

Hello Everyone,

I have a PHP code that reads data from db table. Then it converts it into JSON and show it. However if data table field has - or so then it gives json error.

For e.g.

if($num > 0){
			while($res = mysqli_fetch_array($query)){
				
				$NDate = $res['NDate'];				
				$Summary = substr($res['Summary'],0,256);				
				
				/* CREATE ARRAY FOR SHORT TERM NEWSLETTER */
				$newsletters[]=array('newsletter'=>array("RecID"=>$SNo,"Summary"=>$Summary));
				
			}
			/* JSON OUTPUT*/
			$json = array("AuthOK" => 'True',"newsletters"=>$newsletters);
	
header('Content-type: application/json');
echo json_encode($json);

How to solve the issue ?

Regards,
GR

<?php
error_reporting(0);
require_once 'database_connection.php';
$page = $_GET['page']; // get the requested page
$limit = $_GET['rows']; // get how many rows we want to have into the grid
$sidx = $_GET['sidx']; // get index row - i.e. user click to sort
$sord = $_GET['sord']; // get the direction
if(!$sidx) $sidx =1;
// connect to the database
$result = mysql_query("SELECT COUNT(*) AS count FROM utilizador");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];

if( $count >0 ) {
	$total_pages = ceil($count/$limit);
} else {
	$total_pages = 0;
}
if ($page > $total_pages) $page=$total_pages;
$start = $limit*$page - $limit; // do not put $limit*($page - 1)
$SQL = "SELECT * FROM utilizador ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());

$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    $responce->rows[$i]['id']=$row[idutilizador];
    $responce->rows[$i]['cell']=array($row[idutilizador],$row[nome],$row[utilizador],$row[telefone],$row[email]);
    $i++;
}        
echo json_encode($responce);
?>

<html>
<head>
<title>jQGrid example</title>
<!-- Load CSS--><br />
<link rel="stylesheet" href="css/ui.jqgrid.css" type="text/css" media="all" />
<!-- For this theme, download your own from link above, and place it at css folder -->
<link rel="stylesheet" href="css/jquery-ui-1.9.2.custom.css" type="text/css" media="all" />
<!-- Load Javascript -->
<script src="js/jquery_1.5.2.js" type="text/javascript"></script>
<script src="js/jquery-ui-1.8.1.custom.min.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-pt.js" type="text/javascript"></script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
</head>
<body>
<table id="datagrid"></table>
<div id="navGrid"></div>
<p><script language="javascript">
jQuery("#datagrid").jqGrid({
   	url:'example.php',
    datatype: "json",
    colNames:['Idutilizador','Nome', 'Utilizador', 'Telefone','Email'],
    colModel:[
		{name:'idutilizador',index:'idutilizador', width:55,editable:false,editoptions:{readonly:true,size:10}},
		{name:'nome',index:'nome', width:80,editable:true,editoptions:{size:10}},
		{name:'idutilizador',index:'idutilizador', width:90,editable:true,editoptions:{size:25}},
		{name:'telefone',index:'telefone', width:60, align:"right",editable:true,editoptions:{size:10}},
		{name:'email',index:'email', width:60, align:"right",editable:true,editoptions:{size:10}}
	],
	rowNum:10,
	rowList:[10,15,20,25,30,35,40],
	pager: '#navGrid',
	sortname: 'idutilizador',
	sortorder: "asc",
	height: 500,
	width:900,
	viewrecords: true,
	caption:"Atividades Registadas"
});
jQuery("#datagrid").jqGrid('navGrid','#navGrid',{edit:true,add:true,del:true});
</script>
</body>
</html>