Jump to content

If Else Statements.

johntp

By johntp
in PHP Coding Help

 Share

Recommended Posts

johntp Member

johntp

Posted
Posted

Hey guys, I am doing an echo with pretty much an HTML page in it. Can you do an if else statment in an echo? Pretty much i want to do and if else statment to hide empty fields. See code below

 

<?php
else
{
$query30  = "SELECT * FROM users WHERE Username = '$user'";
$query31  = "SELECT * FROM medical WHERE EmployeeID = '$Employee'";
$query32  = "SELECT * FROM vehicle1 WHERE EmployeeID = '$Employee'";
$query33  = "SELECT * FROM vehicle2 WHERE EmployeeID = '$Employee'";
$query34  = "SELECT * FROM vehicle3 WHERE EmployeeID = '$Employee'";
$query35  = "SELECT * FROM vehicle4 WHERE EmployeeID = '$Employee'";
$result30 = mysql_query($query30);
$result31 = mysql_query($query31);
$result32 = mysql_query($query32);
$result33 = mysql_query($query33);
$result34 = mysql_query($query34);
$result35 = mysql_query($query35);
while($row30 = mysql_fetch_array($result30, MYSQL_ASSOC))
while($row31 = mysql_fetch_array($result31, MYSQL_ASSOC))
while($row32 = mysql_fetch_array($result32, MYSQL_ASSOC))
while($row33 = mysql_fetch_array($result33, MYSQL_ASSOC))
while($row34 = mysql_fetch_array($result34, MYSQL_ASSOC))
while($row35 = mysql_fetch_array($result35, MYSQL_ASSOC))
{
echo "<table width='795' border='0' align='center'>
  <tr>
    <td colspan='2'><div align='center'>
      <p><strong>Test    </strong></p>
      <p>   </p>
    </div>      </td>
  </tr>
  <tr>
    <td width='421' valign='top'><table width='406' border='0'>
      <tr>
        <td colspan='2'><div align='left'><strong>Basic Information </strong></div></td>
      </tr>
      <tr>
        <td width='158'><div align='left'>First Name: </div></td>
        <td width='238'><div align='left'>{$row30['Firstname']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Last Name: </div></td>
        <td><div align='left'>{$row30['Lastname']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Supervisor:</div></td>
        <td><div align='left'>{$row30['Supervisor']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Employee Status: </div></td>
        <td><div align='left'>{$row30['Status']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Employee Number: </div>         </td>
        <td><div align='left'>{$row30['EmployeeID']}</div></td>
      </tr>
      <tr>
        <td colspan='2'><div align='left'><br></div></td>
      </tr>
      <tr>
        <td colspan='2'><div align='left'><strong>Medical/Emergency Information </strong></div></td>
      </tr>
      <tr>
        <td><div align='left'>Medical Issues / Meds:</div></td>
        <td><div align='left'>{$row31['Issues']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Medications:</div></td>
        <td><div align='left'>{$row31['Medications']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Allergies:</div></td>
        <td><div align='left'>{$row31['Allergies']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Emergency Contact::</div></td>
        <td><div align='left'>{$row31['Contact1Name']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number::</div></td>
        <td><div align='left'>{$row31['Contact1Phone']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number 2:</div></td>
        <td><div align='left'>{$row31['Contact1Phone2']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Emergency Contact - 2:</div></td>
        <td><div align='left'>{$row31['Contact2Name']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number:</div></td>
        <td><div align='left'>{$row31['Contact2Phone']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number 2:</div></td>
        <td><div align='left'>{$row31['Contact2Phone2']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Emergency Contact 3:</div></td>
        <td><div align='left'>{$row31['Contact3Name']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number:</div></td>
        <td><div align='left'>{$row31['Contact3Phone']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Phone Number  2:</div></td>
        <td><div align='left'>{$row31['Contact3Phone2']}</div></td>
      </tr>
      
      

    </table></td>
    <td width='364'><table width='349' border='0' align='left'>
      <tr>
        <td colspan='2'><div align='left'><strong>Vehicle Information</strong> </div></td>
        </tr>
      <tr>
        <td width='117'><div align='left'><strong>Car #1:</strong></div></td>
        <td width='222'><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'>License:</div></td>
        <td><div align='left'>{$row32['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Make:</div></td>
        <td><div align='left'>{$row32['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Color:</div></td>
        <td><div align='left'>{$row32['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Model:</div></td>
        <td><div align='left'>{$row32['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Year:</div></td>
        <td><div align='left'>{$row32['Year']}</div></td>
      </tr>
      
      <tr>
        <td><div align='left'><strong>Car #2</strong></div></td>
        <td><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'>License:</div></td>
        <td><div align='left'>{$row33['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Make:</div></td>
        <td><div align='left'>{$row33['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Color:</div></td>
        <td><div align='left'>{$row33['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Model:</div></td>
        <td><div align='left'>{$row33['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Year:</div></td>
        <td><div align='left'>{$row33['Year']}</div></td>
      </tr>
      
      <tr>
        <td><div align='left'><strong>Car #3</strong></div></td>
        <td><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'> License:</div></td>
        <td><div align='left'>{$row34['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Make:</div></td>
        <td><div align='left'>{$row34['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Color : </div></td>
        <td><div align='left'>{$row34['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Model:</div></td>
        <td><div align='left'>{$row34['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Year:</div></td>
        <td><div align='left'>{$row34['Year']}</div></td>
      </tr>
      
      <tr>
        <td><div align='left'><strong>Car #4</strong></div></td>
        <td><div align='left'></div></td>
      </tr>
      <tr>
        <td><div align='left'> License:</div></td>
        <td><div align='left'>{$row35['License']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Make:</div></td>
        <td><div align='left'>{$row35['Make']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Color:</div></td>
        <td><div align='left'>{$row35['Model']}</div></td>
      </tr>
      <tr>
        <td><div align='left'>Model:</div></td>
        <td><div align='left'>{$row35['Color']}</div></td>
      </tr>
      <tr>
        <td><div align='left'> Year:</div></td>
        <td><div align='left'>{$row35['Year']}</div></td>
      </tr>
      

    </table></td>
  </tr>
</table>";
}
}
?> 

Link to comment
Share on other sites
DarkWater Member

DarkWater

Posted
Posted

No, you need to separate it out where you want the ifs.  You need to end the echo (with a closing " and a semicolon) and you need to do an if with some echos in it for each one basically, probably due to the design of your code.  Why do you have like 6 queries when you could probably write that in one or two?

Link to comment
Share on other sites
DarkWater Member

DarkWater

Posted
Posted

Also, why do you have vehicle1, vehicle2, vehicle3, and vehicle4 tables rather than just one vehicles table that associate to the users table with an ID and then the vehicles get sorted by id so that you have them in an approximate order?  You should read up on database normalization.  Once you normalize the database, this would be a simple join and loop to display all the results that you need.

Link to comment
Share on other sites
papaface Advanced Member

papaface

Posted
Posted

That will get so irreparably sloppy in a short amount of time that it's easier to just fix the underlying issue.

Yeah I totally agree, but that wasn't my point. It is valid PHP code.

OPs question:

Can you do an if else statment in an echo? Pretty much i want to do and if else statment to hide empty fields.

The answer. Yes:

Conditional statements in echo's are quite easily possible:

<?php
$num = 1;
echo "\$num has a value of 10? " . ($num == '10' ? 'True' : 'False');
?>

Apply to your code as necessary.

Question answered, mark as solved.

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
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.