We decided that a barcode tracking system would help Kwik Trip (our team's favorite store) keep track of what customers were buying and what customers don't to minimize waste.

What it does

It keeps track of barcodes in a MySQL database and shows managers what people are buying in a simple to understand pie chart.

How we built it

We used a combination of HTML5, CSS, JavaScript, PHP and MySQL to make an easy to use and understand for everybody.

Challenges we ran into

  • The MySQL database wasn’t connecting, but we solved it by changing the database name.
  • The MySQL database wasn’t giving information about the information in it’s rows, but we solved this by rearranging how we setup our variables (since php is a procedural language, it didn’t assign the connection variables earlier).
  • The MySQL database wasn’t storing the information correctly (just giving out random garbage), but we fixed it by changing the database to take in a string instead of an integer, which solved the problem.
  • The bootstrap css framework we used wasn’t connecting, but this was solved by making sure we selected the right document.
  • The form was submitting its results in the wrong manner (get instead of post) but this was easily solved by making sure we set the correct parameter and disabled the default (which was get)
  • The javascript chart wasn’t working because the php wasn’t outputting into an array, but we easily solved this buy just echoing it into an array.
  • The javascript chart wasn’t using the correct variables, but we decided that we could just use the Google Chart API instead (which was more efficient anyways). ## Accomplishments that we're proud of
  • Making this in less than 6 hours
  • Making the code efficient enough to work in store
  • The fact that we were able to work as a team and still get the entire project done together. ## What we learned We (as a team) learned that we really need to keep track of what is done, what needs to be done, and what and who is working on a specific piece of program (basically, time management is really important). ## What's next for KTABS (Kwik Trip Automated Barcode System)
  • Make it look prettier
  • Use a local storage method instead of MySQL
  • Make a camera input for the barcode
  • Make a way to determine what the barcode means
  • Make the code more efficient and add comments to make it easier to understand.
Share this project: