Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

cleo

macrumors 65816
Original poster
Jan 21, 2002
1,186
0
Tampa Bay Area, FL, USA
I'm doing a project that requires quite a bit of interaction with a MySQL database: a form for people to sign up, a "page" for each user, and so forth. It's been awhile since I did anything like this, and while I could relearn, time is of the essence (there's no deadline - it's a project for myself - but the sooner I can get it up, the better).

Are there any web apps (or desktop, I guess) out there to help whip up the scripts? I'm conversant enough to do further tweaking, but it'd be nice to get the bulk of it done for me. Something like Google Forms, you know?

And if not, are there any good, but quick tutorials you can recommend t help me brush up?
 
I don't know of any generators like what you are describing. How about a framework like CakePHP or CodeIgniter? These will handle all the boring load-from-database, join-the-tables, save-to-database stuff for you. They will require some learning up front, but once you get the hang of them, they will speed up your development at least 5-fold, and help you write nice, pretty, well-structured code.

If you are already familiar with the MVC development pattern, you can pick up CakePHP from the website tutorial in about an hour.
 
<security rant>Playing with forces that you dont fully understand yet is quite dangerous, and I would feel uncomfortable to say the least to leave the mysql code up to a program. However if this is just a toy or doesnt go up on to the public tubes pay no attention here </security rant>

anyways,
if you once knew php or <insert scripting language here> it will take a week tops to be back in full swing and total understanding of the project. mysql theory isnt that hard either and the website below should be helpful.

http://www.w3schools.com/

also i dont know if its enough for you but try http://www.squarespace.com/
 
Like mentioned above by MojoWill, if you want something quick, simple, that consits of login and a personal "page", why not take a look at something that's already available?

Here's some links for you to get started:
- Comparison of CMS: http://www.cmsmatrix.org/
- Comparison of weblog: http://www.weblogmatrix.org/

Re-learning everything you've known before won't take too long.
It's the re-building everything that's going to take a while.

If you want it to become a specialized project where existing solutions won't fit your needs, or if you want to practice your knowledge, feel free to rebuild them. But just to get something up and running, try what's out there and see which one you like.



-stndn.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.