Access Checker

Closed

We have a membership card, and I want to check when their membership expires.

I want this to either be accessible through a browser, or as a separate small program.

Please look at the image for an example.

I want to be able to scan in the barcode on the back of the membership card, which it will show the 'Current Status', 'Expiry Date', 'Tournament Credit' and 'Daily Coffee/Tea'.

When you scan a new card, it will show a status of 'EXPIRED', and all 4 boxes will be red. The expiry date will be 'EXPIRED'. Tournament Credit will 'N/A' and Daily Coffee/Tea will be 'N/A.

Once you click the 'Extend 1 month' button, the Current Status will become green and 'Current', as well as the Expiry Date becoming green, and showing an expire date one month in the future.

Tournament Credit and Daily Coffee/Tea will be green and say 'Available'.

If you press 'Use Coffee/Tea', the Daily Coffee/Tea will turn red and say 'N/A'. Every day this will revert back to being Available.

If you press 'Use T Credit', the Tournament Credit will turn red and say 'N/A'. Every month this will reset. Also, if you press the button again, it will revert back to being 'Available'.

Custom Date will allow a user to input a custom expiry date.

Cancel Access will remove the card from the database (thereby making everything expired or n/a).

Hopefully this shouldn't be too hard.

Cheers,

Wade

Skills: Database Administration, HTML, MySQL, PHP, SQL

See more: daily access, expired credit card, wade, SQL Access, hard scan, access tournament database, barcode scan php, turn image button, scan image browser, membership access database, browser barcode, access database check, coffee program, credit card expiry date, green coffee, access daily, access check check, extend access database, barcode scan browser, program expiry date, coffee tea, database barcode input, scan browser, barcode database php, small program access database

Project ID: #4646046

17 freelancers are bidding on average $150 for this job

rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$154 USD in 1 day
(316 Reviews)
6.5
Ameba871117

i am a Database Administration, HTML, MySQL, PHP, SQL expert. pls tell me your site ftp info and job details. then i will work for u immediately. Thx.

$170 USD in 5 days
(100 Reviews)
6.0
bistanil98

Need more detail,can we discuss this,to know more detail,check Private Message. We have a team of professionals,they have more than 11 year of experience,so we can manage this work and will give you quality solution

$170 USD in 6 days
(13 Reviews)
5.8
sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have experience in PHP, MySQL, Ajax, Javascript etc. You can see feedback against my profile they are always awes More

$250 USD in 5 days
(42 Reviews)
5.6
srinichal

I can deliver as a program

$263 USD in 5 days
(15 Reviews)
5.5
rakhon

Hi, very easy project. Please see PM.

$88 USD in 4 days
(6 Reviews)
3.0
BadihBarakat

PHP & MySQL Expert at your service... Send me a sample extract of the MySQL database and I will create a small sample if you like... :)

$122 USD in 3 days
(4 Reviews)
2.7
xuanhuong09

Hi, I have 10 years experienced working on PHP/HTML5/Ajax/Jquery. I can do your work with high quality of code. I also sent private message to you.

$147 USD in 12 days
(1 Review)
2.7
jd009

I am confident I can produce a solution efficiently for you.

$160 USD in 3 days
(1 Review)
1.7
cbrantley24

This looks like a cool project, and I'd love to help you with creating it. I have over 3 years experience in PHP and MySQL, and will be able to complete this to your specifications.

$66 USD in 3 days
(1 Review)
1.3
makhan786

check you pm

$100 USD in 1 day
(0 Reviews)
0.0
tenmor

Dear sir We are 10+yo experienced webdesign and development team so we are glad to get involved in this task We've already implement similar solution for an online store and I am asking you to check PM for more det More

$222 USD in 5 days
(0 Reviews)
0.0
b228

I am ready to start. Check your PM.

$244 USD in 2 days
(0 Reviews)
0.0
vlad70

Ready to do.

$155 USD in 3 days
(0 Reviews)
0.0
expertzsol

Hi, i have gone through your requirements in detail and already have worked on a similar project and can deliver this as u have mentioned we have studied all the requirements and can deliver the same to u . we hav More

$249 USD in 12 days
(0 Reviews)
0.0
submit2world

Lets do it sir !

$35 USD in 3 days
(0 Reviews)
0.0
shankardeokar

Hi i am expert in Database Administration and I like to work with you on this project.

$155 USD in 10 days
(0 Reviews)
0.0
Batista111

Please check our PMB.

$206 USD in 3 days
(0 Reviews)
0.0
anujak999

Dear Sir, I am 6+ years experienced programmer and i can do this job at low cost and short span. Kindly grant me the opportunity to work with you. Regards

$54 USD in 3 days
(0 Reviews)
0.0