Require function question

[jonathan944]

I have eight mssql databases that have a build date field. For each database, I have a script that pulls that build date. I have setup a separate script that calls each of those scripts using the require function for output on an intranet page.

My question is: if there is a problem with connection to one of the databases the require calls, it halts the script and I do not know the results of the databases that follow it. Is there a way to have the script continue even if one of the called scripts halt?

Thanks for any help!!🙂

[dalecosp]

Let's see some of the code, I guess.

You do know about the @ operator?

$test=@include "something.php";

will produce no warnings if the include fails...

[jonathan944]

I've tried the @ in both of the script types, and it still halts. Here is an example of a script that is called with require. The other seven are identical aside from the DBNames.

This file is called pc_version_ch

<?php

/******************CONNECTION INFORMATION***********************************************/
$myServer = "servername";
$myUser = "username";
$myPass = "password";
$DB1Name = "databasename";

$TableName ="tablename";
/**********************************************************************************************/

mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");

$Link = mssql_connect ($myServer, $myUser, $myPass);

mssql_select_db($DB2Name, $Link)
or die("Couldn't connect to $DB2Name on $myServer");

/***************QUERY VARIABLES*****************************************************************/

$Query1 = "Select * from $TableName where product_code = 'date_check'";

/*****************************************************************************************************/

/***************RESULT VARIABLES****************************************************************/

$Result1 = mssql_query($Query1, $Link);

/*****************************************************************************************************/

?>

<table width="400" border="1" cellpadding="0" cellspacing="0">
<tr bgcolor="#990000">
<td colspan="2"><font color="#FFFFFF" face="Geneva, Arial, Helvetica, san-serif"><strong>manufacturing_ch</strong></font></td>
</tr>
<? while ($Row =mssql_fetch_array ($Result1)) {
?>
<tr>
<td width="210"><font face="Geneva, Arial, Helvetica, san-serif">Build Date</font></td>
<td width="218" bgcolor="#FFFFCC"><? print $Row["build_date"]; ?></td>
</tr>
</table>
<?
}

?>

Here is the small script that calls the others with require:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><?php
@require ("pc_version_dist.php");
@require ("pc_version_gt.php");
@require ("pc_version_rd.php");
@require ("pc_version_wl.php");
?></td>
<td align="center"><?php
@require ("pc_version_fin.php");
@require ("pc_version_ch.php");
@require ("pc_version_kh.php");
@require ("pc_version_nb.php");
?></td>
</tr>
</table>

[dalecosp]

One possible strategy:

1. Use include() instead of require(). Require() will
   create a fatal error; include(), only a warning, and the
   script should continue.

2. if desired, use a conditional (e.g., $connect1=@include 'pc_version_dist.php'; )
   and have the result of that test show up in your
   web-app or mailed to you...

HTH, 🙂