· 10 years ago · Sep 13, 2016, 09:32 AM
1<?php
2
3/*
4kode utk memasukkan data log fingerprint ke mysql
5ini pakai php v 5.2
6by aswandi
7www.aswandi.or.id
8
9kode mysql
10
11
12
13CREATE TABLE IF NOT EXISTS `sidik` (
14 `id` int(11) NOT NULL AUTO_INCREMENT,
15 `sesid` int(11) NOT NULL,
16 `pin` int(11) NOT NULL,
17 `datetimef` datetime NOT NULL,
18 `verified` int(11) NOT NULL,
19 `status` int(11) NOT NULL,
20 `ipFinger` varchar(40) NOT NULL,
21 `upload` int(11) NOT NULL,
22 `uploadTime` datetime NOT NULL,
23 `hadir_id` int(11) NOT NULL,
24 `created` datetime NOT NULL,
25 `ipAddress` varchar(40) NOT NULL,
26 PRIMARY KEY (`id`),
27 KEY `pin` (`pin`,`datetimef`),
28 KEY `upload` (`upload`),
29 KEY `datetimef` (`datetimef`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
31
32*/
33
34
35include("parse.php");
36
37
38
39$site["dbhost"] = 'localhost';
40$site["dbport"] = '3306';
41$site["dbname"] = 'dbsidik';
42$site["dblogin"] = 'root';
43$site["dbpass"] = '';
44
45
46
47date_default_timezone_set('Asia/jakarta');
48$con= mysql_connect($site["dbhost"], $site["dblogin"], $site["dbpass"]);
49mysql_select_db($site["dbname"]);
50
51
52
53$created =date("Y-m-d H:i:s");
54
55
56
57function getq($sql){
58
59 $reslt=mysql_query($sql);
60 $row=mysql_fetch_array($reslt);
61 return $row[0];
62}
63
64
65 $ipFinger = "192.168.1.201";
66
67 echo "connect to $ipFinger <br>";
68
69 $Connect = fsockopen($ipFinger, "80", $errno, $errstr, 1);
70 if($Connect){
71 $soap_request="<GetAttLog><ArgComKey xsi:type=\"xsd:integer\">".$Key."</ArgComKey><Arg><PIN xsi:type=\"xsd:integer\">All</PIN></Arg></GetAttLog>";
72
73 /* echo "<pre>";
74 print_r ($soap_request);
75
76 exit; */
77
78 $newLine="\r\n";
79 fputs($Connect, "POST /iWsService HTTP/1.0".$newLine);
80 fputs($Connect, "Content-Type: text/xml".$newLine);
81 fputs($Connect, "Content-Length: ".strlen($soap_request).$newLine.$newLine);
82 fputs($Connect, $soap_request.$newLine);
83 $buffer="";
84 while($Response=fgets($Connect, 1024)){
85 $buffer=$buffer.$Response;
86 }
87 }else echo "Koneksi Gagal";
88
89
90
91
92 $buffer=Parse_Data($buffer,"<GetAttLogResponse>","</GetAttLogResponse>");
93 //echo "<pre>";
94 //echo $buffer;
95 //exit;
96
97 $buffer=explode("\r\n",$buffer);
98 /* echo "<pre>";
99 print_r($buffer);
100 exit; */
101
102 //echo "<hr>";
103 for($a=0;$a<count($buffer);$a++){
104 $data=Parse_Data($buffer[$a],"<Row>","</Row>");
105 $pin=Parse_Data($data,"<PIN>","</PIN>");
106 $datetimef=Parse_Data($data,"<DateTime>","</DateTime>");
107 $verified=Parse_Data($data,"<Verified>","</Verified>");
108 $status=Parse_Data($data,"<Status>","</Status>");
109 $arr_datetime = explode(" ",$datetimef);
110 $tanggal_dimesin = $arr_datetime[0];
111 $jam_dimesin = $arr_datetime[1];
112
113
114
115 $cek = getq("select id from sidik where pin ='$pin' and datetimef = '$datetimef' ");
116 //echo "<br>111 PIN $pin datetime = $datetimef - cek=$cek ";
117 if($cek){
118 echo "- ";
119
120 }else{
121 if($pin){
122 echo "# ";
123 $baru++;
124 $sql="insert into sidik
125
126 ( sesid,pin,datetimef,verified,status,ipFinger,upload,uploadTime,hadir_id,created,ipAddress )
127 Values
128 ( '$sesid','$pin','$datetimef','$verified','$status','$ipFinger','$upload','$uploadTime','$hadir_id','$created','$ipAddress' )";
129
130
131 mysql_query($sql);
132 }
133 }
134
135
136 }
137
138
139?>
140<META HTTP-EQUIV=refresh CONTENT=60;URL="" >