switch ($getType) {
case "1":
$data = array();
$sql = "SELECT songId, songName, singerName, songAlbum, albumName FROM web_songsinfo, web_singersinfo, web_albumsinfo WHERE songName LIKE '%" . $getKeywords . "%'";
$result = $conn->query($sql);
if ($result) {
$code = 1;
$message = "success";
$songInfo = new SongInfo();
while ($resultRow = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$songInfo->songId = $resultRow["songId"];
$songInfo->songName = $resultRow["songName"];
$songInfo->songSinger = $resultRow["singerName"];
$songInfo->albumId = $resultRow["songAlbum"];
$songInfo->albumName = $resultRow["albumName"];
}
$data[] = $songInfo;
mysqli_free_result($result);
} else {
$code = 2;
$message = "failed";
$data = '';
}
break;
case "10":
break;
case "100":
break;
}
mysqli_close($conn);
$response = new searchResponse;
$response->search($code, $message, $data);
response.php:
class searchResponse
{
public function search($code, $message, $data)
{
$result = array(
"code" => $code,
"message" => $message,
"data" => $data
);
echo json_encode($result, JSON_UNESCAPED_UNICODE);
}
}