How to Get JSON Response from MySQL Database using PHP

In This video I have shown that How to get JSON Response from mysql database using PHP. In php a one function is there to convert data into JSON Format
json_encode()
using json_encode() method we can convert php array into json array
GitHut Link : github.com/hiiamrohit/Countri...
First of all you have to make a Database connnection using php then try to fetxh each row and then store into a array and then convert that array into json object and then using print or echo method give response message
~-~~-~~~-~~-~
Please watch: "MySQL Database connection in java 12 using eclipse 2019"
• MySQL Database connect...
~-~~-~~~-~~-~

[@CiroEndara]

thanks so much. you save me a lot of time

[@nikkidotacan5246]

I'm so new at this but you help me a thousand. Thanks man!

[@adamstutorial9114]

Wow! This video just saved me from a week long research, thanks so much I feel like crying

[@abdulshabaaz2304]

Nice information

[@rubenbarros4148]

It Helped me, Well done m8.

[@edmondgoddy]

Very helpful tutorial. Thanks

[@YenHoang-uk2zv]

thanks for your useful things!

[@Raza_9798]

Thank you mate

[@soufeeljazouli1807]

thank u man :D

[@WTamoe]

some wrong: i have "Szczepa\u00c5\u0084ska" but i need "Szczepańska" - my data base is utf-8 , php -> utf-8 - json wont't recognise Polish lang - can you help me?

[@jigsmistry2691]

thx

[@wahidstudios]

is this whats api mean? by providing JSON content to url? so that the frontend developer can work with?

[@emanuelevalente4955]

hi, why the code return me a white blank page? all data are correct

[@unknown92vjsv]

how did he stored the json in the database ???? can anyone help?

[@majormfr8646]

how can we convert mysql data from multiple tables at once into a json object

[@TechnicalBabaji1]

The first thing required is the knowledge to use join( inner join,left join ) and then proceed as shown in the video. The query has to be different and rest all same.

[@muhammadrizwan-tz9oz]

it shows the following error "Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool"

[@reeti5958]

You have made some error in query that's why it is giving false as an error response. Check your query by running them on cmd first

[@mr.RAND5584]

Why some php file does not have this symbol ?>

[@printonex]

Why "" on integer how to remove

[@sagarsharma6153]

Hello I need code of get_city page.?

[@tonybengue]

You don't get JSON Response as you write, you only output the array as JSON with Php, it's not the same thing

[@thanhangvan6278]

I don't connect. you can help me

[@TechnicalBabaji1]

Yes way not.. tell me your error what you are getting.. and also your code where you are getting error

[@thanhangvan6278]

@@TechnicalBabaji1 thank you. I am self-learning web api hoping to help you