+ Post New Thread
Results 1 to 13 of 13
Windows Thread, Online Database in Technical; Now I probably should have put this in a different forum, not sure which one, but I put it here ...
  1. #1

    Join Date
    Oct 2005
    Location
    Corpus Christi Sports College
    Posts
    153
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Online Database

    Now I probably should have put this in a different forum, not sure which one, but I put it here to get the best response. (mods move it wherever)

    Last year I developed a simple tracking system using Access to input student grades. I located it on the server and put it on the start menu for the teachers to access it . The SMT love it, but the staff are always moaning that they cannot access it because their computers don't have access or they want to do it at home.

    Now the only solution I can see to this problem is a an online database. Anyone have any thoughts about what would be the best way to go about this, if anything like this exists already (but price is an issue !) and how easy it would be set up my own ?

  2. #2
    Guest

    Re: Online Database

    How about an MySQL database, with a front end viewable in an interent browser?

    As for how easy that would be, pass. Im sure some of the programmers here could shed some more light.

  3. #3
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,987
    Thank Post
    275
    Thanked 52 Times in 46 Posts
    Blog Entries
    2
    Rep Power
    48

    Re: Online Database

    I set one up pretty easily using a windows web server. It's a very easy conversion. Take a look at the docs. You just need a web facing server

  4. #4

    Join Date
    Nov 2005
    Location
    Middlesbrough
    Posts
    402
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Online Database

    Either mySQL or an Access DB should be fine! Personally i'd use mySQL and PHP though.

    If you have dreamweaver, this has some in built stuff to connect to a database (either PHP or ASP) and pull info from it, it's not the cleanest code but it works if you just want to pull info from a DB and display it.

    This page has some info about dreamweaver and DB connections.

    If you need a hand, give me a shout!

  5. #5

    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    634
    Thank Post
    11
    Thanked 6 Times in 6 Posts
    Rep Power
    22

    Re: Online Database

    Am I right thinking you're in Lancs Pear? If so you can have a MySQL database in your Lancs provided webspace, along with php support.



    Andy

  6. #6

    Join Date
    Oct 2005
    Location
    Corpus Christi Sports College
    Posts
    153
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Online Database

    Yes, I am in Lancs. The MySQL option was the first thing I thought of, I'd rather stay away from Access though !

    Do I have to contact Lancs NGFL or somebody to have the database installed ? We also have some more webspace with supanames which also allows us to use a sql database (although I have a test for moodle on that until Xmas)

    In the short run I would just want to set up the database so staff could input student grades in and then for it to be all collaborated into a report. But in the long run I would want specific queries that staff could enter to pull out class/subject data and be able to print it.

  7. #7
    Guest

    Re: Online Database

    You just need your MySQL Username / Password from your ISP and the address of the MyQSL admin page.

  8. #8

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183

    Re: Online Database

    @pear: email 'webmaster AT lancsngfl DOT ac DOT uk' and you shall be provided with all that you need.

  9. #9

    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    634
    Thank Post
    11
    Thanked 6 Times in 6 Posts
    Rep Power
    22

    Re: Online Database

    I suppose you'd also better look at including some kind of security mechanism if you're putting up personal data.

    Andy.

  10. #10

    Join Date
    Oct 2005
    Location
    Corpus Christi Sports College
    Posts
    153
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Online Database

    Does mysql swell up like access ? Because I'm starting to consider all possibilities such as filling the register in for each class using the database, but I don't want to have a bulky database that is slow.

    Obviously security is an issue and I'll make sure everything requires passwords.

  11. #11

    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    634
    Thank Post
    11
    Thanked 6 Times in 6 Posts
    Rep Power
    22

    Re: Online Database

    Haven't done much fancy with it yet - but it doesn't seem to be getting too big.

  12. #12
    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
    30

    Re: Online Database

    I'd suggest obsure URL with .htaccess / pswd a good start.

    Also, turning off the show folder listing of file and folders [sorry - no idea what its actually called] in the server config for that specific directory perhaps or the whole site maybe.

    My personal host has that turned off anyhow so I've never bothered with having to turn it off hehe

    Just my 2p

    Regards
    N.

  13. #13

    Join Date
    Nov 2005
    Location
    Preston, Lancs
    Posts
    43
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Online Database

    mySQl would be an ideal solution to your problem Pear. You could make the system even better by using a LAMP setup and making a web front-end to the whole thing. Then it'll look nice for the teachers and won't put off any luddites on your staff.
    If it contains student data and you are going to make in available online, you definitely want to look into the security side like Tarquel mentioned before you implement it because you may accidentally fall foul of the DPA.
    BTW- It won't bloat up like an Access database so you shouldn't need to worry to much about the size for what you intend to do.

    Good luck.



SHARE:
+ Post New Thread

Similar Threads

  1. Database Convertor
    By limbo in forum Downloads
    Replies: 3
    Last Post: 14th November 2007, 04:34 PM
  2. EMBC - using a database
    By SpuffMonkey in forum Web Development
    Replies: 6
    Last Post: 9th November 2007, 07:36 PM
  3. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 10:03 PM
  4. Replies: 4
    Last Post: 28th February 2007, 10:37 AM
  5. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 10th January 2007, 12:27 AM

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
  •