want to learn interfacing Arduino ethernet with Mysql

hye,

im getting frustrated here. i have installed MYSQL packages and Wamp Server. I'm using arduino ethernet with ultrasonic sensor. i want to interface the arduino with MYSQL. but i don't know how because i don't have basic knowledge on MYSQL. but i need to run for this project. i have google all the things but, its just show me the php scripts. i don't know where and how to put/insert/create the php scripts. really down here. please help me. if you want to teach me by email, i can give to u. :cry:

The best thing you can do is make a php script that saves the data from the arduino in the mysql database.

Php file is added on the webserver side and called from the arduino; in fact the arduino surf to a specific page and then the php code of that page is executed.

Example:

Just take a look at the arduino code and the php code :smiley:

Good luck :slight_smile:

Tiggy:
The best thing you can do is make a php script that saves the data from the arduino in the mysql database.

Php file is added on the webserver side and called from the arduino; in fact the arduino surf to a specific page and then the php code of that page is executed.

Example:

http://www.instructables.com/id/Save-data-of-temperature-and-humidity-on-MySQL-wit/

Just take a look at the arduino code and the php code :smiley:

Good luck :slight_smile:

hye,thanks for replying me..i see there is php code they put together..which is

CREATE TABLE `your_database`.`tempmoi` (
`id` INT( 255 ) NOT NULL AUTO_INCREMENT ,
`temp1` VARCHAR( 255 ) NOT NULL ,
`moi1` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;

where i have to put this code?

That's mysql code to create the database where you will put your data; not php