Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Script to send card reader data to a server without using the browser

Posted on 2013-01-23
6
Medium Priority
?
468 Views
Last Modified: 2013-02-12
Hi,

I am trying to send data from a card reader to a server (mySQL database) without going trough a web browser. When swiping the card it will return a digit (xxxxxxxxxxx) and this number will be sendt to a script on the server. This script will submit it into the database.

Do you know how to make a listerner script that will take the data and send it to a "logg.php" on the server? ... on Windows 7
0
Comment
Question by:Hans Inge Hagen
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:frankhelk
ID: 38808948
Would you please elaborate a bit more on that process ? I'm not sure how a web browser could be needed anyhow.

What does the barcode scanner device in detail (actice, passive, protocol, etc.) ?

If it contacts a server via HTTP, i.e. by accessing a URL like then there are several ways, i.e.

use some web server like apache, IIS, etc. and plug in some kind of script for this (CGI, PHP, ASP, whatever)
use Tomcat and implement a Java servelet for that
create an own application that listens on the HTTP port and implements just as much of HTTP as needed to communicate with the device

The script could do anything you desire with the code. Using some kind of web- or applet server would come with multithreading capabilities without the need of coding this, meaning i.e. intrinsic support of multiple barcode scanners without the hassle of collisions.

If the device acts different, I'll have to meditate again over this :-)

Possibly you can give the type of the barcode device and some link to a manual ?
0
 
LVL 84

Expert Comment

by:David Johnson, CD, MVP
ID: 38808994
why to a logg.php ?? which involves the web at all and a php routine running on the server?

instead take the output of the card reader and then send it directly to mysql in the format your database requires.. What does the card reader output right now? .. The above requested information would be nice as well. Where are we listening ? is there a specific port and what format are we waiting for?

Too many questions.. not enough answers to even start a reasonable answer
0
 

Author Comment

by:Hans Inge Hagen
ID: 38851903
My Card-reader (mifare) is on a USB (simulated com port 4) .. it will give me a number (1234567890). This number needs to be sent to a mysql server (not on the same machine) and added as a record together with a timestamp ... This is a members log system on a gym.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 14

Accepted Solution

by:
frankhelk earned 2000 total points
ID: 38879259
OK - so your reader sits on an emulated serial interface.

I would recommend to just use some high level programming language of your choice (VB, C++, etc.). Maybe you could use VB.NET express (free).

As example, you might use the SerialPort class available in VB.NET to communicate with your reader. After initializing the reader, I presume it sends the number followed by [CRLF] or embeds it in control character sequences like [STX]...[ETX]. You'll need to filter the number out of the data.

Then use the database access classes (contained in VB.NET, too) to stuff the data into the database, using any kind of additional data (i.e. a timestamp) and/or format.

The generated program then would sit on your database server PC, or (if that database is abroad) on some small interface PC connected to both reader and network. As long as it runs, it will serve as interface between reader and database.
0
 

Author Closing Comment

by:Hans Inge Hagen
ID: 38880329
I do not know VB .. but I will search for an solution somewhere. Thanks
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 38881912
Try to learn - with Visual Studio Express it's free, with some knowledge of programming it's easy to learn. It's worth the effort.

Try "Visual Studio 2012 Express für Windows Desktop" or "Visual Studio 2010 Express All-in-One ISO".
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to dynamically set the form action using jQuery.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month21 days, 3 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question