›

Who knows about MySQL databases / PHP scripts?help

GrafwritahGrafwritah 4,184 Posts
edited September 2005 in Strut Central
Ok, so I'm trying to do this:
Just wanted to let you know that it is possible to have a forum, blog and gallery all working on a single registration system and single login across the 3 different components. This is done using the 3 following packages:BLOG - Nucleus - http://www.nucleuscms.orgFORUM - phpBB - http://www.phpbb.comGALLERY - 4images - http://www.4homepages.de/
Full details here: It works by having 4images and nucleus use phpbb's SQL database.I'm kinda retarded so here's my q:I installed phpBB with Fantastico.Then I went in and installed 4images by hand.However, when I go to set up the database for 4images, whatever info I have apparently isn't correct. I think perhaps I don't have the right password.Does Fantastico set it's own password? I know it's made for retards so I figure this is likely.Anyway, should I try to just install everything by hand, including phpBB?If so, I'm not really familiar with setting up the MySQL databases so.....

  Comments

  • sleepsleep 54 Posts
    i'm not familiar with fantastico but the mySQL database info should be the same as for phpBB. phpBB doesn't change your password. they should all be using the same database server, username and password.

    you shouldn't have to set up your mySQL database unless you're renting a self-managed box. usually your ISP manages the mySQL database and just gives you an IP (address of the server), a username and a password.

    i normally install everything by hand instead of using automatic setup scripts etc
  • anasarcasmanasarcasm 365 Posts
    While we're on the subject can someone suggest a good myspql/php beginner book? The classes offered locally seem awfully broad,and I'm specifically trying to learn dynamic databases as they relate to web store fronts. I know, I know, take that shit to computerhelp.com. Thanks in advance
  • DJFerrariDJFerrari 2,411 Posts
    If I were you I'd try and do all that with one system. Post-Nuke has all those capabilities in one. You can see a list of all CMS with feature lists at CMS Matrix

    As for books and learning, you can't go wrong with any O'Reilly books, but php and MySQL are so straightforward that online help should be enough. MySQL and PHP have good documentation. If you're just trying to build a store, use an Open Source app instead of starting from scratch. You can find a good one at SourceForge

    DJ Ferrari
  • ariel_calmerariel_calmer 3,762 Posts
    While we're on the subject can someone suggest a good myspql/php beginner book? The classes offered locally seem awfully broad,and I'm specifically trying to learn dynamic databases as they relate to web store fronts. I know, I know, take that shit to computerhelp.com. Thanks in advance

    You want "PHP and MySQL Web Development" by Wellling & Thomson. Most chains should stock it or it's on amazon. It's very very good and has an easy learning curve. It's not specific to storefronts, but I built my first database-driven website while I was reading it.

  • SPlDEYSPlDEY Vegas 3,375 Posts
    Just wanted to let you know that it is possible to have a forum, blog and gallery all working on a single registration system and single login across the 3 different components. This is done using the 3 following packages

    This can work, but if your gonna do it by hand its going to take some work. I'd use like a Mambo configuration to do it.

    Does Fantastico set it's own password?

    No.

    Anyway, should I try to just install everything by hand, including phpBB?

    I would. This can help you with your problem:

    http://wakka.xiffy.nl/phpbb
    http://forum.nucleuscms.org/viewtopic.php?t=4595

    I haven't tried this with 4 images, but you may want to give it a shot:
    (http://www.4homepages.de/forumdl/integration_phpbb.zip)


    While we're on the subject can someone suggest a good mysql/php beginner book?

    The lynda.com courses are Invaluable, find a torrent if you gotta.

    - spidey
  • GrafwritahGrafwritah 4,184 Posts
    Thanks for all the help guys.


    I got it them all integrated. I was confused about how the MySQL databases wanted the info. In the end, it was simple - I was just basically inputting the database, username, and server info incorrectly.

    But I got it.

    The integration seems to work well just from trying it out a little. A user can move seamlessly from Nucleus to phpBB to 4images, all the while being logged in.

    When I get around to setting up the skins and templates I want to try out some of the extra shit, like using phpBB's user info pages for Nucleus.

    Oh, and I did it all by hand....
Sign In or Register to comment.