RE: [PHP-DB] Weird PHP behavior...
It turned out to be just a simple file permissions issue.
-Original Message-
From: Mohammad Saad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 12:31 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [PHP-DB] Weird PHP behavior...
Check path on this require
require_once("/www/DW/prod.lib.php");
something is wrong with this
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 10:17 PM
Subject: RE: [PHP-DB] Weird PHP behavior...
> Here is the working code...
>
> require_once("/www/DW/prod.lib.php");
> $hr = date("G");
> if ($hr > 7) {
> $sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate),
> UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B,
> `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID
> AND CURDATE() BETWEEN A.StartDate AND A.StopDate") or die(mysql_error());
> $mid = mktime (0,0,0,date("m") ,date("d")+1,date("Y"));
> } else {
> $sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate),
> UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B,
> `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID
> AND CURDATE()-2 BETWEEN A.StartDate AND A.StopDate") or
die(mysql_error());
> $sql2 = mysql("Calendar2","SELECT B.Title FROM `phpCalendar_Details`
AS
> B, `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID =
> B.CalendarDetailsID AND CURDATE() BETWEEN A.StartDate AND A.StopDate") or
> die(mysql_error());
> $res2 = mysql_fetch_row($sql2);
> $new = $res2[0];
> $mid = mktime (0,0,0,date("m") ,date("d")-2,date("Y"));
> }
> $res = mysql_fetch_row($sql);
> $sa = $res[0];
> $start = $res[1];
> $stop = $res[2];
> $day1 = date("l", $start);
> $date1 = date("jS", $start);
> $month1 = date("F", $start);
> $day3 = date("l", $stop);
> $date3 = date("jS", $stop);
> $month3 = date("F", $stop);
> if ($day1 == "Friday") {
> $day2 = date("l", $mid);
> $date2 = date("jS", $mid);
> $month2 = date("F", $mid);
> if ($month1 != $month2) {
>$line2 = "$month1 $date1, $month2 $date2 and $date3";
> } elseif ($month2 != $month3) {
>$line2 = "$month1 $date1 and $date2, and $month3 $date3";
> } else {
>$line2 = "$month1 $date1, $date2, and $date3";
> }
> $line1 = "ONCALL SA for Friday, Saturday, and Sunday";
> } else {
> if ($month1 != $month3) {
>$line2 = "$month1 $date1 and $date3";
> } else {
>$line2 = "$month1 $date1 and $month3 $date3";
> }
> $line1 = "ONCALL SA for $day1 and $day3";
> }
>
> mysql_select_db($database, $Prod);
> $query = "SELECT name, pager FROM contacts_sa WHERE sbcuid='$sa'";
> $said = mysql_query($query, $Prod) or die(mysql_error());
> $row = mysql_fetch_row($said);
> $name = $row[0];
> $pager = $row[1];
>
> if ($date3 == date("jS", $stop) && $hr < 8) {
> $query2 = "SELECT name FROM contacts_sa WHERE sbcuid='$new'";
> $said2 = mysql_query($query2, $Prod) or die(mysql_error());
> $row2 = mysql_fetch_row($said2);
> $name2 = $row2[0];
> $line4 = "Please be aware the On-Call turnover occurs at 8AM. The
> oncoming SA after 8AM will be $name2.";
> } else {
> $line4 = "$name begins On-Call at 8AM on $day1.";
> }
> ?>
>
>
> Untitled Document
>
>
>
>
> CALL 214-741-6961
> FOR CURRENT ONCALL STATUS.
>
>
> ()
>(pager lang="en-us">
> )
>
>
>
>
>
> The portion of PHP code prior to the HTML is inserted at the top of
the
> file in the broken page. Here is how the HTML portion of the PHP is
> inserted...
>
>
>
>
>
>id="fpAnimOu
> tflyBottomRightFP1" style="position: relative !important"
> onclick="dynAnimOut(th
> is)" language="Javascript1.2">
> CALL 214-741-6961
> FOR CURRENT ONCALL STATUS.
>
>
> ()
> (pager lang="en-us
> ">
> )
>
>
> For escalation procedures,
> click here.
> For restore requests call the
>
Re: [PHP-DB] Weird PHP behavior...
Check path on this require
require_once("/www/DW/prod.lib.php");
something is wrong with this
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 10:17 PM
Subject: RE: [PHP-DB] Weird PHP behavior...
> Here is the working code...
>
> require_once("/www/DW/prod.lib.php");
> $hr = date("G");
> if ($hr > 7) {
> $sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate),
> UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B,
> `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID
> AND CURDATE() BETWEEN A.StartDate AND A.StopDate") or die(mysql_error());
> $mid = mktime (0,0,0,date("m") ,date("d")+1,date("Y"));
> } else {
> $sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate),
> UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B,
> `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID
> AND CURDATE()-2 BETWEEN A.StartDate AND A.StopDate") or
die(mysql_error());
> $sql2 = mysql("Calendar2","SELECT B.Title FROM `phpCalendar_Details`
AS
> B, `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID =
> B.CalendarDetailsID AND CURDATE() BETWEEN A.StartDate AND A.StopDate") or
> die(mysql_error());
> $res2 = mysql_fetch_row($sql2);
> $new = $res2[0];
> $mid = mktime (0,0,0,date("m") ,date("d")-2,date("Y"));
> }
> $res = mysql_fetch_row($sql);
> $sa = $res[0];
> $start = $res[1];
> $stop = $res[2];
> $day1 = date("l", $start);
> $date1 = date("jS", $start);
> $month1 = date("F", $start);
> $day3 = date("l", $stop);
> $date3 = date("jS", $stop);
> $month3 = date("F", $stop);
> if ($day1 == "Friday") {
> $day2 = date("l", $mid);
> $date2 = date("jS", $mid);
> $month2 = date("F", $mid);
> if ($month1 != $month2) {
>$line2 = "$month1 $date1, $month2 $date2 and $date3";
> } elseif ($month2 != $month3) {
>$line2 = "$month1 $date1 and $date2, and $month3 $date3";
> } else {
>$line2 = "$month1 $date1, $date2, and $date3";
> }
> $line1 = "ONCALL SA for Friday, Saturday, and Sunday";
> } else {
> if ($month1 != $month3) {
>$line2 = "$month1 $date1 and $date3";
> } else {
>$line2 = "$month1 $date1 and $month3 $date3";
> }
> $line1 = "ONCALL SA for $day1 and $day3";
> }
>
> mysql_select_db($database, $Prod);
> $query = "SELECT name, pager FROM contacts_sa WHERE sbcuid='$sa'";
> $said = mysql_query($query, $Prod) or die(mysql_error());
> $row = mysql_fetch_row($said);
> $name = $row[0];
> $pager = $row[1];
>
> if ($date3 == date("jS", $stop) && $hr < 8) {
> $query2 = "SELECT name FROM contacts_sa WHERE sbcuid='$new'";
> $said2 = mysql_query($query2, $Prod) or die(mysql_error());
> $row2 = mysql_fetch_row($said2);
> $name2 = $row2[0];
> $line4 = "Please be aware the On-Call turnover occurs at 8AM. The
> oncoming SA after 8AM will be $name2.";
> } else {
> $line4 = "$name begins On-Call at 8AM on $day1.";
> }
> ?>
>
>
> Untitled Document
>
>
>
>
> CALL 214-741-6961
> FOR CURRENT ONCALL STATUS.
>
>
> ()
>(pager lang="en-us">
> )
>
>
>
>
>
> The portion of PHP code prior to the HTML is inserted at the top of
the
> file in the broken page. Here is how the HTML portion of the PHP is
> inserted...
>
>
>
>
>
>id="fpAnimOu
> tflyBottomRightFP1" style="position: relative !important"
> onclick="dynAnimOut(th
> is)" language="Javascript1.2">
> CALL 214-741-6961
> FOR CURRENT ONCALL STATUS.
>
>
> ()
> (pager lang="en-us
> ">
> )
>
>
> For escalation procedures,
> click here.
> For restore requests call the
> Help
>
> Desk
>
> <...snip>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 06, 2003 11:09 AM
> To: NIPP, SCOTT V (SBCSI)
> Subject: RE: [PHP-DB] Weird PHP behavior...
>
>
>
RE: [PHP-DB] Weird PHP behavior...
Here is the working code...
7) {
$sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate),
UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B,
`phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID
AND CURDATE() BETWEEN A.StartDate AND A.StopDate") or die(mysql_error());
$mid = mktime (0,0,0,date("m") ,date("d")+1,date("Y"));
} else {
$sql = mysql("Calendar2","SELECT B.Title, UNIX_TIMESTAMP(A.StartDate),
UNIX_TIMESTAMP(A.StopDate) FROM `phpCalendar_Details` AS B,
`phpCalendar_Daily` AS A WHERE A.CalendarDetailsID = B.CalendarDetailsID
AND CURDATE()-2 BETWEEN A.StartDate AND A.StopDate") or die(mysql_error());
$sql2 = mysql("Calendar2","SELECT B.Title FROM `phpCalendar_Details` AS
B, `phpCalendar_Daily` AS A WHERE A.CalendarDetailsID =
B.CalendarDetailsID AND CURDATE() BETWEEN A.StartDate AND A.StopDate") or
die(mysql_error());
$res2 = mysql_fetch_row($sql2);
$new = $res2[0];
$mid = mktime (0,0,0,date("m") ,date("d")-2,date("Y"));
}
$res = mysql_fetch_row($sql);
$sa = $res[0];
$start = $res[1];
$stop = $res[2];
$day1 = date("l", $start);
$date1 = date("jS", $start);
$month1 = date("F", $start);
$day3 = date("l", $stop);
$date3 = date("jS", $stop);
$month3 = date("F", $stop);
if ($day1 == "Friday") {
$day2 = date("l", $mid);
$date2 = date("jS", $mid);
$month2 = date("F", $mid);
if ($month1 != $month2) {
$line2 = "$month1 $date1, $month2 $date2 and $date3";
} elseif ($month2 != $month3) {
$line2 = "$month1 $date1 and $date2, and $month3 $date3";
} else {
$line2 = "$month1 $date1, $date2, and $date3";
}
$line1 = "ONCALL SA for Friday, Saturday, and Sunday";
} else {
if ($month1 != $month3) {
$line2 = "$month1 $date1 and $date3";
} else {
$line2 = "$month1 $date1 and $month3 $date3";
}
$line1 = "ONCALL SA for $day1 and $day3";
}
mysql_select_db($database, $Prod);
$query = "SELECT name, pager FROM contacts_sa WHERE sbcuid='$sa'";
$said = mysql_query($query, $Prod) or die(mysql_error());
$row = mysql_fetch_row($said);
$name = $row[0];
$pager = $row[1];
if ($date3 == date("jS", $stop) && $hr < 8) {
$query2 = "SELECT name FROM contacts_sa WHERE sbcuid='$new'";
$said2 = mysql_query($query2, $Prod) or die(mysql_error());
$row2 = mysql_fetch_row($said2);
$name2 = $row2[0];
$line4 = "Please be aware the On-Call turnover occurs at 8AM. The
oncoming SA after 8AM will be $name2.";
} else {
$line4 = "$name begins On-Call at 8AM on $day1.";
}
?>
Untitled Document
CALL 214-741-6961
FOR CURRENT ONCALL STATUS.
()
(pager
)
The portion of PHP code prior to the HTML is inserted at the top of the
file in the broken page. Here is how the HTML portion of the PHP is
inserted...
CALL 214-741-6961
FOR CURRENT ONCALL STATUS.
()
(pager
)
For escalation procedures,
click here.
For restore requests call the
Help
Desk
<...snip>
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:09 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Weird PHP behavior...
well show the working code and then show just a portion of the code that is
broken specifically where you are trying to inslucde the working code.
K.
"NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
02/06/2003 12:09 PM
To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
cc:
Subject:RE: [PHP-DB] Weird PHP behavior...
I can show the code, but do I show the working code? If I show the
broken code, it is REALLY long.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:06 AM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: [PHP-DB] Weird PHP behavior...
It might help if you showed the code or at least part of it to help track
down your problem.
khris
"NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
02/06/2003 12:05 PM
To:"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:
Subject:[PHP-DB] Weird PHP behavior...
I developed some dynamic content for a larger web page, and
once I
pasted the code into the appropriate area of the page I am seeing the
strangest error. Here is the
[PHP-DB] Weird PHP behavior...
I developed some dynamic content for a larger web page, and once I pasted the code into the appropriate area of the page I am seeing the strangest error. Here is the error: Warning: Failed opening '/www/DW/index1.htm' for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line 0 I have tried this on 2 different servers running 2 different versions of PHP, 4.1.2 and 4.2.3. The code was developed and tested in a blank page and then inserted into a much larger page developed in FrontPage 2002. Any ideas? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
