connecting to MYSQL in a windows environment

[szym9341]

Hello, I am developing a project that is using .php and mysql which will be hosted on a windows box. I would like to have an database.inc file stored in a location away from public eyes incase .php dies or something else with the web server... how can I do this? My isp doesn't really know (sadly) and they are willing to set folder permissions to what I request... any suggestions?

[Erkilite]

I would just create the file and in that file declare a few global variables like

i usually put this file one level above my web root folder.

<?php

define('DB_HOST','localhost');
define('DB_USER','username');
define('DB_PASSWORD','password');

?>

then in your project just do this

<?php
require_once('database.inc.php');

//or something like

require_once('C:/Program Files/Apache/Apache2/database.inc.php');

//just make sure you use the path to the file.


$dblink=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);

?>