Navicat

Ok, I was working on my Spoke Calculator and have come across a lot of issues. My purpose for making this calculator was to help my learn PHP in a practical manor. Take a problem figure out the issues and then make a working final product. So i managed to make a log in or admin section, gather information from a database and chose 2 fields to make a calculation from the database. I managed to Add, Edit, and remove information from the Database.

I had have spend some time looking around the internet for information to fill up the database and found a lot from a source at work. I made an excel file with all the tables loaded up. I then manually converted the excel file to XML thinking it would import with out a problem. Not quite what i had thought! I searched the net for a means to import xml to MySQL and found this program called Navicat it allows you to connect to a MySQL database and view all contents inside. Even import and export data. I chose to import a excel file and it asked me a few questions and added everything for me. My old method took about 45 minutes of messing around for get about 100 items in the Database and Navicat saved me about 40 minutes. I highly recommend using Navicat for any MySQL maintenance.

My Calculator is finished and is waiting for me to make it a permanent Home so keep checking back.