How to fetch all php variables in .ts file in IONIC 4 and what is the way to get this.httpClient.get. thanks

Ionic Framework Ionic Angular
1

This is my .php file code ----------------------------------------------------------------------------------->
header(‘Access-Control-Allow-Origin: *’);
$conn = mysql_connect(‘127.0.0.1:3306’,‘ramin’,‘VOICETECH008’) or die(mysql_error());
Database = _GET[‘Database’];
$mysql_select_db($Database, $conn);
SelectDate = _GET[‘getDate’];
DayFeeType=_GET[‘DayFeeType’];
Reserved = _GET[‘Reserved’];

if($DayFeeType == 'Academic')
{
	$FeedaycollectQuery=mysql_query("select * from fee_total_collection_details where ReceiptDate = '2019-09-19' and CreatedBy = 'N2' and AmountPaid != '0'");
	while($FeedaycollectQueryrows = mysql_fetch_array($FeedaycollectQuery))
	{
		$ApplicationNo = $FeedaycollectQueryrows['ApplicationNo'];
		$ReceiptNo = $FeedaycollectQueryrows['ReceiptNo'];
		$AmountPaid = $FeedaycollectQueryrows['AmountPaid'];
		$ApplicationNo = $FeedaycollectQueryrows['PaymentMode'];
		$LastModified = $FeedaycollectQueryrows['LastModified'];
		$ConcessionAmount = $FeedaycollectQueryrows['ConcessionAmount'];
		$ApplicationNo = $FeedaycollectQueryrows['ApplicationNo'];
		
		$FEEconce=mysql_query("select * from fee_concession_details where ApplicationNo = '$ApplicationNo'");
		while($FEEconcerows = mysql_fetch_array($FEEconce))
		{
			$ConcessionReason = $FEEconcerows['ConcessionReason'];
		}
		
		$studenydetailsQuery=mysql_query("select * from student_master where ApplicationNo = '$ApplicationNo'");
		while($studenydetailsQueryrows = mysql_fetch_array($studenydetailsQuery))
		{
			$StudentFirstName = $studenydetailsQueryrows['StudentFirstName'];
			$CurrentSemester = $studenydetailsQueryrows['CurrentSemester'];
			$SectionId = $studenydetailsQueryrows['SectionId'];	
		}
		
		$studensectionQuery=mysql_query("select * from section where SectionId = '$SectionId'");
		while($studensectionQueryrows = mysql_fetch_array($studensectionQuery))
		{
			$SectionName = $studensectionQueryrows['SectionName'];
		}
	}
	echo json_encode();
}

This my .ts file code ------------------------------------------------------------------------------------>

getAmountDetail(){

this.storage.get('UserDatabase').then((UserDatabase) => {

  let Db = UserDatabase;

  let AcademicFleet = "Academic";

  let Reserved = "N38";

  let DateSelected = this.SelectDate.split(['T'][0]);

  let Date = DateSelected[0]

  console.log(Date);

  console.log(Db);

  this.httpClient.get('http://www.ramanujan.in/RAMANUJAN_GURUCOOL/RAMANUJAN_APP/get_feefleet_daycollectiondetails_data.php?Database=' +Db + '&getDate=' +Date + '&DayFeeType=' + AcademicFleet + '&Reserved=' + Reserved)

  .subscribe

  ((data) =>{

    console.log(data[0]);

      this.PostData4 = data;

  });

});

}

2

Sorry, but I can’t make head or tail out of your topic title question. What I can say is that you’re exposing too much implementation detail in your REST API. Client apps should neither know, care, or be able to specify database names on servers. You also shouldn’t be building URL query strings by hand: use helper classes like HttpParams or FormData to do this.

Finally, I would suggest reading and emulating the general design of tour of heroes 6.