Integrating PHP and MySQL Into Apache From Full Installation
 

I just setup Fedora Core 1 on my secondary machine as a server. I've never really went outside the realm of html coding for my webservers, but I'm working on a project with my friend, and would like to get forums running on it.

In order to have forums tho, I must first get PHP and MySQL working on my webserver (I think). I've never really done much with SQL at all, but I've used a bit of PHP, but never really had to set it up. It could very well already be working on my webserver, but I highly doubt it. I did a full install (all 3 CD's), and then used yum to update all the packages to the latest they had to offer. Any help with how to get PHP and MySQL up and running within apache (2.0.48) would be greatly appriciated.

Also anyone with knowhow on setting up forums helping, would be great :)

Thanks in advance,

-Tsu.

as apache comes with a detailed documentation i guess u should be a bit more specific. if apache is running u can access the manual at
http://localhost/manual
u can check whether or not php is already running by a script containing

<?php
phpinfo();
?>

save it to the DocumentRoot of the server as test.php and call it from a browser
good luck!

Okay, that little bit of test code showed me that PHP was up and working :)

Also, found SQL and started that up. Just installed PHPNuke and got it working (a bit proud I diddn't totally destroy anything in the process). The only nagging problem I have now is that, they've (PHP-Nuke) added an Amazon.com Ad in the bottom left side of the template, that cannot be removed from the Banner section by the admin, because it's not listed! Haha, I'm rather sure there's a way to remove this ad (I hate unneccessary ads), but I have yet to find it. Anyone have any idea's on how to do this?

Thanks,

-Tsu

I hate that Amazon thingy. I always remove it. Login as your admin and click on the blocks button. Scroll down to where you see the list of active blocks, one should be amazon. Look to the far right under functions, choose delete and it will remove the block from your page.

What version of PHPNUKE are you using? 7.0 doesn't have the amazon ads in it and it is more secure. Go over to http://www.nukecops.com and check them out. They are one of the best sources for PHPNUKE info.

I still a big newbie when it comes to php coding but I've been playing with PHPNuke for almost a year now, so if you need any more help just yell at me. If I don't know I'll do my best to find out for ya.

Wizjr

I'm running 7.0, and it definately comes with that stupid ad in it :)

Thanks for the response as to how to remove that ad, and so quickly as well :) I was looking around, and found it in those blocks (i google searched phpnuke and amazon, and saw that a note about the amazon ad and blocks) and removed it. I came back to say nevermind and boom, you were already there and answered it :) Good lookin' out.

What I don't understand is, I downloaded PHP-Nuke from phpnuke.org and got 7.1 (or so says the link) but when installed, the stats page says 7.0. Strange. Not sure if I somehow got an older version, or if it's a typo in the code.

One thing I need to find is a good page for templates for PHP-Nuke. Also, how to change the main logo on the top left. I switched the logo.gif link in preferences to a logo I made, but it never switched. Not sure how to get that situation undercontrol. Any help on either fix would be greatly appriciated.

Thanks again :)

Tsu

To change your logo or make any changes to the way the site looks you need to edit your theme pages. What I do is take the "theme" folder (the name of the theme inside the "THEMES" directory) and open that. By changing the header.php file in Dreamweaver or something similar you can edit it to make it look like you want. You can do this for most of the theme pages in the folder. Just test it before you go live with it.

A warning if you choose to use other peoples themes make sure you backup EVERYTHING, files and Database. If the theme fails (and some due to bad coding) you will have to reload all your files and the database to the way it was BEFORE you made the changes.

There used to be a small piece of code that you could add to your main site folder and call it if this happened and it would reset it back to the default "BLUE" theme. (as long as you have it still in the themes folder) But I haven't see it listed in a while. If you find it please let me know.

here is a small list of places to check for themes, plug-ins, mods, blocks and such.

:D
http://www.nukescripts.net
http://codezwiz.com
http://www.phpnuke.org (of course)
http://www.nukecops.com
http://www.phpnukefiles.com
http://www.portalzine.de/index.php (contains other CMS)
http://www.nuke-themes.com
http://www.nukeforums.com
http://www.phpbb.com (this is the forum engine in phpnuke)


If you need anymore help just PM me and I'll see what I can do.

Okay, everything is going well here. The only thing I notice is in posts (annoying) I have to use <p> (thats a P between two carrots if it doesn't come up) to seperate paragraphs. This doesn't bother me too much, considering I usually code my entries from scratch, and using a nice GUI is pimp :) The only problem I'm having is, in the forums, it will not seperate that text. It all run's together like one huge entry, even with the paragraph markers. Any thoughts on how to fix that?

Thanks,

Tsu

the forums are controlled by PHPBB. I haven't gotten into any of that code yet. I really haven't had any probs withit. But if you go to there site they have a great forums section there to ask and answer questions.

My mistake, it's not in the forums. In the forums, you only have to use the return key to seperate the paragraphs. Hell, they work best of all :)

What doesn't work for paragraphs are the journal entries. It is literally impossible to seperate the text from stringing together into one huge paragraph. Any ideas?

That is the way the journal works. I think there is a fix/upgrade for it. If not then I know that NukeScripts has lots of Upgrades for the standard modules. Check them out, their stuff is pretty cool. Some of the 'upgrades' are enhancements to the modules others replace them altogether. Another site that I didn't add to the above list is

http://www.nukefixes.com/

Check them out also. they usually have some neat stuff and some good info in the forums too.

could you directly me with a link as to the patch? yea, i'm lame lol, i couldn't find it. plus i've been busy and not able to root around lookin for it. thanks

Just follow the link above. Go to the download section and find the Patched 7.2 version. Add the script below to your main directory. This will fix PHPNuke if you get a theme that screws up. Just copy it over in a text editor and save it as "fixtheme.php" . to use it just type it after your domain like you would if you were going to the admin section of phpnuke.


<?php

require("config.php");

$host = $dbhost;
$database = $dbname;
$username = $dbuname;
$password = $dbpass;
$def_theme = "NukeNews";
mysql_connect($host, $username, $password);
@mysql_select_db($database);

####################### BEGIN THE INSTALL #######################################

mysql_query("update ".$prefix."_config set Default_Theme='$def_theme'");

?>
#This is for: Phpnuke related / Site broken due to Theme error If you don't have the NukeNews theme uploaded in your site then change the value for $def_theme = "Insert_Theme_Name_Here"; so that it reflects one of your working themes, save it, upload it, then point your browser to http://yoursite.com/fixtheme.php #

Hope this helps