Jump to content

[SOLVED] While(!$Lost){ $Lost=true; }

jrm

By jrm
in PHP Coding Help

Recommended Posts

jrm Member

jrm

Posted
Posted

I am having trouble finding my error in this code.  It needs to print out a roster of "Cadets" based on the "PorP" (Past or Present) value.  But I can not find where it is stoping the loop.

 

 
<HTML>
<HEAD>
<Title>Cadet Roster</Title>
</HEAD>
<BODY background="/themes/subtxtr.gif">
<?php

     if(isset($_GET['PorP']))
     {
         $PorP = (int) $_GET['PorP'];
         //echo "<p>" . $PorP . "</p>";
         if(isset($_GET['year']))
         {
             $SelectYear = (int)$_GET['year'];
             //echo "<p>" . $SelectYear . "</p>";
         }
         else
         {
             echo "No Year Selected. Current Year Selected";
             $SelectYear = date("Y");
         }
     }
     else
     {
         echo 'No Time Frame selected!';
         exit;
     }
     echo "<p>Report Generated at: " . date("F j, Y, g:i a") . "</p>\n";


     $link = mysql_connect("192.168.10.6:3306","webuser","getting2Knowu!")
           or die("Could not connect to server: " . mysql_error());
     //echo "<p>Connection Successful</p>";

     switch ($PorP)
     {
        case 1:  //Current Cadets
            echo "<table width = '100%' ><tr><td align = center>Current Cadets</td></tr></table>\n";
            $query = " SELECT Cadets.CadetID, Cadets.SSN, Cadets.Last, Cadets.First, Cadets.Middle, Cadets.DOB, Cadets.PhaseID, Cadets.Number
                   FROM Cadets_be.Cadets
                   WHERE Cadets.PhaseID<5 ORDER BY Cadets.Last, Cadets.First, Cadets.Middle; ";
            break;
        case 2:  //Former Cadets
             echo "<table width=100% ><tr><td align = center>Past Intakes for Year: " . $SelectYear . "</td></tr></table>\n";
             $query = "SELECT Cadets.CadetID, Cadets.SSN, Cadets.Last, Cadets.First, Cadets.Middle, Cadets.DOB, Cadets.PhaseID, Cadets.Number, Year(CadetsDates.DTG) as SelectYear
                    FROM Cadets_be.Cadets INNER JOIN Cadets_be.CadetsDates ON Cadets.CadetID = CadetsDates.CadetID
                    WHERE Year(CadetsDates.DTG)=" . $SelectYear . " AND CadetsDates.SDID=11 and Cadets.Last<>'Test'
                    ORDER BY Cadets.Last, Cadets.First, Cadets.Middle;";
             break;
        case 3: //Aftercare Residents
             echo "<table width=100% ><tr><td align = center>Current Aftercare Residents</td></tr></table>\n";
             $query = " SELECT Cadets.CadetID, Cadets.SSN, Cadets.Last, Cadets.First, Cadets.Middle, Cadets.DOB, Cadets.PhaseID, Cadets.Number
    				FROM Cadets_be.Cadets WHERE Cadets.PhaseID=5
				ORDER BY Cadets.Last, Cadets.First, Cadets.Middle;";
              break;
     }
?>

<br>
<table width="100%" border="2">
<tr>
	<td align="middle" width="2%"><big></big></td>
	<td align="middle" width="15%"><big>Name</big></td>
	<td align="middle" width="5%"><big>SSN</big></td>
	<td align="middle" width="10%"><big>Phase</big></td>
	<td align="middle" width="5%"><big>Num</big></td>
	<td align="middle" width="10%"><big>DOB</big></td>
	<td align="middle" width="10%"><big>Date of Entry</big>
	<td align="middle" width="10%"><big>Est Date of Exit</big></td>
	<td align="middle" width="20%"><big>Remarks</big></td>
</tr>
</table>
<?php

     echo "<table>\n";
     $result = mysql_query($query, $link) or die("Could not run query: " . mysql_error());
     $count = 0;
     while ($Cadets = mysql_fetch_array($result, MYSQL_ASSOC))
     {
         $count += 1;
         $cadetid = $Cadets["CadetID"];
         $middle = str_split($Cadets["Middle"]);
         $Name = $Cadets["Last"] . ", " . $Cadets["First"];
         $Num = $Cadets["number"];
         //$SSN = right($Cadets["ssn"],4);
         $Phaseid = $Cadets["phaseid"];
//         $DOB = $Cadets["DOB"]=="" ? 0 : $Cadets["DOB"];


      switch ($PorP)
     {
        case 1:  //Current Cadets
            echo "<table width = '100%' ><tr><td align = center>Current Cadets</td></tr></table>\n";
            $query = " SELECT Cadets.CadetID, Cadets.SSN, Cadets.Last, Cadets.First, Cadets.Middle, Cadets.DOB, Cadets.PhaseID, Cadets.Number
                       FROM Cadets_be.Cadets
                       WHERE Cadets.PhaseID<5 ORDER BY Cadets.Last, Cadets.First, Cadets.Middle; ";
            break;
        case 2:  //Former Cadets
            echo "<table width=100% ><tr><td align = center>Past Intakes for Year: " . $SelectYear . "</td></tr></table>\n";
            $query = " SELECT Cadets.CadetID, Cadets.SSN, Cadets.Last, Cadets.First, Cadets.Middle, Cadets.DOB, Cadets.PhaseID, Cadets.Number, Year(CadetsDates.DTG) as SelectYear
                       FROM Cadets_be.Cadets INNER JOIN Cadets_be.CadetsDates ON Cadets.CadetID = CadetsDates.CadetID
                       WHERE Year(CadetsDates.DTG)=" . $SelectYear . " AND CadetsDates.SDID=11 and Cadets.Last<>'Test'
                       ORDER BY Cadets.Last, Cadets.First, Cadets.Middle;";
            break;
        case 3: //Aftercare Residents
            echo "<table width=100% ><tr><td align = center>Current Aftercare Residents</td></tr></table>\n";
            $query = " SELECT Cadets.CadetID, Cadets.SSN, Cadets.Last, Cadets.First, Cadets.Middle, Cadets.DOB, Cadets.PhaseID, Cadets.Number
                       FROM Cadets_be.Cadets WHERE Cadets.PhaseID=5
                       ORDER BY Cadets.Last, Cadets.First, Cadets.Middle;";
            break;
     }

                 $DateResult = mysql_query($datesql, $link) or die("Could not run Date Query: " . mysql_error());
         while($Dates = mysql_fetch_array($DateResult, MYSQL_ASSOC))
         {
            $sdid = $Dates["sdid"];
            switch($PorP)
            {
                case 3:	//Aftercare
                    $DoE = 0;
                    $EstDoR = 0;
                    $EstACExit = 0;
                    switch($sdid)
                    {
                        case 11:
                            $DoE = $Dates["date"];
                            break;
                        case 6:
                            $EstDoR = $Dates["date"];
                            break;
                        case 17:
                            $EstACExit = $Dates["date"];
                            break;
                    }
                    break;
                case 2:	//Former
                    $DoE = 0;
                    $EstDoR = 0;
                    switch($sdid)
                    {
                        case 11:
                            $DoE = $Dates["date"];
                            break;
                        case 6:
                            $EstDoR = $Dates["date"];
                            break;
                    }
                    break;
                case 1:	//Current
                    $DoE = 0;
                    $EstDoR = 0;
                    switch($sdid)
                    {
                        case 11:
                            $DoE = $Dates["date"];
                            break;
                        case 8:
                            $EstDoR = $Dates["date"];
                            break;
                    }
                    break;
            }
        }
        mysql_free_result($DateResult);
        switch($PorP)
        {
            case 3:   //Aftercare
                 $DateCommentQuery = " SELECT CadetsDates.CadetID, CadetsDates.Comments FROM Cadets_be.CadetsDates
						          WHERE (((CadetsDates.CadetID)=" . $cadetid . ") AND ((CadetsDates.SDID)=6 Or (CadetsDates.SDID)=12)); ";
                 break;
            case 2:   //Exited
                 $DateCommentQuery = " SELECT CadetsDates.CadetID, CadetsDates.Comments FROM Cadets_be.CadetsDates
						          WHERE (((CadetsDates.CadetID)=" . $cadetid . ") AND ((CadetsDates.Comments) Is Not Null));";
                 break;
            case 1:	//Current
                 $DateCommentQuery = " Select CadetsDates.cadetid, CadetsDates.comments from Cadets_be.CadetsDates
						          WHERE (((CadetsDates.CadetID)=" . $cadetid . ") AND ((CadetsDates.SDID)<>6 And (CadetsDates.SDID)<>12));";
                 break;
        }

        $DateCommentResult = mysql_query($DateCommentQuery, $link) or die("Could not run Query: " . mysql_error());
        while($DateComment = mysql_fetch_array($DateCommentResult, MYSQL_ASSOC))
        {
             if ($DateComment["comments"])
             {$Remarks = $Remarks . $DateComment["comments"];}
             else
             {$Remarks = $Remarks . "<br>" . $DateComment["comments"];}
        }
        mysql_free_result($DateCommentResult);

   		$phasesql = " Select * from Cadets_be.Phase where phaseid = " . $Phaseid .";";
        $PhaseResult = mysql_query($phasesql, $link);
        $PhaseRow = msql_fetch_array($PhaseResult, MYSQL_ASSOC);
        $Phase = $PhaseRow["phase"];
        mysql_free_result($PhaseResult);

        $bgcolor = fmod($count,2);
        switch($bgcolor)
        {
          case 0:
               echo "<tr><td align=center width=2% >". $count."</td></tr>\n";
               break;
          default:
               echo "<tr><td align=center width=2% bgcolor=cadetblue>" . $count . "</td></tr>\n";

        }
   }
     echo "</table>\n";
     
  mysql_close($link);
?>
afasdfasfd
</BODY>
</HTML>

 

When access the page "http://198.168.10.6/CadetRoster.php?PorP=1&year=" (the values really do not matter) all that it displays is the table header:

 

<HTML>
<HEAD>
<Title>Cadet Roster</Title>
</HEAD>
<BODY background="/themes/subtxtr.gif">
<p>Report Generated at: April 7, 2008, 2:45 pm</p>
<table width = '100%' ><tr><td align = center>Current Cadets</td></tr></table>

<br>
<table width="100%" border="2">
<tr>
	<td align="middle" width="2%"><big></big></td>
	<td align="middle" width="15%"><big>Name</big></td>
	<td align="middle" width="5%"><big>SSN</big></td>
	<td align="middle" width="10%"><big>Phase</big></td>
	<td align="middle" width="5%"><big>Num</big></td>
	<td align="middle" width="10%"><big>DOB</big></td>
	<td align="middle" width="10%"><big>Date of Entry</big>
	<td align="middle" width="10%"><big>Est Date of Exit</big></td>
	<td align="middle" width="20%"><big>Remarks</big></td>
</tr>
</table>
<table>

Link to comment
https://forums.phpfreaks.com/topic/100010-solved-whilelost-losttrue/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.