Ethernet Shield + PHP + MySql information

Hello everyone,
I want to clarify some ideas, I'll explain ..
For a school exam I would want to realize an automated home with Arduino..
Starting from the base, I wanted to experiment by lighting the LEDs through a PHP page and save the states of the various LED (on or off) into a a database..

The question is: I don't know where it needs to be hosted PHP page.. Into ethernet shield SD cart? Into an altervista web site? Into a local pc? Anyone can explain me that?

I have seen many examples online where the page was built directly into the Arduino sketch (rather, they were created in .htm, I would want .PHP file) but I would not really like this way..: smiley-confused:
I would like to have a page graphically well done, that allows me to control the components connected to my Arduino using the button on the page, which communicates with the ethernet shield, and then save the information into a database ..
I can not understand the role of the Web Server (to process PHP data) who is carried, and therefore where to load my page..
Assuming that I would connect to the ethernet shield from various devices such as smartphones or tablet or PC, via the address 192.168.x.x of the the shield, I hope someone clarify my ideas about that, thanks :slight_smile:

andrea_p:
Hello everyone,
I want to clarify some ideas, I'll explain ..
For a school exam I would want to realize an automated home with Arduino..
Starting from the base, I wanted to experiment by lighting the LEDs through a PHP page and save the states of the various LED (on or off) into a a database..

The question is: I don't know where it needs to be hosted PHP page.. Into ethernet shield SD cart? Into an altervista web site? Into a local pc? Anyone can explain me that?

I have seen many examples online where the page was built directly into the Arduino sketch (rather, they were created in .htm, I would want .PHP file) but I would not really like this way..: smiley-confused:
I would like to have a page graphically well done, that allows me to control the components connected to my Arduino using the button on the page, which communicates with the ethernet shield, and then save the information into a database ..
I can not understand the role of the Web Server (to process PHP data) who is carried, and therefore where to load my page..
Assuming that I would connect to the ethernet shield from various devices such as smartphones or tablet or PC, via the address 192.168.x.x of the the shield, I hope someone clarify my ideas about that, thanks :slight_smile:

Arduino cannot host php, it is not powerfull enough. It can host html, but this should be enough to control arduino over webpage.

Same with database, it has not enough power to run one.

I suggest running the server in a pc (php and database), and send rest calls to arduino through tcp ip and configure arduino with ethernet shield as rest-api.