Raspberry Pi Project: Online Weather Data Log with MySQL and PHP with Sense Hat.

In this tutorial we are going to learn how to send data to remote webserver and store them into a MySQL database. Then we are going to display all the data using a simple PHP script! Amazing stuff!

Want to learn to code?

[trigoisabel]

I love your tutorials, i'm doing a weather station myself, and your videos with the e-paper were inspiring. The quality of your tutorials and the fact that you use simpler language push me to keep doing more stuffs and wanted to learn more about electronics. Thank you!!!

[juancarlossalazarvaca]

great video, i have a question, you install for this proyect lamp server?

[RonenLin]

Is there a way to get/post data from raspberry to/from a MySQL db hosted on a server? I want to create an app that will be on my pi and allowing the user to get/post data from a hosted MySQL db but unsure what language I should code it in...

[seddikreghis]

giving all the info and do the best as he can, I hope the best for you, very nice channel :)

[radrad]

Hi after some attempts it works. All Fields in the Database are of typ "int(11)" exclusively "date" The Field is a "utf8_bin"
The Field "Id" has the function "AUTO_INCREMENT" an is the prim.key. The User and his Rights still create and that's it.I still enter the data without Pythonscript. This is the next Step.
I am a Beginner so it was a real Challenge for me.

[peter_vandermeulen]

It looks like you are storing the database username and passport in the php file on the publicly hosted site. Is this secure? Is there a better way to restrict which users can access the database?

[nurulnadiaabdullah]

may i know when will the database video come out?

[alessiom]

Hi, nice video. Do you know if the project run in raspberry pi zero w? Thank in advance.

[valentealejandroguardiolab]

Hey quick question can I do all of the things in this video but with an Arduino cause the I couldnt get a raspberry Pi 3 for the project that I'm going to do for my schook

[eduardoaguilar]

I have a question I need to put all the sensors in an interface so I can see them all working how can I do it

[sonbau]

Hi Sir,
At present, we would like to send data from sensor, plc via raspi to the server, after that we can build webserver for each application. My question is whether raspi can store data like dataloger before send data to the server and how to do that?

[arifindobson]

Amazing tutorial. Super useful. Thank god a person like you exist in this world. Keep on inspiring!

[Jgeorgegamer]

Can i do this with a DHT22 Sensor? or, can you make a tutorial using that sensor?

[MkmeOrg]

Get stuff Sir! Yes on the tutorial for me. I work with SQL every day but haven't sent up my own database yet. Cheers

[Elmware]

You were saying that you need a Web server to connect to the senseHAT. Why not install Apache, or HTTPD, with PHP modules and MySQL, and PHPMyAdmin, on your Raspberry Pi, and connect to localhost?

The Raspberry Pi Website has lots of info for setting these things up.

[GetRealwithMike]

Does the HAT sense relative humidity or just humidity itself. I'm studying ESD - electro-static discharge and need the sensor to capture RH - Relative Humidity. And can it be changed to Fahrenheit instead of Celsius?

[testchannel]

Hi can you do a new video for 2020 with a raspberry pi zero W and a bme280 sensor. Thanks you have great channel

[sonaiyahardik]

Can i send the other sensors data as like you explain in video, to web page???

[duARTstudioChannel]

How do you authorize the data post to website on your server?

[vishalprasad]

I want to call a web api and retrive the data from there using a raspberry pi and then i have to display the data present in the web api on a led matrix..can help me out with this how to design this project?