Development SCC rewritten! Error checking, and design criticism welcome.

Discussion in 'Software' started by jezmck, 19 Apr 2005.

Page 1 of 3
  1. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    Please now view this thread from http://forums.bit-tech.net/showthread.php?p=971034#post971034 onwards.
    The site is provisionally complete, and I'm now after any design criticism you may have.

    I have now picked a host, but any suggestions regarding the re-write are very welcome.​

    Hi,
    I've just recieved an email saying that my current host is going to cease hosting soon.
    Argh!

    So, my site, www.jazzle.co.uk/scc/, which runs off an Access DB via ASP, either needs a new home, or re-writing.

    I'd rather stick to PHP (didn't have the choice before), but don't know if I have enough time to convert it in my spare time.

    I think I have a place for the SCC site during the transition to a new server, but that will be limited to mysql/php too.

    So, an alternative is finding a host who can give me both mysql/php and access/asp. I've tried searching, but it seems to be difficult to get the right results and would prefer a personal recommendation anyway.

    All ideas/thoughts/suggestions very welcome.
     
    Last edited: 19 May 2005
    jezmck, 19 Apr 2005
    #1
  2. Dodge

    Dodge What's a Dremel?

    Joined:
    10 Oct 2003
    Posts:
    1,184
    Likes Received:
    0
    http://asp2php.naken.cc/

    try this see if it converts asp to php successfully?

    If you need a php server now to test it out on let me know
     
    Dodge, 19 Apr 2005
    #2
  3. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    don't think I've tried that one, but I've had little success with convertors.
    maybe my code's a bit dodgy!


    I think I may be okay for a php server for the moment, but need advice on converting the DB.
    can I enforce the constraints on the new DB if I'm importing the data?
     
    Last edited: 10 May 2005
    jezmck, 19 Apr 2005
    #3
  4. Dodge

    Dodge What's a Dremel?

    Joined:
    10 Oct 2003
    Posts:
    1,184
    Likes Received:
    0
    I've not used ASP before so im uncertain of how that works.

    Im not sure, i guess it depends on what type of field etc your using. If its just numer/ text then Im going to assume that this would be alot easier than if you have times/dates involved.

    EDIT:

    You dont seem to have too many records is it not eaiser to start from scratch?
     
    Dodge, 19 Apr 2005
    #4
  5. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    there are 73 items, 32 authors, 42 categories, and 41 category-relations.
    fortunately it is just text and numbers, so a scratch restart is feasible.

    I think I should be able to import the data easily enough, maybe I should just bite the bullet and get converting to php (a nicer language anyway).
     
    jezmck, 19 Apr 2005
    #5
  6. Dodge

    Dodge What's a Dremel?

    Joined:
    10 Oct 2003
    Posts:
    1,184
    Likes Received:
    0
    Can you not export asp files to .dat (or similer) create the tables and then import the .dat files. I would have thought that is possible. I've imported .dat files into sql tables before
     
    Dodge, 19 Apr 2005
    #6
  7. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    yeah, I think I can probably just do it via .csv files.
    so now I need a host.

    does anyone know whether it's possible to have both asp and php on the same page?
     
    jezmck, 19 Apr 2005
    #7
  8. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    jezmck, 19 Apr 2005
    #8
  9. simon w

    simon w What's a Dremel?

    Joined:
    3 Nov 2003
    Posts:
    1,302
    Likes Received:
    0
    How about you install IIS locally to run your current site and install WAMP for PHP and MySQL and set it to run on port 81 (well, almost anything other than 80). Now build your DB structure in MySQL and import the data from Access as a CSV file(s). Then you can start converting your ASP to PHP. You already have the design/structure of your website so converting should be a simple task :)
     
    simon w, 19 Apr 2005
    #9
  10. Cookie Monster

    Cookie Monster Multimodder

    Joined:
    27 Aug 2003
    Posts:
    4,208
    Likes Received:
    388
    Cookie Monster, 19 Apr 2005
    #10
  11. ouija

    ouija Trust me, I am doctor!

    Joined:
    10 Nov 2002
    Posts:
    3,026
    Likes Received:
    2
    ouija, 19 Apr 2005
    #11
  12. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    hmm, both look good, will have to compare them.

    any other suggestions welcome.
    would like to have more than one DB, php def desireable.
     
    jezmck, 19 Apr 2005
    #12
  13. ouija

    ouija Trust me, I am doctor!

    Joined:
    10 Nov 2002
    Posts:
    3,026
    Likes Received:
    2
    Well I've spoken to the current and previous owners of k1z.com on MSN several times and the servers are constantly being upgraded and expanded. If there is ever a problem with downtime (very rare) it's resolved within minutes. Any problems I have had with exceeding bandwidth limits are always dealt with forgivingly and understandingly.

    Without a doubt the best host I've used.
     
    ouija, 19 Apr 2005
    #13
  14. Cookie Monster

    Cookie Monster Multimodder

    Joined:
    27 Aug 2003
    Posts:
    4,208
    Likes Received:
    388
    I'd say everything ouija said but about my supplier, and they just started some kind of text message service to notify you of problems or something.
     
    Cookie Monster, 19 Apr 2005
    #14
  15. simon w

    simon w What's a Dremel?

    Joined:
    3 Nov 2003
    Posts:
    1,302
    Likes Received:
    0
    @ ouija & ChristopherGreen: What version of PHP are k1z.com using?
     
    simon w, 19 Apr 2005
    #15
  16. Cookie Monster

    Cookie Monster Multimodder

    Joined:
    27 Aug 2003
    Posts:
    4,208
    Likes Received:
    388
    PHP4 but I dont use k1z.com thats ouija's host. Im @ www.visualnetcentre.com
     
    Cookie Monster, 19 Apr 2005
    #16
  17. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    you on commision?
     
    jezmck, 19 Apr 2005
    #17
  18. Cookie Monster

    Cookie Monster Multimodder

    Joined:
    27 Aug 2003
    Posts:
    4,208
    Likes Received:
    388
    not sure mate, no plug was intended like.

    **goes off to find out**

    yeah mate i can be if i recommend you. hint hint :naughty:
     
    Cookie Monster, 19 Apr 2005
    #18
  19. Haddy

    Haddy World Domination

    Joined:
    22 Jan 2002
    Posts:
    2,821
    Likes Received:
    0
    may want to try www.unitedhosting.co.uk - matts a great guy over there. Their price is matched by their quality and customer support.
     
    Haddy, 20 Apr 2005
    #19
  20. jezmck

    jezmck Minimodder

    Joined:
    25 Sep 2003
    Posts:
    4,456
    Likes Received:
    36
    now that looks very good, how long you been keeping them under your hat?

    (still happy to get other suggestions, but think the above is 'winning' at the mo edit: apart from the prices!, double waht I pay now. )
     
    Last edited: 20 Apr 2005
    jezmck, 20 Apr 2005
    #20
Page 1 of 3

Share This Page