Suggest me appropriate technologies

goodguy

I have a question..
1. I have to create a site where in people can log in & post their complaints.
2. People who log in will have their personal info in it.
3. We should be able to generate a list of all the complaints with their name, SSN, type of complaint & time of complaint
4. On the server side, I have to break the data, create report & post the reports.[probably generate the reports]

Can I use mySql & php for this specification as backend & front end? or else suggest some other effective technologies..thank u guys

bradgrafelman

goodguy wrote:
Can I use mySql & php for this specification as backend & front end?

I don't know, can you use MySQL and PHP well? :p

If you're asking if those two technologies are able to accommodate this use case, then yes, they are more than able to do so. Designing and interacting with a database, however, is nothing you can learn to do well in a day or two (maybe not even a week, TBH). Before you start, for example, I would find a good article or two about security (SQL injections, data sanitizing/validation, etc. etc.) as well as a couple about database normalization techniques.

And of course, once you design your DB schema, feel free to post all of it here for critique/suggestions.

EDIT: Also, welcome to PHPBuilder!

goodguy

Thank you bro..
I have some experience working with sql server 2008 & connected it with c# .net framework..will that experience help here..i know a little bit of sql..not deep....do u think I can design such a site in 2-3 weeks..

bradgrafelman

goodguy wrote:
do u think I can design such a site in 2-3 weeks

There's really no way anyone but you can answer that. It really depends on how much knowledge you have and thus how much time you can spend on development/troubleshooting rather than researching/self-educating/etc.

Best I can offer is to break down the whole process into smaller sub-components, figure out the logical steps needed to implement those, and start writing/testing code. If you get stuck, feel free to post a new thread on a specific problem you're facing. If you're not sure whether you're going about something the right way, feel free to post the code you have in the Code Critique forum.

goodguy

bradgrafelman;10959873 wrote:
There's really no way anyone but you can answer that. It really depends on how much knowledge you have and thus how much time you can spend on development/troubleshooting rather than researching/self-educating/etc.

Best I can offer is to break down the whole process into smaller sub-components, figure out the logical steps needed to implement those, and start writing/testing code. If you get stuck, feel free to post a new thread on a specific problem you're facing. If you're not sure whether you're going about something the right way, feel free to post the code you have in the Code Critique forum.

hey brad..that is so nice of you..if you could give me a small headstart in learning that would be very helpful..thank u..