Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 22, 2012, 02:32 PM   #1
floh
macrumors 6502
 
Join Date: Nov 2011
Location: Stuttgart, Germany
Simple website with user accounts

Hey everyone!

So, I want to create a simple website, and I have never done this (well, yes, but very basic and a long time ago). The website is supposed to have the following features:

- People can create user names (captcha?) and log in with them.
- They can submit some data (just a number and maybe the submission date)
- They can view a graph of their own numbers and an average of everybody else's
- They can log out

Now these features are very basic and don't need to be fancy. The number of users will probably stay below 100. Not knowing anything, I would have gone about it with PHP and a mySQL database, but I have never really used either. I have a lot of coding experience in C and some in Python and am generally not afraid of computers and editors. I own Rapidweaver (because it was included in a software bundle once) but have never used it.

My questions to you are:

1. Are PHP and mySQL the way to do this? Is there a better or easier way?

2. What would you use to draw and show graphs of some data on the website?

3. Would you recommend doing this with Rapidweaver? Can Rapidweaver easily manage a database, logins and a graph, or would I have to manually code the PHP and mySQL part anyways? Or would you recommend to use Rapidweaver for a layout and then edit the resulting pages by hand?

4. Do you (by chance) have any great tipps where I can get examples or pre-coded site sketches like this? It seems to me like many people would want this (a site with accounts), and I don't want to re-program the wheel. This is supposed to be a "could you just quickly code this"-project... as always...

Thanks, and I hope I didn't insult you all with my complete newbie questions.

Floh
floh is offline   0 Reply With Quote
Old Nov 22, 2012, 06:24 PM   #2
Hansr
macrumors 6502a
 
Join Date: Apr 2007
1) Pretty much
2) Highcharts or Flot
3) No
4) You could buy this and use it as a starting place: http://codecanyon.net/item/php-login...nagement/49008
Hansr is offline   1 Reply With Quote
Old Nov 22, 2012, 06:34 PM   #3
floh
Thread Starter
macrumors 6502
 
Join Date: Nov 2011
Location: Stuttgart, Germany
Quote:
Originally Posted by Hansr View Post
1) Pretty much
2) Highcharts or Flot
3) No
4) You could buy this and use it as a starting place: http://codecanyon.net/item/php-login...nagement/49008
This was a very short, but perfectly helpful answer. Thanks a lot.
floh is offline   0 Reply With Quote
Old Nov 23, 2012, 04:46 AM   #4
ghellquist
macrumors regular
 
Join Date: Aug 2011
Location: Stockholm Sweden
Wordpress

Suggestion.
Look at the wordpress system. It solves a number of the things more or less directly (creating users, logging in) and there is a lot of ready plugins available that might already solve what you are planning to do. It will as well allow you to host the site without cost.

// Gunnar
ghellquist is offline   2 Reply With Quote
Old Nov 23, 2012, 05:09 AM   #5
floh
Thread Starter
macrumors 6502
 
Join Date: Nov 2011
Location: Stuttgart, Germany
Quote:
Originally Posted by ghellquist View Post
Look at the wordpress system. It solves a number of the things more or less directly (creating users, logging in)
Thanks, Gunnar. I know the wordpress system (my institute uses it for the webpage we distribute our simulation software through) and it is very convenient.

However, I see three small hickups with that:

1. It does not allow a user to easily create his own account, does it? The way I got to know it, accounts can only be created by an admin user. I would like to avoid that. But I could be wrong here.

2. The database connectivity isn't great. Users in wordpress are supposed to be users that can or can't view certain pages or that have editing capabilities. Basically setting the "page rights" like for users in Unix filesystems. The users are not supposed to be entries in a database, with editable data points associated with their account. I would probably have to hack a lot to get this working and could as well go with PHP directly.

3. Free webspace is great, but I already have that, because I work at a university.

Thanks anyways, and I may actually be wrong about these points.
floh is offline   0 Reply With Quote
Old Nov 23, 2012, 07:08 AM   #6
rdas7
macrumors regular
 
Join Date: Nov 2002
Location: London, England
I'm in precisely the same situation *extensive experience in front-end code, but little hands-on with server-side (beyond accessing APIs that I usually have a hand in architecting, but not coding).

Look into PaaS and SaaS solutions such as Parse.com *might be just what you're looking for! There are several other similar services.
rdas7 is offline   0 Reply With Quote
Old Nov 25, 2012, 12:46 AM   #7
ghellquist
macrumors regular
 
Join Date: Aug 2011
Location: Stockholm Sweden
Quote:
Originally Posted by floh View Post
1. It does not allow a user to easily create his own account, does it? The way I got to know it, accounts can only be created by an admin user. I would like to avoid that. But I could be wrong here.

2. The database connectivity isn't great. Users in wordpress are supposed to be users that can or can't view certain pages or that have editing capabilities. Basically setting the "page rights" like for users in Unix filesystems. The users are not supposed to be entries in a database, with editable data points associated with their account. I would probably have to hack a lot to get this working and could as well go with PHP directly.
Hi.
I am in no way an expert, have only dabbled a bit on the corners with wordpress. I find it to be one (of probably many) shortcuts to solve things that otherwise would take a lot of my (not bugfree) code.
1. There are several plugins allowing users to register themselves with more or less security checks. Check this one as an example (buddypress). http://testbp.org
2. Agree on that part. But I believe that if you have already verified the user and has his name in a PHP variable (wordpress does that) it would be easy to access the MySql database to store stuff.

Anyway, beeing a lazy programmer, I personally try to steal as much as possible.
// Gunnar
ghellquist is offline   0 Reply With Quote
Old Nov 27, 2012, 07:32 AM   #8
TechnologyLasts
macrumors newbie
 
Join Date: Oct 2011
Quote:
Originally Posted by floh View Post
1. It does not allow a user to easily create his own account, does it? The way I got to know it, accounts can only be created by an admin user. I would like to avoid that. But I could be wrong here.
Users can create an account themselves with Wordpress. You don't even have to install any plugins; it's native to Wordpress. It's a checkbox in the settings of the Wordpress site, called "anyone can register". Just check that box and you're good to go.
TechnologyLasts is offline   0 Reply With Quote

Reply
MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Tags
accounts, database, rapidweaver

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 03:26 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC