Convert Data from Mysql to JSON Formate using PHP

Подписаться 96 тыс.

Просмотров 96 тыс.

50% 1

This video tutorial show you how to convert mysql data formate to JSON data formate using PHP. It simply fetch data from mysql database table and convert into JSON string format by using json_encode() function. Source Code - www.webslesson.info/2016/05/co...

Опубликовано:

1 май 2016

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 119

@AbhishekPandeyPoetry 4 года назад

I was restless for the day. And then I found your video. Thank you so much.

@EdLaraweb 5 лет назад

Thanks FRIEND!

@beosoftlabs 8 лет назад

Brilliant, this is what i was looking for. Except, do we need to be repeatedly reminded about being friends? Loved the simplicity.

@mdmasud5888 6 лет назад

This is why i follow your channel. Amazing tutorial.

@czsrac 6 лет назад

Your channel helped me so much with my semestral work. thanks!

@argenisjimenez8118 3 года назад

I didint expect it to be so simple. thanks mate!.

@anupampareek 8 лет назад

You have solved my problem with such ease, thank you very much!

@markm8090 5 лет назад

You've Got a Friend in Me

@patrascuflorin200 6 лет назад

Great! Thank you so much!

@muralidhar40 4 года назад

The robots have taken over our education, but they seem Friendly! Great tutorial.

@safanamunir1232 6 лет назад

it was very helpful...thanku so much! :)

@Devil5Dandruff 5 лет назад

Actuually it works thanks!

@albertsimtengu1019 4 года назад

And i say thank u friend for this content... its exactly what i was looking for

@EduardoHernandez-cr6yf 5 лет назад

thank you very much, you saved my project

@youneskasdi 5 лет назад

You're not fooling anyone skynet, but thanks for the tutorial

@rohitpatil8452 5 лет назад

Thanks for the tut, need help. How to get the blob in an array along with text fields to return so that all can send or transfer as json response?

@bricegnanago409 5 лет назад

So good ! Thank you

@wismannurabdulkholik7427 5 лет назад

Thank you, it work for me.

@DAMIANANDKAROL 4 года назад

THANKS SO MUCH!!!!

@jengalabsafrica 7 лет назад

thanks big time..This was so helpful and easy to understand

@webslesson 7 лет назад

Hi Brenda, if you want any other help, please tell us...

@mahmoudchahine4457 5 лет назад

Thanks man your awsome

@vigneshviswanathan3483 4 года назад

Thank You for this simple explanation

@luisjesussiancasflores7009 3 года назад

wow! it helps me a lot! Thank u

@octaalief1937 3 года назад

Thanks, friend. Really helpful

@howto5891 5 лет назад

you are great!

@zaibali8109 5 лет назад

Thank You for helping me

@AsimYilan 2 года назад

thank u 4 this video dude

@user-nj3lg7wi5r 2 года назад

Thank you very much.

@vijaykanthv5666 6 лет назад

really very nice tutorial....

@soulsoup5283 6 лет назад

thank you Mr.Robot Voice

@rkdasaris6247 7 лет назад

i need to know from here where ur coding ends by displaying the json data how to display the data in html table

@kadeon4380 4 года назад

YOU'RE THE BEST

@youcefdjediai6934 4 года назад

many thanks bro

@arvi3 5 лет назад

What about your enemies? I'm sure they'd want to learn this too. Thanks Frenz 😑

@minaamir2648 5 лет назад

thanx perfect ..

@DhruvinS720 Год назад

thanks for easy explanation 😍😃👌👏

@KiemPlant 4 года назад

Epic!

@MinhLe-xk5rm 7 лет назад

Yes man you are da best!!!!!!

@webslesson 7 лет назад

Hi Cassandra thanks for appreciation.

@akhil3628 7 лет назад

Webslesson so,how to send this json file to front-end (client side ) as output

@MinhLe-xk5rm 7 лет назад

You should use JavaScript to output the data of the JSON file to an HTML file. Linked that HTML file to JS. Search up some tutorial on JSON and AJAX.

@syedaraimafatima5201 5 лет назад

Thanxxxxxxxxxxxxxxxx aloteeeeeeeeeeeee Sir your tutorial solve my problem which will be occur in my code

@marcosmathiasjunior2011 5 лет назад

thank you ! thank you !! I love you, I'm Brazilian, and I did not find the answer on Brazilian sites .. but there's my salvation !!

@lelis.designer 4 года назад

Amigo, eu fiz e deu certinho também, porém não pegou a acentuação, ficou tudo bagunçado, o seu tinha acentuação???

@caio4231 3 года назад

VEEEEERYYYY GOOOOOOD

@Leonism 2 года назад

thank you friend

@ajitpathak6437 7 лет назад

how to make complex json format from database content like your example....i mean nested json...object into another object..your this video so simple to understand by anyone..thanks

@OSPPRO 4 года назад

thank you sir.

@franciscodeassissoaressilv3905 4 года назад

2020 - Muito obrigado, funcionou direitinho pra mim

@lelis.designer 4 года назад

Amigo, eu fiz e deu certinho também, porém não pegou a acentuação, ficou tudo bagunçado, o seu tinha acentuação???

@franciscodeassissoaressilv3905 4 года назад

Tem sim, pega acentuação gráfica e tudo mais...

@zainurrahmansehan5531 2 года назад

Thanks for the tutorial. Is there any way to convert the geolocation data from mysql table to topojson?

@tharindukumara8955 6 лет назад

Thanks sir

@durgeshsingh6380 3 года назад

Thanks bro

@imransk6469 6 лет назад

Thank you sir nice tutorial

@webslesson 6 лет назад

Oh, thanks! Always at your service.

@mohammadashjari18 3 года назад

Thanks you

@tarunjoseph3126 5 месяцев назад

thanks bro

@majormfr8646 4 года назад

awesome work how will we do it for multiple tables at once

@ervinehinay1682 3 года назад

Thanks

@jhomara0904 7 лет назад

Thanks for the video, I have a question. How can I use this array as a variable in a javascript file?

@csandreas1 5 лет назад

use .each(data) to loop through the array, then access json values by something like data.name, data.id, etc

@Meinungsmacher 7 лет назад

i am a robot

@NihalSaxena95 8 лет назад

i have a database which contain image also so how to convert that into json

@oussamacheta7106 5 лет назад

THANK YOU MY ROBOT FRIEND !!

@JitendraKumar-qh1bd 6 лет назад

sir image save in database in json format plz tell me

@TheCaiphus Год назад

thanx

@ashokchandra4911 3 года назад

Usefull my problem is solved 👍

@webslesson 3 года назад

Glad to hear that!

@astigmatik 3 года назад

@@webslesson pls answer my question 😊

@abdulfattah6978 6 лет назад

superb

@webslesson 6 лет назад

Thanks Abdul Fattah for your thoughtful words.

@_rahiali 4 года назад

Friend thank you so much for useful video. Friend can you make some video on how to filter and search through json data. Friend I want to have multiple range slider and be able to run multiple search queries on my jason_array. Thank you.

@bigzy7 6 лет назад

why encode in json when we can print out directly in page?

@davy5537 4 года назад

Beer for you my friend

@astigmatik 3 года назад

May I know how to do error checking after mysqli_connect, and query?

@priteshsingh5976 6 лет назад

what about when data is more the 20K in one table

@brilliantcity 4 года назад

You also thank you

@Nerdhaunt 7 лет назад

You are using local host, What if I want to use the cloud server?

@webslesson 7 лет назад

thanks. I have use local host while making video.

@Nerdhaunt 7 лет назад

If I want to use cloud hosting then I have to put the php file in the Cpanel right?

@ObeyBlake 7 лет назад

That's correct.

@veeragandrati5954 6 лет назад

I tried the same procedure but i am not able to see the data. i have not missed any step, could you please help me?

@ak4shbha6wat58 3 года назад

Sir if we dont need array we need only one value then?

@pavankalyan5534 4 года назад

Hai but i am fetching multiple row from DB and how to receive the data in AJAX ...?

@dheeraj5023 4 года назад

👍👍👍👍

@BADGRAPHIX 8 лет назад

My code's the same as yours but I get the error "mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home1/badgraphix/public_html/readData.php on line 21"

@BADGRAPHIX 8 лет назад

Never mind, it was caused by an error in my MySQL syntax.

@TheTopTenTrends 6 лет назад

Use Single Quote $sql = 'SELECT * FROM tbl_employee'; instead of double quote $sql = "SELECT * FROM tbl_employee";

@pathakvivek7865 6 лет назад

how to give the whole json object name...??

@Holycrabbe 6 лет назад

I had problems with this code : but found the solution to be the following while ( $row = $result->fetch_assoc() ){ $json_array[] = json_encode($row); } I hope this can help somebody out