Solved

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

Posted on 2013-01-23
6
435 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 80

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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 14

Accepted Solution

by:
frankhelk earned 500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…

685 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