Skip to main content
gamedev.net
🔒 Locked

Website help

Started by Don Quioxte Jan 25, 2007 at 4:19 PM 5 replies 1.2k views
Original Post
Don Quioxte
Don Quioxte
At my school, freshmen take a "Basic Computer Applications" class, in which you learn the wonders of Microsoft Word, PowerPoint, and Excel. I built my own computer two years ago. I don't really need to take a class on things I've been able to do for years. The bureaucracy churned in its mysterious workings and another tech-savvy individual and I were placed in a "Website Management" class, which entails updating our school website. I'm ready to learn more than a basic HTML class, and would like to automate some of the website. So, my question for you knowledgeable folk on gamedev is this: In the website above, where the upcoming events are listed, what are some methods of automation for this? For example, having a text/html/xml file that contains a schedule for the year, and automatically updates the website and removes old events. Currently, it is all done manually. In a similar vein, what would be a good way to allow a teacher to fill out a form for a weekly schedule? I was thinking about having one file (xml, html, whatever) that the information is gotten from for the website, but I'm not sure that all of the teachers are tech-savvy enough (or careful enough to not delete, rename, or move the file) for this to work. Currently, I'm just looking for ideas. Tutorials are welcome, too, but are easier to find. I don't have too much website experience, but I learn quickly. I have a few other updates that I want to make on the website, but these are the most important. The rest are design and layout related. Thank you very much for your time.
[sub]-------------------------So impact forces are measured in Ford-Taurus-miles-per-hour in the U.S.? - Trapper Zoid[/sub]
Raptor Tea
Raptor Tea
The first thing that comes to mind is using PHP and MySQL. This would involve setting up a database with a table containing records of upcoming events. Your PHP script would basically connect to the database, select the appropriate table, query 'X' number of rows and then display the content with whatever formatting neccessary.

To have the teachers be able to add their own content you would need to first setup a seperate page with a form containing however many fields you need. From here you'd take the data after it's submitted and run a query to store the new events each in their own record.

Some Googling and a little study and you'll be rolling in an "A+" in no time.
Don Quioxte
Don Quioxte
Thanks!

I asked my dad (network administrator) and he basically said "MySQL and ASP or PHP"
[sub]-------------------------So impact forces are measured in Ford-Taurus-miles-per-hour in the U.S.? - Trapper Zoid[/sub]
superpig
superpig
How frequently is the content updated? If it's infrequent (e.g. once or twice a day at most) and done purely from one side of the network (i.e. only from on campus) then the best performance would be from writing network-internal tools that generate static pages. Those tools might use an SQL-based database along with a web scripting language like PHP to work, but if the site isn't fully dynamic and has a limited page count then there's no need to fetch and format data every time anyone makes a request.
Richard "Superpig" Fine - saving pigs from untimely fates - Microsoft DirectX MVP 2006/2007/2008/2009
"Shaders are not meant to do everything. Of course you can try to use it for everything, but it's like playing football using cabbage." - MickeyMouse
Ravuya
Ravuya
The security and maintenance work on having a dynamic website sounds like a pain in the butt if you're going to take off and dump it on someone else's lap.

If the content doesn't change that much, then you should be OK with just static pages; they're also much easier for non-programmers to edit.

If you're going dynamic, consider using something like Drupal or Joomla instead of coding everything by hand.
Sander
Sander
Another option is to figure out what tools the school currently use to maintain their schedule. See if you can make an (automated) export from it and read that into the website.
liquidAir
liquidAir
Just felt I should chip this in. If you intend to go with the PHP/MySQL route, try to make use of a framework, as this will keep things very neat. You do not want to be dealing with spaghetti code, and this is very easy to achieve in PHP. Trust me.

There're several frameworks out there, but I'd recommend CakePHP.

Good luck.

Topic Locked

This topic has been locked by a moderator. New replies are not allowed.

Sign in to reply to this topic.