Dear friends, I am a programmer (web based). I am a fan of this site. I got many help from you all through this site. Now i am in a new problem and need your help. Description: In my office there is a employee ID card punch/ scanner machine. It tracks employees enter and out time. When a employee come to office he just show the card in front of that machine and same thing do at the time of leaving. Requirements: I want to read data from punch/scanner machine (when it tracks a card) using PHP-MySQL-JavaScript-jQuery-Ajax etc. So that I can manipulate data using PHP-Javascript etc. and store them in MySQL database and finally make a local website from this data using PHP. The main requirement is capturing tracking data from machine and store them in MySQL database. If I can store data to MySQL then I can do rest of things. Can you help me for this anyway? Do you have any reference site or scripts? PLEASE HELP ME Thanks.
This is too specialist to request help without any knowledge of how your current checkin software works.. I would imagine that if you have that machine, that it came with some sort of software. Now, assuming you can call custom commands/options upon sign-in/sign-out with the software provided by the system manufacturer, I would suggest calling a PHP script from a local machine (intranet) to enter the details into the MySQL database.. Example; if your software provided by the manufacturer provides the option of executing a script or something, maybe have it call http://localhost/path/to/checkin/script/checkin.php?employee=1234567890&sign=in&time=*timestamp* then have that PHP script insert the GET data into the database you set up to contain the data.. The issue is, unless you can explain how the machine itsself handles data, there's no way of us knowing what kind of bridge is available..
i fall this type problem in my office. solve is that your id card punch machine generate a .txt file which is may be 16 letters . then u see your machine manual and find 16 digit means. then u can chose your value and read data from .txt file & insert in to your My-Sql database.
There can't be a reference site or script. As Chuckun said, we need some basic information first. If you don't know how the software works for the ID scanner, provide us with the make and model of the scanner. There are two ways that a scanner can function. 1) The scanner could be connected to a computer where it stores the data and log - If it is, then most likely The scanner stores the card data already in a database (Probably in encrypted form). It should also log the scan data and time in database or log file. You can write a code to read from that database and/or log file (assuming that DB is a standard software like Mysql, SQLite etc, and not a proprietary one). 2) Or it could have local memory to store them locally. If it stores them locally then your task is a tough one. It may or may not have an interface to connect to a standard PC. If it does have an interface that provides connectivity between scanner and a computer, then you can either write a software to read data from it or use a standard software (provided there is any). Then save the data in a database. To do it purely in PHP would be a very very difficult task (Read: Impossible).