Connecting Ultrasonic Sensors to MySQL

Hello Everyone,

I am doing a project on a Parking System. I have four ultrasonic sensors, which will display availability of slots. I have already written the code for the sensors to connect to arduino (Uno) and it works perfectly, getting results on serial monitor.

My problem is now, I have to connect these to a web server, I am using MySQL. I need to show the status of each parking slot (i.e empty or car parked), also create a reservation and parking meter. I am a complete novice in this, can anybody please help me with:

what database to create, tables and columns to create?

How to connect sensor to mysql? How to store the data?

The codes and programming to write?

and maybe the whole procedure?

Thank you very much! Regards

duplicate post at

One post on the same topic is more than enough.

None of this has to do with Arduino. I suggest you get the book MySQL for Dummies.

Or “Database design for Mere Mortals” is pretty good too.