Field Type
ID tinyint(1)
Name varchar(20)
Password varchar(20)
UID varchar(20)
State tinyint(1)
Table 7. the member table content
ID: The id is sequence number which can use in relation with other
tables in MySQL.
Name: The name of family members.
Password: The password is the entry password. For keypad password
identification which needs to read this password for comparing the
password by the user enters.
UID: The UID is the entry tag’s UID. For RFID identification which
need to read this UID for comparing the user’s tag UID. The password
and UID data in the web database can provide the remote user to
manage it.
State: The status of this member. This flag decisions whether the item
useful or not, if the state is ‘0’ then the item is useless i.e. the two-tier
identification does not care this filed.
Notification to
Cell Phone
Alarm
Two-tier Identification
Keypad Read
Keyboard Driver
Kernel
Mode
Driver
Mode
RFID Read
RS232 Driver
Linux Kernel
Application
Mode
PHP
interface
MySQL
Figure 35. Using PHP to Access MySQL
Figure 35 shows the application uses the PHP to access MySQL, the
57
