Need Help: Retrieve data from IR Sensor and Update MySQL Database (WAMP)

hello dear forummer,

nice meet all, i'm new arduino... i'm developing car park monitoring system. hava irsensor (like car park sensor) detect item within slot, if sensor detects toy car in slot, means slot occupied/taken. question is, if wanted connect database , updates database everytime sensor detects changes (like change slot status '1' if there toy car detected in slot, , change slot status '0' if empty in slot)

i'm using php, mysql (wamp server) currently.. need retrieve data arduino ir sensor , update mysql database (wamp). need code guidance on how arduino can update mysql database...can please provide me code sample if have done similar project?? please help..

thanks, sorry english.


this database. basic table consist slot number , slot status (1 or 0).


create table seats
(
   rowid varchar(1) not null,
   columnid int not null,
   status int,
   updatedby varchar(10),
   primary key (rowid,columnid)
);

a common approach let wamp server handle database , have arduino send relevant data it. can use ethernet library make arduino act client , either or post information web server. there, script in php, perl or language of choice parse out data , push database. presumably there page on server displays current state of parking garage.

Arduino Forum > Using Arduino > Project Guidance > Need Help: Retrieve data from IR Sensor and Update MySQL Database (WAMP)

arduino