Go Down

Topic: Connecting Ultrasonic Sensors to MySQL (Read 222 times) previous topic - next topic

Hus_Spidey

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

ieee488

duplicate post at http://forum.arduino.cc/index.php?topic=391099.msg2693702#msg2693702

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.


gpsmikey

Or "Database design for Mere Mortals" is pretty good too.
mikey
-- you can't have too many gadgets or too much disk space !
old engineering saying: 1+1 = 3 for sufficiently large values of 1 or small values of 3

Go Up