+ Post New Thread
Results 1 to 9 of 9
How do you do....it? Thread, Php/MySQL Web Design in Technical; Hi All, First post, so bare with me. Nathan harmsworth of machynlleth invited me here, for your info, i'm assistant ...
  1. #1

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Php/MySQL Web Design

    Hi All,

    First post, so bare with me. Nathan harmsworth of machynlleth invited me here, for your info, i'm assistant network manage at a school in leicestershire, with 500 pc's and associated kit, and about 8 servers. 1600+ users at last count.

    I was asked to design and implement a school website when i first arrived back in september. I spent some time developing a nice little html/css site, and rapidly realised that it was going to be unmanageable aftera few months as a static html site.

    I inlcuded a few 'i-frames' so that important news/jobs/notices etc could be updates with blogger.com, but i then started work on learning php and mysql.

    A big part of my degree was working in Java 2, so i'm quite happy with that style of object oriented coding, but the php script style and database interaction were both new.

    I have now reached the stage where i have a development version of the site written in php, which uses a script to scan through a page searching for keyword tags, and replacing them with the appropriate .inc files. The plan is that the staff should be able to edit the .ing files without b*llsing too much up.

    clearly this is a very poor half way house when i've got such tools as php5 and mysql4.1 at my disposal. I don't suppose anyone (more than likely the creator of this lovelly site ) has any experience of similar projects? Thoughts on object oriented php as a whole? should i just try and learn scripting mentality? how about the mysql side? anyone into schema design for these sort of things?

    as i say, java i can cope with, so if i can find a way to make the php job similar to java, i should be alot happier.... I have until sept to get this sorted, so i hope you can help!

    existing static site with i-frames can be viewed at www.jcc.leics.sch.uk

    Thanks in advance

    Adam

  2. #2
    StewartKnight's Avatar
    Join Date
    Jun 2005
    Posts
    1,587
    Thank Post
    2
    Thanked 27 Times in 21 Posts
    Rep Power
    30

    Re: Php/MySQL Web Design

    Heck, has your school not heard of WorkForce Reform, don't expect the teachers to do anything except teach. At my last school the teachers even wanted the admin staff to take on marking the work!!!

  3. #3

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Php/MySQL Web Design

    well, obviously that's the way they'd like it, but there are several layers of dept heads and directors of this and that not to mention the SMT that all fancy being able to update things... they'll porbably pass on the job to thier various admin assistants or p.a.'s but so long as it's not me, and they don't break the site, i'm happy.

    there are dept's like art who'll want to be able to update an image gallery, and people in the main office responsible for updating the weekly newsletter and other such tedious tasks... if it were just a few i'd keep it simple and do it myself... but... being such a big place, we've got too much going on, and too much potential web-info to publish to be arsed with anything less than dynamic... the problem is.... i'm stuck! If only i'd have paid more attention during my jsp's module.... grrrr...

    anyway... still waiting for a php/mysql guru...

    Adam

  4. #4
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    617
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: Php/MySQL Web Design

    Have you heard of Contribute by Macromedia? I have seen it working. To edit a website, all a user needs to do is type in the url, and if they have permission to change something, it's a simple case of replacing old with new.

    http://www.macromedia.com/software/c.../?promoid=BINP

    Worth a look although I do think the webpage hsa to be created with Dreamweaver. Dreamweaver BTW does PHP and all that.

  5. #5

    Join Date
    Jul 2005
    Location
    Leicestershire
    Posts
    50
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Php/MySQL Web Design

    Thanks, I'll take a look.....

    I do have to confess though, I'm a bit of purist when it comes to code.. i like to know and understand what's going on.... thus.... i despise macromedia and thier evil dreamweaver. I've pursuaded the school to buy a copy of PhpEd so i've got my IDE sorted. The idea you mentioned sound interesting though, would be nice if there's an open source implementation somewhere...

    cheers

    Adam

  6. #6

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181

    Re: Php/MySQL Web Design

    Back onto topic...

    You could try an opensource solution - e.g. Mambo (www.mamboserver.org)

    If you know Java, why not use JSP to pull your data out of the database?

  7. #7
    tarquel's Avatar
    Join Date
    Jun 2005
    Location
    Powys, Mid-Wales, UK
    Posts
    1,740
    Thank Post
    13
    Thanked 45 Times in 35 Posts
    Rep Power
    29

    Re: Php/MySQL Web Design

    Adam - take a look at TYPO3 (its what Powys use for their site now).

    If you can setup the linux server to take its requirements, its well managable and basically damn good. You can make (like alot of CMS') different users have different permissions, make content testable first before publishing, really lock down what you want to happen, and tons more.

    ...can anyone tell I was impressed by it when I saw it? lol...

    http://typo3.org/

    You can still write your code and custom content to plugin to it too

    Cheers
    (and change my name pls :P)
    Nath

  8. #8
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,966
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: Php/MySQL Web Design

    I'm a big fan of Wordpress. It has CMS aspirations but currently is geared more toward weblogs. The bare code is simple and well commented - and user permissions are in place so that you could have what you want now - straight out of the box. Just add any gallery module and you're done.

  9. #9

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,924
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204

    Re: Php/MySQL Web Design

    Hello Adam from down the road in place know as Lou -ga - ba -ro ga i.e Loughborough...

    Anyway likme mambo but can be limited at times, have used cutenews php which was quite good and very easy to alter...

    Russ

SHARE:
+ Post New Thread

Similar Threads

  1. Techsoft 2D Design
    By tosca925 in forum Educational Software
    Replies: 14
    Last Post: 10th September 2008, 11:47 AM
  2. Design - Best Webpage you have ever seen?
    By Zoom7000 in forum General Chat
    Replies: 26
    Last Post: 4th June 2008, 12:03 PM
  3. New 2D Design talking to the Old Mill Design
    By Sean in forum Educational Software
    Replies: 5
    Last Post: 15th January 2008, 09:26 AM
  4. Looking for Design software?
    By jumpinjamez in forum Educational Software
    Replies: 3
    Last Post: 10th May 2007, 02:24 PM
  5. Website Design
    By Simcfc73 in forum How do you do....it?
    Replies: 40
    Last Post: 25th September 2006, 02:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •