Introduction: Advanced Money-box
I’ll be showing you how to make an Advanced Money-Box which keeps track of what coins you put in there!
Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.
Step 1: Components
1. Arduino (In my case I’m using a Arduino Mega)
3. Raspberry PI
4. Coin Acceptor CH-926
7. Material to make the box itself
8. 12V Battery pack
Step 2: Make the Sorter
As this is somewhat complicated to explain with text I’ll drop a link below which has clear instructions as to how it is made.
Step 3: Make the Box
Start by making the outlines of your components in place.
Afterwards put it all in place with screws/bolts.
Step 4: Connections
Connect the wires as shown on the image.
Also connect your Arduino to your Raspberry PI with an USB-cable.
Step 5: Arduino
Download the Arduino code above and upload it to your arduino board.
Step 6: Raspberry PI
Follow both guides below to install Apache, PHP, MySQL and PhpMyAdmin on your PI:
Next up you have to transfer the “insertDB.py” file to your Raspberry PI “/home/pi/” directory.
This can be done through FTP.
Follow this guide to autorun the script once the Raspberry PI boots:
Step 7: PhpMyAdmin
1. Create a database called spaarpotDb
2. Create a table called DateTime with columns DateTime (DateTime type), TimeID(Auto increment)
3. Create a table called Inhoud with columns ID (Auto increment), Muntsoort (int)
4. Create a table called Muntsoort with columns MuntID, Value
Step 8: PhpMyAdmin
Add 4 rows of data into the Muntsoort table like on the picture. This wil determine what coin was inserted into your Money-Box. These values can be changed depending on what coins you want to use. Keep in mind you might have to change the values from your arduino code aswell.
Step 9: Adding the Website Files
1. Open up another FTP connection to your raspberry PI.
2. Go to the “/var/www/html” directory and extract the files from the RAR file above into here.
!! Note: if you are unable to transfer the files into this location due to permissions, follow this guide: !!
Install FTP to allow transferring files to and from your Raspberry Pi.
First we have to take ownership of the web root. To do this, use the following command:
sudo chown -R pi /var/www
Next, install vsftpd with the following command:
sudo apt-get install vsftpd
Now we can begin the configuration process. First have to edit the vsftpd.config file. To edit the file use the following command:
sudo nano /etc/vsftpd.conf
Find and edit the following lines as specified:
Change anonymous_enable=YES to anonymous_enable=NO
Then go to the bottom of the file and add
*To uncomment, remove the pound sign (#) in front of the specified line
*Exit the editing interface by pressing ctrl+X, type y to confirm the changes and press enter to save the file path.
Restart the FTP service with the following command:
sudo service vsftpd restart
Be the First to Share