I have the following goal and was wondering if another, experienced programmer can lend some advice. Basically I'm wondering if this is the best approach. This is going to be local in-house with limited use. Will not be on the web, really have no concern (right now) for security or anything much beyond "functionality".
Goal:
Maintain and update a MySQL database with customer information (for current job). Then use this to create other applications and hopefully demo for another job.. I currently work in as a field engineer's support contact for front-end / back-end application that uses Apache and Linux as the back-end. So I would like to stick to Linux as my back-end OS. As far as databases for the current app I support we use everything from Oracle, MSSQL, MySQL, Hypersonic databases. So Kind of a variety. I choose MySQL cause of the price.
Current Plan:
- Use Linux (for testing purposes my Snow Leopard OS) for:
- Apache Server
- MySQL Server
- PHP Server
- Create front-end html page using javascript for validation
- Submit information to PHP and update MySQL, or retrieve data from MySQL
Progress so far:
- Created a html form using javascript for all the validation. Have the validation currently set up in a .js file, was originally in the html page itself.
- Downloaded MAMP and have that set up on my MBP
I originally used Eclipse to make the html form, but purchased Dreamweaver CS5.5. To learn that a little. I have taken beginning programing in VB, java, javascript, and use VBS and bash scripting at work. I know a little about a lot of things, but an "expert" at nothing.
So all that being said if I want to utilize and manipulate a MySQL database, is my current plan appropriate. IE. HTML with javascript -> passing that to PHP -> using PHP to update and query MySQL?
thanx
Goal:
Maintain and update a MySQL database with customer information (for current job). Then use this to create other applications and hopefully demo for another job.. I currently work in as a field engineer's support contact for front-end / back-end application that uses Apache and Linux as the back-end. So I would like to stick to Linux as my back-end OS. As far as databases for the current app I support we use everything from Oracle, MSSQL, MySQL, Hypersonic databases. So Kind of a variety. I choose MySQL cause of the price.
Current Plan:
- Use Linux (for testing purposes my Snow Leopard OS) for:
- Apache Server
- MySQL Server
- PHP Server
- Create front-end html page using javascript for validation
- Submit information to PHP and update MySQL, or retrieve data from MySQL
Progress so far:
- Created a html form using javascript for all the validation. Have the validation currently set up in a .js file, was originally in the html page itself.
- Downloaded MAMP and have that set up on my MBP
I originally used Eclipse to make the html form, but purchased Dreamweaver CS5.5. To learn that a little. I have taken beginning programing in VB, java, javascript, and use VBS and bash scripting at work. I know a little about a lot of things, but an "expert" at nothing.
So all that being said if I want to utilize and manipulate a MySQL database, is my current plan appropriate. IE. HTML with javascript -> passing that to PHP -> using PHP to update and query MySQL?
thanx
Last edited: