PHP / Arduino

Using Arduino Interfacing w/ Software on the Computer
1

Hello everyone,

I am actually working into a seat booking project using PHP/MySQL for the staff side interface and databse, Arduino Mega for the public display.

I want to display with the LCD (Using LiquidCrystal library) the amount of the seat available and the name of the movie.

The problem is I don't know how can I send data from php request to Arduino, moreover both of the number of the seat avaible and the name of the movie is a variable taken from MySQL

I was thinking to do something like

Fetching data from MySQL (php)
Then do a push data to Arduino (nbseat = $nbseat; name = $nameofmovie;)
Display 'nbseat' and 'name' with lcd.write() function

Can you help me to do this program? thanks in advance

2

Can you help me to do this program?

What do you need help with? PHP can open a serial port. If it opens the one that the Arduino is connected to, it can send data to the Arduino.

The Arduino doesn't really need to do more than read serial data and write it to the LCD. Maybe a dozen lines of code, altogether.

3

Hello,

Well, I was planing to do it through a Wireless technologie (Xbee), so I don't know if the serial communication would work...

What I actually want is to make a php file that it fetch the SQL data in order to push it to Arduino as a variable value.

All the SQL fetching data is not a problem for me but I have no idea how to do it when it comes to push the data.

Good day.

4

Well, I was planing to do it through a Wireless technologie (Xbee), so I don't know if the serial communication would work...

What do you think the wireless device replaces? Wires, wouldn't you guess? What wires? Well, that would be the serial port wires don't you think?

What I actually want is to make a php file that it fetch the SQL data in order to push it to Arduino as a variable value.

Go for it.

All the SQL fetching data is not a problem for me but I have no idea how to do it when it comes to push the data.

Open a serial port and start writing. The alternative is to make the PC flash some LEDs and have the Arduino detect the pattern, and try to make some sense of it. Trust me, that's far more complicated.

5