Writing to mysql from a pic... possible?
Posted: Tue Mar 05, 2013 4:35 pm
Hi all,
I have several projects that require to add a record to a mysql server when an object is detected. All is working fine at the moment. I have the following setup.
Object sensor connected to pic (with flowcodeprogram). If object detected, serial data is sent to a computer. I have written a script on the pc, that detects incoming serial data. If data is detected, it adds a record to the database over the internet (mysql community server)... Client accesses a website to check data (php)
Q:
It would be VERY AWSOME to be able to skip the computer and let the pic write the data to the sql database. Even if its an simple insertrecord with only one letter or so.
Has anyone done this, or has a tip for me?
Thanks in advance... Davy
I have several projects that require to add a record to a mysql server when an object is detected. All is working fine at the moment. I have the following setup.
Object sensor connected to pic (with flowcodeprogram). If object detected, serial data is sent to a computer. I have written a script on the pc, that detects incoming serial data. If data is detected, it adds a record to the database over the internet (mysql community server)... Client accesses a website to check data (php)
Q:
It would be VERY AWSOME to be able to skip the computer and let the pic write the data to the sql database. Even if its an simple insertrecord with only one letter or so.
Has anyone done this, or has a tip for me?
Thanks in advance... Davy