MVP Scoring System

[laarchie]

Hi there, I am a student from the UK and I am taking PHP and mySql programming for the first time. I have done a bit of python and html before. I do have some experience with PHP though.

I need to create a project for my coursework. My system will be an MVP system (Cricket) where scores will be input and then MVP scores obtained. I wanted to know if anyone has any experience with this and thus could helpfully guide me in the right direction with resources and anything that could be deemed relevant.

 

I am more than happy to explain further and send my prototype over.

Many thanks.

[NotionCommotion]

No experience with MVP and Cricket, but do have some general experience, and recommend the following:

 

1. Spend some time up front to truly determine your user requirements, else you will find yourself going back and changing your database schema.  Mocking up your pages will both help with your HTML/CSS as well as allow you to better understand your data requirements.
2. After you fully understand your user requirements, spend some developing your database schema or you will find your self going back and changing your application.  If you really understand "normalization", read up on it.
3. And only after you have a good database schema, start your application.
   1. I would recommend a simple MVC design pattern.  Don't use someone else's, but just make your own simple one.
   2. Use a single entry point into your site (index.php) where additional data is included in the URL or Post.
   3. Consider OOP.
   4. Use prepared statements and PDO!
   5. Strongly consider a template engine.  I like Twig.
4. Have fun!

[laarchie]

 

No experience with MVP and Cricket, but do have some general experience, and recommend the following:

 

1. Spend some time up front to truly determine your user requirements, else you will find yourself going back and changing your database schema.  Mocking up your pages will both help with your HTML/CSS as well as allow you to better understand your data requirements.
2. After you fully understand your user requirements, spend some developing your database schema or you will find your self going back and changing your application.  If you really understand "normalization", read up on it.
3. And only after you have a good database schema, start your application.
   1. I would recommend a simple MVC design pattern.  Don't use someone else's, but just make your own simple one.
   2. Use a single entry point into your site (index.php) where additional data is included in the URL or Post.
   3. Consider OOP.
   4. Use prepared statements and PDO!
   5. Strongly consider a template engine.  I like Twig.
4. Have fun!

 

 

Thanks for the quick reply. At the moment I am brushing up my PHP skills on Codecademy as well as following the steps required by my coursework (SDLC). I have studied normalization so that should not be an issue.

 

As for the algorithm that will actually perform the calculation I thought about doing it all in a spreadsheet first. So i can see how everything links together and tweak accordingly. To be fair, my project is just a fancy spreadsheet, the user would input scores and then obtain a ranking pretty much.

 

Much appreciated, thanks.

[jcbones]

As long as you don't try and take that spreadsheet and pass it directly into your database, which would destroy normalization.  Databases are not meant to be spreadsheets, but you can use the database to build a spreadsheet.

Notion gave you some pretty good pointers.

[NotionCommotion]

Notion gave you some pretty good pointers.

 

I learned every one of them the hard way