I developed a full-stack event ticketing website, allowing organizers to scan ticket barcodes in order to mark attendence and prevent forgery. This software was successfullt implemented at an 800-guest event, and is being rented out for future installations of the event.
Every year my school meets with the other two campuses to participate in (and organize) the Bal des Neiges, a winter ball. Every year it attracts 400+ students to each of the two nights (Juniors and Seniors). As part of the Student Council, I was among those responsible for organizing this event. And as the most tech-savvy among our campus’s student council (to the best of my knowledge), I was tasked with developing a solution to ticketing at the door.
I designed tickets to be used across all three campuses and had them printed at a local print-shop. Then, I worked with a younger student from Coding Club to quickly develop a website that could be used to verify that the tickets were valid, mark them as activated, and check whether they had already been used. This system worked so well, with an average of 2 seconds or less to check in each ticket (compared to 20 seconds previously), that it will be used across all three campuses in future years.
Languages: HTML PHP CSS SQL
Links: Check-in page for organizers (password protected)
<li>
<a href="/uploads/projects/bdn/BDN_database.png" title="BDN_database">
<img src="//images.weserv.nl/?url=lucamehl.netlify.app/uploads/projects/bdn/BDN_database.png&w=300&h=300&output=.png&q=50&t=square" alt="BDN_database" title="BDN_database" /><span>BDN_database</span>
</a>
</li>
<li>
<a href="/uploads/projects/bdn/BDN_tickets.png" title="BDN_tickets">
<img src="//images.weserv.nl/?url=lucamehl.netlify.app/uploads/projects/bdn/BDN_tickets.png&w=300&h=300&output=.png&q=50&t=square" alt="BDN_tickets" title="BDN_tickets" /><span>BDN_tickets</span>
</a>
</li>
<li>
<a href="/uploads/projects/bdn/BDN_website.png" title="BDN_website">
<img src="//images.weserv.nl/?url=lucamehl.netlify.app/uploads/projects/bdn/BDN_website.png&w=300&h=300&output=.png&q=50&t=square" alt="BDN_website" title="BDN_website" /><span>BDN_website</span>
</a>
</li>
<li>
<a href="/uploads/projects/bdn20/Screen%20Shot%202020-07-18%20at%2021.57.19.png" title="Screen Shot 2020-07-18 at 21.57.19">
<img src="//images.weserv.nl/?url=lucamehl.netlify.app/uploads/projects/bdn20/Screen%20Shot%202020-07-18%20at%2021.57.19.png&w=300&h=300&output=.png&q=50&t=square" alt="Screen Shot 2020-07-18 at 21.57.19" title="Screen Shot 2020-07-18 at 21.57.19" /><span>Screen Shot 2020-07-18 at 21.57.19</span>
</a>
</li>
UPDATE: I went back and re-wrote the whole website, frontend and backend. The website is hosted on my home web server and I also purchased 3 additional barcode scanners. The software + barcode scanners is now being rented to future Student Councils. Links: NEW scanning page for organizers (password protected)
<li>
<a href="/uploads/projects/bdn20/Screen%20Shot%202020-07-18%20at%2021.57.19.png" title="Screen Shot 2020-07-18 at 21.57.19">
<img src="//images.weserv.nl/?url=lucamehl.netlify.app/uploads/projects/bdn20/Screen%20Shot%202020-07-18%20at%2021.57.19.png&w=300&h=300&output=.png&q=50&t=square" alt="Screen Shot 2020-07-18 at 21.57.19" title="Screen Shot 2020-07-18 at 21.57.19" /><span>Screen Shot 2020-07-18 at 21.57.19</span>
</a>
</li>