data via serial port into Mysql

[miked260772]

I am currently seeking help on how to get a 10 character data string sent in plain text (thru a serial port link) into a Mysql database. The text consists of the first two characters being an adresss of where the data came from and the last eight characters are the actual data,followed by a char return. I would like to split the string into its two component forms and add them to a seperate column and also add a time stamp and ID_ value

see example below. I have read a few things on boards about fopen: is this the way to go? Any advice will be greatly welcome.

regards mike

[e-mail]

example of how the data is formatted and would look like in Mysql:
0312345678[CR]
1523456789[CR]
0312345678[CR]
0312345678[CR]
0972727272[CR]

|ID | address | data | timestamp |

|1 | 03 | 12345678 |time_format|
|2 | 15 | 23456789 |time_format|
|3 | 03 | 12345678 |time_format|
|4 | 03 | 12345678 |time_format|
|5 | 09 | 72727272 |time_format|

[jweissig]

hi,

what application are you using to read the data from the serial decive now? Becuase it might be possible to make a wrapper in perl/php that will insert the data into mysql.

for example you might have a c++ app you are using now that receive's the data and print's it to console?

• Justin

[miked260772]

Justin, here is some extra info regarding the problem

The serial devices are barcode readers that output a string of data whenever they read a barcode. I am currently only able to see the data in a terminal device(hyper terminal), I am using this to faultfind the devices. A future application will require a list of barcodes that have been read, and also a cross refernce to the amount of each... Once I get the data into the database the rest is easy,its just getting it there, that I have the problem with. any suggestions?