使用JSON管理来自多个表的数据（PHP + MySQL）(Using JSON to manage data from multiple tables (PHP + MySQL))

 我目前正在开发一个涉及Android应用程序和MySQL的项目。 我需要从MySQL数据库（位于本地服务器上，我正在使用Apache）获取数据，事实是，我已经通过从SINGLE表获取数据然后使用实现的类来完成此操作“Serializable”我能够“使用”数据。 现在，这是我的.php工作 
 
<?PHP
include_once("connection.php");

$query = "SELECT E.Nombre, COUNT(C.Id_Estudiante_FK) AS Cuenta
FROM Estudiante E INNER JOIN Comentario C ON E.Id_Estudiante=C.Id_Estudiante_FK
GROUP BY E.Id_Estudiante
ORDER BY COUNT(C.Id_Estudiante_FK) DESC"; 

$result = mysqli_query($conn, $query);

while($row = mysqli_fetch_assoc($result)){
        $data[] = $row;
}
echo json_encode($data);
?>
 
 它返回我需要编码的数据，我的问题是我如何管理我得到的信息，是否可以创建另一个实现Serializable的类，其中包含我正在返回的行的属性（哪些是“Nombre”）和“Cuenta” ）？ 
 
 这是我用于查询的php，它只涉及一个表（已经工作，我可以“使用”数据）： 
 
<?PHP
include_once("connection.php");

if(isset($_POST['txttipooferta'])){
$idtipooferta=$_POST['txttipooferta'];

$query = "SELECT * FROM oferta WHERE Id_Tipo_Oferta_FK=$idtipooferta AND Cupos>0 ORDER BY Id_Oferta DESC"; 

$result = mysqli_query($conn, $query);

while($row = mysqli_fetch_assoc($result)){
        $data[] = $row;
}
echo json_encode($data);
}
?>
 
 这是我用来管理从.php获取的数据的类，注意类的属性与表“Oferta”具有的属性相匹配（因为.php的查询是“SELECT *”） 
 
 我的问题是通过创建另一个实现Serializable的类并具有属性“Nombre”和“Cuenta”来解决的吗？ 
 
 谢谢！ 

I'm currently working on a project that involves an Android app and MySQL. I need to get data from a MySQL database (Which is located on a local Server, I'm using Apache), the thing is, I've have already done this by getting data from a SINGLE table and then with a class that implements "Serializable" I'm able to "use" the data. Now, here is my .php working
 
<?PHP
include_once("connection.php");

$query = "SELECT E.Nombre, COUNT(C.Id_Estudiante_FK) AS Cuenta
FROM Estudiante E INNER JOIN Comentario C ON E.Id_Estudiante=C.Id_Estudiante_FK
GROUP BY E.Id_Estudiante
ORDER BY COUNT(C.Id_Estudiante_FK) DESC"; 

$result = mysqli_query($conn, $query);

while($row = mysqli_fetch_assoc($result)){
        $data[] = $row;
}
echo json_encode($data);
?>
 
It returns back the data I need already encoded, my question is how can I manage that information I'm getting, is it possible to just create another class that implements Serializable having as attributes the rows I'm returning (Which are "Nombre" and "Cuenta")?
 
Here is the php I use for the query that only involves one table (Already works, and I'm able to "use" the data):
 
<?PHP
include_once("connection.php");

if(isset($_POST['txttipooferta'])){
$idtipooferta=$_POST['txttipooferta'];

$query = "SELECT * FROM oferta WHERE Id_Tipo_Oferta_FK=$idtipooferta AND Cupos>0 ORDER BY Id_Oferta DESC"; 

$result = mysqli_query($conn, $query);

while($row = mysqli_fetch_assoc($result)){
        $data[] = $row;
}
echo json_encode($data);
}
?>
 
And here is the class that I use to manage the data that I get from the .php, note that the atributes of the class match the one the table "Oferta" has (as the .php's query is "SELECT *")
 
Would my problem be solved by just creating another class that implements Serializable and has as attributes "Nombre" and "Cuenta"?
 
Thank you!

原文：https://stackoverflow.com/questions/37093361