Need suggestions about tools to manipulate data in a MySql database and create forms to display data.

I trade options.  At present I am entering each trade into a spreadsheet .  I can manipulate each individual trade rather easily but when I want to summarize data I have to determine each piece of data I need and what cell it is in and then manually create a summary function.  

Spreadsheets are good for certain things.  Databases are good at storing data for manipulation.

I want to store my trades in a database .  I chose MySql  because it is free.  I am using OpenOffice  calc as my spreadsheet .  I want to be able to export data from MySql  to OpenOffice  Calc .

I want to be able to create forms so I can view the data in the database .  

 I want to avoid using Microsoft products because I don't want to pay the license fees.  I am the only one who will use the data so I want to keep costs low.

From looking at many web pages I gather people are using PHP or Django to display and manipulate MySql  data and create forms.  

I am willing to spend some time to study but I am not going to be an expert programmer.  I have experience using SQL server and using SQL expressions.  I have some experience programming active server pages and ADO.

I have 2 computers both running Windows 7 pro.  They are networked together.  I plan to have one computer running MySql  and the other will be a client machine.

So what I want to do is:
Export data from MySql  to OpenOffice  Calc
Create forms so I can view data in the MySql  database
Print some reports.


QUESTIONS:
1.) From the web sites I have viewed it seems PHP or Django are used to manipulate data (add, delete, insert, update) and to display data.  Which would you use?  Or can you suggest some other tool to use?

2.) I put my trades into spreadsheets because this is the only way I can connect to my broker's web site and get up to the minute price data .  I plan to enter my trades into MySql  and then export the trades to spreadsheets.  It seems Python can create OpenOffice  Calc spreadsheets.  Python seems to be able to talk to MySql  .  What would be required to have Python create forms to view MySql  data?

3.) If I use PHP or Django, I guess I have to install some sort of software to display web pages.  What tool is best to install?  Apache?  Or something else?  If I use Python, would I need to install any web server?

4.) How much html5 would I have to know to make this all work?

5.) May be you have better suggestions?  Please share your suggestions.
donpickAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
I recommend you use OpenOffice Database program to connect to your MySQL database.  You will need the MySQL ODBC drivers to do that.  And you don't 'need' to put the MySQL server on a different machine.  I normally use LibreOffice but I just downloaded OpenOffice and installed it and used it to connect to the MySQL database on the same machine.  I did the same with LibreOffice on the machine beside it which has it's own MySQL server.

https://dev.mysql.com/downloads/connector/odbc/

In addition, the machine with OpenOffice also has WAMP installed which is a complete development package for PHP and MySQL.  You could use it also in your project at some point.  In particular, it makes it very easy to install MySQL.  Then you cause later use PHP thru the WAMP web server to create web pages that do what you want.

http://www.wampserver.com/en/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
donpickAuthor Commented:
Thank you for your help
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.