PHP/MySQL Web Application

Sherbs · 18 May 2011 at 17:11

I am going to start looking into rebuilding our estimating and MIS system in PHP with a SQL powered database.

Are there any guides out there when it comes to database planning and preparation?

Will be the biggest project i've undertaken so far, so would like to get the structure set up correctly.

Quite a small company, but we have around a thousand customers and have done around 11,000 orders in 5 years. So will need to be scalable.

RobH · 18 May 2011 at 17:46

What's it currently written in?

suarve · 18 May 2011 at 19:13

If it's a bit bigger I'd highly recommend a PHP framework to speed up your development. For instance, after the initial learning period, CodeIgniter has made developing things a lot faster for me.

Granted, there's a slight initial learning curve, but if you're familiar with PHP it a bit of none issue.

Sherbs · 19 May 2011 at 12:34

Currently in ASP, but the guys who developed it have let it stagnant for 5 years. I do not have access to the source code, but will be able to get our databases exported.

It could be a lot better and its no longer suiting our needs 100%.

Thinking about building it into a current framework, maybe symphony or wordpress? I've looked into CodeIgniter before, maybe its worth another look.

apoclyps · 21 May 2011 at 22:40

I undertook a project a little like this for my work placement at the start of the year. Some great resources i found were

Netbeans (framework)
PHPmyadmin( MySQL GUI)
vTiger (CRM)
WROX PHP6,Apache and MYSQL web development.

Not sure if it will help but vTiger CRM is quite easy to modify and has a lot of great functionality. Not sure if its suitable to your needs but its easier to modify this package and make some forms than to create something from scratch