Re: PHP Template Trouble

Brad, I cant thank you enough!!! This has been getting to me for weeks. I simply moved the mapping of the URL's so that all the URL's point to the same website, i could then use that http _host to pick them up and then i've basically used this to query the database and give me what I want. It was so simple in the end but I never even thought about doing it this way, i knew there would be an easy solution though. It works perfectly, finally i can get some sleep.. now just got to get around to fixing all the installation!

Well, I'm sure there is a better way to do it, but this should work. config.php does not need to be dynamic in this scenario. 1. Copy index.php and config.php into each site's directory. 2. Change the $db_name variable in config.php to use the correct database. <?php // c:\inetpub\www\example1\config.php $db_host = "localhost"; $db_user = "foo"; $db_pass = "bar"; $db_name = "example1"; ?> <?php // c:\inetpub\www\solution\config.php $db_host = "localhost"; $db_user = "foo"; $db_pass = "bar"; $db_name = "solution"; ?> <?php // index.php (gets copied into each directory) include("config.php"); print "<html><head><title>".$_SERVER['HTTP_HOST']."</title><head><body>"; print "This site is using the database name \"{$db_name}\""; print "</body></html>"; ?> If you can't get it to work using this method, I give up :P Cheers ;) - Brad

-----Original Message----- From: Kevin [mailto:Kevin@harveywalsh.co.uk] Sent: Thursday, October 26, 2006 10:39 AM To: php-general@lists.php.net Subject: Re: [PHP] PHP Template Trouble But the dedicated server has security. In order to use it you must create accounts (these are your ftp accounts) so basically I have example mapped to www.example.com and example2 mapped to www.example2.com example's root dir would be along the lines of: c:\inetpub\www\example\htdocs example2's root dir would be c:\inetput\www\example2\htdocs Example2 cannot access the root dir of example because of the security, it gives a permission denied error and the same the other way around. Kevin Brad Fuller wrote:

    
Cool, then what you want to do is make all the domains point to the same

directory, have your files index.php and config.php in that directory

and it

should work like magic. Then you end up with one copy of the files and how ever many sites you

need.

No frames, no duplicated code. It's been a long time (5+ years) since I worked with Windows/IIS, sorry

I

don't have more specific instructions on how to do the above. Hope that's enough to get you started in the right direction. -Brad -----Original Message----- From: Kevin [mailto:Kevin@harveywalsh.co.uk] Sent: Thursday, October 26, 2006 10:15 AM To: php-general@lists.php.net Subject: Re: [PHP] PHP Template Trouble Yes all the sites are located on a Windows 2003 Dedicated Server. Kevin Brad Fuller wrote:

      
Kevin,

Are all these sites hosted on the same box? -Brad -----Original Message----- From: Kevin [mailto:Kevin@harveywalsh.co.uk] Sent: Thursday, October 26, 2006 9:37 AM To: php-general@lists.php.net Subject: Re: [PHP] PHP Template Trouble Hi Brad, That sounds like a good idea however: Where would config.php go? If it goes on the www.solution.com side of things, then $_SERVER[HTTP_HOST] will always be www.solution.com and if it goes on another then it would be www.example1.com. What you have put would be the kind of solution I am looking for but

its

the $_SERVER[HTTP_HOST] variable that would need to be posted through correctly, even if using frames on www.example1.com (using them to load www.solution.com) $_SERVER[HTTP_HOST] would still equal

www.example1.com

Thanks Kevin Brad Fuller wrote:

        
Hi,

I am trying to have 1 template site and have an unlimited number of websites using this template site to call there own information. The sites are exactly the same except for the database, each of the sites also needs there own URL, for example one of these urls may be www.example1.com and the other www.example2.com. These sites are identical apart from the database they call to, one will call to a database called example1 and the other example2. I want another site (for example www.solution.com) to read what url has been entered and to pull in the database for that site (either example1 or example2) and show that information. I have tried using the CURL library without success (not sure how to use it fully) and have tried using frames but had loads of problems regarding losing session data. can anyone help? Thanks Kev

Here's just an idea to give you maybe a starting point to go from... <?php // config.php $db_host = "localhost"; $db_user = "foo"; $db_pass = "bar"; switch($_SERVER["HTTP_HOST"]){ case "www.example1.com": $db_name = "example1"; break; Case "www.example2.com": $db_name = "example2"; break; case "www.template.com": $db_name = "template"; break; } ?> <?php // index.php include("config.php"); $link = mysql_connect($db_host, $db_user, $db_pass); mysql_select_db($db_name); ... ?>

                        --

PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php