include file for db connection does not seem to be working

[alanl1]

Hi Professionals

 

I have the following php file which works and returns data from the database

 

<?php
 

$server='d3licsql02';
$connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "secret");

//connect to DB
$conn=sqlsrv_connect($server,$connectinfo);

if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}

 

$sql = "SELECT distinct software_manufacturer FROM softusecomp";
$stmt = sqlsrv_query( $conn, $sql);

if( $stmt === false) {
   die( print_r( sqlsrv_errors(), true) );
}

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {

echo "<option value=";
echo "'".$row['software_manufacturer']."'";
echo ">";
echo $row['software_manufacturer'];
echo "</option>";

}

sqlsrv_free_stmt( $stmt);

?>
</select>
  <input type="submit" value="Search">
</br></br>
</form>
</body></html>

 

 

I have changed this to two seperate files below which do not work

 

<?php
 include('ConnectDB');

 

$sql = "SELECT distinct software_manufacturer FROM softusecomp";
$stmt = sqlsrv_query( $conn, $sql);

if( $stmt === false) {
   die( print_r( sqlsrv_errors(), true) );
}

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {

echo "<option value=";
echo "'".$row['software_manufacturer']."'";
echo ">";
echo $row['software_manufacturer'];
echo "</option>";

}

sqlsrv_free_stmt( $stmt);

?>
</select>
  <input type="submit" value="Search">
</br></br>
</form>
</body></html>

 

 

ConnectDB.php

 

<?php

$server='d3licsql02';
$connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "secret");

//connect to DB
$conn=sqlsrv_connect($server,$connectinfo);

if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}

?>

 

 

Any Ideas

 

 

 

 

[InoBB]

not sure if this is a typo, but:

include('ConnectDB');

maybe you forgot to add the .php extension

include('ConnectDB.php');

[alanl1]

no that doesnt work, any other suggestions

[Barand]

Is the included file in the same folder? If not, is it in a folder specified in the included files path.?

[alanl1]

The included file is in the same folder as my webpage.   How do I find the included files path?

[alanl1]

any ideas anyone

[Barand]

How do I find the included files path?

php.ini

[Kingy]

Try and hardcode the path:

include('/home/user/path/to/website/ConnectDB.php'); // or C:\path\to\website\ConnectDB.php if windows

Also are you getting any errors?