WIRELESS BIOMETRIC FINGERPRINT ATTENDANCE SYSTEM USING ARDUINO AND MYSQL DATABASE

WIRELESS BIOMETRIC FINGERPRINT ATTENDANCE SYSTEM USING ARDUINO AND MYSQL DATABASE

• 1.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 DOI: 10.5121/ijcsea.2019.9501 1 WIRELESS BIOMETRIC FINGERPRINT ATTENDANCE SYSTEM USING ARDUINO AND MYSQL DATABASE Prince Asabere1 , Francois Sekyere1 and Willie K. Ofosu2 1 Department of Electrical and Electronics Technology Education, University of Education, Winneba Ghana. 2 School of Engineering Design, Technology, and Professional Programs Penn State Wilkes-Barre Lehman, PA 18627 ABSTRACT Fingerprints are considered to be the best and fastest method for checking attendance. They are secured to use, unique to every person, and do not change in one’s lifetime barring accident. The objective of this paper was to improve on the fingerprint identification system for implementation on a large database. The main objective of this paper was to design and construct an attendance system using a fingerprint module. In this system, Arduino Wemos D1 R2 ESP8266 (microcontroller) and Adafruit fingerprint reader are the main components used to insert records into a database. KEYWORDS Arduino Wemos D1 R2, fingerprint reader, attendance system, MySQL database 1. INTRODUCTION Many organizations are adopting biometric and time to check attendance improve in employee productivity, efficiency, and labor management. Without biometric identification systems, companies continue to rely on manual methods for payroll calculation, which are not only extremely time consuming, but also have high error rates. Compared to these manual methods, biometric attendance systems are error free, easy to install, user friendly and highly accurate. In developing countries, many educational institutions and governmental organizations still use paper-based attendance methods to record and store attendance. It is expensive for most institutions in these countries to procure biometric attendance authentication systems. On the other hand, organizations that have been able to purchase biometric attendance authentication systems are not able to fully customize them to meet their needs because all the biometric systems available on the Ghanaian market are imported and are application specific; therefore, users are limited in their usage. This project seeks to design and develop a finger print-based biometric attendance system to address the limitation and challenges with paper based authentication systems, and as well, be easy to customize.
• 2.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 2 1.1. Fingerprint Recognition A biometric system is a computer system that implements biometric recognition algorithms. A typical biometric system consists of sensing, feature extraction, and matching modules. Depending on the application context, biometric systems may operate in two modes: verification mode and identification mode [1]. Through verification mode, the biometric sensors capture or scan the biometric trait of an individual to produce its digital representation. A quality check is generally performed to ensure that the acquired biometric sample can be reliably processed by the subsequent feature extraction and matching modules. The feature extraction module discards the unnecessary and extraneous information from the acquired samples, and extracts salient and discriminatory information called features that are generally used for matching. In identification mode, the query biometric sample is matched with the reference information stored in the databases to establish the identity associated with the query. [2] Fingerprint Recognition includes taking a fingerprint image of a person and recording its features like arches, whorls, and loops along with the outlines of edges, minutiae and furrows. Matching of the fingerprint can be attained in three ways, such as minutiae, correlation and ridge [3]. Fingerprint Readers are manufactured with pre-programmed sets of information embedded in them. The reader identifies the individual fingerprint by their templates stored in the reader’s memory [4]. To read the data on the fingertip, the reader reflects infrared light to the fingertip to capture the ridge and minutiae of the fingerprint and store it as a template into the reader’s memory. Figure 1 shows the operation of a fingerprint reader Figure 1: Generic block diagram for enrollment and identification of biometric authentication system [4] 2. PROJECT DESCRIPTION In this paper an Arduino based fingerprint attendance authentication system is designed. Fingerprint readers and Arduino Wemos D1 R2 are used to enroll, verify and check attendance. The construction of the device begins with the connection of Arduino Wemos and a fingerprint sensor to the MySQL database via a wireless connection. MySQL is an Open Source Relational SQL Database Management System. In the identification phase, as soon as a user’s fingerprint is scanned on the fingerprint
• 3.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 3 sensor, it reads the fingerprint and then the associated user’s information is displayed on an LCD screen. For this system, user name, fingerprint ID and other information are stored in an attendance table in the MySQL database on the server. The PHP script is a useful tool to connect the Arduino Wemos with a database. The overall block diagram is shown in Figure 2. 2.1. Arduino Wemos D1 R2 Microcontroller The Arduino WeMos D1 R2 is an ESP8266 Wi-Fi based board that uses the Arduino layout with an operating voltage of 3.3V- 5V. The board, as shown in Figure 3, is controlled by the ESP8266 chip (a 32-Bit processor) and has a larger flash memory compared to an Arduino Uno. It consists of 11 digital I/O pins and 1 analogue (input) pin. The board can be connected using a Micro-B type USB cable. The board’s specifications are shown in Table 1. Figure 2: Overall Block Diagram of System. Figure 3: Arduino Wemos D1 R2 Microcontroller Table 1: Specification of Arduino Wemos D1 DESCRIPTION SPECIFICATION Microcontroller ESP-8266MOD Operating Voltage 3.3V – 5V Digital I/O Pins 11 Analog Input Pins 1 Clock Speed 160MHz Flash 4M bytes Length 68.6mm Width 53.4mm Weight 25g
• 4.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 4 2.2. Adafruit Fingerprint Reader DY50 The Adafruit Fingerprint Reader DY50, as shown in Figure 4,was selected because it has a Serial Peripheral Interface (SPI) communication with other hardware [6]. It also supports encryption in Read/Write mode and has a short fingerprint imaging time of 1.0 second. Figure 4: Front and Back image of Adafruit Fingerprint Reader DY50 2.3. Connectivity The Wi-Fi connectivity device is embedded in Arduino Wemos D1 R2. The Wi-Fi is powered by ESP8266MOD. This supports the standard Wi-Fi (802.11 b/g/n) frequency of 2.4GHz and 5GHz. The connectivity is used as the medium to send and receive information from the database wirelessly. 2.4. Database A database management system is a software package for creating and managing databases. Many different types of database systems exist based on how they manage the database structure. In this project, MySQL was used. MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, Mac OS and Windows[7]. Although it can be used in a wide range of applications, MySQL is often associated with web applications and online publishing. It is a component of XAMPP, an open source enterprise stack for web development that uses Linux as the operation system and Apache as the webserver. 3. PRINCIPLE OF OPERATION OF THE FINGERPRINT SYSTEM During enrollment, the fingerprint of a user is captured and the minutiae data are extracted and stored in a reader memory as a template (user’s fingerprint ID). This displays the fingerprint ID on a serial monitor (Figure 5). Figure 6 shows the block diagram of the operation. During authentication, the fingerprint of the user is recaptured by a microcontroller and then the extracted features are compared with the ones already existing in the reader memory to determine the
• 5.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 5 identity of the user in the database. When it successfully matches the fingerprint, the user’s name and telephone number linked to the fingerprint ID in the database are retrieved after which a welcome note is displayed on the LCD display as shown in figure 7. Figure 5: Arduino Wemos Serial Monitor for identification Figure 6: Block diagram showing the operation of the Fingerprint system
• 6.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 6 Figure 7: Fingerprint based system welcoming user after successful identification Arduino WeMos D1 R2 is the controller behind the whole system. When initially powered, it loads the declaration variables and the basic input/output instructions, which initialize the connected devices. It accepts the data received from the fingerprint reader and processes it according to the sketches (code) uploaded on it. When the controller has successfully connected to a Wi-Fi network, it calls for the PHP script responsible for connecting the database and activates it. The code responsible is given below. void httpRequest(int printID) { if (client.connect(host, httpPort)) { Serial.println("connect to database server"); // send the HTTP PUT request: client.print("GET verify_finger.php?id="); client.print(printID); client.println(" HTTP/1.1"); client.println("Host:192.168.1.108"); client.println("User-Agent: arduino-ethernet"); client.println("Connection: close"); client.println(); } else { // if you couldn't make a connection: Serial.println("Sorry, no connection ..."); client.stop(); } The data extracted from the fingerprint reader is then sent to another PHP script. The PHP script compares the extracted data with information stored in the database. If the data matches with information on the database, it will input the correspondent data into the ‘Attendance’ table and trigger the buzzer for one second to indicate that a member
• 7.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 7 is present. But when it finds no match, it triggers the buzzer for two seconds. The PHP codes are given below. <?php /* This PHP code takes finger_ID from Arduino wemos and insert into temporary table and attendance table for verification. */ $conn = new mysqli($servername, $username, $password, $dbname) or die('not connected'); $temporary_name="temporary_name"; $id=$_GET['id']; mysqli_query($conn,'TRUNCATE TABLE temporary;'); $sql1="insert into temporary values('"$temporary_name."','".$id."','')"; ->query($sql1) === TRUE) { echo "ID $id is added"; } else { echo "Error: " . $sql1 . "<br>" . $conn->error; } $sql2="insert into attendance (Finger_ID) values($id)"; if ($conn->query($sql2) === TRUE) { //echo "ID $id is added"; } else { echo "Error: " . $sql2 . "<br>" . $conn->error; } $conn->close(); ?> When the system is running, the LCD monitors the communication between the database and the Arduino WeMos, and displays the correspondent information on the screen as shown in Figure 8 Figure 8: LCD displaying connection status between the Arduino and the database 4. CONSTRUCTION OF THE FINGERPRINT SYSTEM The fingerprint reader communicates with other hardware through the software serial. The connections are done using the WeMos D1 R2 standard communication protocol GPIO 13 and GPIO 15, using the code below;
• 8.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 8 SoftwareSerial mySerial(13, 15); Adafruit_Fingerprint finger = Adafruit_Fingerprint(&mySerial); Serial.begin(115200); finger.begin(57600); int printID; printID=getFingerprintIDez(); if (printID != -1) { Serial.println("Waiting for a good fingerprint ..."); } The fingerprint reader VCC, RX, TX and GND terminals were connected to the 3.3V, GPIO 15, GPIO13 and GND pins of the Arduino WeMos respectively. An LCD display was attached to the Arduino WeMos. The LCD display uses an I2C backpack that was connected to the analog pins SCL and SDA. Figure 9 shows the physical connection of the fingerprint reader, Arduino WeMos and the LCD display. Figure 9: Arduino Wemos, Fingerprint sensor, LCD display connections 5. TESTING OF THE FINGERPRINT SYSTEM The Arduino WeMos was tested with a simple code to blink the internal LED on pin 13. The fingerprint reader was also tested by uploading a sample code (enroll) from the fingerprint library. After uploading the sample code, the serial monitor was opened and a fingertip was scanned on the reader to register the fingerprint template. The database, PHP and HTML forms were created after the installation of the XAMPP bundle. The database was tested by running the PHP connect script. When the script was able to access the database, sample data were keyed into the HTML form and submitted to the database by running the embedded PHP script. 6. COMPLETE SYSTEM TEST All components were tested to verify that they were working effectively. After the individual components were tested, the system was completely assembled. All the components were connected to access the database through Wi-Fi.
• 9.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 9 Figure 9: Final circuit of the fingerprint base system The HTML index file was opened and home page loaded. The fingertips were scanned and the device was able to identify the individual fingerprint IDs and displayed the corresponding data in the database. Figure 10: HTML frontend attendance screen 7. CONCLUSION A wireless biometric fingerprint attendance system is discussed in this paper. In the project,a fingerprint reader and Arduino Wemos D1 R2 were used to enroll, verify and check attendance. The construction of the device began with the connection of the Arduino Wemos and the fingerprint reader to MySQL database via a wireless connection. After the individual components were tested, the system was completely assembled. All the components were connected to access the database through Wi-Fi. To test the complete system, fingertips were scanned and the system was able to identify the individual fingerprint IDs and displayed the corresponding data in the
• 10.
  International Journal ofComputer Science, Engineering and Applications (IJCSEA) Vol. 9, No.4/5, October 2019 10 database. This system will improve the ability of organizations to identify their members and keep track of their working hours or attendance at work. Additionally, the proposed system can be easily customized for different organizational needs. REFERENCES [1] G. Amirthalingam, “A Multimodal Approach for Face and Ear Biometric System,” International Journal of Computer Science Issues(IJCSI), vol. 10, no. 5, pp. 234-241, 2013. [2] Biometric authentication http://www.scholarpedia.org/article/Biometric_authentication [3] Biometric Systems and Security Design Principles. Retrieved from http://wiki.cas.mcmaster.ca/index.php/Biometric_Systems_and_Security_Design_Principles [4] Fingerprint identification. https://www.elprocus.com/fingerprint-identification [5] D. K Yahav, S.E. Oltean, et al, Fingerprint Based Attendance System Using Microcontroller and LabView, International Journal of Advanced Research in Electrical/Electronics and Instrumentation Engineering Vol. 4, Issue 6, June 2015. [6] Lady Ada, (2018-11-14), Adafruit Optical Fingerprint Sensor. Retrieved from: https://cdn- learn.adafruit.com/downloads/pdf/adafruit-optical-fingerprint-sensor.pdf [7] Margaret Rouse, An admin's guide to AWS data management. Retrieved from https://searchoracle.techtarget.com/definition/MySQL AUTHORS Prince Asabere just completed his BSc in Electrical and Electronics Technology Education. His research interest includes embedded system, microcontroller programming. princeasabere@yahoo.com Francois Sekyere is currently a faculty member in the electrical department at the University of Education, Winneba. His research interest includes FPGA, cloud computing, IoT. fsekyere@gmail.com Willie K. Ofosu is a Professor of Electrical Engineering Technology at Penn State Wilkes-Barre. Dr. Ofosu has more than 30 years of experience as an engineer and educator. He is a member of ASEE, IEEE, IET (England), and a Chartered Engineer (CEng) of England. Wk01@psu.edu