how to integrate wordpress with a (website developed using coldfusion and sql server)

how to integrate wordpress with a (website developed using coldfusion and sql server)
sohairzaki2005Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

benchapmanCommented:
Wordpress runs completely separately from the existing site. Simply install Wordpress in a subdirectory of the main site (assuming the server supports PHP and MySQL) and it will stay completely in its subdirectory and will work perfectly. It is not difficult to theme wordpress the same as your current CF site so it looks similar. You may need to edit the Wordpress settings so its links are all Wordpress related and use the "page Links to" plugin to link to the other "internal" site from Wordpress menu items.

If your server does not support PHP MySQL, use a subdomain and set it up as two sites with the Wordpress site on another host but have them linking between them so the end user thinks the site is the same.

I had Wordpress nested in a Joomla site at one stage with no issues. I wanted the power of Joomla for the site and the ease of Wordpress for the blog. There was no problems.

Regards
Ben
sohairzaki2005Author Commented:
Thanks
-From where to download PHP. I found some binary format. I am not familar with php.
http://php.net/downloads.php
which one to download
-I have coldfusion 9, windows server 2008 is my web server operating system, SQL server 2008 is my database for my site. Will there be any conflict between SQL server and mysql
-Also concerning downloading mysql I found a file mysql-5.1.45.zip but It had no setup.exe file.

Thanks again
benchapmanCommented:
Hi

PHP on Windows with IIS is a little bit fiddly but not impossible,

http://php.iis.net/
Here is the simplest and MS recommended way to set up PHP on IIS, it is a new faster and more stable way of doing it than the old ISAPI way (which works fine by the way but is harder to set up, see http://www.thewebhostinghero.com/tutorials/install-iis7-php5-mysql5-win2008server-pt2.html) .

MySQL will not interfere with SQL Server at all, they will happily co-exist as long as you have a reasonable amount of RAM. Download the MSI version to have a simple installation, 32 bit will run on any Windows server but if you have a 64 bit Windows, use 64bit MySQL for best performance. Make sure you choose a root password that you will remember.

Once the server is ready for PHP and MySQL is installed, you can create a database and user for Wordpress (if using internally or for development I just use the ROOT account but dont do this in production), using the admin tools or command line (the MySQL console, not the windows command prompt). You can install PHPMyAdmin if you like, it is a web based PHP admin tool for MySQL which is pretty good but the install is not the easiest.

Drop the entire Wordpress installation file folder tree into a subdirectory on the web site it will run under. Make sure that web site can run PHP (Win2008 doesnt automatically turn on everything that IIS can do), and make sure the default documents include index.php. Browse to the folder and the Wordpress setup will be ready to go. Make sure your user has write permissions to the root of the Wordpress installation or you have to manually add the config file after it is created. Point it to the MySQL database (localhost, database name you set up, username and password you have already set up with permissions to the database) and it takes a couple of seconds to configure the database and write the config file. It generates a random admin password for you then you are up and running.

Good Luck.
Ben

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sohairzaki2005Author Commented:
Thanks a lot
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
WordPress

From novice to tech pro — start learning today.